Am 20.05.2011 16:54, schrieb Jesse Norell:
> 
>> 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.

even if it do other checks in the future a cmdline-option would
be usefull to ignore db-errors and let the admin decide if
100% filtering from the policyd or receive mails is more important

>> 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.

tomorrow or tonight
for now i have to search a good steak or die :-)

> Thanks for the feedback,
> Jesse

i say thank you for your feedback!

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to