Debian Codegraph @

mysql-test/suite/plugins/r/pam.result

raw
1 install plugin pam soname 'auth_pam.so';
2 create user test_pam identified via pam using 'mariadb_mtr';
3 grant all on test.* to test_pam;
4 create user pam_test;
5 grant all on test.* to pam_test;
6 grant proxy on pam_test to test_pam;
7 #
8 # athentication is successful, challenge/pin are ok
9 # note that current_user() differs from user()
10 #
11 Challenge input first.
12 Enter: *************************
13 Now, the magic number!
14 PIN: 9225
15 select user(), current_user(), database();
16 user() current_user() database()
17 test_pam@localhost pam_test@% test
18 #
19 # athentication is unsuccessful
20 #
21 Challenge input first.
22 Enter: *************************
23 Now, the magic number!
24 PIN: 9224
25 #
26 # athentication is unsuccessful
27 #
28 Challenge input first.
29 Enter: ****************
30 Now, the magic number!
31 PIN: 616
32 #
33 # athentication is successful
34 #
35 Now, the magic number!
36 PIN: 9212
37 select user(), current_user(), database();
38 user() current_user() database()
39 test_pam@localhost pam_test@% test
40 #
41 # athentication is unsuccessful
42 #
43 Now, the magic number!
44 PIN: 9212
45 #
46 # MDEV-26339 Account specifics to be handled before proxying
47 #
48 alter user pam_test account lock;
49 alter user pam_test require subject 'foobar';
50 alter user pam_test password expire;
51 Now, the magic number!
52 PIN: 9212
53 select user(), current_user(), database();
54 user() current_user() database()
55 test_pam@localhost pam_test@% test
56 alter user pam_test account unlock;
57 alter user pam_test require none;
58 alter user pam_test identified by '';
59 show create user pam_test;
60 CREATE USER for pam_test@%
61 CREATE USER `pam_test`@`%`
62 alter user test_pam account lock;
63 Now, the magic number!
64 PIN: 9212
65 alter user test_pam account unlock;
66 alter user test_pam require subject 'foobar';
67 Now, the magic number!
68 PIN: 9212
69 alter user test_pam require none;
70 alter user test_pam password expire;
71 Now, the magic number!
72 PIN: 9212
73 select user(), current_user(), database();
74 drop user test_pam;
75 drop user pam_test;
76 create user PAM_TEST identified via pam using 'mariadb_mtr';
77 grant all on test.* to PAM_TEST;
78 #
79 # athentication is unsuccessful
80 #
81 Challenge input first.
82 Enter: *************************
83 Now, the magic number!
84 PIN: 9225
85 set global pam_winbind_workaround=1;
86 #
87 # athentication is successful
88 #
89 Challenge input first.
90 Enter: *************************
91 Now, the magic number!
92 PIN: 9225
93 select user(), current_user(), database();
94 user() current_user() database()
95 PAM_TEST@localhost PAM_TEST@% test
96 drop user PAM_TEST;
97 #
98 # MDEV-27341 Use SET PASSWORD to change PAM service
99 #
100 create user pam_test identified via pam using 'mariadb_mtr';
101 grant all on test.* to pam_test;
102 Challenge input first.
103 Enter: *************************
104 Now, the magic number!
105 PIN: 9225
106 select user(), current_user(), database();
107 user() current_user() database()
108 pam_test@localhost pam_test@% test
109 set password='foo';
110 ERROR HY000: SET PASSWORD is not applicable for users authenticating via pam plugin
111 show create user;
112 CREATE USER for pam_test@%
113 CREATE USER `pam_test`@`%` IDENTIFIED VIA pam USING 'mariadb_mtr'
114 drop user pam_test;
115 uninstall plugin pam;