Hello people,
I am a firsttime user and I ran into some strange problem
which I tried to solve for the last couple of hours but
were unsucessful, so I hope you can give me a hand.
Let me give you the picture:
I got a server running Debian Etch, compiled dbmail myself
and setup MySQL. After that I tried to use dbmail-user
program
to insert a user and an alias into the database, which did
work,
I started the imap and the pop daemon and I could login and
do stuff on the server.
Right after I had that running, I assumed, well dbmail is
working,
so I did install postfix and told postfix to deliver emails
via lmtp to dbmail. So here is where the trouble did start:
As I injected and email for the alias I made before
(daniel test.de),
the email was accepted but immediately was bounced back to
postfix,
which returned it to dbmail and so forth. After about 10
tries,
postfix stops trying to delivering and spits out and mail
delivery
subsystem message. As I had no great experience with dbmail,
I tried
the dbmail-smtp method, which gave me the same result. Then
I tired
to manually inject the email via lmtp guided by the RFC,
which gave
me the same result too. So I am kinda sure that the problem
is
somewhere within dbmail.
Well as I was not really going anywhere, I turned on MySQL
query
logging today to see what happens, and here it is:
11 Query BEGIN
11 Query SELECT user_idnr FROM dbmail_users WHERE
lower(userid) =
lower('__!internal_delivery_user!__')
11 Query SELECT mailbox_idnr FROM dbmail_mailboxes
WHERE name LIKE
'INBOX' AND owner_idnr=1
11 Query INSERT INTO dbmail_physmessage (messagesize,
internal_date) VALUES (0, CURRENT_TIMESTAMP)
11 Query INSERT INTO dbmail_messages(mailbox_idnr,
physmessage_id,
unique_id,recent_flag, status) VALUES (2, 2,
'701816680e98e05978e5c6bf568afa51', 1, 5)
11 Query SELECT physmessage_id FROM dbmail_messages
WHERE
message_idnr = 2
11 Query INSERT INTO dbmail_messageblks (is_header,
messageblk,blocksize, physmessage_id) VALUES (1,'Received:
by
mx1.test.de (Postfix, from userid 65534) id
6A09CC1415B;n
Tue, 14 Aug 2007 10:30:47 +0200 (CEST)nReceived: from
sucker (localhost
[127.0.0.1]) by mx1.test.de (Postfix)n with SMTP id
875CAC14159
for <danieltest.de>;n Tue, 14 Aug 2007
10:30:34 +0200
(CEST)nSubject: testnMessage-Id:
<20070814083039.875CAC14159mx1.test.de>nDate: Tue,
14 Aug 2007
10:30:34 +0200 (CEST)nFrom: rootgosi.atnTo:
undisclosed-recipients:;nX-DBMail-PhysMessage-ID:
1nReturn-Path:
rootgosi.atnMIME-Version: 1.0nn', 521, 2)
11
Query SELECT physmessage_id FROM dbmail_messages WHERE
message_idnr = 2 11 Query INSERT
INTO
dbmail_messageblks (is_header, messageblk,blocksize,
physmessage_id)
VALUES (0,'nsdgndfngsdfngsdfn.n', 22, 2)
11 Query UPDATE dbmail_messages SET nique_id =
'701816680e98e05978e5c6bf568afa51', status = 0 WHERE
message_idnr = 2
11 Query SELECT physmessage_id FROM dbmail_messages
WHERE
message_idnr = 2
11 Query UPDATE dbmail_physmessage SET messagesize =
543, rfcsize
= 563 WHERE id = 2
11 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 = 2
11 Query SELECT user_idnr FROM dbmail_users WHERE
lower(userid) =
lower('__!internal_delivery_user!__')
11 Query SELECT id FROM dbmail_headername WHERE
headername='date'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES (1,2,'Tue, 14 Aug 2007
10:30:34
+0200 (CEST)')
11 Query SELECT id FROM dbmail_headername WHERE
headername='from'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES (2,2,'rootgosi.at')
11 Query SELECT id FROM dbmail_headername WHERE
headername='message-id'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES
(3,2,'<20070814083039.875CAC14159mx1.test.de>')
11 Query SELECT id FROM dbmail_headername WHERE
headername='received'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES (4,2,'by mx1.test.de
(Postfix, from
userid 65534) id 6A09CC1415B; Tue, 14 Aug 2007 10:30:47
+0200 (CEST)')
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES (4,2,'from sucker
(localhost
[127.0.0.1]) by mx1.test.de (Postfix) with SMTP id
875CAC14159
for <danieltest.de>; Tue, 14 Aug 2007
10:30:34 +0200 (CEST)')
11 Query SELECT id FROM dbmail_headername WHERE
headername='subject'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES (8,2,'test')
11 Query SELECT id FROM dbmail_headername WHERE
headername='to'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES
(6,2,'undisclosed-recipients: ;')
11 Query SELECT id FROM dbmail_headername WHERE
headername='x-dbmail-physmessage-id'
11 Query INSERT INTO dbmail_headervalue
(headername_id,
physmessage_id, headervalue) VALUES (7,2,'1')
11 Query INSERT INTO dbmail_tofield (physmessage_id,
toname,
toaddr) VALUES (2,'undisclosed-recipients','')
11 Query INSERT INTO dbmail_fromfield (physmessage_id,
fromname,
fromaddr) VALUES (2,'','rootgosi.at')
11 Query INSERT INTO dbmail_datefield (physmessage_id,
datefield)
VALUES (2,'2007-08-14 08:30:34')
11 Query INSERT INTO dbmail_subjectfield
(physmessage_id,
subjectfield) VALUES (2,'test')
11 Query INSERT INTO dbmail_envelope (physmessage_id,
envelope)
VALUES (2,'("Tue, 14 Aug 2007 10:30:34 +0200"
"test" ((NIL NIL
"root" "gosi.at")) ((NIL NIL
"root" "gosi.at")) ((NIL NIL
"root" "gosi.at")) ((NIL NIL
"undisclosed-recipients" NIL)) NIL
NIL NIL "<20070814083039.875CAC14159mx1.test.de>")')
11 Query SELECT physmessage_id FROM dbmail_messages
WHERE
message_idnr = 2
11 Query SELECT messageblk, is_header FROM
dbmail_messageblks
WHERE physmessage_id = 2 ORDER BY messageblk_idnr
11 Query SELECT physmessage_id FROM dbmail_messages
WHERE
message_idnr = 2
11 Query DELETE FROM dbmail_messages WHERE
message_idnr = 2
11 Query SELECT message_idnr FROM dbmail_messages
WHERE
physmessage_id = 2
11 Query DELETE FROM dbmail_physmessage WHERE id = 2
11 Query DELETE FROM dbmail_messageblks WHERE
physmessage_id = 2
11 Query COMMIT
11 Quit
so the email comes in, get stored in the database and is
deleted right after that. As said before this happens
a few times per email as postfix tries to deliver it again,
here the postfix log:
Aug 14 10:30:39 db1 postfix/smtpd[32276]: 875CAC14159:
client=localhost[127.0.0.1]
Aug 14 10:30:47 db1 postfix/cleanup[32278]: 875CAC14159:
message-id=<20070814083039.875CAC14159mx1.nc-online.de>
Aug 14 10:30:47 db1 postfix/qmgr[24856]: 875CAC14159:
from=<rootgosi.at>, size=372, nrcpt=1 (queue
active)
Aug 14 10:30:47 db1 postfix/pickup[32105]: 6A09CC1415B:
uid=65534
from=<rootgosi.at>
Aug 14 10:30:47 db1 postfix/cleanup[32278]: 6A09CC1415B:
message-id=<20070814083039.875CAC14159mx1.nc-online.de>
Aug 14 10:30:47 db1 postfix/qmgr[24856]: 6A09CC1415B:
from=<rootgosi.at>, size=536, nrcpt=1 (queue
active)
Aug 14 10:30:47 db1 postfix/pipe[32280]: 875CAC14159:
to=<danieltest.de>, relay=dbmail-smtp, delay=13,
delays=13/0/0/0.05,
dsn=2.0.0, status=sent (delivered via dbmail-smtp service)
Aug 14 10:30:47 db1 postfix/qmgr[24856]: 875CAC14159:
removed
As said before, this happens a couple of time, until
postfix gives up.
Well, I most likely made a newbie misstake, like maybe
I have to tell dbmail for which domains it should accept
emails instead of just creating an alias danieltest.de,
anyhow I hope you can give me a hand.
Kind regards,
Daniel Urstöger
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
Hello Marc,
thanks for helping, well actually I somehow
broke the user within the database, so postfix
thought it was there but dbmail couldn´t deliver
it at all.
so that problem is fixed now, and since I had some
time with dbmail and postfix, I am putting together
a tutorial on kb.gosi.at 
Greetings,
Daniel
Marc Dirix schrieb:
>> Aug 14 10:30:39 db1 postfix/smtpd[32276]:
875CAC14159:
>> client=localhost[127.0.0.1]
>> Aug 14 10:30:47 db1 postfix/cleanup[32278]:
875CAC14159:
>> message-id=<20070814083039.875CAC14159mx1.nc-online.de>
>> Aug 14 10:30:47 db1 postfix/qmgr[24856]:
875CAC14159:
>> from=<rootgosi.at>, size=372, nrcpt=1 (queue
active)
>> Aug 14 10:30:47 db1 postfix/pickup[32105]:
6A09CC1415B: uid=65534
>> from=<rootgosi.at>
>> Aug 14 10:30:47 db1 postfix/cleanup[32278]:
6A09CC1415B:
>> message-id=<20070814083039.875CAC14159mx1.nc-online.de>
>> Aug 14 10:30:47 db1 postfix/qmgr[24856]:
6A09CC1415B:
>> from=<rootgosi.at>, size=536, nrcpt=1 (queue
active)
>> Aug 14 10:30:47 db1 postfix/pipe[32280]:
875CAC14159:
>> to=<danieltest.de>, relay=dbmail-smtp, delay=13,
delays=13/0/0/0.05,
>> dsn=2.0.0, status=sent (delivered via dbmail-smtp
service)
>> Aug 14 10:30:47 db1 postfix/qmgr[24856]:
875CAC14159: removed
>>
>
>
> This looks like a normal delivery. If it bounces, after
delivery, and
> gets deleted there should be a configuration error in
dbmail.
>
> a) Which version of dbmail?
> (Try dbmail-users -V)
>
> b) Please post your configuration of aliases
> (dbmail-users -l )
>
> c) Do you have sievescripts active? Have you inserted
any? Post them here.
> (dbmail-sievecmd -u USERNAME -l)
>
>
>> Well, I most likely made a newbie misstake, like
maybe
>> I have to tell dbmail for which domains it should
accept
>> emails instead of just creating an alias danieltest.de,
>> anyhow I hope you can give me a hand.
>>
>
> creating an alias should be enough to deliver the
message.
>
> Try inserting a message by hand with the dbmail-smtp
script, or telnet
> to localhost lmtp port (lmtp takes the same commands as
smtp).
>
> If the above is working, then move on to postfix.
>
>
> Marc
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
