I'm sending this to the dev list, where it belongs. Aaron, you're the main man
on this subject. Any ideas?
Ewald Geschwinde wrote:
Sorry that I write to you but I have a question whether this is a bug in
the package or not? (dbmail-pgsql sarge testing 1.2.11)
I have added the 2 entries in the alias table:
17 | [EMAIL PROTECTED] | [EMAIL PROTECTED] |
0
20 | [EMAIL PROTECTED] | 15 |
0
from users table:
15 | [EMAIL PROTECTED] |
36 | [EMAIL PROTECTED]
The following trace i try to send a mail to [EMAIL PROTECTED] and it is
not forwarded to [EMAIL PROTECTED]
Jan 18 13:05:09 cybserv postfix/pipe[20773]: 58D5CC03D:
to=<[EMAIL PROTECTED]>, relay=spamassassin, delay=8, status=sent (cybserv)
Jan 18 13:05:09 cybserv postfix/qmgr[19660]: 58D5CC03D: removed
Jan 18 13:05:09 cybserv postfix/qmgr[19660]: C8BD9C13E:
from=<[EMAIL PROTECTED]>, size=1077, nrcpt=1 (queue active)
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): searching
value for config item [host]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): found
value [localhost]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): searching
value for config item [db]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): found
value [dbmail]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): searching
value for config item [user]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): found
value [postgres]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): searching
value for config item [pass]
Jan 18 13:05:09 cybserv dbmail/smtp[20802]: GetConfigValue(): found
value []
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: read_header(): readheader
start
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: read_header(): end header
found
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: read_header(): readheader
done
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: read_header(): found header
[Received: by cybserv (Postfix, from userid 65534) ^Iid C8BD9C13E; Tue,
18 Jan 2005 13:05:09 +0100 (CET) Received: from imap.univie.ac.at
(mailbox-lmtp.univie.ac.at [131.130.1.27]) ^Iby cybserv (Postfix) with
ESMTP id 58D5CC03D ^Ifor <[EMAIL PROTECTED]>; Tue, 18 Jan 2005 13:05:01
+0100 (CET) Received: from pcge.cc.univie.ac.at (pcge.cc.univie.ac.at
[131.130.2.58]) ^Iby imap.univie.ac.at (8.12.10/8.12.10) with ESMTP id
j0IC4sXK169270 ^Ifor <[EMAIL PROTECTED]>; Tue, 18 Jan 2005 13:04:57 +0100
Subject: testmail From: Ewald Geschwinde <[EMAIL PROTECTED]> To:
[EMAIL PROTECTED] Content-Type: text/plain Date: Tue, 18 Jan 2005 13:02:10
+0100 Message-Id: <[EMAIL PROTECTED]>
Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 Content-Transfer-Encoding:
7bit X-DCC-ZID-Univie-Metrics: mx9.univie.ac.at 4247; Body=1 Fuz1=1
X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on cybserv
X-Spam-Level: X-Spam-Status: No, score=0.0 required=5.
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: read_header(): header size
[998]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: read_header(): function
successfull
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mime_readheader(): entering
mime loop
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mime_readheader(): found
double newline; header size: 23 lines
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): mimelist
currently has [16] nodes
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): mail
address parser starting
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): total
fields in header 16
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): scanning
for Return-Path
Jan 18 13:05:10 cybserv last message repeated 15 times
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): found 0
emailaddresses
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): mail
address parser finished
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): mimelist
currently has [16] nodes
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): mail
address parser starting
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): total
fields in header 16
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): scanning
for From
Jan 18 13:05:10 cybserv last message repeated 11 times
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): found
[EMAIL PROTECTED], next in list is (null)
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): scanning
for From
Jan 18 13:05:10 cybserv last message repeated 3 times
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): found 1
emailaddresses
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: mail_adr_list(): mail
address parser finished
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: main(): using
SPECIAL_DELIVERY to usernames
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: __auth_query(): connection
ok
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: __auth_query(): executing
query [SELECT user_idnr FROM users WHERE userid='[EMAIL PROTECTED]']
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): added
user [EMAIL PROTECTED] id [36] to delivery list
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): alias
deliver_to is [36]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: create_unique_id(): created:
ca001ed6f38f290363eb7232f1d15b05
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE lower(name) = lower('(null)')
AND owner_idnr=36::bigint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_get_mailboxid(): user has
no mailbox named [(null)]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE lower(name) = lower('INBOX')
AND owner_idnr=36::bigint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[INSERT INTO
messages(mailbox_idnr,messagesize,unique_id,internal_date,recent_flag,status)
VALUES (108::bigint, 0, 'ca001ed6f38f290363eb7232f1d15b05', '2005-01-18
13:05:10', 1, 5::smallint)]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT currval('message_idnr_seq');]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[INSERT INTO messageblks(messageblk,blocksize,message_idnr) VALUES
('Received: by cybserv (Postfix, from userid 65534) ^Iid C8BD9C13E; Tue,
18 Jan 2005 13:05:09 +0100 (CET) Received: from imap.univie.ac.at
(mailbox-lmtp.univie.ac.at [131.130.1.27]) ^Iby cybserv (Postfix) with
ESMTP id 58D5CC03D ^Ifor <[EMAIL PROTECTED]>; Tue, 18 Jan 2005 13:05:01
+0100 (CET) Received: from pcge.cc.univie.ac.at (pcge.cc.univie.ac.at
[131.130.2.58]) ^Iby imap.univie.ac.at (8.12.10/8.12.10) with ESMTP id
j0IC4sXK169270 ^Ifor <[EMAIL PROTECTED]>; Tue, 18 Jan 2005 13:04:57 +0100
Subject: testmail From: Ewald Geschwinde <[EMAIL PROTECTED]> To:
[EMAIL PROTECTED] Content-Type: text/plain Date: Tue, 18 Jan 2005 13:02:10
+0100 Message-Id: <[EMAIL PROTECTED]>
Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 Content-Transfer-Encoding:
7bit X-DCC-ZID-Univie-Metrics: mx9.univie.ac.at 4247; Body=1 Fuz1=1
X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT currval('messageblk_idnr_seq');]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): we need
to deliver [0] messages to external addresses
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages():
allocating [524288] bytes of memory for readblock
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[INSERT INTO messageblks(messageblk,blocksize,message_idnr) VALUES
('testing -- Ewald Geschwinde <[EMAIL PROTECTED]> ', 50::bigint,
289466::bigint)]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT currval('messageblk_idnr_seq');]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): updating
size fields
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: create_unique_id(): created:
e99cb93d31a10970096984079f7149ed
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[UPDATE messages SET messagesize=1048::bigint,
unique_id='e99cb93d31a10970096984079f7149ed', status=0::smallint,
rfcsize = 0::bigint WHERE message_idnr=289466::bigint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT owner_idnr FROM mailboxes WHERE mailbox_idnr = (SELECT
mailbox_idnr FROM messages WHERE message_idnr = 289466::bigint)]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT mailbox_idnr FROM mailboxes WHERE owner_idnr = 36::bigint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_check_sizelimit():
checking mailbox [108]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_check_mailboxsize():
executing query [SELECT SUM(messagesize) FROM messages WHERE
mailbox_idnr = 108::bigint AND status<2::smallint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT SUM(messagesize) FROM messages WHERE mailbox_idnr = 108::bigint
AND status<2::smallint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: __auth_query(): connection
ok
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: __auth_query(): executing
query [SELECT maxmail_size FROM users WHERE user_idnr = 36::bigint]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_check_sizelimit():
comparing currsize + blocksize [6181], maxsize [0]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): message
id=289466, size=1048 is inserted
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: GetConfigValue(): searching
value for config item [AUTO_NOTIFY]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: GetConfigValue(): found
value [no]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: GetConfigValue(): searching
value for config item [AUTO_REPLY]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: GetConfigValue(): found
value [yes]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): starting
auto-reply procedure
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: db_query(): executing query
[SELECT reply_body FROM auto_replies WHERE user_idnr = 36]
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): no reply
body specified, skipping auto-reply
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): Freeing
memory blocks
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): header
freed
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): uniqueid
freed
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): strblock
freed
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages():
insertquery freed
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages():
updatequery freed
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: insert_messages(): End of
function
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: main(): freeing memory
blocks
Jan 18 13:05:10 cybserv dbmail/smtp[20802]: main(): they're all free.
we're done.
Jan 18 13:05:10 cybserv postfix/pipe[20800]: C8BD9C13E:
to=<[EMAIL PROTECTED]>, relay=dbmail, delay=1, status=sent (tecwing.ch)
Jan 18 13:05:10 cybserv postfix/qmgr[19660]: C8BD9C13E: removed
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
