<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;"><div><br></div>Never has been, nor is there on the working system … I don’t even know where that query is coming from, as my imapd.conf has:<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);">pwcheck_method: auxprop</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">auxprop_plugin: sql</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0); min-height: 14px;"><br></div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">sasl_sql_engine: sqlite</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">sasl_sql_database: /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);">sasl_sql_select: SELECT %p FROM sasl_auth WHERE userid = '%u@%r'</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">sasl_sql_insert: INSERT INTO sasl_auth ( userid, %p, domain ) VALUES ( '%u@%r', '%v' )</div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">sasl_sql_update: UPDATE sasl_auth SET %p = '%v' WHERE userid = '%u@%r'</div><div><br></div><div>this is the same config on both system, and even lookign on the *good* system (that I’m reading / sending this through) at its /var/log/debug.log, I see it doing that extra query, but, again, no idea where it is coming from … its not something I wrote … only the first query is:</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 14:02:37 hub pop3[75904]: 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 14:02:37 hub pop3[75904]: sql plugin create statement from userPassword ams <a href="http://hub.org">hub.org</a></div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0); position: static; z-index: auto;">Mar 26 14:02:37 hub pop3[75904]: sql plugin doing query SELECT userPassword FROM sasl_auth WHERE userid = '<a href="mailto:ams@hub.org">ams@hub.org</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 14:02:37 hub pop3[75904]: sql plugin create statement from cmusaslsecretPLAIN ams <a href="http://hub.org">hub.org</a></div><div style="margin: 0px; font-size: 10px; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0); position: static; z-index: auto;">Mar 26 14:02:37 hub pop3[75904]: sql plugin doing query SELECT cmusaslsecretPLAIN FROM sasl_auth WHERE userid = '<a href="mailto:ams@hub.org">ams@hub.org</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 14:02:37 hub pop3[75904]: 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 14:02:37 hub pop3[75904]: commit transaction</div></div><div><br></div><div><br></div><div><br></div><div><br></div><div><div>On Mar 26, 2014, at 10:11 , Helmut Weigel <<a href="mailto:helmut.weigel@dfb-medien.de">helmut.weigel@dfb-medien.de</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="DE" link="blue" vlink="purple" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div class="WordSection1" style="page: WordSection1;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Hi,<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">the problem is located in your SQL Database. The Error Message says:<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">There’s no colum cmusaslsecretPLAIN<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Double Check your Database<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">Regards Helmut<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><span lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);"> </span></div><div><div style="border-style: solid none none; border-top-color: rgb(225, 225, 225); border-top-width: 1pt; padding: 3pt 0cm 0cm;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><b><span style="font-size: 11pt; font-family: Calibri, sans-serif;">Von:</span></b><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><span class="Apple-converted-space"> </span><a href="mailto:info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu" style="color: purple; text-decoration: underline;">info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu</a><span class="Apple-converted-space"> </span>[<a href="mailto:info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu" style="color: purple; text-decoration: underline;">mailto:info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu</a>]<span class="Apple-converted-space"> </span><b>Im Auftrag von<span class="Apple-converted-space"> </span></b>Marc Fournier<br><b>Gesendet:</b><span class="Apple-converted-space"> </span>Mittwoch, 26. März 2014 17:28<br><b>An:</b><span class="Apple-converted-space"> </span><a href="mailto:info-cyrus@lists.andrew.cmu.edu" style="color: purple; text-decoration: underline;">info-cyrus@lists.andrew.cmu.edu</a><br><b>Betreff:</b><span class="Apple-converted-space"> </span>NO Login failed: generic failure<o:p></o:p></span></div></div></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">I have two servers, both with identical configurations, right down to their imapd.conf files … both use sqlite to store auth information …<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">Both running on FreeBSD 10.x, and versions of imapd/sasl are the same:<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">cyrus-imapd24-2.4.17_4/ cyrus-sasl-2.1.26_5<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">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 …<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">/var/log # telnet localhost imap<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Trying 127.0.0.1...<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Connected to localhost.<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Escape character is '^]'.<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">* OK [CAPABILITY IMAP4rev1 LITERAL+ ID ENABLE STARTTLS AUTH=SCRAM-SHA-1 AUTH=DIGEST-MD5 AUTH=CRAM-MD5 AUTH=LOGIN AUTH=PLAIN SASL-IR] xxx.xxx Cyrus IMAP v2.4.17 server ready<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">. login<span class="Apple-converted-space"> </span><a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a><span class="Apple-converted-space"> </span>xxx<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">. NO Login failed: generic failure<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">. logout<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">* BYE LOGOUT received<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">. OK Completed<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Connection closed by foreign host.<o:p></o:p></span></div></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">/var/log/debug.log shows:<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">==<o:p></o:p></div></div><div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:08 xxx imap[67279]: SQL backend defaulting to engine 'sqlite'<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:08 xxx imap[67279]: executed<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:08 xxx imap[67279]: sql auxprop plugin using sqlite engine<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:08 xxx imap[67279]: IOERROR: opening /var/spool/imap/user_deny.db: No such file or directory<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:08 xxx imap[67279]: accepted connection<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:36 xxx imap[67279]: accepted connection<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin Parse the username<span class="Apple-converted-space"> </span><a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a><span class="Apple-converted-space"> </span> <o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin try and connect to a host<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host ''<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: begin transaction<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin create statement from userPassword xxx xxx.xxx <o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black; position: static; z-index: auto;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin doing query SELECT userPassword FROM sasl_auth WHERE userid = '<a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a>';<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin create statement from cmusaslsecretPLAIN xxx xxx.xxx <o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin doing query SELECT cmusaslsecretPLAIN FROM sasl_auth WHERE userid = '<a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a>';<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin: no such column: cmusaslsecretPLAIN<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: commit transaction<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin Parse the username<span class="Apple-converted-space"> </span><a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a><span class="Apple-converted-space"> </span> <o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin try and connect to a host<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 xxx imap[67279]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host ''<o:p></o:p></span></div></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">/var/log/messages shows:<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">Mar 26 16:09:49 rdfund imap[67279]: badlogin: xxx [200.46.208.227] plaintext<span class="Apple-converted-space"> </span><a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a><span class="Apple-converted-space"> </span>SASL(-1): generic failure: checkpass failed<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">I’ve even tried su’ng to the cyrus user and running the sql command against the database, and it returns the right database:<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">% echo "SELECT userPassword FROM sasl_auth WHERE userid = ‘<a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;">xxx@xxx.xxx</a>';" | sqlite /var/db/sqlite/mailsys<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">rightPW<o:p></o:p></span></div></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; background-color: black;"><span style="font-size: 7.5pt; font-family: Monaco, serif; color: rgb(245, 245, 245);">%<o:p></o:p></span></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">I’ve double checked the imapd.conf files, and they are identical except different admins: and one has tls_* lines in it … but I’m having the identical issue with *another* server, and it doesn’t have the tls_* lines …<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">I figure I have to be overlooking *something* stupid, but I’m at a loss as to what it could be … I’ve even checked md5 on imapd between both working / non-working … identical …<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">Is there any way of getting more debug information out of the backend without modifying the code itself? <o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">Thanks ...<o:p></o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><o:p> </o:p></div></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><br>______________________________________________________________________<br>This email has been scanned by the Symantec Email Security.cloud service.<br>For more information please visit<span class="Apple-converted-space"> </span><a href="http://www.symanteccloud.com/" style="color: purple; text-decoration: underline;">http://www.symanteccloud.com</a><br>______________________________________________________________________</div></div></div></blockquote></div><br></div></body></html>