4 messages in net.sourceforge.lists.courier-users[courier-users] Problem using authlib...
FromSent OnAttachments
Christopher HartungAug 17, 2007 11:18 am 
Sam VarshavchikAug 17, 2007 2:26 pm 
Christopher HartungAug 18, 2007 7:29 am 
Enda CronnollyAug 18, 2007 9:46 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:[courier-users] Problem using authlib-mysql and authdaemondActions...
From:Christopher Hartung (chma@googlemail.com)
Date:Aug 17, 2007 11:18:40 am
List:net.sourceforge.lists.courier-users

Hi there,

i've a little problem using courier in associate with authlib-mysql. I'm using Fedora core 3 and compiled all the courier stuff (courier and courier-authlib) for myself. After compiling i installed the following packages:

courier-authlib-0.59.3-10.fc3 courier-authlib-userdb-0.59.3-10.fc3 courier-maildrop-wrapper-0.56.0-1.3 courier-authlib-pipe-0.59.3-10.fc3 courier-authlib-mysql-0.59.3-10.fc3 courier-authlib-debuginfo-0.59.3-10.fc3 courier-0.56.0-1.3 courier-imapd-0.56.0-1.3 courier-mysql-0.56.0-1.3 courier-authlib-devel-0.59.3-10.fc3 courier-maildrop-0.56.0-1.3 courier-debuginfo-0.56.0-1.3

My authmysqlrc - config looks like this:

MYSQL_SERVER 127.0.0.1 MYSQL_USERNAME syscp MYSQL_PASSWORD ****** MYSQL_PORT 0 MYSQL_DATABASE syscp MYSQL_USER_TABLE mail_users MYSQL_CRYPT_PWFIELD password_enc MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD username MYSQL_HOME_FIELD homedir MYSQL_MAILDIR_FIELD maildir MYSQL_WHERE_CLAUSE postfix='Y'

My problem is that authdaemond creates a sql-statement to get information of the user like this:

*Aug 16 18:00:56 vs249166 authdaemond: SQL query: SELECT username, password_enc, "", uid, gid, homedir, "", "", "", "" FROM mail_users WHERE username = "te@domain.tld <mailto:te@domain.tld>" AND (postfix='Y')*

So the authdaemond isn't using the MYSQL_MAILDIR_FIELD parameter. I also changed the config-files like imapd so that MAILDIRPATH isn't used. But the problem is still there. Do you know problems like this? Did i misconfigured something?

Thanks for your answers

Greetings chris