[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
app_dom='$(domain)'
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