Shulou(Shulou.com)06/03 Report--

Monitoring SQL Server with Zabbix ODBC monitoring

1. Create a group ODBC Templates

two。 Create Template SQL Server and Template MySQL

3. Install unixODBC on Zabbbix

Shell > yum-y install unixODBC unixODBC-devel

4. Install the unixODBC driver for the corresponding database on Zabbix

UnixODBC has a list of supported databases and drivers:

Http://www.unixodbc.org/drivers.html

For SQL Server:

A) install the unixODBC driver

Shell > yum install freetds

B) configure unixODBC

We complete the configuration of ODBC by editing the odbcinst.ini and odbc.ini files. First, verify the location of the configuration file with the following command:

Shell > odbcinst-j

You can use the following command to find the location of the ODBC driver:

Shell > find /-name 'libtdsodbc*'

Add SQL Server driver FreeTDS to / etc/odbcinst.ini:

Shell > vim / etc/odbcinst.ini

[FreeTDS]

Description = ODBC for SQL Server

Driver = / usr/lib64/libtdsodbc.so.0

Setup = / usr/lib64/libtdsS.so

FileUsage = 1

The FreeTDS driver has a command line tool, tsql or even SQL Server, and it can also be a file / etc/freetds.conf that can be configured to connect to the DSN of SQL Server.

The TDS protocol version corresponding to each version of SQL Server:

Http://www.freetds.org/userguide/choosingtdsprotocol.htm

Configure odbc connection information:

Shell > vim / etc/odbc.ini

[szsql01]

Driver = FreeTDS

Server = 192.168.137.6

Port = 1433

Database = DBAdmin

TDS_Version = 8.0

This time, instead of setting the user name and password in the file, we set it on the page.

To check if the driver sees your data source:

Shell > odbcinst-Q-s

C) create and authorize users on the monitored SQL Server 2016 server szsql01.

D) Test connecting to the database on Zabbix.

Shell > isql-v szsql01 database username password

E) install zabbix 3.2 agent on szsql01.

Open Powershell as an administrator and download the installation package.

After unzipping, rename zabbix_agents_3.2.0.win to zabbix, copy the configuration file in the conf directory to the parent directory, rename it to zabbix_agentd.conf, and edit and update the following values.

# Server= [zabbix server ip]

# Hostname= [Hostname of client system]

Server=192.168.137.5

ServerActive=192.168.137.5

Hostname=192.168.137.6

Note: the Hostname should be the same as when you created the Host.

Install zabbix agent as a service and start the service:

Check the error log c:\ zabbix_agentd.log started by the agent to see if it is normal.

F) add monitoring items to the new Template SQL Server template created by Zabbix

G) connect the monitored server szlinux01 to the template and view the data:

Reference:

Https://www.zabbix.com/documentation/3.4/manual/config/items/itemtypes/odbc_checks

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.