Paul J Stevens | 2 May 15:23 2010
Picon

[SCM]Paul's DBMail tree branch, dbmail_2_2, updated. v2.2.13-26-g6f3460e

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, dbmail_2_2 has been updated
       via  6f3460e66ab58859e381a145979a46effad0bf53 (commit)
      from  2adf5966f78326b382bda304fdf2ae0b78493c19 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 6f3460e66ab58859e381a145979a46effad0bf53
Author: Paul J Stevens <paul@...>
Date:   Sun May 2 15:20:44 2010 +0200

    propagate sub-address into sieve handler

-----------------------------------------------------------------------

Summary of changes:
 modules/sortnull.c  |    2 +-
 modules/sortsieve.c |    5 ++++-
 sort.c              |    2 +-
 sort.h              |    2 +-
 sortmodule.c        |    4 ++--
 5 files changed, 9 insertions(+), 6 deletions(-)

hooks/post-receive
(Continue reading)

Paul J Stevens | 2 May 15:31 2010
Picon

[SCM]Paul's DBMail tree branch, master, updated. 4d82947c8fab388885925e1e7d11c3b316e6e65a

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  4d82947c8fab388885925e1e7d11c3b316e6e65a (commit)
       via  6dc60b4274dc2823567217f2904e88608a5486c3 (commit)
      from  794fb9d54edd9363082919970a62ae3fbb19074f (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 4d82947c8fab388885925e1e7d11c3b316e6e65a
Author: Paul J Stevens <paul@...>
Date:   Sun May 2 15:30:08 2010 +0200

    propagate sub-address into sieve handler

commit 6dc60b4274dc2823567217f2904e88608a5486c3
Author: Paul J Stevens <paul@...>
Date:   Fri Apr 30 13:48:08 2010 +0200

    wip #844

-----------------------------------------------------------------------

Summary of changes:
 src/dbmail-message.c    |    2 +-
(Continue reading)

Mantis Bug Tracker | 2 May 15:35 2010

[DBMail 0000844]: Sieve vacation should not auto-reply to alias email


A NOTE has been added to this issue. 
====================================================================== 
http://dbmail.org/mantis/view.php?id=844 
====================================================================== 
Reported By:                jasb
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   844
Category:                   Sieve (delivery, dbmail-sievecmd, dbmail-timsieved)
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             17-Apr-10 17:11 CEST
Last Modified:              02-May-10 15:35 CEST
====================================================================== 
Summary:                    Sieve vacation should not auto-reply to alias email
Description: 
my email, has some alias:

email:
jorge <at> mydomain.pt

alias:
dns <at> mydomain.pt
jorge.bastos <at> mydomain.pt
(Continue reading)

Jorge Bastos | 3 May 10:38 2010
Picon

Re: Moving to GIT HEAD

Hi Paul,

Sorry to re-ask, but since you didn’t said nothing, and meanwhile responded to other stuff in dbmail <at> , not urgent but ‘d like to solve it.

 

Jorge,

 

From: dbmail-dev-bounces-taRh+z1m2xodnm+yROfE0A@public.gmane.org [mailto:dbmail-dev-bounces-taRh+z1m2xodnm+yROfE0A@public.gmane.org] On Behalf Of Jorge Bastos
Sent: sexta-feira, 30 de Abril de 2010 21:28
To: dbmail-dev-taRh+z1m2xodnm+yROfE0A@public.gmane.org
Subject: [Dbmail-dev] Moving to GIT HEAD

 

Hi Paul,

 

Two things, when moving to the GIT HEAD:

 

Adding the UNIQUE key to the envelope table, I have a duplicated record, how can I fix this in a safe way?

 

--

mysql> CREATE UNIQUE INDEX dbmail_envelope_1 ON dbmail_envelope(physmessage_id);

ERROR 1062 (23000): Duplicate entry '294904' for key 3

mysql>

--

 

 

Other thing is, after using the last GIT HEAD, POP3 doesn’t work, check this:

 

70 17028

71 758

72 789

73 6928

74 761

75 18600

.

retr 71

+OK 685222690176369404 octets

RETR command, selecting message-ERR I'm leaving, you're too slow

Connection closed by foreign host.

 

The “+OK ……” response, seams very wrong on the msg size, it reports a HUGE SIZE.

I ask, can this be a problem derivered from the UNIQUE KEY not be applied ?

 

 

Here’s the log when I run this test:

 

 

 

 

 

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_read(+125): [0x9082930] state: [2]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_read_cb(+340): [0xb624e008] reset timeout [600]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_readln(+416): [0xb624e008] C < [9:retr 71^M ]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+328): incoming buffer: [retr 71]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+342): state[2], command issued :cmd [retr], value [71]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+354): command looked up as commandtype 5

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+537): RETR command, retrieving message

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+545): RETR command, selecting message

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_get_message_lines(+1536): request for [-2] lines

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_query(+342): [0x904f1b8] [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 7391890]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] log_query_time(+288): last query took [0.000] seconds

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_query(+342): [0x904f1b8] [SELECT l.part_key,l.part_depth,l.part_order,l.is_header,DATE_FORMAT(ph.internal_date, GET_FORMAT(DATETIME,'

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] log_query_time(+288): last query took [0.001] seconds

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] dbmail_message_init_with_string(+706): parse message

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): Received: from smtp.decimal.pt (localhost.localdomain [127.0.0.1])^Iby smtp.decimal.pt (Postfix) with ESMTP id 97E0D10BFD

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): Received: by smtp.decimal.pt (Postfix, from userid 108)^Iid 8B5E210B5D6;^IFri, 30 Apr 2010 08:39:13 +0100 (WEST)

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): To: trash-lcG7AWEBJY0VhHzd4jOs4w@public.gmane.org

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): Subject: Exploit.HTML.IFrame-8 found on 127.0.0.1

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): Message-Id: <20100430073913...8B5E210B5D6-RwzF62VVGd7itphCTaQFMQ@public.gmane.org>

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): Date: Fri, 30 Apr 2010 08:39:13 +0100 (WEST)

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): From: clamsmtp-RwzF62VVGd7itphCTaQFMQ@public.gmane.org

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): X-Virus-Scanned: ClamAV using ClamSMTP

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[message] _register_header(+778): Return-Path: clamsmtp-RwzF62VVGd7itphCTaQFMQ@public.gmane.org

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0xb624e008] S > [62/62:+OK 650906485596881660 octets^M RETR command, selecting message]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9082930] state: [2]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9082930] state: [2]

