[Dovecot] MySQL Auth and default_mail_env
Hi
Not sure how much support you guys can offer but when I use
default_mail_env = mbox:/var/spool/mail/%d/imap/%n/:INBOX=/var/spool/mail/%d/%n
I get the login error ..
Fatal: Failed to create storage with data: mbox:/var/spool/mail/DOMAIN/imap/USER/:INBOX=/var/spool/mail/DOMAIN/USER
It is grabbing the right values for %d and %n from the mysql query
65 Query SELECT password FROM users WHERE username = 'USER' AND domainname = 'DOMAIN' 65 Query SELECT home, uid, gid FROM users where username = 'USER' AND domainname = 'DOMAIN'
Anyone have the same experience.
Any help is appreciated.
Gary TechnicalAbuse.com
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/
I can't use substitution with this method and I get Fatal: chdir errors now on login
For the UID / GID listed in the DB
This is a bit frustrating.
Is anyone using mysql auth successfully ? OR should I be waiting for a working release.
Gary TechnicalAbuse.com
-----Original Message----- From: dovecot-bounces@dovecot.org [mailto:dovecot-bounces@dovecot.org] On Behalf Of dovecot@technicalabuse.com Sent: Sunday, March 07, 2004 5:15 PM To: dovecot@dovecot.org Subject: [Dovecot] MySQL Auth and default_mail_env
Hi
Not sure how much support you guys can offer but when I use
default_mail_env = mbox:/var/spool/mail/%d/imap/%n/:INBOX=/var/spool/mail/%d/%n
I get the login error ..
Fatal: Failed to create storage with data: mbox:/var/spool/mail/DOMAIN/imap/USER/:INBOX=/var/spool/mail/DOMAIN/USER
It is grabbing the right values for %d and %n from the mysql query
65 Query SELECT password FROM users WHERE username = 'USER' AND domainname = 'DOMAIN' 65 Query SELECT home, uid, gid FROM users where username = 'USER' AND domainname = 'DOMAIN'
Anyone have the same experience.
Any help is appreciated.
Gary TechnicalAbuse.com
From: dovecot@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
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@madole.net] Sent: Tuesday, March 09, 2004 7:11 AM To: dovecot@technicalabuse.com Cc: dovecot@dovecot.org Subject: Re: [Dovecot] MySQL Auth and default_mail_env
From: dovecot@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
From: dovecot@technicalabuse.com Sent: Tuesday, March 09, 2004 3:04 PM
Now I get chdir fatals but at least it's dynamic.
failed with uid Permission denied
So what are the permissions on the directories?
David
This message is spam and virus free. Filtering solutions by http://omd3.com Expert computer system support and development by http://baysidenetworks.com
participants (2)
-
David S. Madole
-
dovecot＠technicalabuse.com