[Dovecot] MySQL Auth and default_mail_env

[dovecot at technicalabuse.com]

No reason , only that I hadn't thought of that at 4:30 AM heh 

I am using that now as the select for testing. Thanks. 

Now I get chdir fatals but at least it's dynamic.

failed with uid Permission denied

Gary


-----Original Message-----
From: David S. Madole [mailto:david at madole.net] 
Sent: Tuesday, March 09, 2004 7:11 AM
To: dovecot at technicalabuse.com
Cc: dovecot at dovecot.org
Subject: Re: [Dovecot] MySQL Auth and default_mail_env

> From: <dovecot at technicalabuse.com>
> Sent: Tuesday, March 09, 2004 4:49 AM
>
> Well I got the env to work with leaving an empty
>
> default_mail_env =
>
> In the conf and using the full path in the db.
>
> IE: mbox:/var/spool/mail/domain/imap/user/
>


If you don't want to actually define it in the database, then why not just
use a query like like:

user_query = SELECT 'mbox:/var/spool/mail/%d/imap/%n/' as mail, home, uid,
gid FROM users WHERE username = '%n' AND domainname = '%d'

And let mySQL do the substitution bit?

David


____________________________________________________________________________
This message is spam and virus free.  Filtering solutions by http://omd3.com
Expert computer system support and development by http://baysidenetworks.com