Apr 30 21:09:11 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+175): reset timeout [600]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[server] _sock_cb(+463): 12 2, 0x90813c8, ssl:N

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[server] _sock_cb(+523): connection accepted

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] client_init(+160): saddr [0x9083ad0] sa_family [2] len [16]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Notice:[clientbase] client_init(+165): incoming connection on [192.168.0.222:110]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] client_init(+168): caddr [0x9082d20] sa_family [2] len [16]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Notice:[clientbase] client_init(+183): incoming connection from [188.80.95.190:35825]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[misc] create_unique_id(+127): created: a27fcead3ff2d2504393c342b69c8f5a

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_uncork(+211): [0x908d370]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] send_greeting(+60): key "banner" section "POP" var banner value [Decimal Informatica e Gestao, Lda <-> POP3 Server]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0x908d370] S > [95/95:+OK Decimal Informatica e Gestao, Lda <-> POP3 Server <a27fcead3ff2d2504393c342b69c8f5a <at> lira>^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9087548] state: [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9087548] state: [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+169): reset timeout [60]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_read(+125): [0x9087548] state: [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_read_cb(+340): [0x908d370] reset timeout [60]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_readln(+416): [0x908d370] C < [35:USER comandante.bvconde <at> sirene.pt^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+328): incoming buffer: [USER comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+342): state[0], command issued :cmd [USER], value [comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+354): command looked up as commandtype 1

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0x908d370] S > [56/56:+OK Password required for comandante.bvconde <at> sirene.pt^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9087548] state: [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9087548] state: [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+169): reset timeout [60]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_read(+125): [0x9087548] state: [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_read_cb(+340): [0x908d370] reset timeout [60]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_readln(+416): [0x908d370] C < [20:PASS ompwd^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+328): incoming buffer: [PASS ompwd]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+342): state[0], command issued :cmd [PASS], value [bvcondecompwd]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+354): command looked up as commandtype 2

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_query(+342): [0x904f1b8] [SELECT 1=1 FROM dbmail_usermap LIMIT 1 OFFSET 0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] log_query_time(+288): last query took [0.000] seconds

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_use_usermap(+731): enabling usermap lookups

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_usermap_resolve(+2963): checking userid [comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org] in usermap

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_usermap_resolve(+2969): client on inet socket [inet:192.168.0.222:110]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_prepare(+395): [0x904f1b8] [SELECT login, sock_allow, sock_deny, userid FROM dbmail_usermap WHERE login in (?,'ANY') ORDER BY sock_allo

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_set_str(+403): [0x9082b38] 1:[comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_usermap_resolve(+3015): login [comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org] not found in usermap

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_prepare(+395): [0x904f1b8] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower(?)]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_set_str(+403): [0x90827d8] 1:[comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_query(+342): [0x904f1b8] [SELECT passwd, encryption_type FROM dbmail_users WHERE user_idnr = 399]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] log_query_time(+288): last query took [0.000] seconds

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[auth] auth_validate(+360): validating using plaintext passwords

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_exec(+310): [0x904f1b8] [UPDATE dbmail_users SET last_login = '2010-04-30 21:09:18' WHERE user_idnr = 399]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] log_query_time(+288): last query took [0.017] seconds

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+462): validation OK, building a session for user [comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_prepare(+395): [0x904f1b8] [SELECT idnr FROM dbmail_pbsp WHERE ipnumber = ?]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_set_str(+403): [0x90827d8] 1:[188.80.95.190]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_prepare(+395): [0x904f1b8] [UPDATE dbmail_pbsp SET since = CURRENT_TIMESTAMP WHERE idnr = ?]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_set_u64(+415): [0x9082b38] 1:[60782]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_log_ip(+1070): ip [188.80.95.190] logged

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_findmailbox(+1707): looking for mailbox with FQN [INBOX].

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[misc] mailbox_remove_namespace(+204): [INBOX]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_prepare(+395): [0x904f1b8] [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE owner_idnr = ? AND name LIKE ? ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_set_u64(+415): [0x90886d8] 1:[399]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_stmt_set_str(+403): [0x90886d8] 2:[INBOX]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[db] db_find_create_mailbox(+2275): mailbox [INBOX] found

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_query(+342): [0x904f1b8] [SELECT pm.messagesize, msg.message_idnr, msg.status, msg.unique_id FROM dbmail_messages msg, dbmail_physmes

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] log_query_time(+288): last query took [0.000] seconds

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] db_createsession(+110): adding items to list

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0x908d370] S > [60/60:+OK comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org has 0 messages (0 octets)^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Notice:[pop3] pop3(+477): user comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org logged in [messages=0, octets=0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9087548] state: [2]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9087548] state: [2]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+175): reset timeout [600]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_read(+125): [0x9087548] state: [2]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_read_cb(+340): [0x908d370] reset timeout [600]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_readln(+416): [0x908d370] C < [6:STAT^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+328): incoming buffer: [STAT]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+354): command looked up as commandtype 3

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0x908d370] S > [9/9:+OK 0 0^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9087548] state: [2]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9087548] state: [2]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+175): reset timeout [600]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_read(+125): [0x9087548] state: [2]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_read_cb(+340): [0x908d370] reset timeout [600]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_readln(+416): [0x908d370] C < [6:QUIT^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+328): incoming buffer: [QUIT]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3(+354): command looked up as commandtype 0

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_close(+174): [0x9087548] sessionResult [0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Notice:[pop3] pop3_close(+183): user comandante.bvconde-3zNU/IGlAzBeoWH0uzbU5w@public.gmane.org logging out [messages=0, octets=0]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_get(+255): [0x904f1b8] connection from pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Database:[db] db_con_close(+273): [0x904f1b8] connection to pool

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0x908d370] S > [18/18:+OK see ya later^M ]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9087548] state: [5]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9087548] state: [5]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_bailout(+108): [0x9087548]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_close(+484): closing clientbase [0x908d370]

