I found that if you create a user, there needs to be at least one alias
(which doesn't seem to be covered in the docs (what few of them there
are.)). So if your create an account [EMAIL PROTECTED] then there
needs to be an alias of [EMAIL PROTECTED] as well. Then the command
becomes
dbmail-adduser a [EMAIL PROTECTED] <password> <clientid> \
<maxmailboxsize> [EMAIL PROTECTED]
Curtis
On Wed, 18 Feb 2004, 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
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
