i am running the policyd on our main-server since this morning because some users do not realize that it does not solve the quota-problem (daily corn-notifies) to remove 5 messages
it works great until now but could be optimized
what about writing only warnings to the maillog if db-connection
fails or is interrupted but leaving the service running and
answer with "OK" to get away a single-point of failure since this
is only a quota-check and without the policyd every mail to a full
mailbox would be a bounce/backscatter, it think in an error-case
this would be OK as fallback too and after resume db-connection
a message in the maillog "dbmail-policyd: normal operations resumed"
___________________________________
on our second server there is a normal mysqld-instance for
php and dbmail/pstfix/dovecot are using a dedicated mysqld
at "/var/lib/mysql/mysqld_dbmail.sock"
"dbmail-postfix-policyd" seems not to be working with non-standard-port/socket
the message below says to me it try to connect to the default-mysqld
dbmail-postfix-policyd[11814]: fatal: DBI
connect('dbname=dbmail;host=localhost','dbmailro',...)
failed: Access denied for user 'dbmailro'@'localhost'
removing the "host"-line does not force the socket as hoped, even on a machine
where mysqld is running on
standard-port/socket it would not connect while dbmail do not need the line
fatal: DBI
connect('dbname=dbmail;host=/var/lib/mysql/mysqld_dbmail.sock','dbmailro',...)
failed: Unknown MySQL
server host '/var/lib/mysql/mysqld_dbmail.sock' (1) at
/usr/sbin/dbmail-postfix-policyd line 146#012
fatal: DBI connect('dbname=dbmail;host=/var/lib/mysql/mysql.sock','dbmail',...)
failed: Unknown MySQL server host
'/var/lib/mysql/mysql.sock'
cat /etc/dbmail-postfix-policyd.conf
[DBMAIL]
driver = mysql
authdriver = sql
host = localhost
sqlsocket = /var/lib/mysql/mysqld_dbmail.sock
user = dbmailro
pass = *******************************
db = dbmail
table_prefix = dbmail_
encoding = utf8
default_msg_encoding = utf8
--
Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/
http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
