it looks like functionality is (somehow) dependent from platform!
A) when i try to connect from Solaris box, i keep getting error (even [client] section is updated):
ERROR 2059 (HY000): Authentication plugin 'auth_pam' cannot be loaded: ld.so.1: mysql: fatal: /usr/lib64/mysql/plugin/auth_pam.so: open failed: No such file or directory
Client box should not care about plugin location on server side, or?
B) if i try from Linux (have similar MySQL packages installed, and i am pasting password which is verified in LDAP):
ERROR 1698 (28000): Access denied for user 'myusr'@'linux-client.fqdn'
and at same time pam_ldap module (with enabled debug) shows (from /etc/log/secure) - note 4 seconds difference:
So, i have update:
it looks like functionality is (somehow) dependent from platform!
A) when i try to connect from Solaris box, i keep getting error (even [client] section is updated):
ERROR 2059 (HY000): Authentication plugin 'auth_pam' cannot be loaded: ld.so.1: mysql: fatal: /usr/lib64/ mysql/plugin/ auth_pam. so: open failed: No such file or directory
Client box should not care about plugin location on server side, or?
B) if i try from Linux (have similar MySQL packages installed, and i am pasting password which is verified in LDAP):
ERROR 1698 (28000): Access denied for user 'myusr' @'linux- client. fqdn'
and at same time pam_ldap module (with enabled debug) shows (from /etc/log/secure) - note 4 seconds difference:
Apr 25 16:02:59 TEST mysqld: pam_warn( mysqld: auth): function= [pam_sm_ authenticate] service=[mysqld] terminal= [<unknown> ] user=[myusr] ruser=[myusr] rhost=[ linux-client. fqdn] mysqld: auth): authentication failure; logname= uid=101 euid=101 tty= ruser=myusr rhost=linux- client. fqdn user=myusr
Apr 25 16:03:03 TEST mysqld: pam_unix(
C) using Linux client on server box, i can access DB WITHOUT need to specify password !!!
Regards/Pozdrav