NO Login failed: generic failure

[Marc Fournier]

On Mar 26, 2014, at 11:25 , Dan White <dwhite at olp.net> wrote:

>> 
> 
> Add 'sasl_log_level: 7' to imapd.conf, and verify your syslog daemon is
> logging 'auth.*’.

With sasl_log_level set to 7, master restarted:

Mar 26 19:47:17 xxx imap[1448]: Could not open db 
Mar 26 19:47:17 xxx imap[1448]: sql plugin Parse the username sales at xxx.info
Mar 26 19:47:17 xxx imap[1448]: sql plugin try and connect to a host
Mar 26 19:47:17 xxx imap[1448]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host '' 
Mar 26 19:47:17 xxx imap[1448]: begin transaction
Mar 26 19:47:17 xxx imap[1448]: sql plugin create statement from userPassword sales xxx.info
Mar 26 19:47:17 xxx imap[1448]: sql plugin doing query SELECT userPassword FROM sasl_auth WHERE userid = 'sales at xxx.info';
Mar 26 19:47:17 xxx imap[1448]: sql plugin create statement from cmusaslsecretPLAIN sales xxx.info
Mar 26 19:47:17 xxx imap[1448]: sql plugin doing query SELECT cmusaslsecretPLAIN FROM sasl_auth WHERE userid = 'sales at xxx.info';
Mar 26 19:47:17 xxx imap[1448]: sql plugin: no such column: cmusaslsecretPLAIN 
Mar 26 19:47:17 xxx imap[1448]: commit transaction
Mar 26 19:47:17 xxx imap[1448]: sql plugin Parse the username sales at xxx.info
Mar 26 19:47:17 xxx imap[1448]: sql plugin try and connect to a host
Mar 26 19:47:17 xxx imap[1448]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host '' 

‘k, so “Could not open db” … useful, but why not?  Which db?  From the command line, as user ‘cyrus’:

# su - cyrus
% ls -ld /var/db/sqlite/mailsys
-rw-r--r--  1 root  wheel  8192 Mar 26 07:52 /var/db/sqlite/mailsys
% sqlite /var/db/sqlite/mailsys
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> select count(1) from sasl_auth;
11
sqlite> % 

But, if it can’t open the db (or is that for a different db?), then how does it know that the first query works fine, but the second one is missing a column?  It has to open the db to do that … unless, again, the ‘Could not open’ is trying to open a different db?







-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20140326/212ecbe1/attachment-0001.html