On Mar 26, 2014, at 11:25 , Dan White <dwhite@xxxxxxx> wrote:
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@xxxxxxxx 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@xxxxxxxx'; 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@xxxxxxxx'; 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@xxxxxxxx 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? |
---- 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
