MySQL Checks
Hello,
I'm looking to create an Item that will preform a simple ODBC connection to a MySQL database and trigger an email alert if the connection fails for some reason E.g. whether the service is down or the users password has changed.
With some preliminary testing - changing the password to an incorrect value - it appears that the Item is toggled to 'Not Supported' which disabled the trigger that was created to alert if no value has been received in the past five minutes.
Is it possible to do a simple ODBC auth test (confirms daemon is running and password works) and trigger an alert if an error is returned?
I realize I can make a custom script to do this but I think there may be a better way.
I'm looking to create an Item that will preform a simple ODBC connection to a MySQL database and trigger an email alert if the connection fails for some reason E.g. whether the service is down or the users password has changed.
With some preliminary testing - changing the password to an incorrect value - it appears that the Item is toggled to 'Not Supported' which disabled the trigger that was created to alert if no value has been received in the past five minutes.
Is it possible to do a simple ODBC auth test (confirms daemon is running and password works) and trigger an alert if an error is returned?
I realize I can make a custom script to do this but I think there may be a better way.