Web lists-archives.com

MySQL error to syslog




HI,

I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a
miss-configured service that generates faulty connections. After a
while, MySQl blocks any connection from the web server.

At some stage, I had set-up a script that would browse syslog log and
look for a string like "Host 'xxx' is blocked because of many connection
errors; unblock with 'mysqladmin flush-hosts'" and would then issue a
mysqladmin flush-hosts.

But after an upgrade, MySQl stopped reporting to syslog.

MySQL process is:

database<root>: ps auwwx | grep mysql
mysql 81063   0.0  0.1   9852  1172 ??  Is    3Dec14      0:00.18 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/database/mysql/my.cnf --user=mysql --datadir=/database/mysql --pid-file=/database/mysql/database.cs.ait.ac.th.pid --syslog
mysql 81386   0.0  2.0 314712 42180 ??  I     3Dec14      8:19.75
/usr/local/libexec/mysqld --defaults-extra-file=/database/mysql/my.cnf
--basedir=/usr/local --datadir=/database/mysql
--plugin-dir=/usr/local/lib/mysql/plugin --user=mysql
--pid-file=/database/mysql/database.cs.ait.ac.th.pid
--socket=/tmp/mysql.sock --port=3306

Any help will be greatly appreciated.

TIA,

Olivier

-- 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql