[horde] Passing Auth from Horde Group to IMP failing

Thu Sep 25 19:35:17 UTC 2008

More logging information (from the logs related to dovecot). It looks 
like when horde passes the information to imap, it strips off the 
domain. Since my direct IMAP authentication is working (outside of 
horde), I can log into horde, AND I can log into imp, I think the 
problem is in the passing of the UserID from horde to imp?  (for the 
account rick3 at int.example.com). It also looks like it's being passed 
as 'plain' instead of 'crypt-md5', which means I bet once I fix the 
userID I'll hit another hurdle.

whether that's a horde problem or a config file problem I can't tell. 
If anyone can tell me where that might be I'll be glad to check.

Here's the log:

Sep 25 15:30:12 rickmail dovecot: auth(default): new auth connection: pid=23912
Sep 25 15:30:25 rickmail dovecot: auth(default): client in: 
AUTH        1      PLAIN    service=IMAP    secured 
lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1   resp=AHJpY2szAFRlc3QzMzM=
Sep 25 15:30:25 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): query: SELECT password FROM mailbox 
WHERE username = 'rick3'
Sep 25 15:30:25 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): unknown user
Sep 25 15:30:25 rickmail dovecot: auth(default): new auth connection: pid=23918
Sep 25 15:30:25 rickmail dovecot: auth(default): client out: 
FAIL       1      user=rick3
Sep 25 15:30:25 rickmail dovecot: auth(default): client in: 
AUTH        2      PLAIN    service=IMAP    secured 
lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1   resp=AHJpY2szAFRlc3QzMzM=
Sep 25 15:30:25 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): query: SELECT password FROM mailbox 
WHERE username = 'rick3'
Sep 25 15:30:25 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): unknown user
Sep 25 15:30:27 rickmail dovecot: auth(default): client out: 
FAIL       2      user=rick3
Sep 25 15:30:27 rickmail dovecot: auth(default): client in: 
AUTH        3      PLAIN    service=IMAP    secured 
lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1   resp=AHJpY2szAFRlc3QzMzM=
Sep 25 15:30:27 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): query: SELECT password FROM mailbox 
WHERE username = 'rick3'
Sep 25 15:30:27 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): unknown user
Sep 25 15:30:29 rickmail dovecot: auth(default): client out: 
FAIL       3      user=rick3
Sep 25 15:30:29 rickmail dovecot: imap-login: Aborted login: 
user=<rick3>, method=PLAIN, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured
Sep 25 15:30:30 rickmail dovecot: auth(default): client in: 
AUTH        1      PLAIN    service=IMAP    secured 
lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1   resp=AHJpY2szAFRlc3QzMzM=
Sep 25 15:30:30 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): query: SELECT password FROM mailbox 
WHERE username = 'rick3'
Sep 25 15:30:30 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): unknown user
Sep 25 15:30:30 rickmail dovecot: auth(default): new auth connection: pid=23920
Sep 25 15:30:31 rickmail dovecot: auth(default): client out: 
FAIL       1      user=rick3
Sep 25 15:30:31 rickmail dovecot: auth(default): client in: 
AUTH        2      PLAIN    service=IMAP    secured 
lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1   resp=AHJpY2szAFRlc3QzMzM=
Sep 25 15:30:31 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): query: SELECT password FROM mailbox 
WHERE username = 'rick3'
Sep 25 15:30:31 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0.1): unknown user
Sep 25 15:30:33 rickmail dovecot: auth(default): client out: 
FAIL       2      user=rick3
Sep 25 15:30:33 rickmail dovecot: auth(default): client in: 
AUTH        3      PLAIN    service=IMAP    secured 
lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1   resp=AHJpY2szAFRlc3QzMzM=
Sep 25 15:30:33 rickmail dovecot: auth-worker(default): 
sql(rick3,::ffff:127.0.0

At 12:34 AM 9/25/2008, horde at corwyn.net wrote:
>I'm wondering if this is possibly a password encryption problem? I 
>have crypt-md5 enabled in postfixadmin, and cryptmd5 enabled in 
>dovecot-mysql.conf, and crypt-md5 enabled in the horde configuration 
>file when using custom mysql queries, but I'm wondering if the 
>password gets encrypted, and then the encrypted password somehow is 
>what's passed back in but along the way gets encrypted again, and 
>thus doesn't pass between horde and imp.
>
>Rick
>
>At 09:13 PM 9/24/2008, Rick Steeves wrote:
>>At 01:32 PM 9/24/2008, Jan Schneider wrote:
>>CentOS5 running postfix, dovecot. Postfix maintains accounts in
>>>>mySQL. dovecot imap/pop authentication works to mySQL. Currently
>>>>using custom SQL queries in Horde > Authentication.  The queries at
>>>>least appear to be right, as I can log into horde using an account
>>>>set up in the mySQL database. I can log in (via command line to
>>>>IMAP) to dovecot/IMAP.
>>>>
>>>>I have edited imp/config/servers.php and set 'hordeauth' => 'full'
>>>>so users only need to login once and Horde then passes
>>>>authentication data to Imp
>>>>(http://oli.lugh.ch/horde-workaround.org.html)
>>>>
>>>>If I change horde authentication to use IMP, then logging into horde
>>>>also logs into IMP. However, What I would like is to be able to log
>>>>into horde using mysql, and have it automatically authenticate to
>>>>IMP / My Mailbox.  What currently happens is that I can log into
>>>>horde, but I still have a link to log into My Inbox. Selecting that
>>>>link means I have to log in again (same user ID and password).
>>>
>>>No, this should work.
>>>
>>>Jan.
>>
>>
>>Any suggestions on where to look for why it's not?
>>
>>
>>
>>
>
>
>
>--
>Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: horde-unsubscribe at lists.horde.org