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 <=
[EMAIL PROTECTED] H=nf-out-0910.google.com [64.233.182.188] P=esmtp S=1596 id=
[EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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('[EMAIL PROTECTED]')
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] found total of [1] aliases
Dec 9 09:16:32 [dbmail/smtp] Info:[dsn] dsn.c,dsnuser_resolve(+565):
delivering [EMAIL PROTECTED] 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 <
[EMAIL PROTECTED]>)\\012\\011id 1Gt5oO-0003qS-Jp\\011for
[EMAIL PROTECTED];\\012\\011Sat,
09 Dec 2006 09:16:32 -0800\\012Received: by nf-out-0910.google.com with SMTP
id x4so1579210nfb\\012\\011for <[EMAIL PROTECTED]>; 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: <
[EMAIL PROTECTED]>\\012Date: Sat, 9
Dec 2006 09:16:30 -0800\\012From: "E-mail User" <[EMAIL PROTECTED]>\\012To:
[EMAIL PROTECTED]: Mail delivery\\012Return-Path: "E-mail User" <
[EMAIL PROTECTED]>\\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 <[EMAIL PROTECTED]>')]
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,'<[EMAIL PROTECTED]>')]
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 <
[EMAIL PROTECTED]>; 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 <[EMAIL
PROTECTED]>)_id
1Gt5oO-0003qS-Jp_for [EMAIL PROTECTED]; 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,'[EMAIL PROTECTED]')]
Dec 9 09:16:33 [dbmail/smtp] Debug:[sql] dbpgsql.c,db_query(+279): [INSERT
INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (13820,'','
[EMAIL PROTECTED]')]
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','[EMAIL PROTECTED]')]
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] [EMAIL PROTECTED]
- 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)] [EMAIL PROTECTED]
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 "<
[EMAIL PROTECTED]>")')]
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 [EMAIL PROTECTED] 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 <
[EMAIL PROTECTED]> 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
