<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>Yes, they are all the same … data isn’t, obvously, but the structure hasn’t changed … in fact, the mail systems on all three servers that I’m currently working with have been running / configured for 5+ years now … only change was upgraded OS from FreeBSD 9 -> 10 and upgraded ports to the latest … <div><br></div><div>I did the upgrade from 9 -> 10 for <a href="http://hub.org">hub.org</a> first (the domain I’m emailing from) and all went smooth … I never change config files unless I have to, and in this case, nothing had to be changed … and the lack of useful error message is making it twice as difficult to debug ;(</div><div><br><div><br></div><div><br><div><div>On Mar 26, 2014, at 10:59 , 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 lang="EN-US" style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125);">You said, you compared the cyrus config files.<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);">Did you compare the structure and data of the sqllite databases?<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>Marc Fournier [<a href="mailto:scrappy@hub.org" style="color: purple; text-decoration: underline;">mailto:scrappy@hub.org</a>]<span class="Apple-converted-space"> </span><br><b>Gesendet:</b><span class="Apple-converted-space"> </span>Mittwoch, 26. März 2014 18:20<br><b>An:</b><span class="Apple-converted-space"> </span>Helmut Weigel<br><b>Cc:</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>Re: 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 style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">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:<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><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);">pwcheck_method: auxprop<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);">auxprop_plugin: sql<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);"> </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);">sasl_sql_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);">sasl_sql_database: /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);">sasl_sql_select: SELECT %p FROM sasl_auth WHERE userid = '%u@%r'<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);">sasl_sql_insert: INSERT INTO sasl_auth ( userid, %p, domain ) VALUES ( '%u@%r', '%v' )<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);">sasl_sql_update: UPDATE sasl_auth SET %p = '%v' WHERE userid = '%u@%r'<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;">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:<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 14:02:37 hub pop3[75904]: 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 14:02:37 hub pop3[75904]: sql plugin create statement from userPassword ams<span class="Apple-converted-space"> </span><a href="http://hub.org/" style="color: purple; text-decoration: underline;">hub.org</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 14:02:37 hub pop3[75904]: sql plugin doing query SELECT userPassword FROM sasl_auth WHERE userid = '<a href="mailto:ams@hub.org" style="color: purple; text-decoration: underline;">ams@hub.org</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 14:02:37 hub pop3[75904]: sql plugin create statement from cmusaslsecretPLAIN ams<span class="Apple-converted-space"> </span><a href="http://hub.org/" style="color: purple; text-decoration: underline;">hub.org</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 14:02:37 hub pop3[75904]: sql plugin doing query SELECT cmusaslsecretPLAIN FROM sasl_auth WHERE userid = '<a href="mailto:ams@hub.org" style="color: purple; text-decoration: underline;">ams@hub.org</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 14:02:37 hub pop3[75904]: 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 14:02:37 hub pop3[75904]: commit transaction<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;"><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;">On Mar 26, 2014, at 10:11 , Helmut Weigel <<a href="mailto:helmut.weigel@dfb-medien.de" style="color: purple; text-decoration: underline;">helmut.weigel@dfb-medien.de</a>> wrote:<o:p></o:p></div></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;"><br><br><o:p></o:p></div><blockquote style="margin-top: 5pt; margin-bottom: 5pt;"><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);">Hi,</span><o:p></o:p></div></div><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><o:p></o:p></div></div><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:</span><o:p></o:p></div></div><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><o:p></o:p></div></div><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><o:p></o:p></div></div><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</span><o:p></o:p></div></div><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><o:p></o:p></div></div><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><o:p></o:p></div></div><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</span><o:p></o:p></div></div><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><o:p></o:p></div></div><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</span><o:p></o:p></div></div><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><o:p></o:p></div></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 class="apple-converted-space"><span style="font-size: 11pt; font-family: Calibri, sans-serif;"> </span></span><span style="font-size: 11pt; font-family: Calibri, sans-serif;"><a href="mailto:info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu" style="color: purple; text-decoration: underline;"><span style="color: purple;">info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu</span></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;"><span style="color: purple;">mailto:info-cyrus-bounces+weigel=dfbnet.org@lists.andrew.cmu.edu</span></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;"><span style="color: purple;">info-cyrus@lists.andrew.cmu.edu</span></a><br><b>Betreff:</b><span class="apple-converted-space"> </span>NO Login failed: generic failure</span><o:p></o:p></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;"> <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</span><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;">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</span><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);">Trying 127.0.0.1...</span><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);">Connected to localhost.</span><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);">Escape character is '^]'.</span><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);">* 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</span><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);">. login<span class="apple-converted-space"> </span><a href="mailto:xxx@xxx.xxx" style="color: purple; text-decoration: underline;"><span style="color: purple;">xxx@xxx.xxx</span></a><span class="apple-converted-space"> </span>xxx</span><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);">. NO Login failed: generic failure</span><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);">. logout</span><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);">* BYE LOGOUT received</span><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);">. OK Completed</span><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);">Connection closed by foreign host.</span><o:p></o:p></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'</span><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:08 xxx imap[67279]: executed</span><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:08 xxx imap[67279]: sql auxprop plugin using sqlite engine</span><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:08 xxx imap[67279]: IOERROR: opening /var/spool/imap/user_deny.db: No such file or directory</span><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:08 xxx imap[67279]: accepted connection</span><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:36 xxx imap[67279]: accepted connection</span><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 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;"><span style="color: purple;">xxx@xxx.xxx</span></a><span class="apple-converted-space"> </span> </span><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 xxx imap[67279]: sql plugin try and connect to a host</span><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 xxx imap[67279]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host ''</span><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 xxx imap[67279]: begin transaction</span><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 xxx imap[67279]: sql plugin create statement from userPassword xxx xxx.xxx </span><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 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;"><span style="color: purple;">xxx@xxx.xxx</span></a>';</span><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 xxx imap[67279]: sql plugin create statement from cmusaslsecretPLAIN xxx xxx.xxx </span><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 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;"><span style="color: purple;">xxx@xxx.xxx</span></a>';</span><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 xxx imap[67279]: sql plugin: no such column: cmusaslsecretPLAIN</span><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 xxx imap[67279]: commit transaction</span><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 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;"><span style="color: purple;">xxx@xxx.xxx</span></a><span class="apple-converted-space"> </span> </span><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 xxx imap[67279]: sql plugin try and connect to a host</span><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 xxx imap[67279]: sql plugin trying to open db '/var/db/sqlite/mailsys' on host ''</span><o:p></o:p></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;"><span style="color: purple;">xxx@xxx.xxx</span></a><span class="apple-converted-space"> </span>SASL(-1): generic failure: checkpass failed</span><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’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;"><span style="color: purple;">xxx@xxx.xxx</span></a>';" | sqlite /var/db/sqlite/mailsys</span><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);">rightPW</span><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);">%</span><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’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><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;"><span style="color: purple;">http://www.symanteccloud.com</span></a><br>______________________________________________________________________</div></div></blockquote></div></div></div></div></blockquote></div><br></div></div></body></html>