Re: [Pam-mysql-general] SELECT returned no result

[Gary W. S. <ga...@pr...>]

> =3D=3D> /var/log/secure <=3D=3D
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - option verbose is set
to
> "1"
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
> called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
> called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
> returning 0.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql -
pam_mysql_check_passwd()
> called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql -
> pam_mysql_format_string() called Apr  4 11:24:50 scalix in.imap41d:
> pam_mysql - pam_mysql_quick_escape() called.
> Apr  4 11:24:50 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
> WHERE scalix =3D 'UserTestscalixTest User' AND (idUsers > 0) Apr  4

SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest User' AND
(idUsers > 0)

Is this just a typo (or replacement) or does the username actually have
a space in it?  Also, when you cut and paste this exact SQL statement
into mysql client do you indeed get a new result.  If you do then it
could be the tunnel.