|Subject:||RE: Monit and SQL query|
|Date:||Tue, 11 Sep 2012 20:11:15 +0800|
sorry the db is MySQL
and i am trying to read the difference between the last written record and the current time.
if its been 12 hours already. it should send an alert via monit.
problem is i am not really sure how to grep or an sql result that has different values (not just 1 or 0)
if status != 0 then alert -- should i still use status?
sorry im completely new to monit.
Date: Mon, 10 Sep 2012 14:51:42 -0400
Subject: Re: Monit and SQL query
Build a shell script that:
1. will issue the command to your server (you did not say what kind of sql server you have)
2. will parse the result from the server using for example grep and regex
3. If the result is unexpected use 'exit 1'
4. Set in monit as Martin said
On Mon, Sep 10, 2012 at 6:34 AM, Charles Pino <address@hidden> wrote:
-- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
|[Prev in Thread]||Current Thread||[Next in Thread]|