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

[Clive Goodhead]

> 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