Hello Michael,
On 2015-05-16 00:59, Prof. Dr. Michael Schefczyk wrote:
The second step seems to be more difficult than expected: I did make
the database available on another mysql-server in the LAN. On my
mailpiler, I did make the following changes:
/var/www/piler/config.php
-> changed DB_HOSTNAME from 'localhost' to 'LAN IP:3306'
no need to set the port number, the hostname (or ip-address) is
sufficient alone.
/usr/local/etc/piler.conf
-> deleted mysqlsocket = ... and added mysqlhost = LAN IP and
mysqlport=3306
Then, mailpiler failed for not finding a piler DB. Adding just an
empty piler DB to the mailpiler host (not the mysql server it is
supposed to use) makes the health monitor display output again.
Please let me know what I did miss in order to connect to the separate
mysql server.
check on the piler host with the mysql command, if you can connect to
the remote sql server.
Janos
