Re: {Disarmed} Re: [monit] Is this possible?

[Dimitri Yioulos]

John,

Yes.  Every time I change monitrc, I restart monit.

Oops, seems I'm getting a bit bleary-eyed here.  My last post should have 
read:

if I use the path /var/lib/mysql/brockton.pid, I get the 
response "brockton.pid is a regular file".  If I use the path /var/lib/mysql, 
I get the repsonse "brockton.pid is not a regular file".

Here's the output of monit.log where the path Is /var/lib/mysql/brockton.pid:

[EDT Jul 31 13:56:26] error    : 'mysqld' process is not running
[EDT Jul 31 13:56:29] info     : 'mysqld' trying to restart
[EDT Jul 31 13:56:29] info     : 'mysqld' start: /etc/rc.d/init.d/mysql
[EDT Jul 31 13:56:29] error    : 'brockton.pid' file doesn't exist
[EDT Jul 31 13:56:32] info     : 'brockton.pid' trying to restart
[EDT Jul 31 13:59:55] info     : 'mysqld' process is running with pid 14874
[EDT Jul 31 14:00:04] info     : 'brockton.pid' file exist
[EDT Jul 31 14:00:09] error    : 'brockton.pid' timestamp was changed 
for /var/lib/mysql/brockton.pid

Dimitri

