> 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"
That might be good behavior, at least for now (maybe if the policy
server did other checks in the future it should die again). You want to
throw that in a github issue and I'll get to it some time.
>
> 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
Try again, with/after commit 8724b18b823c52c38ba1.
Thanks for the feedback,
Jesse
--
Jesse Norell
Kentec Communications, Inc.
[email protected]
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
