DaemonForums  

Go Back   DaemonForums > OpenBSD > OpenBSD Packages and Ports

OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   (View Single Post)  
Old 28th August 2009
revzalot's Avatar
revzalot revzalot is offline
Shell Scout
 
Join Date: May 2008
Posts: 123
Thanked 1 Time in 1 Post
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

/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.'
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Smtp Auth Help needed roundkat OpenBSD General 4 8th May 2009 08:25 PM
Problem with Postfix and Sasl auth unixbsd OpenBSD General 1 27th April 2009 03:26 AM
Courier IMAP Different MD5 version jrs665 OpenBSD Packages and Ports 3 30th October 2008 12:34 PM
fetchmail: POP3< -ERR internal server error graudeejs FreeBSD General 3 19th July 2008 02:02 PM
FAM keeps crashing with courier-imap krreagan FreeBSD General 0 14th May 2008 11:15 PM


All times are GMT. The time now is 07:01 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick