Re: mysql protocol problems - monit 4.5.1

[Martin Pala]

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