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
