Mark Constable writes:

courier-imap 4.15-1 and courier-authdaemon 0.66.1 on Ubuntu 14.10

I can't for the life of me figure out why MYSQL_MAILDIR_FIELD / maildir
is not returning a value?

Oct 3 11:59:41 netserva authdaemond: SQL query: SELECT username, "", password, uid, gid, homedir, "", quota, "", "" FROM mail_users WHERE username = 'ma...@netserva.goldcoast.org' Oct 3 11:59:41 netserva authdaemond: Authenticated: sysusername=<null>, sysuserid=1, sysgroupid=1, homedir=/var/customers/mail/, address=ma...@netserva.goldcoast.org, fullname=<null>, maildir=<null>, quota=100000000S, options=<null> Oct 3 11:59:41 netserva authdaemond: Authenticated: clearpasswd=xxxxxxxx, passwd=<null>

~ cat /etc/courier/authmysqlrc
MYSQL_CLEAR_PWFIELD     password
MYSQL_DATABASE          netserva
MYSQL_GID_FIELD         gid
MYSQL_HOME_FIELD        homedir
MYSQL_LOGIN_FIELD       username
MYSQL_MAILDIR_FIELD     maildir
MYSQL_PASSWORD          xxxxxxxx
MYSQL_PORT              3306
MYSQL_QUOTA_FIELD       quota
MYSQL_SERVER            127.0.0.1
MYSQL_UID_FIELD         uid
MYSQL_USERNAME          netserva
MYSQL_USER_TABLE        mail_users

~ mysql -BNe "explain mail_users" netserva
id      int(11) NO      PRI     NULL    auto_increment
email   varchar(255)    NO      UNI
username        varchar(255)    NO
password        varchar(128)    NO
password_enc    varchar(128)    NO
uid     int(11) NO              0
gid     int(11) NO              0
homedir varchar(255)    NO
maildir varchar(255)    NO
postfix enum('Y','N')   NO              Y
domainid        int(11) NO              0
customerid      int(11) NO              0
quota   varchar(15)     NO              0
pop3    tinyint(1)      NO              1
imap    tinyint(1)      NO              1
mboxsize        bigint(30)      NO              0

~ mysql -BNe "select homedir,maildir from mail_users" netserva
/var/customers/mail/    markc/netserva.goldcoast.org/markc/Maildir

~ ll /var/customers/mail/markc/netserva.goldcoast.org/markc/Maildir
total 0
drwx------ 1 daemon daemon 0 Oct  3 11:28 cur/
drwx------ 1 daemon daemon 0 Oct  3 11:28 new/
drwx------ 1 daemon daemon 0 Oct  3 11:28 tmp/

~ grep DEFAULT /etc/courier/courierd (truncated)
courierd:DEFAULTDELIVERY="| /usr/bin/maildrop"
courierd:MAILDROPDEFAULT=./Maildir

What's courierd doing here? You said that you are running the courier-imap package, at the beginning.

This is probably a packaging issue with different/duplicated packages, using different configuration directories.

The pristine tarball's default configuration should be putting all the configuration files in /usr/local/etc/authlib. The RPM package configure courier-authlib to use /etc/authlib.

You need to double-check where the Ubuntu package puts things.

Attachment: pgpiViMak4lBo.pgp
Description: PGP signature

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to