You can crank up logging on postfix too to give you a more exact mysql
error. This is done by going into master.cf and adding -v to the SMTP line.
Like this:
smtp inet n - n - - smtpd -v -v -v
each time you add another -v it increases verbosity. Try that and then look
at the logs again.
-Micah
At 10:05 AM 12/28/2004, you wrote:
>comment out 'skip-networking' in /etc/mysql/my.cnf
Should this not be commented out?
>Otherwise the daemons wouldn't start, and you wouldn't be able to
>list users with dbmail-adduser.
I did not install debian's packages because it is the 1.x version of dbmail.
I compiled dbmail 2.x with the provided instructions and then configured
postfix with the postfix instructions for smtp. The daemons are not
running. They will not start. dbmail-users says failed to connect when
trying to open connection to the database.
>*Never* run dbmail as effective user root. Effective group mysql is almost
>just as bad! Change them now.
Thanks, they are changed now.
>make sure you can connect to mysql with the exact parameters you specify in
>dbmail.conf and your postfix
>sql_recipients.cf file. That is: don't just specify the user and password,
>but also specify the hostname.
I can connect using the same username, host, and password as in both
dbmail.conf and sql_recipients.cf from a command line.
>You might have an my.cnf installed somewhere that changes the hostname
>without you realizing it. Probably not in
>your case, but be specific.
The only my.cnf on my system is at: /etc/mysql/my.cnf and it is setup to use
the /var/run/mysqld/mysqld.sock. This mysql-server install was simply an
apt-get for a debian package.
>(assuming you use the debian init scripts)
I am not. Debian only has a package for dbmail 1.x that I can see. I want
to use dbmail 2.x. I downloaded it and installed. Just for kicks I just
tried to apt-get dbmail-mysql, but now it can't connect saying that it can't
find dbmail-adduser when I try to run the debian init scripts. What the
heck is going on here?
>sql_recipients.cf but postfix can't, check the permissions on that file.
sql_recipients.cf is owned by postfix:postfix with -rw-r--r--
>If all this doesn't help: set trace_level=5 everywhere in the dbmail.conf,
>and send us your syslogs and configs.
I don't see any logs relevant to dbmail. Probably because I can't start the
daemons of course.
Postfix does however, deliver undeliverable messages due to temporary lookup
failures to the postmaster on my system.
Transcript of session follows.
Out: 220 server1.visimark.us ESMTP Postfix (Debian/GNU)
In: EHLO mail.skyviewmail.com
Out: 250-server1.visimark.us
Out: 250-PIPELINING
Out: 250-SIZE 10240000
Out: 250-VRFY
Out: 250-ETRN
Out: 250 8BITMIME
In: MAIL FROM: SIZE=5000
Out: 250 Ok
In: RCPT TO:
Out: 451 : Temporary lookup failure
In: DATA
Out: 554 Error: no valid recipients
In: RSET
Out: 250 Ok
In: QUIT
Out: 221 Bye
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
