Monit tries to login to mysql as anonymous user and then perform mysql
ping request. In the case that the authentication failed, it assumes
that mysql is running, but the account doesn't exist. This should allow
to use the protocol test even in the case that the default anonymous
account was removed or denied.
Based on your monit log:
[CDT Aug 13 12:55:10] MYSQL: error receiving login response -- Resource
temporarily unavailable
it seems that no response came from the server or it was not recognized
by monit (had less then seven bytes).
I think you can try the following:
- enable mysql query log (or possibly other logs) and make them as
verbose as possible
- use tcpdump to catch and analyze the traffic between monit and mysql
server
Martin
unruhtech wrote:
as you can see, there is nothing to suggest a problem.
the reason it is restarting is because of monit not being able to connect
and doing a restart.
here is my mysqld.log for the last day:
050812 20:23:54 mysqld started
050812 20:23:54 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
A mysqld process already exists at Fri Aug 12 20:24:15 CDT 2005
A mysqld process already exists at Sat Aug 13 10:48:59 CDT 2005
050813 10:55:23 [Note] /usr/libexec/mysqld: Normal shutdown
050813 10:55:23 InnoDB: Starting shutdown...
050813 10:55:24 InnoDB: Shutdown completed; log sequence number 0 43644
050813 10:55:24 [Note] /usr/libexec/mysqld: Shutdown complete
050813 10:55:24 mysqld ended
050813 10:55:25 mysqld started
050813 10:55:25 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
050813 10:55:36 [Note] /usr/libexec/mysqld: Normal shutdown
050813 10:55:36 InnoDB: Starting shutdown...
050813 10:55:38 InnoDB: Shutdown completed; log sequence number 0 43644
050813 10:55:38 [Note] /usr/libexec/mysqld: Shutdown complete
050813 10:55:38 mysqld ended
050813 10:55:39 mysqld started
050813 10:55:39 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
050813 10:57:25 [Note] /usr/libexec/mysqld: Normal shutdown
050813 10:57:25 InnoDB: Starting shutdown...
050813 10:57:27 InnoDB: Shutdown completed; log sequence number 0 43644
050813 10:57:27 [Note] /usr/libexec/mysqld: Shutdown complete
050813 10:57:27 mysqld ended
050813 10:57:28 mysqld started
050813 10:57:28 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
050813 10:59:28 [Note] /usr/libexec/mysqld: Normal shutdown
050813 10:59:28 InnoDB: Starting shutdown...
050813 10:59:31 InnoDB: Shutdown completed; log sequence number 0 43644
050813 10:59:31 [Note] /usr/libexec/mysqld: Shutdown complete
050813 10:59:31 mysqld ended
050813 10:59:31 mysqld started
050813 10:59:31 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
050813 11:01:31 [Note] /usr/libexec/mysqld: Normal shutdown
050813 11:01:31 InnoDB: Starting shutdown...
050813 11:01:34 InnoDB: Shutdown completed; log sequence number 0 43644
050813 11:01:34 [Note] /usr/libexec/mysqld: Shutdown complete
050813 11:01:34 mysqld ended
050813 11:01:34 mysqld started
050813 11:01:34 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
050813 11:03:34 [Note] /usr/libexec/mysqld: Normal shutdown
050813 11:03:34 InnoDB: Starting shutdown...
050813 11:03:37 InnoDB: Shutdown completed; log sequence number 0 43644
050813 11:03:37 [Note] /usr/libexec/mysqld: Shutdown complete
050813 11:03:37 mysqld ended
050813 11:03:37 mysqld started
050813 11:03:38 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
050813 12:52:32 [Note] /usr/libexec/mysqld: Normal shutdown
050813 12:52:32 InnoDB: Starting shutdown...
050813 12:52:35 InnoDB: Shutdown completed; log sequence number 0 43644
050813 12:52:35 [Note] /usr/libexec/mysqld: Shutdown complete
050813 12:52:35 mysqld ended
050813 12:52:36 mysqld started
050813 12:52:36 InnoDB: Started; log sequence number 0 43644
/usr/libexec/mysqld: ready for connections.
Version: '4.1.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
maybe the monit docs should state exactly what needs to be changed for it
to work.
so what needs to be set/changed? i simply do not know.
steve
On Sat, Aug 13, 2005 at 09:49:05PM +0200, Martin Pala wrote:
For mysql test to succeed, it is also needed to set access on mysql
side, otherwise monit request can be refused - you should check mysql
logs for errors ...
Martin
unruhtech wrote:
here is what i am getting in my log file:
[CDT Aug 13 12:55:10] MYSQL: error receiving login response -- Resource
temporarily unavailable
[CDT Aug 13 12:55:10] 'mysql' failed protocol test [MYSQL] at
INET[192.168.1.34:3306].
here is my monitrc entry (pretty much right out of the docs):
check process mysql with pidfile /var/run/mysqld/mysqld.pid
group database
mode active
start program = "/etc/init.d/mysqld start"
stop program = "/etc/init.d/mysqld stop"
if failed host 192.168.1.34 port 3306 protocol mysql then restart
if 5 restarts within 5 cycles then timeout
running on FC4 and using monit 4.5.1
is this a mysql config problem (no clue what) or a monit problem?
ideas?
thanks,
steve
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general
