Hi all, Im having problems with sieve. Users cant authenticate. imap, cyradm and postfix smtpauth all work . Im using pam_mysql and saslauthd.
heres the log entries: <START> ar 12 14:54:08 gabrielle saslauthd[8125]: pam_sm_authenticate called. Mar 12 14:54:08 gabrielle saslauthd[8125]: dbuser changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: dbpasswd changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: host changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: database changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: table changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: usercolumn changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: passwdcolumn changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: crypt changed. Mar 12 14:54:08 gabrielle saslauthd[8125]: db_connect called. Mar 12 14:54:08 gabrielle saslauthd[8125]: returning 0 . Mar 12 14:54:08 gabrielle saslauthd[8125]: db_checkpasswd called. Mar 12 14:54:08 gabrielle saslauthd[8125]: pam_mysql: where clause = Mar 12 14:54:08 gabrielle saslauthd[8125]: SELECT password FROM real_user WHERE username='test' Mar 12 14:54:08 gabrielle saslauthd[8125]: sqlLog called. Mar 12 14:54:08 gabrielle saslauthd[8125]: pam_mysql: error: sqllog set but logtable not set Mar 12 14:54:08 gabrielle saslauthd[8125]: pam_mysql: error: sqllog set but logmsgcolumn not set Mar 12 14:54:08 gabrielle saslauthd[8125]: pam_mysql: error: sqllog set but logusercolumn not set Mar 12 14:54:08 gabrielle saslauthd[8125]: pam_mysql: error: sqllog set but loghostcolumn not set Mar 12 14:54:08 gabrielle saslauthd[8125]: pam_mysql: error: sqllog set but logtimecolumn not set Mar 12 14:54:08 gabrielle saslauthd[8125]: returning 0 . Mar 12 14:54:08 gabrielle saslauthd[8125]: returning 0. Mar 12 14:54:08 gabrielle saslauthd[8125]: AUTHFAIL: user=test service=sieve realm= [PAM acct error] Mar 12 14:54:08 gabrielle timsieved[9297]: Password verification failed Mar 12 14:54:09 gabrielle timsieved[9297]: badlogin: localhost.localdomain[127.0.0.1] PLAIN authentication failure <STOP> Seems that timsieved needs realm but the others dont? Heres the version info <START> name : Cyrus IMAPD version : v2.1.12 2003/02/03 20:43:58 vendor : Project Cyrus support-url: http://asg.web.cmu.edu/cyrus os : Linux os-version : 2.4.19-xfs environment: Cyrus SASL 2.1.12 Sleepycat Software: Berkeley DB 4.1.25: (December 19, 2002) OpenSSL 0.9.7a Feb 19 2003 CMU Sieve 2.2 mmap = shared lock = fcntl nonblock = fcntl auth = unix idle = poll mboxlist.db = db3 subs.db = flat seen.db = flat duplicate.db = db3-nosync tls.db = db3-nosync <STOP> Any advise appeciated Stuart
