Re: [Dbmail] IMAP retrieve

Tue, 14 Mar 2006 03:39:21 +0100 (CET) 

From: micah <[EMAIL PROTECTED]>

Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] IMAP retrieve
Date: Mon, 13 Mar 2006 17:21:14 -0800

Jim Douglas wrote:

From: micah <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] IMAP retrieve
Date: Mon, 13 Mar 2006 16:52:44 -0800

Jim Douglas wrote:

From: micah <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] IMAP retrieve
Date: Mon, 13 Mar 2006 15:29:30 -0800

Jim Douglas wrote:

From: micah <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] IMAP retrieve
Date: Mon, 13 Mar 2006 14:58:44 -0800


Are you using DBMail or Dovecot?

Jim Douglas wrote:

I have a problem retrieving mail from dbmail with IMAP.

I am using Evolution and Dovecot.

I started dbmail.lmtpd and dbmail.imapd, then Postfix.
From Evolution it says authentication failed, but there's nothing in the 
postfix log file.



Jim


_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
I stopped Dovecot, so now it's just DBmail and Evolution. I heve the Evolution recieve option set to IMAP 

Jim


_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Okay, so crank up your dbmail-imap logging to 5, and see why the authentication is failing, it should let you know if it's a problem connecting to the DB, or if it's a lookup error, or what-not. 

-Micah
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


I set this (I hope that's what you menn)
[IMAP]
TRACE_LEVEL=5


Nothing to the maillog file...same error from Evolution.

Jim
Did you restart the IMAP process? You should get TONS of messages with trace_level = 5, even when it's working properly. 

-Micah
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


How do you re-start dbmai-imapd?  I rebooted.

This is the logging
Mar 13 20:03:00 caz-63-65-11-183 postfix/postfix-script: starting the Postfix mail system Mar 13 20:03:00 caz-63-65-11-183 postfix/master[4304]: daemon started -- version 2.2.2, configuration /etc/postfix Mar 13 20:03:49 caz-63-65-11-183 dbmail/imap4d[4159]: serverchild.c,PerformChildTask: incoming connection from [66.65.161.178 (azz-16-16-121-13.phil.res.rr.com)] Mar 13 20:03:49 caz-63-65-11-183 dbmail/imap4d[4159]: serverchild.c,PerformChildTask: client info init complete, calling client handler Mar 13 20:03:49 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): line read for PID 4159 Mar 13 20:03:49 caz-63-65-11-183 dbmail/imap4d[4159]: COMMAND: [A00000 CAPABILITY] Mar 13 20:03:49 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Executing command capability... Mar 13 20:03:49 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Finished command capability Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): line read for PID 4159 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: COMMAND: [A00001 LOGIN test4 zoothead] 
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[0]: 'test4'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[1]: 'password1'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Executing command login... Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: _ic_login(): trying to validate user Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid = 'test4'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: authsql.c,auth_validate: validating using plaintext passwords Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [UPDATE dbmail_users SET last_login = '2006-03-13 20:04:03' WHERE user_idnr = '7'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: _ic_login(): user (id:7, name test4) tries login Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: _ic_login(): user (id 7, name test4) login accepted @ 2006-03-13 20:04:03 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Finished command login Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): line read for PID 4159 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: COMMAND: [A00002 NAMESPACE] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Executing command namespace... Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Finished command namespace Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): line read for PID 4159 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: COMMAND: [A00003 LIST "" "%"] 
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[0]: ''
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[1]: '%'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Executing command list... Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: ic_list(): build the pattern: [^[^\/]*$] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_list_mailboxes_by_regex: in func Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN dbmail_users usr ON acl.user_id = usr.user_idnr WHERE (mbx.owner_idnr = '7') OR (acl.user_id = '7' AND acl.lookup_flag = '1') OR (usr.userid = 'anyone' AND acl.lookup_flag = '1')] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_list_mailboxes_by_regex: checking mailbox: INBOX, nr 6, owner = 7 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_list_mailboxes_by_regex: comparing mailbox [INBOX] to regular expression Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_list_mailboxes_by_regex: regex match INBOX, mailbox_idnr = 6 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_list_mailboxes_by_regex: exit Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_findmailbox_by_regex: found [1] mailboxes Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: imapcommands.c,_ic_list: children[0] = 6 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT name FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT owner_idnr, name FROM dbmail_mailboxes WHERE mailbox_idnr = '6' ] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = '7' AND name LIKE 'INBOX/%'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Finished command list Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): line read for PID 4159 Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: COMMAND: [A00004 STATUS INBOX (MESSAGES UNSEEN)] 
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[0]: 'INBOX'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[1]: '('
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[2]: 'MESSAGES'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[3]: 'UNSEEN'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: arg[4]: ')'
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Executing command status... Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_findmailbox: looking for mailbox with FQN [INBOX]. Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND owner_idnr='7'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: db.c,db_acl_has_right: checking ACL for user [7] on mailbox [6] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '6' AND owner_idnr = '7'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = '6'] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='6' AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='6' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='6' AND (status='0' OR status='1') AND recent_flag=1] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '6' AND status < '2' ORDER BY message_idnr ASC] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: dbmysql.c,db_query: executing query [SELECT message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: imapcommands.c,_ic_status: RESPONSE [ * STATUS "INBOX" (MESSAGES 1 UNSEEN 1) 
 ]
Mar 13 20:04:03 caz-63-65-11-183 dbmail/imap4d[4159]: IMAPClientHandler(): Finished command status
IMAPD is not showing any login error. Maybe it's Evolution screwing the pooch. 

-Micah
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail



It's now working...I restared Evolution...

Thanks.
Jim

Reply via email to