Thanks!so much! I really appreciate your help and sharing of experience. With ur suggestion, I doubl-checked my authmysqlrc file and really got two careless trailing spaces, after removing them, logging in has no problem already.
Hope other struggling ppl found who met the same problem saw this post asap, and good luck to all of u guys who are now working with courier, including me!
cheers!
From: "David Ziggy Lubowa" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Subject: Re: [courier-users] Courier + POP3 + MYSQL authentication problem Date: Mon, 28 Jul 2003 13:22:03 +0300 (EAT)
I had a similar problem , it took me 2 weeks :( , there where trailing spaces in the authmysqlrc file so i could never authenticate, i think this issue has to be sorted out, please have a look at your authmysqlrc file and make sure there are no trailing spaces ( abit hard to find, you might want to get a new authmysqlrc file and edit it carefully , and also configure your my.cnf file to log the connections to the database. Also set logging to some of those courier-imap files i forget which ones but if you read most of them IIRC pop3-ssl and pop3 plus imap $$ imap-ssl allow logging.
good luck
> I have just installed courier_0.42.2(the complete package) with mysql > support(tried both mysql_3.23.5/MySQL-4.0.14-0) for authentication, my > configuration is listed as follows: > ./configure \ > --with-authmysql=yes \ > --without-authchangepwdir \ > --with-mysql-libs=/usr/mysql/lib/mysql \ > --without-IPv6 \ > --without-SSL \ > --enable-dependency-tracking \ > --with-mysql-includes=/usr/mysql/include/mysql > > After installation, I configured whatever necessary for using mysql as > authentication module-- > 1. authmodulelist: authdaemon authmysql > 2. authdaemonrc: authmodulelist="authmysql" > version="authdaemond.mysql" 3. authmysqlrc: configuration for mysql > connection(I am sure all > correct) > 4. Create table in mysql database(format is correct) > > Then I started courier as follows: > ./libexec/authlib/authdaemond start > ./sbin/courier start > ./sbin/pop3d start > > > Couier-pop3 actually started, and authdaemon.mysql started by > authdaemond > > Finally, I use "telnet localhost 110" to test a user account, it > returns me-- > etc]$ telnet localhost 110 > Trying 127.0.0.1... > Connected to localhost. > Escape character is '^]'. > +OK Hello there. > user test > +OK Password required. > pass test > -ERR Login failed. > > The more strange thing is that when I check the status of file > "authmysqlrc", it seems never read by courier when a user tried to log > in by telnet.......I have struggled on this problem for one whole week > and hasn't got the answer. Does anyone know what's the step missing in > my installation and configuration? I've re-install by romving older > installation compelely for many times, but never works. Anyone's > suggestion will be appreciated! > > _________________________________________________________________ > Find gifts, buy online with MSN Shopping. http://shopping.msn.com.sg/ > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click- url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > courier-users mailing list > [EMAIL PROTECTED] > Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
-- David Ziggy Lubowa Network Engineer One2net ----------------------------------- A Network Of People And Technology
_________________________________________________________________
Get 10mb of inbox space with MSN Hotmail Extra Storage http://join.msn.com/?pgmarket=en-sg
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