On Thursday 31 July 2008 1:45 pm, Tomich,John wrote:
> You are aware that when you change monit config file, you must signal
> monit that you have done so, if monit is not configured to watch its own
> config file?  Also, is the brockton.pid file being changed after monit
> begins watching it?  Mysql must bounce in order for monit to detect the
> PID change.
>
>
> Regards,
>
> jt
>
> 888888888888
> John Tomich, IS Web Infrastructure
> Tempe campus
> *  480.337.5854
>
>
>
>
>  If you are not the intended recipient of this message (including
> attachments), or if you have received this message in error, immediately
> notify us and delete it and any attachments.  If you no longer wish to
> receive e-mail from Edward Jones, please send this request to
> address@hidden  You must include the e-mail address that you
> wish not to receive e-mail communications.  For important additional
> information related to this e-mail, visit
> www.edwardjones.com/US_email_disclosure
>
> -----Original Message-----
>
>
> From: address@hidden
> [mailto:address@hidden On
> Behalf Of Dimitri Yioulos
> Sent: Thursday, July 31, 2008 10:35 AM
> To: This is the general mailing list for monit
> Subject: Re: {Disarmed} Re: [monit] Is this possible?
>
> Yes.  In fact, I changed perms on both restart.sql and restart.sh to
> 777.  I also tried the timestamp directive.  NG.  As I mentioned, if I
> run ./restart.sh, it does run restart.sql, which creates the intended
> results in MySQL.
>
> BTW, in looking at monit.log, if I use the path
> /var/lib/mysql/brockton.pid, I get the response "brockton.pid is not a
> regular file".  If I use the path /var/lib/mysql, I get the repsonse
> "brockton.pid is not a regular file".
> Huh?  Which should it be?
>
> On Thursday 31 July 2008 1:20 pm, Tomich,John wrote:
> > And monit process owner has execute access to restart.sh?  If so,
> > maybe try using timestamp directive instead of checksum.
> >
> >
> > Regards,
> >
> > jt
> >
> > 888888888888
> > John Tomich, IS Web Infrastructure
> > Tempe campus
> > *  480.337.5854
> >
> >
> >
> >
> >  If you are not the intended recipient of this message (including
> > attachments), or if you have received this message in error,
> > immediately notify us and delete it and any attachments.  If you no
> > longer wish to receive e-mail from Edward Jones, please send this
> > request to address@hidden  You must include the e-mail
> > address that you wish not to receive e-mail communications.  For
> > important additional information related to this e-mail, visit
> > www.edwardjones.com/US_email_disclosure
> >
> > -----Original Message-----
> >
> >
> > From: address@hidden
> > [mailto:address@hidden
> > On Behalf Of Dimitri Yioulos
> > Sent: Thursday, July 31, 2008 10:16 AM
> > To: This is the general mailing list for monit
> > Subject: Re: {Disarmed} Re: [monit] Is this possible?
> >
> > Yes, it's root's home.  So, myfile.sql lives in /root.  I suppose I
> > could move it to, say, /usr/loca/scripts, which would then become the
> > path in the directive in question, but what difference would that
>
> make?
>
> > On Thursday 31 July 2008 1:07 pm, Tomich,John wrote:
> > > Silly question - you actually have a directory named 'root' under
>
> '/'?
>
> > > Regards,
> > >
> > > jt
> > >
> > > 888888888888
> > > John Tomich, IS Web Infrastructure
> > > Tempe campus
> > > *  480.337.5854
> > >
> > >
> > >
> > >
> > >  If you are not the intended recipient of this message (including
> > > attachments), or if you have received this message in error,
> > > immediately notify us and delete it and any attachments.  If you no
> > > longer wish to receive e-mail from Edward Jones, please send this
> > > request to address@hidden  You must include the e-mail
> > > address that you wish not to receive e-mail communications.  For
> > > important additional information related to this e-mail, visit
> > > www.edwardjones.com/US_email_disclosure
> > >
> > > -----Original Message-----
> > >
> > >
> > > From: address@hidden
> > > [mailto:address@hidden
> > > ]
> > > On Behalf Of Dimitri Yioulos
> > > Sent: Thursday, July 31, 2008 9:54 AM
> > > To: This is the general mailing list for monit
> > > Subject: Re: {Disarmed} Re: [monit] Is this possible?
> > >
> > > John,
> > >
> > > I changed the directive to read:
> > >
> > > check file brockton.pid path /var/lib/mysql
> > >   if changed checksum
> > >   then exec "/root/restart.sh"
> > >
> > > Still no joy.  Grrrr.
> > >
> > > Dimitri
> > >
> > > On Thursday 31 July 2008 12:33 pm, Tomich,John wrote:
> > > > Dimitri,
> > > >
> > > > I'm no monit expert, but all the examples of checkfile I've seen
> > > > do not repeat the actual filename to check in the 'with path'
>
> string.
>
> > > > Perhaps you need to end your path with the directory where the
> > > > script you want to run lives?
> > > >
> > > >
> > > > Regards,
> > > >
> > > > jt
> > > >
> > > > 888888888888
> > > > John Tomich, IS Web Infrastructure Tempe campus
> > > > *  480.337.5854
> > > >
> > > >
> > > >
> > > >
> > > >  If you are not the intended recipient of this message (including
> > > > attachments), or if you have received this message in error,
> > > > immediately notify us and delete it and any attachments.  If you
>
> no
>
> > > > longer wish to receive e-mail from Edward Jones, please send this
> > > > request to address@hidden  You must include the e-mail
> > > > address that you wish not to receive e-mail communications.  For
> > > > important additional information related to this e-mail, visit
> > > > www.edwardjones.com/US_email_disclosure
> > > >
> > > > -----Original Message-----
> > > >
> > > >
> > > > From: address@hidden
>
> [mailto:address@hidden
>
> > > > ]
> > > > On Behalf Of Dimitri Yioulos
> > > > Sent: Thursday, July 31, 2008 9:23 AM
> > > > To: This is the general mailing list for monit
> > > > Subject: Re: {Disarmed} Re: [monit] Is this possible?
> > > >
> > > > (I'm not sure if I should be top-posting, but to keep the thread
> > > > consistent, I'm top-posting)
> > > >
> > > > The command is mysql start, and not mysqld start.  The restart of
> > > > MySQl works fine.  I created an simple bash script to execute
> > > > "myfile.sql", which I tested and know works. So, the second
> > > > directive
> > >
> > > looks like this:
> > > > check file brockton.pid path /var/lib/mysql/brockton.pid
> > > >   if changed checksum
> > > >   then exec "/root/restart.sh"
> > > >
> > > > However, the script doesn't seem to fire off.  So, I'm almost
>
> there,
>
> > > > but the most important part (the MySQL table work) isn't
>
> happening.
>
> > > > Any ideas as to why?
> > > >
> > > > Dimitri
> > > >
> > > > On Thursday 31 July 2008 11:34 am, Pierrick Grasland wrote:
> > > > > just in case :
> > > > >
> > > > > mysql or mysqld ?
> > > > >
> > > > > if it's the second, then your error is here :
> > > > >
> > > > > start program = "/etc/rc.d/init.d/mysql*d* start"
> > > > >  stop program = "/etc/rc.d/init.d/mysql*d* stop"
> > > > >
> > > > > On Thu, Jul 31, 2008 at 5:20 PM, Dimitri Yioulos
> > > >
> > > > <address@hidden>wrote:
> > > > > > On Thursday 31 July 2008 10:54 am, Dimitri Yioulos wrote:
> > > > > > > On Thursday 31 July 2008 9:55 am, Pierrick Grasland wrote:
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I hope to correctly understand your problem :
> > > > > > > >
> > > > > > > > *executing a script after mysql restart.*
> > > > > > > >
> > > > > > > > So, my first solution is below :
> > > > > > > > >From the manual :
> > > > > > > >
> > > > > > > > ***IF CHANGED [MD5|SHA1] CHECKSUM [[<X>] <Y> CYCLES]
> > > > > > > >       THEN action*
> > > > > > > >
> > > > > > > > or
> > > > > > > >
> > > > > > > > ***IF CHANGED TIMESTAMP [[<X>] <Y> CYCLES] THEN action*
> > > > > > > >
> > > > > > > >
> > > > > > > > I think you can adapted this as follow :
> > > > > > > >
> > > > > > > >  check file mysqlpidfile path <path of pidfile>
> > > > > > > >    if changed sha1 checksum
> > > > > > > >          then exec "mysqlreload.sh"
> > > > > > > >
> > > > > > > >
> > > > > > > > Add a simple :
> > > > > > > >
> > > > > > > > check process mysql with pidfile mysqlpidfile start =
>
> "..."
>
> > > > > > > > stop = "..."
> > > > > > > >
> > > > > > > > And I think you have it.
> > > > > > > >
> > > > > > > > (when mysql restart, it will have a new pid, so a
>
> different
>
> > > > > > > > checksum or timestamp
> > > > > > > >
> > > > > > > > I'm not sure of the syntax (can't test), but I think it
>
> will
>
> > > > work.
> > > >
> > > > > > > > Regards,
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > Pierrick Grasland
> > > > > > >
> > > > > > > Pierrick,
> > > > > > >
> > > > > > > Thank you so much!
> > > > > > >
> > > > > > > Not having a lot of experience creating monit directives,
>
> I'm
>
> > > > > > > not sure exactly what to do with the directives you've shown
> >
> > me.
> >
> > > > > > > To accomplish
> > > > > >
> > > > > > what
> > > > > >
> > > > > > > I want to do, would my directives look like this?:
> > > > > > >
> > > > > > > check process mysqld with pidfile
>
> /var/lib/mysql/brockton.pid
>
> > > > > > >   start program = "/etc/rc.d/init.d/mysql start"
> > > > > > >   stop program = "/etc/rc.d/init.d/mysql stop"
> > > > > > >   if failed host 192.168.100.7 port 3306 type TCP then
>
> restart
>
> > > > > > >   if 5 restarts within 5 cycles then timeout
> > > > > > >
> > > > > > > check file /var/lib/mysqld/brockton.pid
> > > > > > >   if changed sha1 checksum
> > > > > > >   then exec "mysql test1 < /root/restart.sql"
> > > > > > >
> > > > > > > If so, when I try to start monit, I get the follwing error:
> > > > > > >
> > > > > > > Starting monit: /etc/monitrc:216: Error: syntax error 'if'
> > > > > > >
> > > > > > > [FAILED]
> > > > > > >
> > > > > > > Where am I going wrong?
> > > > > > >
> > > > > > > Dimitri
> > > > > >
> > > > > > Sorry to respond to my own post, but I corrected one of the
> > > > > > directives (should have followed Pierrick's directions
> > > > > > explicitly
> > > > > >
> > > > > > :-) ) to read:
> > > > > >
> > > > > > check file brockton.pid path /var/lib/mysqld/brockton.pid
> > > > > >   if changed sha1 checksum
> > > > > >  then exec "mysql test1 < /root/restart.sql"
> > > > > >
> > > > > > and the error I quoted in my last post went away.  However,
>
> it's
>
> > > > > > been replaced
> > > > > > by:
> > > > > >
> > > > > > Starting monit: /etc/monitrc:217: Error: the executable does
>
> not
>
> > > > > > exist 'mysql'
> > > > > >
> > > > > > [FAILED]
> > > > > >
> > > > > > The script I'm using to do the table changes in MySQL is in
>
> the
>
> > > > > > form
> > > > > >
> > > > > > "myfile.sql", and is executed with the command "mysql
> > > > > > databasename
> > > > > >
> > > > > > <
> > > > > >
> > > > > > myfile.sql".  Monit seems to be tripping over this.  Am I not
> > > > > > able
> > > > > >
> > > > > > to execute this command via monit?
> > > > > >
> > > > > > Dimitri
> > > > > >
> > > > > > --
> > > > > > This message has been scanned for viruses and dangerous
>
> content
>
> > > > > > by
> > > > > >
> > > > > > MailScanner, and is believed to be clean.
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > To unsubscribe:
> > > > > > http://lists.nongnu.org/mailman/listinfo/monit-general
> > > > >
> > > > > --
> > > > > Pierrick Grasland
> > > >
> > > > --
> > > > This message has been scanned for viruses and dangerous content by
> > > > MailScanner, and is believed to be clean.
> > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe:
> > > > http://lists.nongnu.org/mailman/listinfo/monit-general
> > > >
> > > >
> > > > --
> > > > To unsubscribe:
> > > > http://lists.nongnu.org/mailman/listinfo/monit-general
> > >
> > > --
> > > This message has been scanned for viruses and dangerous content by
> > > MailScanner, and is believed to be clean.
> > >
> > >
> > >
> > > --
> > > To unsubscribe:
> > > http://lists.nongnu.org/mailman/listinfo/monit-general
> > >
> > >
> > > --
> > > To unsubscribe:
> > > http://lists.nongnu.org/mailman/listinfo/monit-general
> >
> > --
> > This message has been scanned for viruses and dangerous content by
> > MailScanner, and is believed to be clean.
> >
> >
> >
> > --
> > To unsubscribe:
> > http://lists.nongnu.org/mailman/listinfo/monit-general
> >
> >
> > --
> > To unsubscribe:
> > http://lists.nongnu.org/mailman/listinfo/monit-general
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>
> --
> To unsubscribe:
> http://lists.nongnu.org/mailman/listinfo/monit-general
>
>
> --
> To unsubscribe:
> http://lists.nongnu.org/mailman/listinfo/monit-general

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.