Ok, now I have built the rpm's successfully under
non-root
installed the rpm's as root.
I can connect to the port just fine.
I login with uname and pwd and get Login
Failed. Always.
Logs in mysql show that the data is getting pulled. Authtest <uname> <pwd> comes back with data. What's up.
1.5.3 with pop3 and authdaemond.mysql.
NOTE: I
have cut out all of the comments. It does not work with them so what
you are seeing is the non-commented schtuff. The authmysqlrc has "1" space
separating the variable from the value with nothing at the end.
---------------------------------------------
authdaemonrc
authmodulelist="authmysql"
authmodulelistorig="authmysql"
daemons=1
version="authdaemond.mysql"
authdaemonvar=/var/run/authdaemon.courier-imap
----------------------------------------------
authmodulelistorig="authmysql"
daemons=1
version="authdaemond.mysql"
authdaemonvar=/var/run/authdaemon.courier-imap
----------------------------------------------
authmysqlrc
MYSQL_SERVER localhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfix
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_OPT 0
MYSQL_DATABASE maildb
MYSQL_USER_TABLE users
MYSQL_CLEAR_PWFIELD clear
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD id
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
----------------------------------------------
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfix
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_OPT 0
MYSQL_DATABASE maildb
MYSQL_USER_TABLE users
MYSQL_CLEAR_PWFIELD clear
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD id
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
----------------------------------------------
pop3d
PIDFILE=/var/run/pop3d.pid
MAXDAEMONS=40
MAXPERIP=4
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
POP3AUTH=""
POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1"
POP3AUTH_TLS=""
POP3AUTH_TLS_ORIG="LOGIN PLAIN"
PORT=110
ADDRESS=0
TCPDOPTS="-nodnslookup -noidentlookup"
POP3DSTART=YES
MAXDAEMONS=40
MAXPERIP=4
AUTHMODULES="authdaemon"
AUTHMODULES_ORIG="authdaemon"
POP3AUTH=""
POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1"
POP3AUTH_TLS=""
POP3AUTH_TLS_ORIG="LOGIN PLAIN"
PORT=110
ADDRESS=0
TCPDOPTS="-nodnslookup -noidentlookup"
POP3DSTART=YES
----------------------------------------------
(tail
of authdaemond.mysql
trace)
0.001018 read(6,
"\6daniel\rqxEFB7i2UXtoY\3foo\0041002\0041002\22/data/mail/daniel/\0\0\6Daniel",
63)
= 63
0.001311 read(6, "\1\0\0\r", 4) = 4
0.001055 read(6, "\376", 1) = 1
0.040044 select(5, NULL, [4], NULL, {10, 0}) = 1 (out [4], left {10, 0})
0.002197 write(4, "FAIL\n", 5) = 5
0.001354 close(4) = 0
0.026142 select(9, [5 8], NULL, NULL, {300, 0} <unfinished ...>
0.001311 read(6, "\1\0\0\r", 4) = 4
0.001055 read(6, "\376", 1) = 1
0.040044 select(5, NULL, [4], NULL, {10, 0}) = 1 (out [4], left {10, 0})
0.002197 write(4, "FAIL\n", 5) = 5
0.001354 close(4) = 0
0.026142 select(9, [5 8], NULL, NULL, {300, 0} <unfinished ...>
----------------------------------------------
mysql.log
020927 7:13:21
75 Query SELECT id, "", clear, uid, gid,
home, maildir, "", name FROM users WHERE id = "daniel "
Help please as I
have beat myself with a hammer numerous times and I am loosing brain cells
quickly.
Thanks,
Daniel
