[tpop3d-discuss] Strange problem with mysql authentication.

Leon Botes leon at trusc.net
Thu, 27 Feb 2003 12:37:54 +0200

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
> ='$(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