RE: [tpop3d-discuss] Strange problem with mysql authentication.

[Leon Botes]

How would one go about doing that.
Please explain in detail.



> auth-mysql-pass-query: SELECT CONCAT('/var/mail/', '$(local_part)'),
> CONCAT('{plaintext}', passwd), user, mbox_type FROM locals WHERE
user
> ='$(local_part)'  AND app_dom = '$(domain)'
>

'user' in the third field is a problem - for virtual users it needs
to be defined in the database as the user/UID that your virtual users
run under (for testing you can 'hard code' it rather than redo your
database). If that alone does not solve the problem look at your mysql
logs to see what query was passed to mysql-server.

Clive Goodhead
Cornwall Internet Limited


_______________________________________________
tpop3d-discuss mailing list
address@hidden
http://lists.beasts.org/mailman/listinfo/tpop3d-discuss