[tpop3d-discuss] Re: one more question...

Chris Lightfoot chris at ex-parrot.com
Mon, 1 Sep 2003 23:15:30 +0100


    [ to list ]

On Tue, Sep 02, 2003 at 10:14:13AM +1200, Dan Clark wrote:
> Hi there,
>     One more question, mail is being delivered to the following location...
> 
> /var/mail/domainname.co.nz/dan - (dan being the mail file not a directory)
> 
> Do I need to remove the 'local_part' bit after $(domain) 3rd line from my
> tpop3d.conf?
> 
> auth-mysql-pass-query: \
>         SELECT CONCAT('/var/mail/', '$(domain)',\
>         '/', '$(local_part)'),\


at this point, $(domain) is domainname.co.nz and
$(local_part) is dan. So the above should give you the
result you want. Note that you could store the whole path
in the database if you want, rather than constructing it.

>         CONCAT('{md5}', password), \
>         'mailnull', 'mbox' \
>         FROM users\
>         WHERE username = '$(local_part)'\
>         AND domainname = '$(domain)'

-- 
``Odd things, animals.
  Dogs look up to you. Cats look down to you.
  Only pigs see you as an equal.'' (Churchill)