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

[kamtcha <ka...@gm...>]

Hi Gary,

Thanks for your help - I'm in fact trying to do something quite =20
complexe which is trying to setup virtual users   authenticated with =20
pam_mysql.

I ran the SQL statement alone, and it does return the right password.

I inserted the password in clear, and set the 'crypt' attribute to 0. =20=

Here is my vsftpd file located in /etc/pam.d :

auth       required     pam_mysql.so host=3Dlocalhost db=3Dbookmi =20
user=3DXXXX passwd=3DXXXXX table=3Dusers usercolumn=3Duser_name =20
passwdcolumn=3Dpassword crypt=3D0 verbose=3D1
account       required     pam_mysql.so host=3Dlocalhost db=3Dbookmi =20
user=3DXXXX passwd=3DXXXXX table=3Dusers usercolumn=3Duser_name =20
passwdcolumn=3Dpassword crypt=3D0 verbose=3D1

And now it works... Don't know what change made it working !

Thx for your reply,
Seb


On 21 Oct 2006, at 01:10, Gary W. Smith wrote:

> Hello,
>
>
>
> Try posting the relevant sections of you pam-mysql.conf file.
>
>
>
> I don=92t remember what return value 6 is (as I dug into the code and =20=

> made some changes myself) but you might want to look that up in the =20=

> source.  I suspect that it=92s one of two things; record not found or =20=

> password doesn=92t match.
>
>
>
> Try running the sql statement in manually and see if it does indeed =20=

> return a code.
>
>
>
> The other thing I would recommend trying (only for development =20
> though) is to use clear text passwords first and see if auth =20
> works.  Then use your preferred method once things are working =20
> fine.  When we first tried this we run into the issue of our tools =20
> using a different method than pam-mysql for the encryption of the =20
> password.
>
>
>
> Gary Wayne Smith
>
>
>
>
>
>
>
> From: pam...@li... [mailto:pam-=20
> mys...@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 ?
>
>
>
> Hi guys,
>
>
>
> I posted a help message on the forum few days ago, but it does not =20
> seem to be very active, I hope someone will be able to help me o =20
> this list ?
>
>
>
> I'm stuck with the error code returned by the fonctions of pam-=20
> mysql, I don't know if the different methods are successful or not =20
> (well, they arn't as I can't be authenticated, but I don't know *why*)
>
>
>
> pam_mysql - option verbose is set to "1"
>
> pam_mysql - pam_mysql_close_db() called.
>
> pam_mysql - pam_sm_authenticate() called.
>
> pam_mysql - pam_mysql_converse() called.
>
> pam_mysql - pam_mysql_open_db() called.
>
> pam_mysql - pam_mysql_open_db() returning 0.
>
> pam_mysql - pam_mysql_check_passwd() called.
>
> pam_mysql - pam_mysql_format_string() called
>
> pam_mysql - pam_mysql_quick_escape() called.
>
> pam_mysql - SELECT password FROM users WHERE user_name =3D 'user1'
>
> pam_mysql - pam_mysql_sql_log() called.
>
> pam_mysql - pam_mysql_sql_log() returning 0.
>
> pam_mysql - pam_mysql_check_passwd() returning 6.
>
> pam_mysql - pam_sm_authenticate() returning 7.
>
> pam_mysql - pam_mysql_release_ctx() called.
>
> pam_mysql - pam_mysql_destroy_ctx() called.
>
> pam_mysql - pam_mysql_close_db() called.
>
>
>
>
>
> All the details are here:
>
> http://sourceforge.net/forum/forum.php?=20
> thread_id=3D1595166&forum_id=3D17691
>
>
>
> Please can you help me ?
>
>
>
> Seb
>
>