Hi Paul, Thanks for your reply,
For me "This old known bug, fix a long time ago" made Dbmail useless... Why are those fixes not in Dbmail 2.0.10 that everybody download.... Why put on your web page "Dbmail-2.0.10 is now available. This is a bugfix maintenance release." When the real bugfix maintenance release is somewhere hidden in "svn-trunk" Could you add those fix to a 2.0.11 release so others wont go through the same "pain" as I just did. 1 - Play yoyo all weekend between the Dbmail and Horde mailing list.... 2 - Cancel my 15 hours migration.... Thanks Paul, Sorry... I had to let the steam out... I appreciate all the work you put in Dbmail. Jacques Beaudoin Agent d'administration Les services des technologies de l'information et des communications Commission scolaire de la Pointe de l'Île Montréal, Québec, Canada Courriel/Email: [EMAIL PROTECTED] Cel: 514 918-3350 Selon Paul J Stevens <[EMAIL PROTECTED]>: > Jacques, this is an (old) known bug, fix a long time ago in svn-trunk. > > http://www.dbmail.org/mantis/view.php?id=97 > > Since you're already migrating, please consider using 2.1.6 or svn-trunk > in stead of 2.0.10. > > Jacques Beaudoin wrote: > > Hi, > > > > Maby I'm the only one using Horde with Dbmail but, > > > > for me this is a big Horde with Dbmail bug, and I have to solve this. > > > > I nead some help from the DBmail group and the Horde Group. > > > > I'm currently migrating my mail server and > > > > I think I have a bug between Horde-IMP-4.1.1 and Dbmail-2.0.10 > > > > that I do not have between Horde-IMP-3.2.8 and dbmail-1.2.11 > > > > After a user has read a message in the INBOX in Horde-IMP > > the "mail enveloppe" on the left is suppose to disappear showing > > that the user has read the message. > > > > With my current mail server under Horde-IMP-3.2.8 and dbmail-1.2.11 > > I have no problem. > > > > But on my new server under Horde-IMP-4.1.1 and Dbmail-2.0.10 it does not > > disapper, > > so the a user is left in the dark on which message was read. > > > > Is it Horde or is it Dbmail ? > > > > When I look in dbmail mysql database the "seen flag" is set for the message. > > ... so far so good.... > > > > But why is the "mail enveloppe" still appearing for that message > > in Horde-IMP. > > > > Attach is a dbmail log of a transaction updating the "seen flag". > > > > Can't someone take a look at it to see if everything is normal. > > > > Thanks > > > > Jacques Beaudoin > > Agent d'administration > > Les services des technologies > > de l'information et des communications > > Commission scolaire de la Pointe de l'Île > > Montréal, Québec, Canada > > > > Courriel/Email: [EMAIL PROTECTED] > > Cel: 514 918-3350 > > > > > > > > Selon Jacques Beaudoin <[EMAIL PROTECTED]>: > > > >> Hi, > >> > >> I'm using IMP-h3-4.1.1 > >> and when I open a mail the right enveloppe ICON does not disappear > >> > >> Is there a fix for this. > >> > >> Cordialement > >> > >> Jacques Beaudoin > >> Agent d'administration > >> Les services des technologies > >> de l'information et des communications > >> Commission scolaire de la Pointe de l'Île > >> Montréal, Québec, Canada > >> > >> Courriel/Email: [EMAIL PROTECTED] > >> Cel: 514 918-3350 > >> > >> > >> > >> > >> > >> > >> ------------------------------------------------------------------------ > >> > >> LOG_INFO_FLUSH > >> May 20 01:32:53 mail dbmail/imap4d[3201]: serverchild.c,PerformChildTask: > >> client info init > complete, calling client handler > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:53 mail dbmail/imap4d[3201]: COMMAND: [00000000 CAPABILITY] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command capability... > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command capability > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:53 mail dbmail/imap4d[3201]: COMMAND: [00000001 AUTHENTICATE > >> LOGIN] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[0]: 'LOGIN' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command > authenticate... > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid = > 'jacques-beaudoin'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: authsql.c,auth_validate: > >> validating using plaintext > passwords > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [UPDATE > dbmail_users SET last_login = '2006-05-20 01:32:53' WHERE user_idnr = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command authenticate > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:53 mail dbmail/imap4d[3201]: COMMAND: [00000002 CAPABILITY] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command capability... > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command capability > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:53 mail dbmail/imap4d[3201]: COMMAND: [00000003 SELECT INBOX] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[0]: 'INBOX' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command select... > >> May 20 01:32:53 mail dbmail/imap4d[3201]: db.c,db_findmailbox: looking for > >> mailbox with FQN > [INBOX]. > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND owner_idnr='1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: 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 = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND (status='0' > OR status='1') UNION > SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND > (status='0' OR status='1') > AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE > mailbox_idnr='1166' AND > (status='0' OR status='1') AND recent_flag=1] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > message_idnr FROM dbmail_messages WHERE mailbox_idnr = '1166' AND status < > '2' ORDER BY > message_idnr ASC] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '1166' AND status > < '2' AND seen_flag > = '0'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command select > >> May 20 01:32:53 mail dbmail/imap4d[3201]: 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 = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND (status='0' > OR status='1') UNION > SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND > (status='0' OR status='1') > AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE > mailbox_idnr='1166' AND > (status='0' OR status='1') AND recent_flag=1] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > message_idnr FROM dbmail_messages WHERE mailbox_idnr = '1166' AND status < > '2' ORDER BY > message_idnr ASC] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:53 mail dbmail/imap4d[3201]: COMMAND: [00000004 UID FETCH > >> 3388056 UID] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[0]: 'FETCH' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[1]: '3388056' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[2]: 'UID' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command uid... > >> May 20 01:32:53 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 1] > >> = UID (returning 2) > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, > DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM > dbmail_messages msg, > dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr > BETWEEN '3388056' AND > '3388056' AND mailbox_idnr = '1166' AND status < '2' ORDER BY message_idnr > ASC] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: ic_fetch(): no parsing at all > >> May 20 01:32:53 mail dbmail/imap4d[3201]: _ic_fetch(): no parsing, into > >> fetch loop > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command uid > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:53 mail dbmail/imap4d[3201]: COMMAND: [00000005 FETCH 9 > >> BODY.PEEK[HEADER]] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[0]: '9' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[1]: 'BODY.PEEK' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[2]: '[' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[3]: 'HEADER' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: arg[4]: ']' > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command fetch... > >> May 20 01:32:53 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 4] > >> = ] (returning 5) > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, > DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM > dbmail_messages msg, > dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr > BETWEEN '3388056' AND > '3388056' AND mailbox_idnr = '1166' AND status < '2' ORDER BY message_idnr > ASC] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: Fetching msgID 3388056 (fetch > >> num 9) > >> May 20 01:32:53 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > messageblk FROM dbmail_messageblks blk, dbmail_messages msg WHERE > blk.physmessage_id = > msg.physmessage_id AND msg.message_idnr = '3388056' ORDER BY > blk.messageblk_idnr ASC LIMIT 1] > >> May 20 01:32:53 mail dbmail/imap4d[3201]: mime_readheader(): entering mime > >> loop > >> May 20 01:32:53 mail dbmail/imap4d[3201]: mime_readheader(): found double > >> newline; header > size: 17 lines > >> May 20 01:32:53 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command fetch > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:54 mail dbmail/imap4d[3201]: COMMAND: [00000006 FETCH 9 > >> (INTERNALDATE RFC822.SIZE > FLAGS)] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[0]: '9' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[1]: '(' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[2]: 'INTERNALDATE' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[3]: 'RFC822.SIZE' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[4]: 'FLAGS' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[5]: ')' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command fetch... > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 2] > >> = INTERNALDATE > (returning 3) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 3] > >> = RFC822.SIZE > (returning 4) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 4] > >> = FLAGS (returning > 5) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, > DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM > dbmail_messages msg, > dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr > BETWEEN '3388056' AND > '3388056' AND mailbox_idnr = '1166' AND status < '2' ORDER BY message_idnr > ASC] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: ic_fetch(): no parsing at all > >> May 20 01:32:54 mail dbmail/imap4d[3201]: _ic_fetch(): no parsing, into > >> fetch loop > >> May 20 01:32:54 mail last message repeated 2 times > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command fetch > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:54 mail dbmail/imap4d[3201]: COMMAND: [00000007 FETCH 9 > >> (BODYSTRUCTURE FLAGS)] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[0]: '9' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[1]: '(' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[2]: 'BODYSTRUCTURE' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[3]: 'FLAGS' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[4]: ')' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command fetch... > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 2] > >> = BODYSTRUCTURE > (returning 3) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 3] > >> = FLAGS (returning > 4) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, > DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM > dbmail_messages msg, > dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr > BETWEEN '3388056' AND > '3388056' AND mailbox_idnr = '1166' AND status < '2' ORDER BY message_idnr > ASC] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: Fetching msgID 3388056 (fetch > >> num 9) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > block.messageblk FROM dbmail_messageblks block, dbmail_messages msg WHERE > block.physmessage_id = > msg.physmessage_id AND msg.message_idnr = '3388056' ORDER BY > block.messageblk_idnr] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db_start_msg(): starting, > >> stopbound: '<null>' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: mime_readheader(): entering mime > >> loop > >> May 20 01:32:54 mail dbmail/imap4d[3201]: mime_readheader(): found double > >> newline; header > size: 17 lines > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db_start_msg(): found singlepart > >> msg > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmsgbuf.c,db_update_msgbuf: > >> update msgbuf_buf > updating 131072, 3659, 2856, 2856 > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmsgbuf.c,db_update_msgbuf: > >> update msgbuf: entire > fit > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmsgbuf.c,db_update_msgbuf > >> update msgbuf succes > NOMORE > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db_start_msg(): exit > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command fetch > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:54 mail dbmail/imap4d[3201]: COMMAND: [00000008 UID STORE > >> 3388056 +Flags (\SEEN)] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[0]: 'STORE' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[1]: '3388056' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[2]: '+Flags' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[3]: '(' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[4]: '\SEEN' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[5]: ')' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command uid... > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: 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 = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND (status='0' > OR status='1') UNION > SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='1166' AND > (status='0' OR status='1') > AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE > mailbox_idnr='1166' AND > (status='0' OR status='1') AND recent_flag=1] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > message_idnr FROM dbmail_messages WHERE mailbox_idnr = '1166' AND status < > '2' ORDER BY > message_idnr ASC] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT 1] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [UPDATE > dbmail_messages SET seen_flag=1 WHERE message_idnr BETWEEN '3388056' AND > '3388056' AND status < > '2' AND mailbox_idnr = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag > FROM > dbmail_messages WHERE message_idnr = '3388056' AND status < '2' AND > mailbox_idnr = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command uid > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:54 mail dbmail/imap4d[3201]: COMMAND: [00000009 FETCH 9 > >> BODY.PEEK[1]] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[0]: '9' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[1]: 'BODY.PEEK' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[2]: '[' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[3]: '1' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: arg[4]: ']' > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command fetch... > >> May 20 01:32:54 mail dbmail/imap4d[3201]: db.c,db_acl_has_right: checking > >> ACL for user [1166] > on mailbox [1166] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '1166' AND owner_idnr > = '1166'] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: next_fetch_item(): args[idx = 4] > >> = ] (returning 5) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, > DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM > dbmail_messages msg, > dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr > BETWEEN '3388056' AND > '3388056' AND mailbox_idnr = '1166' AND status < '2' ORDER BY message_idnr > ASC] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: Fetching msgID 3388056 (fetch > >> num 9) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmsgbuf.c,db_dump_range: > >> Dumping range: (1,0) - > (1,2855) > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmysql.c,db_query: executing > >> query [SELECT > block.messageblk FROM dbmail_messageblks block, dbmail_messages msg WHERE > block.physmessage_id = > msg.physmessage_id AND msg.message_idnr = '3388056' ORDER BY > block.messageblk_idnr] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: dbmsgbuf.c,db_dump_range: adding > >> '^M' to buf > >> May 20 01:32:54 mail last message repeated 69 times > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command fetch > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): line read > >> for PID 3201 > >> May 20 01:32:54 mail dbmail/imap4d[3201]: COMMAND: [0000000a LOGOUT] > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Executing > >> command logout... > >> May 20 01:32:54 mail dbmail/imap4d[3201]: IMAPClientHandler(): Finished > >> command logout > >> May 20 01:32:54 mail dbmail/imap4d[3201]: serverchild.c,PerformChildTask: > >> client handling > complete, closing streams > >> May 20 01:32:54 mail dbmail/imap4d[3201]: serverchild.c,client_close: > >> closing write stream > >> May 20 01:32:54 mail dbmail/imap4d[3201]: serverchild.c,client_close: > >> closing read stream > >> May 20 01:32:54 mail dbmail/imap4d[3201]: serverchild.c,PerformChildTask: > >> connection closed > >> May 20 01:32:54 mail dbmail/imap4d[3201]: serverchild.c,PerformChildTask: > >> waiting for > connection > >> > >> ------------------------------------------------------------------------ > >> > >> _______________________________________________ > >> Dbmail mailing list > >> [email protected] > >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
