On Mon, October 2, 2006 9:23 am, Jim Douglas wrote: > I have verified SALS on the server is working, I get this error logging > in from a web client, I tried 'localhost' and the domain name. these are > the errors, > > Oct 2 08:44:23 cpe-22-22-22-222 imapd: Connection, > ip=[::ffff:22.22.22.222] > Oct 2 08:44:23 cpe-22-22-22-222 authdaemond: authmysql: > mysql_select_db(mysql) error: Access denied for user 'dbmail'@'localhost' > to database 'mysql' Oct 2 08:44:23 cpe-22-22-22-222 imapd: LOGIN FAILED, > user=pr, ip=[::ffff:22.22.22.222] > Oct 2 08:44:23 cpe-22-22-22-222 imapd: authentication error: Input/output > error > > ..with the domain name I get, > > > Oct 2 09:10:12 cpe-22-22-222-222 authdaemond: failed to connect to mysql > server (server=www.mysite.org, userid=dbmail): Access denied for user > 'dbmail'@'cpe-22-22-222-222.phi.res.rr.com' (using password: YES) > Oct 2 09:10:12 cpe-22-22-222-222 imapd: LOGIN FAILED, user=pe, > ip=[::ffff:22.22.222.222] > Oct 2 09:10:12 cpe-22-22-222-222 imapd: authentication error: > Input/output > error > > > What am I missing? > > > ...these are the authmysqlrc I changed, > > > MYSQL_SERVER www.mysite.org > MYSQL_USERNAME dbmail > MYSQL_PASSWORD mypassword > MYSQL_DATABASE dbmail > MYSQL_USER_TABLE dbmail_users
Courier-authlib can't connect to the MySQL server in order to lookup account info. The MySQL server is responding that the username/password Courier-authlib supplied (MYSQL_USERNAME and MYSQL_PASSWORD) is invalid. Verify that this username/password works by using the mysql command line client: #mysql -p dbmail Until this is working, Courier won't work. Also, if this is all one system, and your dbmail mysql user only has local access to the MySQL database, you need to change MYSQL_SERVER to localhost instead of the DNS name or IP address, otherwise MySQL Server will believe it to be a remote system connecting and will reject the login. Jay -- Jay Lee Network / Systems Administrator Information Technology Dept. Philadelphia Biblical University -- ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
