Hi
I've trying to get 2.1.5 to work.
After compiling, and installing it I see this log notice in the mail.log
The mail gets both inserted into the mailfolder, and reject which makes
sendmail retry and reinsert the mail.
After reverting to the former install everything works again.
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT 1=1 FROM dbmail_headervalue LIMIT 1 OFFSET 0]
Mar 7 00:27:08 xi dbmail/smtp[30956]:
dbmail-message.c,_set_content_from_stream: parse message
Mar 7 00:27:08 xi dbmail/smtp[30956]: mime.c,mime_fetch_headers: found
[19] mime headers
Mar 7 00:27:08 xi dbmail/smtp[30956]: main.c,main: scanning for
[deliver-to]
Mar 7 00:27:08 xi dbmail/smtp[30956]: mime.c,mail_address_build_list:
mail address parser starting
Mar 7 00:27:08 xi dbmail/smtp[30956]: mime.c,mime_findfield: scanning
for deliver-to
Mar 7 00:27:08 xi dbmail/smtp[30956]: dsn.c, dsnuser_resolve: checking
if [EMAIL PROTECTED] is a valid username, alias, or
catchall.
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
checking user [EMAIL PROTECTED] in alias table
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
checks [0]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) =
lower('[EMAIL PROTECTED]') AND lower(alias) <>
lower(deliver_to)]
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
into checking loop
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
checking user [EMAIL PROTECTED] to 3
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
checking user [3] in alias table
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
checks [1]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) =
lower('3') AND lower(alias) <> lower(deliver_to)]
Mar 7 00:27:08 xi dbmail/smtp[30956]: authsql.c,auth_check_user_ext:
adding [3] to deliver_to address
Mar 7 00:27:08 xi dbmail/smtp[30956]: dsn.c, address_has_alias: user
[EMAIL PROTECTED] found total of [1] aliases
Mar 7 00:27:08 xi dbmail/smtp[30956]: dsn.c, dsnuser_resolve:
delivering [EMAIL PROTECTED] as an alias.
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [BEGIN]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE lower(userid) =
lower('[EMAIL PROTECTED]@__')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: misc.c,create_unique_id: created:
701816680e98e05978e5c6bf568afa51
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1']
Mar 7 00:27:08 xi dbmail/smtp[30956]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_physmessage (messagesize, internal_date)
VALUES ('0', CURRENT_TIMESTAMP)]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_physmessage_id_seq')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id,
unique_id,recent_flag, status) VALUES ('3', '4098',
'701816680e98e05978e5c6bf568afa51', '1', '5')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_message_idnr_seq')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize,
physmessage_id) VALUES ('1','Return-Path:
<[EMAIL PROTECTED]>\\012Received: from localhost
([EMAIL PROTECTED] [127.0.0.1])\\012\\011by
xi.l.electronics-design.nl (8.13.5/8.13.5/Debian-3) with
ESMTP\\012\\011id k26NR85S030946\\011for
<[EMAIL PROTECTED]>;\\012\\011Tue, 7 Mar 2006 00:27:08
+0100\\012Received: from beta.electronics-design.nl
[212.125.143.248]\\011by localhost\\012\\011with POP3
(fetchmail-6.2.5.4)\\012\\011for [EMAIL PROTECTED]
(single-drop); Tue, 07 Mar 2006 00:27:08 +0100 (CET)\\012Received: from
xi.l.electronics-design.nl (81-171-22-172.dsl.fiberworld.nl
[81.171.22.172])\\012\\011by beta.electronics-design.nl (IzNoGooD_0305)
with ESMTP\\012\\011id k26NSXq5020734 (version=TLSv1/SSLv3
cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)\\012\\011for
<[EMAIL PROTECTED]>; Tue, 7 Mar 2006 00:28:35 +0100
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_messageblk_idnr_seq')]
Mar 7 00:27:08 xi dbmail/smtp[30956]:
dbmail-message.c,dbmail_message_store: allocating [524288] bytes of
memory for readblock
Mar 7 00:27:08 xi dbmail/smtp[30956]: pipe.c, store_message_in_blocks:
inserting message:
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize,
physmessage_id) VALUES ('0','\\012\\012', '2', '4098')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_messageblk_idnr_seq')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [UPDATE dbmail_messages SET unique_id =
'701816680e98e05978e5c6bf568afa51', status = '0' WHERE message_idnr =
'8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [UPDATE dbmail_physmessage SET messagesize = '1660', rfcsize =
'1696' WHERE id = '4098']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT dbmail_mailboxes.owner_idnr FROM dbmail_mailboxes,
dbmail_messages WHERE dbmail_mailboxes.mailbox_idnr =
dbmail_messages.mailbox_idnr AND dbmail_messages.message_idnr = '8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: db.c,db_add_quotum_used: adding
1660 to mailsize
Mar 7 00:27:08 xi dbmail/smtp[30956]:
db.c.user_idnr_is_delivery_user_idnr: looking up user_idnr for
[EMAIL PROTECTED]@__
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT user_idnr FROM dbmail_users WHERE lower(userid) =
lower('[EMAIL PROTECTED]@__')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='Content-Type']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (10,4098,'text/plain')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='Return-Path']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (1,4098,'<[EMAIL PROTECTED]>')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='Received']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (2,4098,'from localhost
([EMAIL PROTECTED] [127.0.0.1])^Iby
xi.l.electronics-design.nl (8.13.5/8.13.5/Debian-3) with ESMTP id
k26NR85S030946^Ifor <[EMAIL PROTECTED]>; Tue, 7 Mar 2006
00:27:08 +0100')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (2,4098,'from beta.electronics-design.nl
[212.125.143.248]^Iby localhost with POP3 (fetchmail-6.2.5.4)^Ifor
[EMAIL PROTECTED] (single-drop); Tue, 07 Mar 2006 00:27:08
+0100 (CET)')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (2,4098,'from xi.l.electronics-design.nl
(81-171-22-172.dsl.fiberworld.nl [81.171.22.172])^Iby
beta.electronics-design.nl (IzNoGooD_0305) with ESMTP^Iid k26NSXq5020734
(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)^Ifor
<[EMAIL PROTECTED]')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (2,4098,'from [10.0.0.114] ([10.0.0.114])^Iby
xi.l.electronics-design.nl (8.13.5/8.13.5/Debian-3) with ESMTP^Iid
k26NQtre030941^Ifor <[EMAIL PROTECTED]>;^ITue, 7 Mar 2006
00:26:55 +0100')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='Message-Id']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES
(4,4098,'<[EMAIL PROTECTED]>')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='To']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (6,4098,'[EMAIL PROTECTED]')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='From']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (5,4098,'Marc Dirix <[EMAIL PROTECTED]>')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='Subject']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (7,4098,'test')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='Date']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (3,4098,'Tue, 7 Mar 2006 00:28:30 +0100')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='X-Mailer']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (15,4098,'Apple Mail (2.749)')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE headername='X-Scanned-By']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (19,4098,'milter-date/0.12.160
(beta.electronics-design.nl^I[212.125.143.248]); Tue, 07 Mar 2006
00:28:35 +0100')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (19,4098,'milter-sender/0.62.837
(beta.electronics-design.nl^I[212.125.143.248]); Tue, 07 Mar 2006
00:28:35 +0100')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE
headername='X-milter-date-PASS']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (23,4098,'YES')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE
headername='X-Virus-Scanned']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (24,4098,'ClamAV version 0.88, clamav-milter version
0.87 on beta')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE
headername='X-Virus-Status']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (25,4098,'Clean')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT id FROM dbmail_headername WHERE
headername='X-DBMail-PhysMessage-ID']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue) VALUES (9,4098,'4098')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr)
VALUES (4098,'','[EMAIL PROTECTED]')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_fromfield (physmessage_id, fromname, fromaddr)
VALUES (4098,'Marc Dirix','[EMAIL PROTECTED]')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES
(4098,'2006-03-06 23:28:30')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield)
VALUES (4098,'test')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: pipe.c, insert_messages:
temporary msgidnr is [8280]
Mar 7 00:27:08 xi dbmail/smtp[30956]: pipe.c, insert_messages: calling
sort_and_deliver for useridnr [3]
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='3']
Mar 7 00:27:08 xi dbmail/smtp[30956]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT pm.messagesize FROM dbmail_physmessage pm, dbmail_messages
msg WHERE pm.id = msg.physmessage_id AND message_idnr = '8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT 1 FROM dbmail_users WHERE user_idnr = '3' AND
(maxmail_size > 0) AND (curmail_size + '1660' > maxmail_size)]
Mar 7 00:27:08 xi dbmail/smtp[30956]: misc.c,create_unique_id: created:
f3cfe2370080243e17842f14d2d30010
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [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,
'f3cfe2370080243e17842f14d2d30010', status FROM dbmail_messages WHERE
message_idnr = '8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT currval('dbmail_message_idnr_seq')]
Mar 7 00:27:08 xi dbmail/smtp[30956]: db.c,db_add_quotum_used: adding
1660 to mailsize
Mar 7 00:27:08 xi dbmail/smtp[30956]:
db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for
[EMAIL PROTECTED]@__
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [UPDATE dbmail_users SET curmail_size = curmail_size + '1660'
WHERE user_idnr = '3']
Mar 7 00:27:08 xi dbmail/smtp[30956]: sort.c, sort_deliver_to_mailbox:
message id=8281, size=1660 is inserted
Mar 7 00:27:08 xi dbmail/smtp[30956]: sort.c, sort_and_deliver: Keep
was not cancelled. Message will be delivered by default.
Mar 7 00:27:08 xi dbmail/smtp[30956]: pipe.c, insert_messages:
successful sort_and_deliver for useridnr [3]
Mar 7 00:27:08 xi dbmail/smtp[30956]: pipe.c, insert_messages: deliver
[0] messages to external addresses
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr =
'8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [DELETE FROM dbmail_messages WHERE message_idnr = '8280']
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [SELECT message_idnr FROM dbmail_messages WHERE physmessage_id =
'4098']
Mar 7 00:27:08 xi dbmail/smtp[30956]: pipe.c, insert_messages:
temporary message deleted from database. Done.
Mar 7 00:27:08 xi dbmail/smtp[30956]: dbpgsql.c,db_query: executing
query [COMMIT]
Mar 7 00:27:08 xi dbmail/smtp[30956]: main(): freeing dsnuser list
Mar 7 00:27:08 xi dbmail/smtp[30956]: dsn.c, dsnuser_free: dsnuser
freed
Mar 7 00:27:08 xi sm-mta[30955]: k26NR85S030946: SYSERR(root): mailer
dbmail died with signal 11
Mar 7 00:27:08 xi sm-mta[30955]: k26NR85S030946:
to=<[EMAIL PROTECTED]>, delay=00:00:00, xdelay=00:00:00,
mailer=dbmail, pri=121391, relay=l.electronics-design.nl, dsn=4.0.0,
stat=Deferred: dbmail mailer (/usr/sbin/dbmail-smtp) exited with
EX_TEMPFAIL
