Debian Codegraph @

mysql-test/suite/plugins/t/pam.test

raw
1 let $PAM_PLUGIN_VERSION= $AUTH_PAM_SO;
2 --source pam_init.inc
3
4 --write_file $MYSQLTEST_VARDIR/tmp/pam_good.txt
5 not very secret challenge
6 9225
7 select user(), current_user(), database();
8 EOF
9
10 --write_file $MYSQLTEST_VARDIR/tmp/pam_bad.txt
11 not very secret challenge
12 9224
13 select user(), current_user(), database();
14 EOF
15
16 --write_file $MYSQLTEST_VARDIR/tmp/pam_ugly.txt
17 crash pam module
18 616
19 select user(), current_user(), database();
20 EOF
21
22 --write_file $MYSQLTEST_VARDIR/tmp/pam_good2.txt
23 9212
24 select user(), current_user(), database();
25 EOF
26
27 --echo #
28 --echo # athentication is successful, challenge/pin are ok
29 --echo # note that current_user() differs from user()
30 --echo #
31 --exec $MYSQL_TEST -u test_pam < $MYSQLTEST_VARDIR/tmp/pam_good.txt
32
33 --echo #
34 --echo # athentication is unsuccessful
35 --echo #
36 --error 1
37 --exec $MYSQL_TEST -u test_pam < $MYSQLTEST_VARDIR/tmp/pam_bad.txt
38
39 --echo #
40 --echo # athentication is unsuccessful
41 --echo #
42 --error 1
43 --exec $MYSQL_TEST -u test_pam < $MYSQLTEST_VARDIR/tmp/pam_ugly.txt
44
45 --echo #
46 --echo # athentication is successful
47 --echo #
48 --exec $MYSQL_TEST -u test_pam -pgoodpassword < $MYSQLTEST_VARDIR/tmp/pam_good2.txt
49
50 --echo #
51 --echo # athentication is unsuccessful
52 --echo #
53 --error 1
54 --exec $MYSQL_TEST -u test_pam -pbadpassword < $MYSQLTEST_VARDIR/tmp/pam_good2.txt
55
56 --echo #
57 --echo # MDEV-26339 Account specifics to be handled before proxying
58 --echo #
59
60 # one can connect if the proxy account is locked
61 alter user pam_test account lock;
62 alter user pam_test require subject 'foobar';
63 alter user pam_test password expire;
64 --error 0
65 --exec $MYSQL_TEST -u test_pam -pgoodpassword < $MYSQLTEST_VARDIR/tmp/pam_good2.txt
66 alter user pam_test account unlock;
67 alter user pam_test require none;
68 alter user pam_test identified by '';
69 show create user pam_test;
70
71 #one cannot connect if the proxied account is locked
72 alter user test_pam account lock;
73 --error 1
74 --exec $MYSQL_TEST -u test_pam -pgoodpassword < $MYSQLTEST_VARDIR/tmp/pam_good2.txt
75 alter user test_pam account unlock;
76
77 alter user test_pam require subject 'foobar';
78 --error 1
79 --exec $MYSQL_TEST -u test_pam -pgoodpassword < $MYSQLTEST_VARDIR/tmp/pam_good2.txt
80 alter user test_pam require none;
81
82 alter user test_pam password expire;
83 --error 1
84 --exec $MYSQL_TEST -u test_pam -pgoodpassword < $MYSQLTEST_VARDIR/tmp/pam_good2.txt
85
86 drop user test_pam;
87 drop user pam_test;
88 create user PAM_TEST identified via pam using 'mariadb_mtr';
89 grant all on test.* to PAM_TEST;
90
91 --echo #
92 --echo # athentication is unsuccessful
93 --echo #
94 --error 1
95 --exec $MYSQL_TEST -u PAM_TEST < $MYSQLTEST_VARDIR/tmp/pam_good.txt
96
97 set global pam_winbind_workaround=1;
98 --echo #
99 --echo # athentication is successful
100 --echo #
101 --exec $MYSQL_TEST -u PAM_TEST < $MYSQLTEST_VARDIR/tmp/pam_good.txt
102
103 --remove_file $MYSQLTEST_VARDIR/tmp/pam_good.txt
104 --remove_file $MYSQLTEST_VARDIR/tmp/pam_good2.txt
105 --remove_file $MYSQLTEST_VARDIR/tmp/pam_bad.txt
106 --remove_file $MYSQLTEST_VARDIR/tmp/pam_ugly.txt
107 drop user PAM_TEST;
108
109 --echo #
110 --echo # MDEV-27341 Use SET PASSWORD to change PAM service
111 --echo #
112 create user pam_test identified via pam using 'mariadb_mtr';
113 grant all on test.* to pam_test;
114 --write_file $MYSQLTEST_VARDIR/tmp/setpwd.txt
115 not very secret challenge
116 9225
117 select user(), current_user(), database();
118 error ER_SET_PASSWORD_AUTH_PLUGIN;
119 set password='foo';
120 show create user;
121 EOF
122 --exec $MYSQL_TEST -u pam_test < $MYSQLTEST_VARDIR/tmp/setpwd.txt
123 --remove_file $MYSQLTEST_VARDIR/tmp/setpwd.txt
124 drop user pam_test;
125
126 let $count_sessions= 1;
127 --source include/wait_until_count_sessions.inc
128 uninstall plugin pam;