Apr 30 21:09:18 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_cork(+204): [0x908d370]

Apr 30 21:09:52 lira dbmail/pop3d[664]: [0x903afb0] Info:[clientbase] ci_write(+320): [0xb624e008] S > [35/35:-ERR I'm leaving, you're too slow^M ]

Apr 30 21:09:52 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] socket_write_cb(+161): [0x9082930] state: [5]

Apr 30 21:09:52 lira dbmail/pop3d[664]: [0x903afb0] Debug:[pop3] pop3_cb_write(+238): [0x9082930] state: [5]

Apr 30 21:09:52 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientsession] client_session_bailout(+108): [0x9082930]

Apr 30 21:09:52 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_close(+484): closing clientbase [0xb624e008]

Apr 30 21:09:52 lira dbmail/pop3d[664]: [0x903afb0] Debug:[clientbase] ci_cork(+204): [0xb624e008]

 

 

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@...
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Paul J Stevens | 3 May 18:14 2010
Picon

Re: Moving to GIT HEAD

Jorge Bastos wrote:
> Hi Paul,
> 
> Sorry to re-ask, but since you didn’t said nothing, and meanwhile
> responded to other stuff in dbmail <at> , not urgent but ‘d like to solve it.

Not urgent, then.

> Adding the UNIQUE key to the envelope table, I have a duplicated record,
> how can I fix this in a safe way?

