8 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Courier and Mysql
FromSent OnAttachments
jaredSep 3, 2002 4:39 pm 
Sam VarshavchikSep 3, 2002 5:55 pm 
Michael L. BarrowSep 3, 2002 6:47 pm 
Hor Hen LeySep 3, 2002 7:13 pm 
Hor Hen LeySep 3, 2002 11:27 pm 
Hor Hen LeySep 3, 2002 11:32 pm 
Roland SchneiderSep 4, 2002 2:13 am 
jaredSep 4, 2002 11:14 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] Courier and MysqlActions...
From:Roland Schneider (list@serv.ch)
Date:Sep 4, 2002 2:13:39 am
List:net.sourceforge.lists.courier-users

--jared wrote on 03.09.2002 16:33 -0700:

the authmysqlrc contains:

a big mess...

MYSQL_SERVER 10.1.10.20 #This is the local IP just switched it for more testing used to be localhost MYSQL_USERNAME postfix

the above wont work. dont invent _any_ additional whitespaces nor anything else. but you should leave that line at 'localhost' anyway.

MYSQL_CRYPT_PWFIELD crypt MYSQL_CLEAR_PWFIELD clear #at first this was commented out but since I could not get crytp to work I tried this also. MYSQL_UID_FIELD uid

the above wont work. read the comments in that file again.

MYSQL_GID_FIELD gid

you also missed the uid.

Now when I telnet into port 110 and try and authencate I fail. I use the user name in the ID field and the password in the crypt field. I have checked my logs and they only say Sep 3 16:28:48 mail pop3d: LOGIN FAILED, ip=[::ffff:10.1.0.17]

fix your authmysqlrc (every single line!), and then use courier's authtest and mysql's query-log.

Roland