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 <[email protected]>wrote: > sql statement is supposed to evaluate if the result is >= to 12 , if true > then alert. > > how do i put that in place of " PROCESS OUTPUT AND RETURN 1 IF FAILED > OTHERWISE 0" ?? > > thanks > > ------------------------------ > From: [email protected] > Subject: Re: Monit and SQL query > Date: Mon, 10 Sep 2012 09:06:11 +0200 > To: [email protected] > > > Hello, > > you can use the "check program" to test the exit value of custom script. > In this case the script can execute the SQL statement and return error if > problem is found. > > Script skeleton: > --8<-- > #!/bin/bash > /ur/bin/mysql -e "SQL STATEMENT" ... | PROCESS OUTPUT AND RETURN 1 IF > FAILED OTHERWISE 0 > --8<-- > > Connection of the script with monit: > --8<-- > check program myscript with path "/usr/local/bin/myscript.sh" > if status != 0 then alert > --8<-- > > Regards, > Martin > > > On Sep 9, 2012, at 4:58 PM, Charles Pino <[email protected]> wrote: > > Hello all, > is it possible to execute and SQL query and have monit execute and alert > or something else depending on its response? > > i have a sql query that queries a specific table. of something hasnt been > updated in that table for 12 hours. i need to send an alert or whatever. > that the table/field hasnt been updated. > > please help. > > thanks > > -- > To unsubscribe: > https://lists.nongnu.org/mailman/listinfo/monit-general > > > > -- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general > > -- > To unsubscribe: > https://lists.nongnu.org/mailman/listinfo/monit-general >
-- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
