I am resending this because although I see it in the old archives I don't see it in the new archives and I never saw it go out on the list. Forgive me if you have already received and discarded this question :-)
------------------------------------------------------------------------------------------------------------ Hi, I just upgraded to dbmail 2.2.1 with exim and am having a problem with none of the message bodies showing up. Any messages that were delivered under 2.1.7 show up fine but anything that has been delivered since moving to 2.2.1 has no body. I have tried with both lmtp and smtp but neither seems to work. My exim configuration has not changed (except to switch between lmpt and smtp when testing). If I move back to the 2.1.7 lmtp any new messages have a body. Here is a level 5 trace: Dec 9 09:16:32 [exim] 2006-12-09 09:16:32 1Gt5oO-0003qS-Jp <= user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail> H=nf-out-0910.google.com [64.233.182.188] P=esmtp S=1596 id= 3d9db1730612090916tddf987le421e786b789e36d at mail.gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail> Dec 9 09:16:32 [dbmail/smtp] Debug:[db] dbmodule.c,db_load_driver(+67): looking for pgsql as modules/.libs/libpgsql.so Dec 9 09:16:32 [dbmail/smtp] Info:[db] dbmodule.c,db_load_driver(+71): cannot load modules/.libs/libpgsql.so: cannot open shared object file: No such file or directory Dec 9 09:16:32 [dbmail/smtp] Debug:[db] dbmodule.c,db_load_driver(+67): looking for pgsql as /usr/local/lib/dbmail/libpgsql.so Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authmodule.c,auth_load_driver(+63): looking for auth_sql as modules/.libs/libauth_sql.so Dec 9 09:16:32 [dbmail/smtp] Info:[auth] authmodule.c,auth_load_driver(+67): cannot load modules/.libs/libauth_sql.so: cannot open shared object file: No such file or directory Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authmodule.c,auth_load_driver(+63): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT 1=1 FROM dbmail_headervalue LIMIT 1 OFFSET 0] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT 1=1 FROM dbmail_envelope LIMIT 1 OFFSET 0] Dec 9 09:16:32 [dbmail/smtp] Debug:[message] dbmail-message.c,_set_content_from_stream(+469): parse message Dec 9 09:16:32 [dbmail/smtp] Info:[dsn] dsn.c,dsnuser_resolve(+558): checking if [user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>] is a valid username, alias, or catchall. Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+219): checking user [user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>] in alias table Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+236): checks [0] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>') AND lower(alias) <> lower(deliver_to)] Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+270): into checking loop Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+276): checking user user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail> to 3 Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+219): checking user [3] in alias table Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+236): checks [1] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('3') AND lower(alias) <> lower(deliver_to)] Dec 9 09:16:32 [dbmail/smtp] Debug:[auth] authsql.c,auth_check_user_ext(+258): adding [3] to deliver_to address Dec 9 09:16:32 [dbmail/smtp] Debug:[dsn] dsn.c,address_has_alias(+262): user [user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>] found total of [1] aliases Dec 9 09:16:32 [dbmail/smtp] Info:[dsn] dsn.c,dsnuser_resolve(+565): delivering [user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>] as an alias. Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [BEGIN] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('[EMAIL PROTECTED]@__')] Dec 9 09:16:32 [dbmail/smtp] Debug:[misc] misc.c,create_unique_id(+109): created: 701816680e98e05978e5c6bf568afa51 Dec 9 09:16:32 [dbmail/smtp] Debug:[db] db.c,db_findmailbox(+2296): looking for mailbox with FQN [INBOX]. Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name ILIKE 'INBOX' AND owner_idnr=1] Dec 9 09:16:32 [dbmail/smtp] Debug:[db] db.c,db_find_create_mailbox(+3129): mailbox [INBOX] found Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES (0, TO_TIMESTAMP('2006-12-09 09:16:32', 'YYYY-MM-DD HH:MI:SS'))] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_physmessage_id_seq')] Dec 9 09:16:32 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id, unique_id,recent_flag, status) VALUES (3, 13820, '701816680e98e05978e5c6bf568afa51', 1, 5)] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_message_idnr_seq')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize, physmessage_id) VALUES (1,'Received: from nf-out-0910.google.com ([64.233.182.188])\\012\\011by mail2.majro.dhs.org\\012\\011with esmtp (Exim 4.62)\\011(envelope-from < user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>)\\012\\011id 1Gt5oO-0003qS-Jp\\011for user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>;\\012\\011Sat, 09 Dec 2006 09:16:32 -0800\\012Received: by nf-out-0910.google.com with SMTP id x4so1579210nfb\\012\\011for <user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>; Sat, 09 Dec 2006 09:16:31 -0800 (PST)\\012DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; \\012\\011h=received:message-id:date:from:to:subject:mime-version:content-type; \\012\\011b=Og5ha1TUWosLuhOJtnvF6PbgDVnoDXxtk7CWefv/Azm0CnyId1zfPqT9GPd/rXQLvEw6EGjQCk53P5lVQ6l6BTSvLUPeA/6MiVUdI1QPXI9K0uZ9GG911releeRiU57SoPolCvVExiXNG7ZiPjn/gso9sKuEA0vpeDQvYt+O2pw=\\012Received: by 10.49.93.4 with SMTP\\012\\011id v4mr67573nfl.1165684590587; Sat, 09 Dec 2006 09:16:30 -0800 (PST)\\012Received: by 10.48.12.18 with HTTP; Sat, 9 Dec 2006 09:16:30 -0800 (PST)\\012Message-ID: < 3d9db1730612090916tddf987le421e786b789e36d at mail.gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>\\012Date: Sat, 9 Dec 2006 09:16:30 -0800\\012From: "E-mail User" <user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>\\012To: user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>\\012Subject: Mail delivery\\012Return-Path: "E-mail User" < user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>\\012X-DBMail-PhysMessage-ID: 13820\\012MIME-Version: 1.0\\012Content-Type:multipart/alternative;\\012\\011boundary="----=_Part_30737_14653407.1165684590561"\\012\\012', 1263, 13820)] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_messageblk_idnr_seq')] Dec 9 09:16:33 [dbmail/smtp] Debug:[message] dbmail-message.c,dbmail_message_store(+861): allocating [524288] bytes of memory for readblock Dec 9 09:16:33 [dbmail/smtp] Debug:[delivery] pipe.c,store_message_in_blocks(+477): inserting message [------=_Part_30737_14653407.1165684590561_Content-Type: text/plain; charset=ISO-8859-1; format=flowed_Content-Transfer-Encoding: 7bit_Content-Disposition: inline__Does the body show up?__------=_Part_30737_14653407.1165684590561_Content-Type: text/html; charset=ISO-8859-1_Content-Transfer-Encoding: 7bit_Content-Disposition: inline__Does the body show up?<br>__------=_Part_30737_14653407.1165684590561--__] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize, physmessage_id) VALUES (0,'------=_Part_30737_14653407.1165684590561\\012Content-Type: text/plain; charset=ISO-8859-1; format=flowed\\012Content-Transfer-Encoding: 7bit\\012Content-Disposition: inline\\012\\012Does the body show up?\\012\\012------=_Part_30737_14653407.1165684590561\\012Content-Type: text/html; charset=ISO-8859-1\\012Content-Transfer-Encoding: 7bit\\012Content-Disposition: inline\\012\\012Does the body show up?<br>\\012\\012------=_Part_30737_14653407.1165684590561--\\012\\012', 407, 13820)] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_messageblk_idnr_seq')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [UPDATE dbmail_messages SET unique_id = '701816680e98e05978e5c6bf568afa51', status = 0 WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [UPDATE dbmail_physmessage SET messagesize = 1670, rfcsize = 1710 WHERE id = 13820] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT dbmail_mailboxes.owner_idnr FROM dbmail_mailboxes, dbmail_messages WHERE dbmail_mailboxes.mailbox_idnr = dbmail_messages.mailbox_idnr AND dbmail_messages.message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,user_idnr_is_delivery_user_idnr(+4310): looking up user_idnr for [EMAIL PROTECTED]@__] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('[EMAIL PROTECTED]@__')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='Content-Type'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (323,13820,'multipart/alternative; _boundary="----=_Part_30737_14653407.1165684590561"')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='Date'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (6,13820,'Sat, 9 Dec 2006 09:16:30 -0800')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='DomainKey-Signature'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (31,13820,'a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=Og5ha1TUWosLuhOJtnvF6PbgDVnoDXxtk7CWefv/Azm0CnyId1zfPqT9GPd/rXQLvEw6EGjQCk53P5lVQ6l6BTSvLUPeA/6MiVUdI1QPXI9K0uZ9GG911releeRiU57SoPolCvVExiXNG7ZiPjn/gso9sKuEA0vpeDQvYt+O2pw=')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='From'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (7,13820,'E-mail User <user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='Message-ID'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (5,13820,'<3d9db1730612090916tddf987le421e786b789e36d at mail.gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='Received'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (2,13820,'by nf-out-0910.google.com with SMTP id x4so1579210nfb for < user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>; Sat, 09 Dec 2006 09:16:31 -0800 (PST)')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (2,13820,'from nf-out-0910.google.com ([64.233.182.188])_by mail2.majro.dhs.org with esmtp (Exim 4.62)_(envelope-from <user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>)_id 1Gt5oO-0003qS-Jp_for user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>; Sat, 09 Dec 2006 09:16:32 -0800')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (2,13820,'by 10.49.93.4 with SMTP id v4mr67573nfl.1165684590587; Sat, 09 Dec 2006 09:16:30 -0800 (PST)')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (2,13820,'by 10.48.12.18 with HTTP; Sat, 9 Dec 2006 09:16:30 -0800 (PST)')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='Subject'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (9,13820,'Mail delivery')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE headername='To'] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (8,13820,'user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (13820,'',' user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_fromfield (physmessage_id, fromname, fromaddr) VALUES (13820,'E-mail User','user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (13820,'2006-12-09 17:16:30')] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (13820,'Mail delivery')] Dec 9 09:16:33 [dbmail/smtp] Debug:[misc] misc.c,dbmail_imap_append_alist_as_plist(+1824): handling a standard address [E-mail User] [user at gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>]. - Last output repeated 2 times - Dec 9 09:16:33 [dbmail/smtp] Debug:[misc] misc.c,dbmail_imap_append_alist_as_plist(+1824): handling a standard address [(null)] [user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>]. Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_envelope (physmessage_id, envelope) VALUES (13820,'("Sat, 09 Dec 2006 09:16:30 -0800" "Mail delivery" (("E-mail User" NIL "user" "gmail.com")) (("E-mail User" NIL "user" "gmail.com")) (("E-mail User" NIL "user" " gmail.com")) ((NIL NIL "user" "domain.tld")) NIL NIL NIL "< 3d9db1730612090916tddf987le421e786b789e36d at mail.gmail.com <https://mailman.fastxs.nl/mailman/listinfo/dbmail>>")')] Dec 9 09:16:33 [dbmail/smtp] Debug:[delivery] pipe.c,insert_messages(+547): temporary msgidnr is [30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[delivery] pipe.c,insert_messages(+570): calling sort_and_deliver for useridnr [3] Dec 9 09:16:33 [dbmail/smtp] Info:[sort] sort.c,sort_and_deliver(+55): Destination [user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>] useridnr [3], mailbox [(null)], source [4] Dec 9 09:16:33 [dbmail/smtp] Info:[misc] misc.c,find_bounded(+313): Found nothing between '+' and '@' Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT name FROM dbmail_sievescripts WHERE owner_idnr = 3 AND active = 1] Dec 9 09:16:33 [dbmail/smtp] Info:[sort] sort.c,sort_deliver_to_mailbox(+136): useridnr [3] mailbox [INBOX] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,db_findmailbox(+2296): looking for mailbox with FQN [INBOX]. Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name ILIKE 'INBOX' AND owner_idnr=3] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,db_find_create_mailbox(+3129): mailbox [INBOX] found Dec 9 09:16:33 [dbmail/smtp] Debug:[sort] sort.c,sort_deliver_to_mailbox(+150): Checking if we have the right to post incoming messages Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = 1] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,db_acl_has_right(+3956): checking ACL [post_flag] for user [3] on mailbox [1] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT owner_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = 1] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,db_acl_has_right(+3966): mailbox [1] is owned by user [3], is that also [3]? Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,db_acl_has_right(+3970): mailbox [1] is owned by user [3], giving all rights Dec 9 09:16:33 [dbmail/smtp] Info:[sort] sort.c,sort_deliver_to_mailbox(+175): user [3] has right to deliver mail to [INBOX] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT pm.messagesize FROM dbmail_physmessage pm, dbmail_messages msg WHERE pm.id = msg.physmessage_id AND message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT 1 FROM dbmail_users WHERE user_idnr = 3 AND (maxmail_size > 0) AND (curmail_size + 1670 > maxmail_size)] Dec 9 09:16:33 [dbmail/smtp] Debug:[misc] misc.c,create_unique_id(+109): created: 559f6743b00d1d507b2264799c6d6cb0 Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messages (mailbox_idnr,physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, unique_id, status) SELECT 1, physmessage_id, seen_flag, answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, '559f6743b00d1d507b2264799c6d6cb0', status FROM dbmail_messages WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_message_idnr_seq')] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,user_idnr_is_delivery_user_idnr(+4320): no need to look up user_idnr for [EMAIL PROTECTED]@__] Dec 9 09:16:33 [dbmail/smtp] Debug:[db] db.c,user_quotum_inc(+336): adding 1670 to mailsize Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [UPDATE dbmail_users SET curmail_size = curmail_size + 1670 WHERE user_idnr = 3] Dec 9 09:16:33 [dbmail/smtp] Message:[sort] sort.c,sort_deliver_to_mailbox(+195): message id=30263, size=1670 is inserted Dec 9 09:16:33 [dbmail/smtp] Info:[sort] sort.c,sort_and_deliver(+112): Keep was not cancelled. Message will be delivered by default. Dec 9 09:16:33 [dbmail/smtp] Info:[delivery] pipe.c,insert_messages(+577): successful sort_and_deliver for useridnr [3] Dec 9 09:16:33 [dbmail/smtp] Debug:[delivery] pipe.c,insert_messages(+636): deliver [0] messages to external addresses Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [DELETE FROM dbmail_messages WHERE message_idnr = 30262] Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = 13820] Dec 9 09:16:33 [dbmail/smtp] Debug:[delivery] pipe.c,insert_messages(+658): temporary message deleted from database. Done. Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [COMMIT] Dec 9 09:16:33 [dbmail/smtp] Debug:[dsn] dsn.c,dsnuser_free(+241): dsnuser freed Dec 9 09:16:33 [dbmail/smtp] Debug:[smtp] main.c,main(+379): they're all free. we're done. Dec 9 09:16:33 [dbmail/smtp] Debug:[smtp] main.c,main(+387): exit code is [0]. Dec 9 09:16:33 [exim] 2006-12-09 09:16:33 1Gt5oO-0003qS-Jp => user < user at domain.tld <https://mailman.fastxs.nl/mailman/listinfo/dbmail>> R=dbmail_aliases T=transport_dbmail Dec 9 09:16:33 [exim] 2006-12-09 09:16:33 1Gt5oO-0003qS-Jp Completed Thanks for the help. David
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
