>From: "Jay Lee" <[EMAIL PROTECTED]> >To: "Jim Douglas" <[EMAIL PROTECTED]> >CC: [email protected] >Subject: Re: [courier-users] login error >Date: Mon, 2 Oct 2006 10:26:22 -0400 (EDT) > >On Mon, October 2, 2006 10:15 am, Jim Douglas wrote: > > 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? > >Set DEBUG_LOGIN=2 in authdaemonrc and restart courier-authlib. That >should give some more verbose errors and help pinpoint the problem. > >Jay >-- >Jay Lee >Network / Systems Administrator >Information Technology Dept. >Philadelphia Biblical University >--
This is from the log, it is definately a problem. How does this query get built? What should it return in the columns? Oct 2 11:41:58 cpe-22-22-222-222 authdaemond: SQL query: SELECT id, crypt, clear, uid, gid, home, "", "", name, "" FROM dbmail_users WHERE id = "foo" In my SASL smtp.conf I have SELECT passwd FROM dbmail_users WHERE userid = '%u' (Which authenticated successfully when I tested SASL on the server) Thanks, 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
