First - there were bugs with marking messages as read. After marking as read - if I reenter the IMAP-folder the read message was again unread. After some 'reading' ;) this bug somehow disappeared, I hope this is forever.
Second and the main one... The same problem with aliases...The messages are being delivered AND dbmail-smtp returns code EX_NOUSER, which is in the log-files of Exim, the Exim sends an error to the message sender (about a permanent error and that the delivery had failed), but the message in fact had been delivered to the user. But there are strange situations when this isn't happening. I tried to model such situation but unsuccessfully (I thought that when To: in header isn't in any local domains and when only RCPT TO: points to a valid address it would do fine - it didn't).
So, as for my configuration: in Exim I use:command = /usr/local/sbin/dbmail-smtp -d ${local_part} "${if def:h_x-spam-flag:{-mSpam}{} }"
so I use special delivery to email addresses (in terms of main.c).I attached the trace=5 log of such delivery (in fact - two deliveries: the first one is delivering the original message itself, and the immediate second one - the error message). In the logs I sent a message to myself.
That's what Exim said about it:2005-08-26 11:12:34 1E8YOA-000Nh9-Qx <= [EMAIL PROTECTED] H=### ([127.0.0.1]) [###] P=esmtpsa X=TLSv1:AES256-SHA:256 A=auth_plain:danil S=5183 [EMAIL PROTECTED] 2005-08-26 11:12:35 1E8YOA-000Nh9-Qx ** [EMAIL PROTECTED] R=dbmail T=dbmail_deliver: Child process of dbmail_deliver transport returned 67 (could mean user nonexistent) from command: /usr/local/sbin/dbmail-smtp 2005-08-26 11:12:35 1E8YOB-000NhF-2d <= <> R=1E8YOA-000Nh9-Qx U=exim P=local S=6006
2005-08-26 11:12:35 1E8YOA-000Nh9-Qx Completed2005-08-26 11:12:35 1E8YOB-000NhF-2d ** [EMAIL PROTECTED] R=dbmail T=dbmail_deliver: Child process of dbmail_deliver transport returned 67 (could mean user nonexistent) from command: /usr/local/sbin/dbmail-smtp
2005-08-26 11:12:35 1E8YOB-000NhF-2d Frozen (delivery error message) There are 10 messages frozen for this moment due to the same reason.Now, as for my database: I have an alias danil for my user danil. I've described my mail system here some time ago, I use it to process mail for 2 domains with the same users (localparts in Exim's terms).
In the log I didn't find main(): using SPECIAL_DELIVERY to email addresses however I use -d for delivering. So the main question - why does dbmail-smtp return EX_NOUSER?..Unfortunately, I don't have much time to dig much more the sources, but what I think is: (just my opinion) it may be because of DSN_CLASS_NONE in the end of message processing. Also it could be because of quota, because user danil has it unlimited (may be some errors or smth else..). But I tried to do the same thing with the limited accounts - it's all the same.
Why DSN_CLASS_NONE - may be it's because of getopt again?......Because it seems to me that dbmail-smtp acts as if it's a normal delivery, but I do give it a parameter -d ${local_part}...
By the away I tried to use -d${local_part} - the same result...
I use FreeBSD 4.9.
PS
In fact I have two dbmail-routers in Exim: first one as I mentiond and
the second one for the unknown users.
The first one has conditionSELECT alias_idnr FROM dbmail_aliases WHERE alias='${quote_mysql:$local_part}'
and the second one (dbmail_unknown) doesn't.The dbmail_unknown router didn't run in any of these sitiations (with needless error messages), it means that Exim did find the right alias for delivering, and dbmail-smtp had problems with it...
[EMAIL PROTECTED] wrote:
perhaps I should ask this first... I noticed in exim4 that the aliases never make it to the transport_dbmail transport I set up as the local_delivery. I added a router that looks up in the aliases file the email (which is also the username in my setup) and it now seems to work. If you look at: http://www.glug.us/dokuwiki/doku.php?id=howtos:debianmailserverYou'll see the "transport_dbmail" and "dbmailalias" sections for exim4.Specifically the following is the part that made it work: condition = ${lookup mysql{SELECT alias_idnr FROM dbmail_aliases WHERE \ alias='${quote_mysql:[EMAIL PROTECTED]' OR \ alias='${quote_mysql:@$domain}'}{yes}{no}} Again, in my setup all users have an alias which points to their box... each user uses his or her email address to log in as the username. Example: Userid: [EMAIL PROTECTED] Alias: [EMAIL PROTECTED] So I got it working and I think my problem may have been I didn't have an alias router in exim as looking deeper intot he logs (actually starting exim4 in non-daemon logging mode) showed that the transport_dbmail wasn't getting fired. Also, when I turn trace_level=5 on where does it put the log? I looked in /var/log/syslog and /var/log/messages but they didn't seem to be elevated to the higher log level. Thanks, [EMAIL PROTECTED] On 8/22/05, Paul J Stevens <[EMAIL PROTECTED]> wrote:Could you please provide a trace_level=5 here. I'll look into it asap. [EMAIL PROTECTED] wrote:I just installed dbmail2-mysql from the web site and I cannot get aliases to work. 2005-08-23 01:54:15 H=(p02m141.mxlogic.net) [66.179.26.141] F=<[EMAIL PROTECTED]> rejected RCPT <[EMAIL PROTECTED]>: Unrouteable address I'm using exim4 and here's my call to dbmail-smtp transport_dbmail: driver = pipe command = "/usr/sbin/dbmail-smtp -d [EMAIL PROTECTED]" return_fail_output user = dbmail Real users get transmitted correctly, just no aliases at all.
-- Best regards, Danil V. Gerun.
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [host]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [db]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [user]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [pass]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [sqlport]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [sqlsocket]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [trace_level]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: header.c,consume_header_line: end
of header found
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: header.c,get_rfc_size:
remaining_len = zd
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mime_readheader(): entering mime
loop
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mime_readheader(): found double
newline; header size: 22 lines
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): mimelist currently
has [14] nodes
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): mail address
parser starting
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): total fields in
header 14
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): scanning for
Return-Path
Aug 26 11:12:34 nebulus last message repeated 13 times
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): found 0
emailaddresses
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): mail address
parser finished
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): mimelist currently
has [14] nodes
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): mail address
parser starting
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): total fields in
header 14
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): scanning for From
Aug 26 11:12:34 nebulus last message repeated 9 times
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): found [EMAIL
PROTECTED], next in list is <null>
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): scanning for From
Aug 26 11:12:34 nebulus last message repeated 3 times
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): found 1
emailaddresses
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: mail_adr_list(): mail address
parser finished
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext:
checking user [] in alias table
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('') AND
lower(alias) <> lower(deliver_to)]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext: user
not in aliases table
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dsn.c, dsnuser_resolve: user []
found total of [0] aliases
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dsn.c, dsnuser_resolve: user []
checking for domain forwards.
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext:
checking user [danil] in alias table
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('danil') AND
lower(alias) <> lower(deliver_to)]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext: into
checking loop
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext:
checking user danil to 1
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext:
checking user [1] in alias table
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('1') AND
lower(alias) <> lower(deliver_to)]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: authsql.c,auth_check_user_ext:
adding [1] to deliver_to address
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dsn.c, dsnuser_resolve: user
[danil] found total of [1] aliases
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[BEGIN]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: misc.c,create_unique_id: created:
4415f21293b1816a7efa278e2c62ac04
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='12']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES ('0',
CURRENT_TIMESTAMP)]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id,
unique_id,recent_flag, status) VALUES ('12', '36922',
'4415f21293b1816a7efa278e2c62ac04', '1', '5')]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('1','From [EMAIL PROTECTED] Fri Aug 26 11:12:34
2005\nReceived: from ### ([###] helo=[127.0.0.1])\n by smtp.sochiwater.ru with
esmtpsa (TLSv1:AES256-SHA:256)\n (Exim 4.52 (FreeBSD))\n id
1E8YOA-000Nh9-Qx\n for [EMAIL PROTECTED]; Fri, 26 Aug 2005 11:12:34
+0400\nMessage-ID: <[EMAIL PROTECTED]>\nDate: Fri, 26 Aug 2005 11:12:35
+0400\nFrom: \"Danil V. Gerun\" <[EMAIL PROTECTED]>\nReply-To: [EMAIL
PROTECTED]: =?KOI8-R?Q?=ED=F5=F0_=C7=2E_=F3=CF=DE=C9_=22=F7=CF=C4?=\n
=?KOI8-R?Q?=CF=CB=C1=CE=C1=CC=22_/_Water_Supply_and_Water_Tr?=\n
=?KOI8-R?Q?eatment_Municipal_Unitary_Undertaking_of_city_Soc?=\n
=?KOI8-R?Q?hi?=\nUser-Agent: Mozilla Thunderbird 1.0.6
(Windows/20050716)\nX-Accept-Language: en-us, en\nMIME-Version: 1.0\nTo:
[EMAIL PROTECTED]: test\nContent-Type: multipart/signed; prot
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: store_message_temp(): allocating
[524288] bytes of memory for readblock
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: pipe.c,store_message_in_blocks:
inserting message: This is a cryptographically signed message in MIME format.
--------------ms070805060306050206010801 Content-Type: text/plain;
charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit test
--------------ms070805060306050206010801 Content-Type:
application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding:
base64 Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIH6TCC
Ak8wggG4oAMCAQICAw7f1DANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UE
ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDUwNjA3MDgxNzIzWhcNMDYwNjA3MDgxNzIz
WjBFMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSIwIAYJKoZIhvcNAQkBFhNk
YW5pbEBzb2NoaXdhdGVyLnJ1MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDa1pq67NHQ
nGHpFUz/9m7nCsbReIuo/Qey+VTop7XsxzUfZW7D3TZWZhKeYsAQeqP
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('0','This is a cryptographically signed message in MIME
format.\n\n--------------ms070805060306050206010801\nContent-Type: text/plain;
charset=KOI8-R; format=flowed\nContent-Transfer-Encoding:
7bit\n\ntest\n\n--------------ms070805060306050206010801\nContent-Type:
application/x-pkcs7-signature; name=\"smime.p7s\"\nContent-Transfer-Encoding:
base64\nContent-Disposition: attachment;
filename=\"smime.p7s\"\nContent-Description: S/MIME Cryptographic
Signature\n\nMIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIH6TCC\nAk8wggG4oAMCAQICAw7f1DANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UE\nChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv\nbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDUwNjA3MDgxNzIzWhcNMDYwNjA3MDgxNzIz\nWjBFMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSIwIAYJKoZIhvcNAQkBFhNk\nYW5pbEBzb2NoaXdhdGVyLnJ1
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[UPDATE dbmail_messages SET unique_id = '4415f21293b1816a7efa278e2c62ac04',
status = '0' WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[UPDATE dbmail_physmessage SET messagesize = '5234', rfcsize = '5324' WHERE id
= '36922']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.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 = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: db.c,db_add_quotum_used: adding
5234 to mailsize
Aug 26 11:12:34 nebulus dbmail/smtp[91091]:
db.c.user_idnr_is_delivery_user_idnr: looking up user_idnr for [EMAIL
PROTECTED]@__
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: pipe.c, insert_messages: temporary
msgidnr is [79601]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: pipe.c, insert_messages: calling
sort_and_deliver for useridnr [1]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT pm.messagesize FROM dbmail_physmessage pm, dbmail_messages msg WHERE
pm.id = msg.physmessage_id AND message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT 1 FROM dbmail_users WHERE user_idnr = '1' AND (maxmail_size > 0) AND
(curmail_size + '5234' > maxmail_size)]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: misc.c,create_unique_id: created:
d4e8e5a3c477617cc54ee01fc9691dd1
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.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, 'd4e8e5a3c477617cc54ee01fc9691dd1',
status FROM dbmail_messages WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: db.c,db_add_quotum_used: adding
5234 to mailsize
Aug 26 11:12:34 nebulus dbmail/smtp[91091]:
db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for [EMAIL
PROTECTED]@__
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size + '5234' WHERE user_idnr =
'1']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: sort.c, sort_and_deliver: message
id=79602, size=5234 is inserted
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: pipe.c, insert_messages: successful
sort_and_deliver for useridnr [1]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [AUTO_NOTIFY]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value [no]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): searching value
for config item [AUTO_REPLY]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: GetConfigValue(): found value [no]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: insert_messages(): we need to
deliver [0] messages to external addresses
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[DELETE FROM dbmail_messages WHERE message_idnr = '79601']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = '36922']
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: insert_messages(): temporary
message deleted from database
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: insert_messages(): End of function
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dbmysql.c,db_query: executing query
[COMMIT]
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: main(): freeing dsnuser list
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dsn.c, dsnuser_free: dsnuser freed
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: dsn.c, dsnuser_free: dsnuser freed
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: main(): freeing all other lists
Aug 26 11:12:34 nebulus dbmail/smtp[91091]: main(): freeing memory blocks
Aug 26 11:12:35 nebulus dbmail/smtp[91091]: main(): they're all free. we're
done.
Aug 26 11:12:35 nebulus dbmail/smtp[91091]: main(): exit code is [67].
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [host]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [db]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [user]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [pass]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [sqlport]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [sqlsocket]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [trace_level]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: header.c,consume_header_line: end
of header found
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: header.c,get_rfc_size:
remaining_len = zd
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mime_readheader(): entering mime
loop
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mime_readheader(): found double
newline; header size: 12 lines
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): mimelist currently
has [9] nodes
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): mail address
parser starting
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): total fields in
header 9
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): scanning for
Return-Path
Aug 26 11:12:35 nebulus last message repeated 8 times
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): found 0
emailaddresses
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): mail address
parser finished
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): mimelist currently
has [9] nodes
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): mail address
parser starting
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): total fields in
header 9
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): scanning for From
Aug 26 11:12:35 nebulus last message repeated 4 times
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): found [EMAIL
PROTECTED], next in list is <null>
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): scanning for From
Aug 26 11:12:35 nebulus last message repeated 3 times
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): found 1
emailaddresses
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: mail_adr_list(): mail address
parser finished
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext:
checking user [] in alias table
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('') AND
lower(alias) <> lower(deliver_to)]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext: user
not in aliases table
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dsn.c, dsnuser_resolve: user []
found total of [0] aliases
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dsn.c, dsnuser_resolve: user []
checking for domain forwards.
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext:
checking user [danil] in alias table
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('danil') AND
lower(alias) <> lower(deliver_to)]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext: into
checking loop
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext:
checking user danil to 1
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext:
checking user [1] in alias table
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('1') AND
lower(alias) <> lower(deliver_to)]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: authsql.c,auth_check_user_ext:
adding [1] to deliver_to address
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dsn.c, dsnuser_resolve: user
[danil] found total of [1] aliases
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[BEGIN]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: misc.c,create_unique_id: created:
4415f21293b1816a7efa278e2c62ac04
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='12']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES ('0',
CURRENT_TIMESTAMP)]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id,
unique_id,recent_flag, status) VALUES ('12', '36924',
'4415f21293b1816a7efa278e2c62ac04', '1', '5')]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('1','From MAILER-DAEMON Fri Aug 26 11:12:35
2005\nReceived: from exim by smtp.sochiwater.ru with local (Exim 4.52
(FreeBSD))\n id 1E8YOB-000NhF-2d\n for [EMAIL PROTECTED]; Fri, 26 Aug
2005 11:12:35 +0400\nX-Failed-Recipients: [EMAIL PROTECTED]:
auto-generated\nFrom: Mail Delivery System <[EMAIL PROTECTED]>\nTo: [EMAIL
PROTECTED]: Mail delivery failed: returning message to sender\nMessage-Id:
<[EMAIL PROTECTED]>\nDate: Fri, 26 Aug 2005 11:12:35 +0400\n\n', '500',
'36924')]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: store_message_temp(): allocating
[524288] bytes of memory for readblock
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: pipe.c,store_message_in_blocks:
inserting message: This message was created automatically by mail delivery
software. A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:
[EMAIL PROTECTED] local delivery failed ------ This is a copy of the
message, including all the headers. ------ Return-path: <[EMAIL PROTECTED]>
Received: from hosaka.vodanew.ru ([192.168.5.24] helo=[127.0.0.1]) by
smtp.sochiwater.ru with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.52
(FreeBSD)) id 1E8YOA-000Nh9-Qx for [EMAIL PROTECTED]; Fri, 26 Aug 2005
11:12:34 +0400 Message-ID: <[EMAIL PROTECTED]> Date: Fri, 26 Aug 2005 11:12:35
+0400 From: "Danil V. Gerun" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED]
Organization: =?KOI8-R?Q?=ED=F5=F0_=C7=2E_=F3=CF=DE=C9_=22=F7=CF=C4?=
=?KOI8-R?Q?=CF=CB=C1=CE=C1=CC=22_/_Water_Supply_and_Water_Tr?=
=?KOI8-R?Q?eatment_Municipal_Unitary_Underta
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('0','This message was created automatically by mail
delivery software.\n\nA message that you sent could not be delivered to one or
more of its\nrecipients. This is a permanent error. The following address(es)
failed:\n\n [EMAIL PROTECTED] local delivery failed\n\n------ This is a
copy of the message, including all the headers. ------\n\nReturn-path: <[EMAIL
PROTECTED]>\nReceived: from hosaka.vodanew.ru ([192.168.5.24]
helo=[127.0.0.1])\n by smtp.sochiwater.ru with esmtpsa
(TLSv1:AES256-SHA:256)\n (Exim 4.52 (FreeBSD))\n id 1E8YOA-000Nh9-Qx\n
for [EMAIL PROTECTED]; Fri, 26 Aug 2005 11:12:34 +0400\nMessage-ID: <[EMAIL
PROTECTED]>\nDate: Fri, 26 Aug 2005 11:12:35 +0400\nFrom: \"Danil V. Gerun\"
<[EMAIL PROTECTED]>\nReply-To: [EMAIL PROTECTED]:
=?KOI8-R?Q?=ED=F5=F0_=C7=2E_=F3=CF=DE=C9_=22=F7=CF=C4?=\n =?KO
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[UPDATE dbmail_messages SET unique_id = '4415f21293b1816a7efa278e2c62ac04',
status = '0' WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[UPDATE dbmail_physmessage SET messagesize = '6051', rfcsize = '6163' WHERE id
= '36924']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.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 = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: db.c,db_add_quotum_used: adding
6051 to mailsize
Aug 26 11:12:35 nebulus dbmail/smtp[91096]:
db.c.user_idnr_is_delivery_user_idnr: looking up user_idnr for [EMAIL
PROTECTED]@__
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: pipe.c, insert_messages: temporary
msgidnr is [79604]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: pipe.c, insert_messages: calling
sort_and_deliver for useridnr [1]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='1']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT pm.messagesize FROM dbmail_physmessage pm, dbmail_messages msg WHERE
pm.id = msg.physmessage_id AND message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT 1 FROM dbmail_users WHERE user_idnr = '1' AND (maxmail_size > 0) AND
(curmail_size + '6051' > maxmail_size)]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: misc.c,create_unique_id: created:
37cb25d4da2ff9fd5ca0e5d4f3a8f0bb
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.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, '37cb25d4da2ff9fd5ca0e5d4f3a8f0bb',
status FROM dbmail_messages WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: db.c,db_add_quotum_used: adding
6051 to mailsize
Aug 26 11:12:35 nebulus dbmail/smtp[91096]:
db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for [EMAIL
PROTECTED]@__
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size + '6051' WHERE user_idnr =
'1']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: sort.c, sort_and_deliver: message
id=79605, size=6051 is inserted
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: pipe.c, insert_messages: successful
sort_and_deliver for useridnr [1]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [AUTO_NOTIFY]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value [no]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): searching value
for config item [AUTO_REPLY]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: GetConfigValue(): found value [no]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: insert_messages(): we need to
deliver [0] messages to external addresses
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[DELETE FROM dbmail_messages WHERE message_idnr = '79604']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = '36924']
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: insert_messages(): temporary
message deleted from database
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: insert_messages(): End of function
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dbmysql.c,db_query: executing query
[COMMIT]
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: main(): freeing dsnuser list
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dsn.c, dsnuser_free: dsnuser freed
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: dsn.c, dsnuser_free: dsnuser freed
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: main(): freeing all other lists
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: main(): freeing memory blocks
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: main(): they're all free. we're
done.
Aug 26 11:12:35 nebulus dbmail/smtp[91096]: main(): exit code is [67].
smime.p7s
Description: S/MIME Cryptographic Signature
