dovecot - Mar 2004 - 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 at dovecot.org [mailto:dovecot-bounces at dovecot.org] On
Behalf Of dovecot at technicalabuse.com
Sent: Sunday, March 07, 2004 5:15 PM
To: dovecot at 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

Well I've tried a number of different permissions , uid , gid 

What I have are mail server permissions on the spool folders where the users
are virtual.

The mail server runs under exim:mail and I have tried unique uid:gid and
exim:mail uid:gid To access the directories as well as the folder
permissions 770 750 etc. 

Dovecot is running as it's own user (imapd) 

What should they be working as ?

Maybe I missed something in the docs.

Gary

-----Original Message-----
From: dovecot-bounces at dovecot.org [mailto:dovecot-bounces at dovecot.org] On
Behalf Of David S. Madole
Sent: Tuesday, March 09, 2004 1:30 PM
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 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