I've just setup for the first time a domain forward with dbmail-users -x @gabl.gv.at -t @gabl-bruck.at
and this made it correctly into the database. But when sending to f...@gabl.gv.at, LMTP delivers the message somewhere into dbmail, instead of back to postfix in order to deliver it to another server (gabl- bruck.at is not local on this system). Maybe this forward should be done at the postfix level already, but for management reasons I'd prefer dbmail does it, as I don't want to store such redirects in an external table. Trace 5 of lmtp attached. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[serverchild] serverchild.c,select_and_accept(+282): connection accepted
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Message:[serverchild] serverchild.c,PerformChildTask(+349): incoming connection from [127.0.0.1] by pid [16997]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[serverchild] serverchild.c,PerformChildTask(+374): client info init complete, calling client handler
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [LHLO mailsrv1.zmi.at]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+284): command issued :cmd [LHLO], value [mailsrv1.zmi.at]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 0
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [MAIL FROM:<r...@mailsrv1.zmi.at> SIZE=424]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+284): command issued :cmd [MAIL], value [FROM:<r...@mailsrv1.zmi.at> SIZE=424]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 4
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[misc] misc.c,find_bounded(+375): Found [r...@mailsrv1.zmi.at] of length [20] between '<' and '>' so next skip [26]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [RCPT TO:<c.my...@gabl.gv.at>]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+284): command issued :cmd [RCPT], value [TO:<c.my...@gabl.gv.at>]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 9
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[misc] misc.c,find_bounded(+375): Found [c.my...@gabl.gv.at] of length [18] between '<' and '>' so next skip [22]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,dsnuser_init(+202): dsnuser initialized
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,dsnuser_resolve(+578): checking if [c.my...@gabl.gv.at] is a valid username, alias, or catchall.
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+222): checking user [c.my...@gabl.gv.at] in alias table
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+239): checks [0]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('c.my...@gabl.gv.at') AND lower(alias) <> lower(deliver_to)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+266): user c.my...@gabl.gv.at not in aliases table
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,address_has_alias(+251): user [c.my...@gabl.gv.at] found total of [0] aliases
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('c.my...@gabl.gv.at')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,address_is_username(+348): username not found [c.my...@gabl.gv.at]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,address_is_domain_catchall(+370): user [c.my...@gabl.gv.at] checking for domain forwards.
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,address_is_domain_catchall(+382): domain [...@gabl.gv.at] checking for domain forwards
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+222): checking user [...@gabl.gv.at] in alias table
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+239): checks [0]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('@gabl.gv.at') AND lower(alias) <> lower(deliver_to)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+273): into checking loop
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+279): checking user @gabl.gv.at to @gabl-bruck.at
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+222): checking user [...@gabl-bruck.at] in alias table
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+239): checks [1]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('@gabl-bruck.at') AND lower(alias) <> lower(deliver_to)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[auth] authsql.c,auth_check_user_ext(+261): adding [...@gabl-bruck.at] to deliver_to address
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,address_is_domain_catchall(+419): domain [...@gabl.gv.at] found total of [1] aliases
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[dsn] dsn.c,dsnuser_resolve(+605): delivering [c.my...@gabl.gv.at] as a domain catchall.
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+270): incoming buffer: [DATA]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+292): command looked up as commandtype 3
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+554): requesting sender to begin message.
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[message] dbmail-message.c,_set_content_from_stream(+425): parse message
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[lmtp] lmtp.c,lmtp(+585): whole message = Received: by mailsrv1.zmi.at (Postfix, from userid 0) id 0762E5491; Tue, 23 Jun 2009 18:37:31 +0200 (CEST) Date: Tue, 23 Jun 2009 18:37:31 +0200 To: c.my...@gabl.gv.at Subject: test User-Agent: Heirloom mailx 12.1 6/15/06 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20090623163732.0762e5...@mailsrv1.zmi.at> From: r...@mailsrv1.zmi.at (root) test
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [BEGIN]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('_...@!internal_delivery_user!@__')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,create_unique_id(+113): created: 0f2bb07b92fce5112554ccb6713d58fa
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] db.c,db_findmailbox(+2605): looking for mailbox with FQN [INBOX].
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,mailbox_remove_namespace(+176): [INBOX]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name ILIKE 'INBOX' AND owner_idnr=1]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] db.c,db_find_create_mailbox(+3471): mailbox [INBOX] found
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES (0, CURRENT_TIMESTAMP)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_physmessage_id_seq')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id, unique_id,recent_flag, status) VALUES (7, 2045064, '0f2bb07b92fce5112554ccb6713d58fa', 1, 5)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_message_idnr_seq')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize, physmessage_id) VALUES (1,'Received: by mailsrv1.zmi.at (Postfix, from userid 0)\\011id 0762E5491;\\012\\011Tue, 23 Jun 2009 18:37:31 +0200 (CEST)\\012Date: Tue, 23 Jun 2009 18:37:31 +0200\\012To: c.my...@gabl.gv.at\\012subject: test\\012User-Agent: Heirloom mailx 12.1 6/15/06\\012Message-Id: <20090623163732.0762e5...@mailsrv1.zmi.at>\\012From: r...@mailsrv1.zmi.at (root)\\012Return-Path: r...@mailsrv1.zmi.at\\012mime-version: 1.0\\012Content-Type: text/plain; charset=us-ascii\\012Content-Transfer-Encoding: 7bit\\012\\012', 440, 2045064)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_messageblk_idnr_seq')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[delivery] pipe.c,store_message_in_blocks(+479): inserting message [test ]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_messageblks (is_header, messageblk,blocksize, physmessage_id) VALUES (0,'test\\012', 5, 2045064)]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT currval('dbmail_messageblk_idnr_seq')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [UPDATE dbmail_messages SET unique_id = '0f2bb07b92fce5112554ccb6713d58fa', status = 0 WHERE message_idnr = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [UPDATE dbmail_physmessage SET messagesize = 445, rfcsize = 459 WHERE id = 2045064]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: 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 = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] db.c,user_idnr_is_delivery_user_idnr(+4592): looking up user_idnr for [...@!internal_delivery_user!@__]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('_...@!internal_delivery_user!@__')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='content-type']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_iconv_init(+2085): key "ENCODING" section "DBMAIL" var ic->db_charset value [utf8]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_iconv_init(+2086): key "DEFAULT_MSG_ENCODING" section "DBMAIL" var ic->msg_charset value [utf8]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_iconv_init(+2110): Initialize DB encoding surface [UTF-8..utf8]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_iconv_init(+2114): Initialize DB decoding surface [utf8..UTF-8]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_iconv_init(+2118): Initialize default MSG decoding surface [utf8..UTF-8]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (2,2045064,'text/plain; charset=us-ascii')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='date']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (3,2045064,'Tue, 23 Jun 2009 18:37:31 +0200')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='from']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (4,2045064,'root <r...@mailsrv1.zmi.at>')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='message-id']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (5,2045064,'<20090623163732.0762e5...@mailsrv1.zmi.at>')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='received']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (6,2045064,'by mailsrv1.zmi.at (Postfix, from userid 0) id 0762E5491; Tue, 23 Jun 2009 18:37:31 +0200 (CEST)')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='return-path']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (7,2045064,'r...@mailsrv1.zmi.at')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='subject']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (9,2045064,'test')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='to']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (10,2045064,'c.my...@gabl.gv.at')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='user-agent']
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (55,2045064,'Heirloom mailx 12.1 6/15/06')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_tofield (physmessage_id, toname, toaddr) VALUES (2045064,'','c.my...@gabl.gv.at')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_fromfield (physmessage_id, fromname, fromaddr) VALUES (2045064,'root','r...@mailsrv1.zmi.at')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES (2045064,'2009-06-23 16:37:31')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_subjectfield (physmessage_id, subjectfield) VALUES (2045064,'test')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_imap_append_alist_as_plist(+1890): handling a standard address [root] [r...@mailsrv1.zmi.at].
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_imap_append_alist_as_plist(+1890): handling a standard address [root] [r...@mailsrv1.zmi.at].
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_imap_append_alist_as_plist(+1890): handling a standard address [root] [r...@mailsrv1.zmi.at].
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[misc] misc.c,dbmail_imap_append_alist_as_plist(+1890): handling a standard address [(null)] [c.my...@gabl.gv.at].
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_envelope (physmessage_id, envelope) VALUES (2045064,'("Tue, 23 Jun 2009 18:37:31 +0200" "test" (("root" NIL "root" "mailsrv1.zmi.at")) (("root" NIL "root" "mailsrv1.zmi.at")) (("root" NIL "root" "mailsrv1.zmi.at")) ((NIL NIL "c.mynha" "gabl.gv.at")) NIL NIL NIL "<20090623163732.0762e5...@mailsrv1.zmi.at>")')]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[delivery] pipe.c,insert_messages(+549): temporary msgidnr is [4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [COMMIT]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] db.c,db_commit_transaction(+214): last transaction took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[delivery] pipe.c,insert_messages(+644): deliver [1] messages to external addresses
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[delivery] pipe.c,insert_messages(+649): delivering to external addresses
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[delivery] pipe.c,send_forward_list(+217): delivering to [1] external addresses
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[delivery] pipe.c,parse_and_escape(+54): parsing address [...@gabl-bruck.at]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Message:[delivery] pipe.c,parse_and_escape(+57): unable to parse email address [...@gabl-bruck.at]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Message:[delivery] pipe.c,send_mail(+125): could not prepare 'to' address.
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [DELETE FROM dbmail_messages WHERE message_idnr = 4049067]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = 2045064]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [DELETE FROM dbmail_physmessage WHERE id = 2045064]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[sql] dbpgsql.c,db_query(+279): [DELETE FROM dbmail_messageblks WHERE physmessage_id = 2045064]
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[delivery] pipe.c,insert_messages(+667): temporary message deleted from database. Done.
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[dsn] dsn.c,dsnuser_free(+230): dsnuser freed
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Debug:[serverchild] serverchild.c,PerformChildTask(+379): client handling complete, closing streams
Jun 23 18:37:32 mailsrv1.zmi.at dbmail/lmtpd[16997]: Info:[serverchild] serverchild.c,PerformChildTask(+381): connection closed
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
