I have two servers, both with identical configurations, right down to their imapd.conf files … both use sqlite to store auth information …
Both running on FreeBSD 10.x, and versions of imapd/sasl are the same: cyrus-imapd24-2.4.17_4/ cyrus-sasl-2.1.26_5 One works great, nary a problem … the other, I get the above message when I try and authenticate. And I can’t find anything different … I’ve checked permissions on the various files, etc … /var/log # telnet localhost imap Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ ID ENABLE STARTTLS AUTH=SCRAM-SHA-1 AUTH=DIGEST-MD5 AUTH=CRAM-MD5 AUTH=LOGIN AUTH=PLAIN SASL-IR] xxx.xxx Cyrus IMAP v2.4.17 server ready . login x...@xxx.xxx xxx . NO Login failed: generic failure . logout * BYE LOGOUT received . OK Completed Connection closed by foreign host. /var/log/debug.log shows: == Mar 26 16:09:08 xxx imap[67279]: SQL backend defaulting to engine 'sqlite' Mar 26 16:09:08 xxx imap[67279]: executed Mar 26 16:09:08 xxx imap[67279]: sql auxprop plugin using sqlite engine Mar 26 16:09:08 xxx imap[67279]: IOERROR: opening /var/spool/imap/user_deny.db: No such file or directory Mar 26 16:09:08 xxx imap[67279]: accepted connection Mar 26 16:09:36 xxx imap[67279]: accepted connection Mar 26 16:09:49 xxx imap[67279]: sql plugin Parse the username x...@xxx.xxx Mar 26 16:09:49 xxx imap[67279]: sql plugin try and connect to a host Mar 26 16:09:49 xxx imap[67279]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host '' Mar 26 16:09:49 xxx imap[67279]: begin transaction Mar 26 16:09:49 xxx imap[67279]: sql plugin create statement from userPassword xxx xxx.xxx Mar 26 16:09:49 xxx imap[67279]: sql plugin doing query SELECT userPassword FROM sasl_auth WHERE userid = 'x...@xxx.xxx'; Mar 26 16:09:49 xxx imap[67279]: sql plugin create statement from cmusaslsecretPLAIN xxx xxx.xxx Mar 26 16:09:49 xxx imap[67279]: sql plugin doing query SELECT cmusaslsecretPLAIN FROM sasl_auth WHERE userid = 'x...@xxx.xxx'; Mar 26 16:09:49 xxx imap[67279]: sql plugin: no such column: cmusaslsecretPLAIN Mar 26 16:09:49 xxx imap[67279]: commit transaction Mar 26 16:09:49 xxx imap[67279]: sql plugin Parse the username x...@xxx.xxx Mar 26 16:09:49 xxx imap[67279]: sql plugin try and connect to a host Mar 26 16:09:49 xxx imap[67279]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host '' /var/log/messages shows: Mar 26 16:09:49 rdfund imap[67279]: badlogin: xxx [200.46.208.227] plaintext x...@xxx.xxx SASL(-1): generic failure: checkpass failed I’ve even tried su’ng to the cyrus user and running the sql command against the database, and it returns the right database: % echo "SELECT userPassword FROM sasl_auth WHERE userid = ‘x...@xxx.xxx';" | sqlite /var/db/sqlite/mailsys rightPW % I’ve double checked the imapd.conf files, and they are identical except different admins: and one has tls_* lines in it … but I’m having the identical issue with *another* server, and it doesn’t have the tls_* lines … I figure I have to be overlooking *something* stupid, but I’m at a loss as to what it could be … I’ve even checked md5 on imapd between both working / non-working … identical … Is there any way of getting more debug information out of the backend without modifying the code itself? Thanks ...
---- Cyrus Home Page: http://www.cyrusimap.org/ List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/ To Unsubscribe: https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
