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

[xyon <xy...@in...>]

On Wed, 2007-04-04 at 10:37 -0700, Gary W. Smith wrote:
> > =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
>=20
> SELECT pwd FROM users WHERE scalix =3D 'UserTestscalixTest User' AND
> (idUsers > 0)
>=20
> Is this just a typo (or replacement) or does the username actually have
> a space in it?
Yes, there is purposely a space.

>   Also, when you cut and paste this exact SQL statement
> into mysql client do you indeed get a new result.
I get a proper result when cutting and pasting this exact statement into
the MySQL command line.

>   If you do then it could be the tunnel.
I have eliminated the tunnel from the equation, and am just connecting
to the MySQL host directly (since this is not in production and I'm
using a test database/passwords and it's all on a private subnet,
encryption isn't a big deal for troubleshooting) and have the exact same
results (see below).

I have the 'mysqlclient14' libs installed, but accessing a mysql5
server, although I don't see how this could be a problem as I've done
this many times with other applications before.


Here is the log results:
=3D=3D> /var/log/secure <=3D=3D
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - option verbose is set to
"1"
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
returning 0.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_format_string()
called
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_quick_escape()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
WHERE scalix =3D 'lastfirstscalixfirst last' AND (1=3D1)
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT returned no
result.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
returning 1.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
returning 0.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_converse()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_open_db()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_format_string()
called
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_quick_escape()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT pwd FROM users
WHERE scalix =3D 'lastfirstscalixfirst last' AND (1=3D1)
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - SELECT returned no
result.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_check_passwd()
returning 1.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_sql_log()
returning 0.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_sm_authenticate()
returning 10.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_release_ctx()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_destroy_ctx()
called.
Apr  4 13:51:23 scalix in.imap41d: pam_mysql - pam_mysql_close_db()
called.




--=20
xyon

-------------------------------------------------------------------------
"They who can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." --Benjamin Franklin
-------------------------------------------------------------------------