I'm in the process of installing a mailserver using postfix,courier,mysql, etc. I'm getting very close but I'm stuck when I try to test courier authentication to mysql. According to my maillog, authdaemond keeps appending a '.' to my login name 'vmail' and my database called 'mail'. I've made sure my
/etc/courier/authmysqlrc
Code:
MYSQL_SERVER 127.0.0.1
MYSQL_USERNAME vmail
MYSQL_PASSWORD vmail
MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
DEFAULT_DOMAIN examples.com
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD login
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
MYSQL_QUOTA_FIELD quota
Here's the error:
Code:
Aug 28 22:29:18 mail1 authdaemond: Installing libauthmysql
Aug 28 22:29:18 mail1 authdaemond: Installation complete: authmysql
Aug 28 22:29:19 mail1 postfix/postfix-script[7546]: starting the Postfix mail system
Aug 28 22:29:20 mail1 postfix/master[12482]: daemon started -- version 2.6-20090125, configuration /etc/postfix
Aug 28 22:31:19 mail1 authdaemond: failed to connect to mysql server (server=127.0.0.1, userid=vmail.): Access denied for user 'vmail.'@'localhost' (using password: YES)
Aug 28 22:38:16 mail1 authdaemond: authmysql: mysql_select_db(mail.) error: Incorrect database name 'mail.'