[tpop3d-discuss] Strange problem with mysql authentication.

Clive Goodhead clive.goodhead at swnet.co.uk
Thu, 27 Feb 2003 09:45:35 -0000

> 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