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
------------------------------------------------------------------------------
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