Delete either one of them


> mysql> CREATE UNIQUE INDEX dbmail_envelope_1 ON
> dbmail_envelope(physmessage_id);
> 
> ERROR 1062 (23000): Duplicate entry '294904' for key 3

I'd clean out the oldest one.

> Other thing is, after using the last GIT HEAD, POP3 doesn’t work, check
> this:

> +OK 685222690176369404 octets

Looking at the code I don't see anything obvious. I'll run some tests
later on, see if I can easily reproduce this. But I'm on a vacation, so
no promisses.


-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Jorge Bastos | 3 May 18:19 2010
Picon

Re: Moving to GIT HEAD

> > mysql> CREATE UNIQUE INDEX dbmail_envelope_1 ON
> > dbmail_envelope(physmessage_id);
> >
> > ERROR 1062 (23000): Duplicate entry '294904' for key 3
> 
> I'd clean out the oldest one.

Going to do it!

> 
> > Other thing is, after using the last GIT HEAD, POP3 doesn’t work,
> check
> > this:
> 
> > +OK 685222690176369404 octets
> 
> Looking at the code I don't see anything obvious. I'll run some tests
> later on, see if I can easily reproduce this. But I'm on a vacation, so
> no promisses.

Oh, good vacation then Paul :)
You'll have time when you came back!

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
Paul J Stevens | 5 May 10:29 2010
Picon

