In a previous post we installed the tools necessary to access Microsoft SQL Server, continuing our quest I needed to monitor some filegroups and decided to create something like Pyora. It only monitors filegroups (Primary used and Log used), but I plan to add more items like datasize, logcachehit, etc. The idea is pretty simple, ./pyssql.py fetch data from SQL Server via Zabbix. Follow the instructions below to install and use it:...
Install the required packages UnixODBC and FreeTDS packages yum install -y unixODBC unixODBC-devel freetds Configure unixODBC Add the content below to the file /etc/odbcinst.ini [FreeTDS] Description=ODBC for SQL Server Driver=/usr/lib/libtdsodbc.so Setup=/usr/lib/libtdsS.so FileUsage=1 Configure FreeTDS Add the content below to the file /etc/freetds.conf tds version = 8 client charset = UTF-8 Install pypyodbc to Python handle ODBC connections pypyodc is a pure python ODBC interface. For more information access https://code.google.com/p/pypyodbc/ I’m using pip to install it....