[Vmail-discuss] MySQL Auth - mysqlPASSWORD encrypted fields

Yves Thommes ythommes at interact.lu
Fri, 6 Jun 2003 15:20:56 +0000


Ok ok, i got it.

i have to use the {mysql} directive for the password. 
however, this wasn't mentioned in any of the readme files or documentations, i 
had to take a look at the auth_mysql source.

anyway, sorry for the disturbence :)


have a nice weekend,
yves



On Friday 06 June 2003 14:39, Yves Thommes wrote:
> Hi there!
>
>
> I'm setting up a new mailserver using tpop3d with vmail-sql.
>
> all my pop accounts are stored in a mysql table, but the passwords are
> encrypted using the MySQL function PASSWORD.
>
>
> Is there any way to get this working with tpop3d/vmail-sql please ?
> I tried almost everything possible with the tpop3d config file, but i
> always get authentication errors.
>
> Do i have to hack the tpop3d/vmail-sql source to get this working ?
> Or do i have to store the passwords using another format ? MD5... ?
>
> It would be really nice if somebody had a solution for my current
> situation, i got about 1000 e-mail accounts with encrypted passwords. An i
> don't want to change the passwords of all those users just because i have
> to change the encryption algorithm.
>
>
> Please help.
> Thanks
>
>
> Best regards,
> Yves
>
>
> _______________________________________________
> vmail-discuss mailing list
> vmail-discuss@lists.beasts.org
> http://lists.beasts.org/mailman/listinfo/vmail-discuss