NO Login failed: generic failure

[Mogens Melander]

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 at 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 = 'xxx at 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


-- 
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.