jarischaefer / docker-librenms

Docker image for LibreNMS
MIT License
115 stars 37 forks source link

Monitor SQL Server 2014 #117

Closed alrodgir closed 4 years ago

alrodgir commented 4 years ago

Hello There, ¿It's possible to monitor SQL services with this docker? I'm installed the check_mssql nagios plugin, but the error I obtain is this. UNKNOWN: PDO MSSQL/DBLIB support is not installed on this server. Try adding packages php-pdo and php-mssql.

Or maybe is better if I use another nagios plugin.

jarischaefer commented 4 years ago

Please pull the latest version and run the following command to check driver support: docker run --rm jarischaefer/docker-librenms php -i | grep -i sqlsrv.

The new image contains https://github.com/microsoft/msphpsql, I hope it works for SQL Server 2014.

jarischaefer commented 4 years ago

Closed due to inactivity.

alrodgir commented 4 years ago

Sorry, I had forgotten this post. I've tried try the command and works perfect. Captura

But when I'm going to create the alert for the service, I don't see the sqlsrv check Captura1

Which service I need to search.

Thanks.

jarischaefer commented 4 years ago

I'm installed the check_mssql nagios plugin, but the error I obtain is this. UNKNOWN: PDO MSSQL/DBLIB support is not installed on this server. Try adding packages php-pdo and php-mssql.

How did you get this error last time? I do not know whether LibreNMS offers MSSQL support out-of-the-box, I thought you were going to use the nagios plugin.

alrodgir commented 4 years ago

Yes, I used the nagios plugin check_mssql, I copied the script in the plugin folder. Now I can't remember the command I used to test the plugin. I'll search and tell u more.