>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
