-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Jul 19, 2010, at 3:24 AM, <[email protected]> <[email protected]> wrote: > 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.
Check your MySQL configuration. You may be running into a connection limit problem. I believe the default limit is 100. If it's not a connection limit issue, it may be something else, but likely MySQL related. Check the .err file in your MySQL directory for more hints at what the problem may be... > Thanks and regards, > Kai-Uwe - --------------------------- Jason 'XenoPhage' Frisvold [email protected] - --------------------------- "Any sufficiently advanced magic is indistinguishable from technology." - - Niven's Inverse of Clarke's Third Law -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.14 (Darwin) iEYEARECAAYFAkxFEuwACgkQ8CjzPZyTUTTP5wCfSuBrOrPyju+AKYSxtj3eT0Z+ KCgAnjQ1RHWowxF90CBFABMh0MAmGwki =CzoZ -----END PGP SIGNATURE-----