[SCM]Paul's DBMail tree branch, master, updated. 009278eb565c749a3cfeb8bfa04e6acb9ea712c3

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  009278eb565c749a3cfeb8bfa04e6acb9ea712c3 (commit)
      from  4d82947c8fab388885925e1e7d11c3b316e6e65a (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 009278eb565c749a3cfeb8bfa04e6acb9ea712c3
Author: Paul J Stevens <paul@...>
Date:   Wed May 5 10:26:57 2010 +0200

    cleanups and speedups

    cachegrind runs, sigpipe handling, compiler warnings

-----------------------------------------------------------------------

Summary of changes:
 src/clientbase.c            |   15 +++++----------
 src/dbmail-message.c        |    6 ------
 src/dbmail-message.h        |    2 --
 src/dm_cache.c              |   11 +++++------
 src/dm_db.c                 |   11 ++++-------
 src/dm_misc.c               |    5 ++---
 src/modules/sortsieve.c     |    2 +-
 test-scripts/testpop.py     |    5 +++--
 test/check_dbmail_message.c |   21 ---------------------
 9 files changed, 20 insertions(+), 58 deletions(-)

hooks/post-receive
--
Paul's DBMail tree
Mantis Bug Tracker | 5 May 17:08 2010

[DBMail 0000843]: Thunderbird can't fetch message


A NOTE has been added to this issue. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=843 
====================================================================== 
Reported By:                maximP
Assigned To:                paul
====================================================================== 
Project:                    DBMail
Issue ID:                   843
Category:                   IMAP daemon
Reproducibility:            sometimes
Severity:                   crash
Priority:                   normal
Status:                     feedback
target:                      
====================================================================== 
Date Submitted:             15-Apr-10 15:41 CEST
Last Modified:              05-May-10 17:08 CEST
====================================================================== 
Summary:                    Thunderbird can't fetch message
Description: 
Sometimes Thunderbird can't fetch a message from dbmail IMAP server. The
problem appears when opening some messages which contain attachments. The
result is Thunderbird shows in status bar "Loading message..."
notifications, and the loading never finishes (it's interrupted on
timeout). If, after some attempts, the message can be opened, it's cut, not
complete message.
====================================================================== 

---------------------------------------------------------------------- 
 (0003040) paul (administrator) - 15-Apr-10 15:57
 http://www.dbmail.org/mantis/view.php?id=843#c3040 
---------------------------------------------------------------------- 
there's some kind of event-starvation going on since the event_add
recursion fix. 

---------------------------------------------------------------------- 
 (0003041) paul (administrator) - 23-Apr-10 09:04
 http://www.dbmail.org/mantis/view.php?id=843#c3041 
---------------------------------------------------------------------- 
I think I've got this covered now. Please let me know if it's still a
problem. 

---------------------------------------------------------------------- 
 (0003042) maximP (reporter) - 26-Apr-10 09:17
 http://www.dbmail.org/mantis/view.php?id=843#c3042 
---------------------------------------------------------------------- 
The problem became more annoying. The messages are opened quickly, without
delays, but some messages are broken. For example, Thunderbird shows just a
small part of jpeg picture attached to some message. The old version (about
the beginning of March) is OK. 

---------------------------------------------------------------------- 
 (0003044) paul (administrator) - 28-Apr-10 14:48
 http://www.dbmail.org/mantis/view.php?id=843#c3044 
---------------------------------------------------------------------- 
I can't reproduce this. I've been trying with all kinds of attachments, big
and small. 

---------------------------------------------------------------------- 
 (0003052) maximP (reporter) - 05-May-10 17:08
 http://www.dbmail.org/mantis/view.php?id=843#c3052 
---------------------------------------------------------------------- 
Today's (2010-05-05) git version imapd just dies when fetching messages.
The log says:

*** glibc detected *** dbmail-imapd: double free or corruption (!prev):
0x00000000006ebff0 ***
======= Backtrace: =========
/lib64/libc.so.6[0x7f3d3e35a108]
/lib64/libc.so.6(cfree+0x76)[0x7f3d3e35bc66]
/usr/local/dbmail/lib/dbmail/libdbmail.so.0[0x7f3d3fd5f084]
/usr/local/dbmail/lib/dbmail/libdbmail.so.0[0x7f3d3fd5f536]
/usr/local/dbmail/lib/dbmail/libdbmail.so.0[0x7f3d3fd62bf6]
/usr/local/dbmail/lib/dbmail/libdbmail.so.0(imap_get_structure+0x130)[0x7f3d3fd62f20]
dbmail-imapd[0x414cd7]
/usr/lib64/libglib-2.0.so.0(g_tree_foreach+0x5a)[0x7f3d3f617f7a]
dbmail-imapd(dbmail_imap_session_fetch_get_items+0x5e)[0x41420e]
dbmail-imapd[0x40eb73]
/usr/lib64/libglib-2.0.so.0[0x7f3d3f616d27]
/usr/lib64/libglib-2.0.so.0[0x7f3d3f615784]
/lib64/libpthread.so.0[0x7f3d3e646070]
/lib64/libc.so.6(clone+0x6d)[0x7f3d3e3b911d]
======= Memory map: ======== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
15-Apr-10 15:41  maximP         New Issue                                    
15-Apr-10 15:57  paul           Note Added: 0003040                          
23-Apr-10 09:04  paul           Note Added: 0003041                          
23-Apr-10 09:05  paul           Assigned To               => paul            
23-Apr-10 09:05  paul           Status                   new => resolved     
23-Apr-10 09:05  paul           Resolution               open => fixed       
23-Apr-10 09:05  paul           Fixed in Version          => 2.3.7           
26-Apr-10 09:17  maximP         Note Added: 0003042                          
26-Apr-10 09:17  maximP         Status                   resolved => feedback
26-Apr-10 09:17  maximP         Resolution               fixed => reopened   
28-Apr-10 14:48  paul           Note Added: 0003044                          
05-May-10 17:08  maximP         Note Added: 0003052                          
======================================================================
Paul J Stevens | 5 May 18:01 2010
Picon

[SCM]Paul's DBMail tree branch, master, updated. 1f377374467943a56f9b2c33c7886552ac89b0bc

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Paul's DBMail tree".

The branch, master has been updated
       via  1f377374467943a56f9b2c33c7886552ac89b0bc (commit)
      from  009278eb565c749a3cfeb8bfa04e6acb9ea712c3 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 1f377374467943a56f9b2c33c7886552ac89b0bc
Author: Paul J Stevens <paul@...>
Date:   Wed May 5 18:00:07 2010 +0200

    fix small regression

-----------------------------------------------------------------------

Summary of changes:
 src/dm_misc.c |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

hooks/post-receive
--
Paul's DBMail tree
Paul J Stevens | 5 May 18:01 2010
Picon

Re: [DBMail 0000843]: Thunderbird can't fetch message

Mantis Bug Tracker wrote:

> ---------------------------------------------------------------------- 
>  (0003052) maximP (reporter) - 05-May-10 17:08
>  http://www.dbmail.org/mantis/view.php?id=843#c3052 
> ---------------------------------------------------------------------- 
> Today's (2010-05-05) git version imapd just dies when fetching messages.
> The log says:

Fixed that one.

--

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Gmane