Can you also connect to the mysql server using the explicit -h localhost
switch. Without it you might by connecting over a tcp socket in stead
of a unix socket, like postfix is trying to do.
So: mysql -h localhost -u postfix -p'pass123' dbmail
should emulate a postfix connection. Also check /etc/mysql/my.cnf
for lines starting with socket to make sure everything looks neat.
Markus Welsch wrote:
Hi all,
Now since I'm able to use dbmail I'd like to implement
POP-before-SMTP. I've created the table, configured dbmail to write
it's information to it, the only problem is at the postfix side:
Feb 28 13:36:36 box postfix/smtpd[2480]: warning: connect to mysql
server localhost: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
Feb 28 13:36:36 box postfix/smtpd[2480]: fatal:
mysql:/etc/postfix/pop_before_smtp.cf: table lookup problem
Feb 28 13:36:37 box postfix/cleanup[2482]: warning: premature
end-of-input on cleanup socket while reading input attribute name
Feb 28 13:36:37 box postfix/master[2433]: warning: process
/usr/lib/postfix/smtpd pid 2480 exit status 1
The relevant content of my main.cf:
mynetworks = 127.0.0.0/8, mysql:/etc/postfix/pop_before_smtp.cf
The content of pop_before_smtp.cf:
user = postfix
password = pass123
dbname = dbmail
table = pbsp
select_field = since
where_field = ipnumber
additional_conditions = and unix_timestamp() - unix_timestamp(since)
<= 18000
Well I can connect to the mysql-server using
mysql -u postfix -p
The packages installed:
box:/etc/postfix# dpkg --list | grep mysql
ii dbmail-mysql 1.1-1 scalable SQL based pop and imap
mailserver
ii libdbd-mysql-p 2.1020-2 A Perl5 database interface to the
MySQL data
ii libmysqlclient 3.23.55-2 mysql database client library
ii libmysqlclient 3.23.55-2 mysql database development files
ii mysql-client 3.23.55-2 mysql database client binaries
ii mysql-common 3.23.55-2 mysql database common files (e.g.
/etc/mysql
ii mysql-server 3.23.55-2 mysql database server binaries
ii postfix-mysql 2.0.3-4 MYSQL map support for Postfix
Anybody knows a solution ?
Kind Regards,
Markus
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
