[tpop3d-discuss] Strange problem with mysql authentication.

Clive Goodhead clive.goodhead at swnet.co.uk
Thu, 27 Feb 2003 13:32:12 -0000

> How would one go about doing that.
> Please explain in detail.
OK, change your entry to:

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

where XXXX is the name of the unix user that owns the files for
virtual users. Authentication will fail if XXXX is not valid.

Clive Goodhead
Cornwall Internet Limited