View Single Post
  #1   (View Single Post)  
Old 28th August 2009
revzalot's Avatar
revzalot revzalot is offline
Shell Scout
Join Date: May 2008
Posts: 123
Default Courier IMAP/POP3 can't auth to mysql db

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

MYSQL_USERNAME          vmail
MYSQL_PASSWORD          vmail
MYSQL_PORT              3306    
MYSQL_OPT               0
MYSQL_DATABASE          mail    
MYSQL_USER_TABLE        users   
MYSQL_CRYPT_PWFIELD     password        
MYSQL_UID_FIELD         uid
MYSQL_GID_FIELD         gid
MYSQL_LOGIN_FIELD       login   
MYSQL_HOME_FIELD        home
MYSQL_NAME_FIELD        name
Here's the error:
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=, 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.'
Reply With Quote