From: "M. J. [Mike] OBrien" <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: <[EMAIL PROTECTED]>,"DBMail mailinglist" <[email protected]>
Subject: [Dbmail] can't find user
Date: Mon, 13 Mar 2006 16:50:29 -0500
Ok.
Then try this postmap test to simulate postfix doing a lookup and see if
the alias exists in your dbmail_aliases table and if your sql-recipients.cf
correctly enables postix to make that query:
From the command line:
postmap -q <[EMAIL PROTECTED]> mysql:/etc/postfix/sql-recipients.cf
If that doesn't produce a response of :
<[EMAIL PROTECTED]>
check that the alias exists in the dbmail_aliases table; username and
password are correct sql-recipients.cf as well as all other aspects of
/sql-recipients.cf
best...
Mike
----- Original Message ----- From: "Mark Nernberg"
<[EMAIL PROTECTED]>
To: "M. J. [Mike] OBrien" <[EMAIL PROTECTED]>; "DBMail mailinglist"
<[email protected]>
Sent: Monday, March 13, 2006 4:36 PM
Subject: Re: [Dbmail] can't find user
On 3/13/06 4:29 PM, "M. J. [Mike] OBrien" <[EMAIL PROTECTED]> wrote:
Check against the following that your local recipients are mapped
correctly:
From previous post:
...//
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.
//...
That's not the issue.
dbmail is rejecting on delivery.
-=-=-=-=-
Mike
----- Original Message -----
From: "Mark Nernberg" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Monday, March 13, 2006 4:06 PM
Subject: Re: [Dbmail] can't find user
On 3/13/06 2:53 PM, "Jim Douglas" <[EMAIL PROTECTED]> wrote:
It obvious from the log file the user can't be found, he definately is
in
the database, dbmail.
I think it's safe to assume dbmail checked the users table and didn't
find
this email address.
How come?
main.cf
mailbox_transport = dbmail-lmtp:localhost:24
local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf
/etc/postfix/sql-recipients.cf
user = dbmail
password = mypassword
hosts = localhost
dbname = dbmail
table = dbmail_aliases
select_field = alias
where_field = alias
Mar 13 14:42:39 cpe-63-25-161-18 dbmail/lmtpd[26213]: pidfile.c,
pidfile_create: File [/var/run/dbmail-lmtpd.pid] exists and process id
[26213] is running.
Mar 13 14:42:44 cpe-63-25-161-18 postfix/postfix-script: starting the
Postfix mail system
Mar 13 14:42:44 cpe-63-25-161-18 postfix/master[26259]: daemon started
--
version 2.2.2, configuration /etc/postfix
Mar 13 14:43:03 cpe-63-25-161-18 postfix/smtpd[26266]: connect from
web42206.mail.yahoo.com[66.18.23.27]
Mar 13 14:43:03 cpe-63-25-161-18 postfix/smtpd[26266]: NOQUEUE: reject:
RCPT
from web42206.mail.yahoo.com[66.18.23.27]: 550 <[EMAIL PROTECTED]>:
Recipient address rejected: User unknown in local recipient table;
from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]> proto=SMTP
helo=<web42206.mail.yahoo.com>
Mar 13 14:43:03 cpe-63-25-161-18 postfix/smtpd[26266]: disconnect from
web42206.mail.yahoo.com[66.18.23.27]
I, too, have been having this problem. My database logs reflect that
dbmail
is returning the error.
It especially seems to occur with multi-recipient messages.
--
Mark J. Nernberg
Director of Technology
1-Fast Computer Service
(412)478-6262
http://www.1fast.us/
Customer Support: [EMAIL PROTECTED]
Providing secure technology solutions since 2003.
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
Mark J. Nernberg
Director of Technology
1-Fast Computer Service
(412)478-6262
Company Website: http://www.1fast.us/
For technical support or customer service, please email [EMAIL PROTECTED]
1-Fast Computer Service: secure solutions since 2003
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
I missed this line in the documentation,
"A user always needs to have at least one alias to receive mail"
I went back and added a user with an alias and everything worked.
Thanks,
Jim
