Re: [Pam-mysql-general] what the error code of the methods mean ?

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

Hello,=20

=20

Try posting the relevant sections of you pam-mysql.conf file.

=20

I don't remember what return value 6 is (as I dug into the code and made
some changes myself) but you might want to look that up in the source.
I suspect that it's one of two things; record not found or password
doesn't match.

=20

Try running the sql statement in manually and see if it does indeed
return a code.

=20

The other thing I would recommend trying (only for development though)
is to use clear text passwords first and see if auth works.  Then use
your preferred method once things are working fine.  When we first tried
this we run into the issue of our tools using a different method than
pam-mysql for the encryption of the password. =20

=20

Gary Wayne Smith

=20

=20

=20

________________________________

From: pam...@li...
[mailto:pam...@li...] On Behalf Of
kamtcha
Sent: Friday, October 20, 2006 3:01 PM
To: pam...@li...
Subject: [Pam-mysql-general] what the error code of the methods mean ?

=20

Hi guys,=20

=20

I posted a help message on the forum few days ago, but it does not seem
to be very active, I hope someone will be able to help me o this list ?=20

=20

I'm stuck with the error code returned by the fonctions of pam-mysql, I
don't know if the different methods are successful or not (well, they
arn't as I can't be authenticated, but I don't know *why*)

=20

pam_mysql - option verbose is set to "1"=20

pam_mysql - pam_mysql_close_db() called.=20

pam_mysql - pam_sm_authenticate() called.=20

pam_mysql - pam_mysql_converse() called.=20

pam_mysql - pam_mysql_open_db() called.=20

pam_mysql - pam_mysql_open_db() returning 0.=20

pam_mysql - pam_mysql_check_passwd() called.=20

pam_mysql - pam_mysql_format_string() called=20

pam_mysql - pam_mysql_quick_escape() called.=20

pam_mysql - SELECT password FROM users WHERE user_name =3D 'user1'=20

pam_mysql - pam_mysql_sql_log() called.=20

pam_mysql - pam_mysql_sql_log() returning 0.=20

pam_mysql - pam_mysql_check_passwd() returning 6.=20

pam_mysql - pam_sm_authenticate() returning 7.=20

pam_mysql - pam_mysql_release_ctx() called.=20

pam_mysql - pam_mysql_destroy_ctx() called.=20

pam_mysql - pam_mysql_close_db() called.=20

=20

=20

All the details are here:

http://sourceforge.net/forum/forum.php?thread_id=3D1595166&forum_id=3D176=
91

=20

Please can you help me ?

=20

Seb