>From: "Jay Lee" <[EMAIL PROTECTED]> >To: "Jim Douglas" <[EMAIL PROTECTED]> >CC: [email protected] >Subject: Re: [courier-users] login error >Date: Mon, 2 Oct 2006 09:29:15 -0400 (EDT) > >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
No problem connecting with un/pw, mysql -p dbmail I tried "localhost" initially because everything is on the same server..... I have since changed, MYSQL_PORT 3306 MYSQL_CLEAR_PWFIELD clear Oct 2 10:12:00 cpe-22-22-22-222 imapd: Connection, ip=[::ffff:22.22.22.222] Oct 2 10:12:00 cpe-22-22-22-222 imapd: LOGIN FAILED, user=foo, ip=[::ffff:22.22.22.222] Oct 2 10:12:00 cpe-22-22-22-222 imapd: authentication error: Input/output error Oct 2 10:12:10 cpe-22-22-22-222 imapd: Connection, ip=[::ffff:22.22.22.222] Oct 2 10:12:10 cpe-22-22-22-222 imapd: LOGIN FAILED, user=pe, ip=[::ffff:22.22.22.222] Oct 2 10:12:10 cpe-22-22-22-222 imapd: authentication error: Input/output error The above error looks like the connection is ok, but the users are not. But they are in the db... What next? Jim ------------------------------------------------------------------------- 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
