4 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Unable to connect...
FromSent OnAttachments
Christopher ChengAug 9, 2001 2:12 am 
Sam VarshavchikAug 9, 2001 5:03 am 
Roland SchneiderAug 9, 2001 5:16 am 
ves...@tana.itAug 9, 2001 5:24 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] Unable to connect to MySQLActions...
From:Roland Schneider (rol@serv.ch)
Date:Aug 9, 2001 5:16:42 am
List:net.sourceforge.lists.courier-users

--Christopher Cheng wrote on 09.08.2001 17:12 +0800: [...]

then I renamed "/usr/lib/courier/etc/authdaemonrc.dist" to "/usr/lib/courier/etc/authdaemonrc"

You should have a line have there: authmodulelist="authmysql"

and everywhere else: authmodulelist="authdaemon"

"/usr/lib/courier/etc/authmysqlrc.dist" to "/usr/lib/courier/etc/authmysqlrc" and changed the settings to

MYSQL_SERVER localhost MYSQL_USERNAME admin MYSQL_USERNAME admin

You dont need this twice, but should do no harm :)

[...]

mysql>grant all on *.* to admin@localhost identified by 'admin';

And reloaded the grant-tables in mysql ?

mysql>insert into passwd values ('password', 1, 1, 'christopher', '', '', 1000);

You set both uid and gid to 1 (which is 'daemon' on BSD), and left HOME and MAIL empty with only 1000 bytes quota. Dont know if this is the only problem, but it will never work in the real world.

Finally I restarted the authmysql daemon

/usr/lib/courier/libexec/authlib/authdaemond.mysql stop /usr/lib/courier/libexec/authlib/authdaemond.mysql start

Then, I use Outlook Express to connect to it and it says "Login failed"

Try `authtest christopher password` (in src/authlib) but first fix up your HOME and make shure the ./Maildir is owned by the selected UID.

Anybody has a clue? By the way, where is the default log file for auth?

There should something like this in your mysql-log:

Connect admin@localhost on SELECT id, crypt, plain, uid, gid, home, maildir, "", name FROM ...

Roland