Hey Bradley;
"status=bounced (User unknown in virtual alias table)" explicitly identifies
your problems (plural). And Zamri is certainly correct -- you seek too much
of a guessing game. Ok. Let's see what we can do... If using the help and
examples below gets you going, don't bother answering any of my questions.
You have a Postfix config issue. What version is it? Throw out what you
think you know about Postfix virtual_alias_mapping and other MDA features --
DBMail is now your MDA. Many of Postfix's delivery features are not
needed -- just get the mail to DBMail with local_recipient_maps and DBMail
will deliver the mail. Your best transport is LMTP daemon to begin. You can
get fancy with dbmail-lmtp/dbmail-smtp per-domain options later on if you
like.
1) Is your Postfix compiled with MySQL? (make -f Makefile.init makefiles
'CCARGS=-DHAS_MYSQL -I/usr/local/include/mysql'
'AUXLIBS=-L/usr/local/lib/mysql -lmysqlclient -lz -lm')
2) How is this "virtual_aliases.cf " called in main.cf? (Show us the line of
text from main.cf just to be sure of what it is.)
3) What does virtual_aliases.cf contain?
4) Do you also have a sql-recipients.cf or mailbox.cf or something else from
where postfix is doing verify recipient userid (first_part) or
alias(first_part @ last_part)or is this virtual_aliases.cf doing that job.
"virtual_aliases.cf" is typically used for *virtual_alias_maps* NOT
*local_recipient_maps*. Is that what you are trying to do with this?
5) Did you read "INSTALL" and INSTALL.postfix" in the DBMail tarball.
QUOTE "//...Create a file in your Postfix config directory (/etc/postfix),
with
the name sql-recipients.cf, and put the following in it:
user = <username>
password = <password>
hosts = <dbhost>
dbname = <dbname>
table = dbmail_aliases
select_field = alias
where_field = alias
Where you replace <username>, <password>, <dbhost> and <dbname> by the
database username, password, host and name of the dbmail database.
Now we need to tell Postfix to use this file. Add the following line
in main.cf:
local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf
This tells Postfix to use the database to check if a recipient is
present in the database. Postfix will refuse the message if a
recipient is not present.
...//"
END QUOTE
6) Please note that later versions of Postfix 2.2.9 and 3 require the
following query format. Earlier 2.2.1-8 are backward compatible but later
versions I believe will not be.
user = dbmail
password = dbmail
dbname = dbmail
hosts = 127.0.0.1
|| query = SELECT alias FROM dbmail_aliases WHERE alias = '%s'
best...
Mike
----- Original Message -----
From: "zamri" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Wednesday, February 22, 2006 6:44 AM
Subject: Re: [Dbmail] Almost there but can't send to mysql from postfix
On 2/22/06, Bradley Giesbrecht <[EMAIL PROTECTED]> wrote:
I have struggled with this install for a couple days off and on and
need some help.
1. In my imap client I can check my dbmail mailbox, copy email to it,
and read them.
2. postmap produces the following.
# postmap -q [EMAIL PROTECTED] mysql:/sw/etc/postfix/virtual_aliases.cf
[EMAIL PROTECTED]
3. Sending via telnet does this.
# telnet 192.168.100.200 25
Trying 192.168.100.200...
Connected to t-flower.dyndns.org.
Escape character is '^]'.
220 cpgnode102.cpgstar.com ESMTP Postfix (2.2.8)
HELO 192.168.100.200
250 cpgnode102.cpgstar.com
MAIL FROM: [EMAIL PROTECTED]
250 Ok
RCPT TO: [EMAIL PROTECTED]
250 Ok
DATA
354 End data with <CR><LF>.<CR><LF>
Test
.
250 Ok: queued as 97FE2BC86CF
4. mail.log show this
Feb 21 20:20:05 Pico postfix/master[5671]: reload configuration /sw/
etc/postfix
Feb 21 20:20:21 Pico postfix/smtpd[7487]: connect from t-
flower.dyndns.org[192.168.100.200]
Feb 21 20:20:35 Pico postfix/smtpd[7487]: 97FE2BC86CF: client=t-
flower.dyndns.org[192.168.100.200]
Feb 21 20:20:45 Pico postfix/cleanup[7490]: 97FE2BC86CF: message-
id=<[EMAIL PROTECTED]>
Feb 21 20:20:45 Pico postfix/qmgr[7483]: 97FE2BC86CF:
from=<[EMAIL PROTECTED]>, size=369, nrcpt=1 (queue active)
Feb 21 20:20:45 Pico postfix/error[7491]: 97FE2BC86CF:
to=<[EMAIL PROTECTED]>, relay=none, delay=13, status=bounced (User
unknown in virtual alias table)
Feb 21 20:20:45 Pico postfix/cleanup[7490]: 4C5ACBC86D1: message-
id=<[EMAIL PROTECTED]>
Feb 21 20:20:45 Pico postfix/qmgr[7483]: 4C5ACBC86D1: from=<>,
size=2069, nrcpt=1 (queue active)
Feb 21 20:20:45 Pico postfix/qmgr[7483]: 97FE2BC86CF: removed
Feb 21 20:20:45 Pico postfix/error[7491]: 4C5ACBC86D1:
to=<[EMAIL PROTECTED]>, relay=none, delay=0, status=bounced (User
unknown in virtual alias table)
Feb 21 20:20:45 Pico postfix/qmgr[7483]: 4C5ACBC86D1: removed
I'm sure someone would need more info which I will be happy to
provide if anyone is inclined to help.
I'm no expert in this but I think you should give your
virtual-aliases.cfand postconf -n output.
Thank you.
Bradley Giesbrecht
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--------------------------------------------------------------------------------
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
