Burak Yýlmaz wrote:
Hi all;
I have set up postfix with all its modules...There is a problem about courier
configuration..My log says;
SQL query: SELECT email, crypt, "", uid, gid, homedir, "", "", name, "" FROM
postfix_users WHERE email = "bur...@albumx.com"
Apr 19 08:18:28 albumx authdaemond: password matches successfully
Apr 19 08:18:28 albumx authdaemond: authmysql: sysusername=<null>,
sysuserid=1003, sysgroupid=1003, homedir=/usr/local/vmail/,
address=burak@albumx, fullname=BurakYILMAZ, maildir=<null>, quota=<null>,
options=<null>
Apr 19 08:18:28 albumx authdaemond: authmysql: clearpasswd=<null>,
passwd=Pcu0z6tOC3bhw
Apr 19 08:18:28 albumx authdaemond: Authenticated: sysusername=<null>,
sysuserid=1003, sysgroupid=1003, homedir=/usr/local/vmail/,
address=burak@albumx, fullname=BurakYILMAZ, maildir=<null>, quota=<null>,
options=<null>
Apr 19 08:18:28 albumx authdaemond: Authenticated: clearpasswd=xxxxx,
passwd=Pcu0z6tOC3bhw
Apr 19 08:18:28 albumx pop3d: chdir Maildir: No such file or directory
As you see above i can get authenticated...But because of the SQL QUERY above it
cannot get "maildir" field from database
I am searching where this query stored...I must edit it and add maildir to its
select statament
I have looked inside "authmysqlrc" file but query is not there!
How am i going to edit this SQL QUERY?
the file should be authmysqlrc, now you need to find which directory it
is in. This depends on your system/installation/build.
look in /path/to/authdaemond and see where it looks for authdaemonrc.
authmysqlrc should be in the same dir.
# grep authdaemonrc `which authdaemond`