[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,

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