sslug-teknik team mailing list archive

[Mogens Kjaer <mk@xxxxxx>]

Robert Larsen wrote:
...
> Oct 13 14:54:23 ubuntu-isp sshd[28671]: pam_mysql - SELECT password FROM
> users WHERE name = 'bob'
> Oct 13 14:54:23 ubuntu-isp sshd[28671]: pam_mysql -
> pam_mysql_check_passwd() returning 6.
> Oct 13 14:54:23 ubuntu-isp sshd[28671]: pam_mysql - pam_mysql_sql_log()
> called.
> Oct 13 14:54:23 ubuntu-isp sshd[28671]: pam_mysql - pam_mysql_sql_log()
> returning 0.
> Oct 13 14:54:23 ubuntu-isp sshd[28671]: pam_mysql -
> pam_sm_authenticate() returning 7.
> Oct 13 14:54:23 ubuntu-isp sshd[28671]: pam_unix(sshd:auth): check pass;
> user unknown
...

> Hvis jeg udfører søgningen selv i MySQL får jeg følgende:
> mysql> SELECT password FROM users WHERE name = 'bob';
> +----------+
> | password |
> +----------+
> | blar     |
> +----------+
> 1 row in set (0.00 sec)

Det ser da ikke helt ud som om at pam kan slå op i mysql
databasen.

Prøv med logning af mysql for at se om requesten overhovedet
når frem.

Mogens

-- 
Mogens Kjaer, Carlsberg A/S, Computer Department
Gamle Carlsberg Vej 10, DK-2500 Valby, Denmark
Phone: +45 33 27 53 25, Mobile: +45 22 12 53 25
Email: mk@xxxxxx Homepage: http://www.crc.dk