You got your answer in: sql plugin: no such column: cmusaslsecretPLAIN I've been there.. Edit your SQL to match your DB layout. On Wed, March 26, 2014 17:27, Marc Fournier wrote: > > 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 … > > 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 = 'xxx@xxxxxxx'; > 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 = 'xxx@xxxxxxx'; > Mar 26 16:09:49 xxx imap[67279]: sql plugin: no such column: > cmusaslsecretPLAIN > Mar 26 16:09:49 xxx imap[67279]: commit transaction -- Mogens Melander +66 8701 33224 BTW. I would prefere (prefere, not being a proper English word, substitute with: like ) to receive e-mail in plain text. Please look for an option, to associate, mail to me, with plain text. Thank you. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---- 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
