Hi all, I have installed the ossec-Server v2.4.1 on SLES 11 SP1 with MySQL-Support, also a few agents on some test systems. Everything is working fine, but from time to time I get error messages from ossec-dbd and the database connection is broken. The MySQL-Logfiles are clean, the MySQL-Server is in the same machine like the ossec-server. If I restart the ossec-server with /var/ossec/bin/ossec-control restart then everything works for a few days until the ossec-dbd error reoccurs.
Any ideas? Output from /var/ossec/logs/ossec.log: 2010/07/17 08:57:11 ossec-dbd(5203): ERROR: Error executing query 'SELECT id FROM location WHERE name = 'sles11-sp1-vm1-k us->ossec-monitord' AND server_id = '1' LIMIT 1'. Error: 'MySQL server has gone away'. 2010/07/17 08:57:11 ossec-dbd(5209): INFO: Closing connection to database. 2010/07/17 08:57:11 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:57:11 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 08:57:13 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:57:13 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 08:57:17 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:57:17 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 08:57:25 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:57:25 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 08:57:41 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:57:41 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 08:58:13 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:58:13 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 08:59:17 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 08:59:17 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 09:01:25 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 09:01:25 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 09:05:41 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 09:05:41 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 09:14:13 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 09:14:13 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 09:31:17 ossec-dbd(5210): INFO: Attempting to reconnect to database. 2010/07/17 09:31:17 ossec-dbd(5202): ERROR: Error connecting to database 'localhost'(ossec): ERROR: Unknown MySQL server host 'localhost' (3). 2010/07/17 10:05:25 ossec-dbd(5208): ERROR: Multiple database errors. Exiting. Thanks and regards, Kai-Uwe
