Your installation is incomplete. Part of the create_tables...
sql files is the statement:
INSERT INTO users (userid, passwd, encryption_type)
VALUES ('[EMAIL PROTECTED]@__', '', 'md5');
Apparently this systemuser is missing.
David wrote:
Hi, I'm new to DBmail and am having some difficult
time configuring dbmail to work with postfix. I am
using dbmail 2.0 rc2 by the way.
Basically, I am trying to set up a box with a DSL line
running Postfix and DBmail on the same machine. I
want Postfix to receive email, detect my domain
echopc.com and then recognize that it's a "virtual
domain" and forward the message (regardless of
recipient name) to dbmail for processing. I manage to
get Postfix to forward mail by putting echopc.com in
the $mydestination variable and then creating a
/etc/postfix/transport file that looks like this:
echopc.com dbmail:
I also have an entry in master.cf that looks like
this:
dbmail unix - n n - -
pipe
flags= user=dbmail:dbmail
argv=/usr/local/sbin/dbmail-smtp -d ${recipient}
In DBmail, I created a user with dmail-adduser and
added aliases of @echopc.com (catch all alias) so that
any email that don't match a particular username, but
is addressed to the echopc.com domain will be sent to
this user.
When I send an email to [EMAIL PROTECTED], I get the
following error according to /var/log/maillog
Feb 18 10:07:18 trinity postfix/smtpd[21456]: connect
from web21403.mail.yahoo.com[216.136.232.73]
Feb 18 10:07:18 trinity postfix/smtpd[21456]:
70C76AB5B5:
client=web21403.mail.yahoo.com[216.136.232.73]
Feb 18 10:07:18 trinity postfix/cleanup[21457]:
70C76AB5B5:
message-id=<[EMAIL PROTECTED]>
Feb 18 10:07:18 trinity postfix/smtpd[21456]:
disconnect from
web21403.mail.yahoo.com[216.136.232.73]
Feb 18 10:07:18 trinity postfix/nqmgr[20065]:
70C76AB5B5: from=<[EMAIL PROTECTED]>, size=808,
nrcpt=1 (queue active)
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): searching value for config item
[host]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): found value [localhost]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): searching value for config item [db]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): found value [dbmail]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): searching value for config item
[user]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): found value [dbmail]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): searching value for config item
[pass]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): found value [dbpass]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): searching value for config item
[sqlport]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): found value []
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): searching value for config item
[sqlsocket]
Feb 18 10:07:18 trinity dbmail/smtp[21460]:
GetConfigValue(): found value []
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): readheader start
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): copying line into header
Feb 18 10:07:19 trinity last message repeated 10 times
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): single blank line found
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): copying line into header
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): readheader done
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): found header [Received: from
web21403.mail.yahoo.com (web21403.mail.yahoo.com
[216.136.232.73]) ^Iby trinity.the.matrix (Postfix)
with SMTP id 70C76AB5B5 ^Ifor <[EMAIL PROTECTED]>; Wed,
18 Feb 2004 10:07:18 -0800 (PST) Message-ID:
<[EMAIL PROTECTED]>
Received: from [206.17.88.100] by
web21403.mail.yahoo.com via HTTP; Wed, 18 Feb 2004
09:46:49 PST Date: Wed, 18 Feb 2004 09:46:49 -0800
(PST) From: David <[EMAIL PROTECTED]> Subject:
sending to dbmail To: [EMAIL PROTECTED] MIME-Version:
1.0 Content-Type: text/plain; charset=us-ascii ] of
len [551] using mem [551]
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
read_header(): function successfull
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mime_readheader(): entering mime loop
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mime_readheader(): found double newline; header size:
12 lines
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): mimelist currently has [9] nodes
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): mail address parser starting
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): total fields in header 9
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): scanning for Return-Path
Feb 18 10:07:19 trinity last message repeated 8 times
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): found 0 emailaddresses
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): mail address parser finished
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): mimelist currently has [9] nodes
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): mail address parser starting
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): total fields in header 9
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): scanning for From
Feb 18 10:07:19 trinity last message repeated 4 times
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): found [EMAIL PROTECTED], next in
list is (null)
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): scanning for From
Feb 18 10:07:19 trinity last message repeated 3 times
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): found 1 emailaddresses
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list(): mail address parser finished
Feb 18 10:07:19 trinity dbmail/smtp[21460]: main():
using SPECIAL_DELIVERY to email addresses
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list_special(): gathering info from command
line
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
mail_adr_list_special(): adding [EMAIL PROTECTED] to
userlist
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
insert_messages(): resolving address
[EMAIL PROTECTED]
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
dbpgsql.c,db_query: executing query [SELECT user_idnr
FROM users WHERE userid='[EMAIL PROTECTED]']
Feb 18 10:07:19 trinity dbmail/smtp[21460]: pipe.c,
resolve_address: added user [EMAIL PROTECTED] id [1]
to delivery list
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
dbpgsql.c,db_query: executing query [SELECT user_idnr
FROM users WHERE
userid='[EMAIL PROTECTED]@__']
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
pipe.c,store_message_temp: unable to find user_idnr
for user [EMAIL PROTECTED]@__]. Make sure
this system user is in the database!
Feb 18 10:07:19 trinity dbmail/smtp[21460]:
insert_messages(): failed to store temporary message.
Feb 18 10:07:19 trinity dbmail/smtp[21460]: main():
freeing memory blocks
Feb 18 10:07:19 trinity dbmail/smtp[21460]: main():
they're all free. we're done.
Feb 18 10:07:19 trinity postfix/pipe[21459]:
70C76AB5B5: to=<[EMAIL PROTECTED]>, relay=dbmail,
delay=1, status=sent (echopc.com)
What am I doing wrong? The user exists and dbmail
seems to find the userid on the first SQL query, but
then fails at the end. Any help would be greatly
appreciate it.
Thanks,
David
__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
