[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[tpop3d-discuss] Re: one more question...
From: |
Chris Lightfoot |
Subject: |
[tpop3d-discuss] Re: one more question... |
Date: |
Mon, 1 Sep 2003 23:15:30 +0100 |
User-agent: |
Mutt/1.3.24i |
[ 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)
- [tpop3d-discuss] Re: one more question...,
Chris Lightfoot <=