From: Paul J Stevens <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: DBMail mailinglist <[email protected]>
Subject: Re: [Dbmail] Receiving mail
Date: Sat, 11 Mar 2006 14:35:00 +0100
,
Try things one step at a time.
If dbmail-users complains about connecting to mysql, there's NO way you
should even think about postfix yet.
'dbmail-users -l' should not complain, period. If it does, your
dbmail.conf is not correct.
It sounds to me like you're new to mysql, new to postfix, and new to
dbmail, and confusing issues to boot.
1) add a user 'dbmail' to mysql which has full permissions on the dbmail
database. Something like 'GRANT ALL ON dbmail.* TO [EMAIL PROTECTED]
IDENTIFIED BY 'somepassword'.
2) Make sure you can connect to the dbmail database in mysql using that
user/password combo: mysql -u dbmail -psomepassword dbmail
3) edit dbmail.conf to make sure the user=, pass=, and db= settings are
correct.
4) do 'dbmail-users -l'. If that doesn't work go back to 3)
5) add a dbmail user by running dbmail-users -a testuser -w testpassword
6) try inserting a simple message into the INBOX of that user:
cat >> testmessage.eml << EOF
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: test
test
EOF
cat testmessage.eml | dbmail-smtp -u testuser
check the database make sure the message is there in the
dbmail_messageblks table
Once you make sure all this works as expected, move forward to setting
up some real dbmail users with email aliases, and try to hook up your
MTA (postfix).
If you do suspect there's a problem with dbmail, try setting the
TRACE_LEVEL to 5, and start eyeballing the syslog.
Jim Douglas wrote:
>> From: Micah Stevens <[EMAIL PROTECTED]>
>> Reply-To: DBMail mailinglist <[email protected]>
>> To: DBMail mailinglist <[email protected]>
>> Subject: Re: [Dbmail] Receiving mail
>> Date: Fri, 10 Mar 2006 14:37:12 -0800
>>
>> On Friday 10 March 2006 2:29 pm, Jim Douglas wrote:
>> > Mar 10 17:18:09 cpe-66-65-161-178 postfix/smtpd[9236]: NOQUEUE:
reject:
>> > RCPT from web42207.mail.yahoo.com[66.218.93.208]: 550
>> <[EMAIL PROTECTED]>:
>> > Recipient address rejected: User unknown in local recipient table;
>> > from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]>..
>> >
>> > I added added xyxyxy.org to mydestination for dbmail and postfix is
not
>> > connecting to the database.
>>
>> This means exactly what it says, user was not found in the local
>> recipient
>> table, it has nothing to do with mydestination.
>>
>> -Micah
>> _______________________________________________
>> Dbmail mailing list
>> [email protected]
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>
> I tried quite a few configuration changes before backtracking and
> finding that the dbmail-users command had a problem....
>
> User unknown in local recipient table; from=<[EMAIL PROTECTED]>
> to=<[EMAIL PROTECTED]> proto=SMTP helo=<web42202.mail.yahoo.com>
> Mar 10 22:39:21 cpe-66-65-161-178 postfix/smtpd[8103]: disconnect from
> web42202.mail.yahoo.com[66.218.93.203]
> Mar 10 22:39:36 cpe-66-65-161-178 dbmail/adduser[8109]:
> dbmysql.c,db_connect: mysql_real_connect failed: Access denied for user
> 'root'@'localhost' (using password: NO)
>
>
> this was the command,
> dbmail-users -a jim -w password -g 0 -m 25M -s [EMAIL PROTECTED]
> Why does it say access denied for 'root' when the adduser command is
> adding a user 'jim'?
>
> I also re-created the MySql tables...
>
> Peter
>
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
When I login to mysql with
mysql -u dbmail -p
it prompts for a password, I enter it and can connect. No problem.
When I try to connect with,
dbmail-users -l
I get
Opening connection to database...
Failed. Could not connect to database (check log)
Command Failed.
This is my dbmail.conf, I know the socket, username, password, database are
correct...
Thanks for your help..
# $Id: dbmail.conf 1539 2004-12-27 21:41:07Z paul $
# (c) 2000-2002 IC&S, The Netherlands
#
# Configuration file for DBMAIL
# This configuration file needs to be run through dbmail-config to be
effective
# after that, changes are effective inmediatly
[DBMAIL]
# Database settings
host=localhost # host for database, set to localhost if database is
om
# the same host as dbmail and you want to use a
local socket
# for connecting.
sqlport=3306 # if you want to use TCP/IP for connecting to the
database,
# and have the database running on a non-standard
port.
# when using a local socket connection to the
database, fill
# in the path to the socket here (e.g.
/var/run/mysql.sock)
sqlsocket=/var/lib/mysql/mysql.sock
user=dbmail # user to connect as to database
pass=mypassword # password for user to database
db=dbmail # name of database
# postmaster's email address.
[EMAIL PROTECTED]
# trace level for dbmail-util
TRACE_LEVEL=2
[SMTP]
SENDMAIL=/usr/sbin/sendmail # sendmail executable for forwarding mail
AUTO_NOTIFY=no
AUTO_REPLY=no
TRACE_LEVEL=2
[LMTP]
# the user that dbmail-lmtpd will run as (need to be root to bind to a
port<1024)
EFFECTIVE_USER=root
# the group that dbmail-lmtpd will run as
EFFECTIVE_GROUP=dbmail
BINDIP=* # the ipaddress the dbmail-lmtpd server has to bind
# to, * for all adresses. Use 127.0.0.1 to only
# bind to localhost.
PORT=24 # the port number the dbmail-lmtpd server has
to bind to.
NCHILDREN=20 # default number of LMTP handlers (each is a
process)
MAXCHILDREN=10 # max. number of LMTP handlers
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=10000 # the maximum number of connections a default childs
makes
TIMEOUT=300 # the time (s) before the dbmail-lmtpd should shutdown a
connection which is being idle.
RESOLVE_IP=yes # if yes, the lmtp daemon resolves IP
numbers to DNS names in the log
TRACE_LEVEL=2
MAX_ERRORS=500
[POP]
EFFECTIVE_USER=nobody # the user that dbmail-pop3d will run as (need to
be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that dbmail-pop3d will run as
BINDIP=* # the ipaddress the dbmail-pop3d server has to bind to, * for
all addresses
PORT=110 # the port number the dbmail-pop3d server has
to bind to.
NCHILDREN=50 # default number of POP3 handlers (each is a
process)
MAXCHILDREN=200 # mac. number of POP3 handlers
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=10000 # the maximum number of connections a default childs
makes
TIMEOUT=300 # the time (s) before the dbmail-pop3d should shutdown a
connection which is being idle.
RESOLVE_IP=yes # if yes, the pop daemon resolves IP
numbers to DNS names in the log
POP_BEFORE_SMTP=no
TRACE_LEVEL=2
[IMAP]
EFFECTIVE_USER=nobody
EFFECTIVE_GROUP=nogroup
BINDIP=*
PORT=143
NCHILDREN=50
MAXCHILDREN=200 # mac. number of IMAPD handlers
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
MAXCONNECTS=10000 # the maximum number of connections a default childs
makes
TIMEOUT=4000 # the time (s) before the dbmail-imapd should shutdown a
connection which is being idle.
RESOLVE_IP=yes # if yes, the imap daemon resolves IP
numbers to DNS names in the log
IMAP_BEFORE_SMTP=no
TRACE_LEVEL=2
# end of configuration file
Opening connection to database...
