<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br><div><div>On Mar 26, 2014, at 11:25 , Dan White <<a href="mailto:dwhite@olp.net">dwhite@olp.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><blockquote type="cite"><br></blockquote><br>Add 'sasl_log_level: 7' to imapd.conf, and verify your syslog daemon is<br>logging 'auth.*’.<br></blockquote><div><br></div><div>With sasl_log_level set to 7, master restarted:</div><div><br></div><div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: Could not open db </div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin Parse the username <a href="mailto:sales@xxx.info">sales@xxx.info</a></div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin try and connect to a host</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host '' </div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: begin transaction</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin create statement from userPassword sales xxx.info</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin doing query SELECT userPassword FROM sasl_auth WHERE userid = '<a href="mailto:sales@xxx.info">sales@xxx.info</a>';</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin create statement from cmusaslsecretPLAIN sales xxx.info</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin doing query SELECT cmusaslsecretPLAIN FROM sasl_auth WHERE userid = '<a href="mailto:sales@xxx.info">sales@xxx.info</a>';</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin: no such column: cmusaslsecretPLAIN </div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: commit transaction</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin Parse the username <a href="mailto:sales@xxx.info">sales@xxx.info</a></div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin try and connect to a host</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Mar 26 19:47:17 xxx imap[1448]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host '' </div><div><br></div><div>‘k, so “Could not open db” … useful, but why not? Which db? From the command line, as user ‘cyrus’:</div><div><br></div><div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);"># su - cyrus</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">% ls -ld /var/db/sqlite/mailsys</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">-rw-r--r-- 1 root wheel 8192 Mar 26 07:52 /var/db/sqlite/mailsys</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">% sqlite /var/db/sqlite/mailsys</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">SQLite version 2.8.17</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">Enter ".help" for instructions</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">sqlite> select count(1) from sasl_auth;</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">11</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">sqlite> % </div></div><div><br></div><div>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?</div><div><br></div><div><br></div></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div></body></html>