database monitor + proxy

[mcsetestac]

Good morning everyone, happy to have joined this forum. Thank you.
I would like to raise a question that I cannot resolve regarding monitoring a database. I'm currently safely using Zabbix version 4.4.4 with proxies. No problem.
Now I should connect to an MS SQL database to extract data with queries. I installed the odbc (FREETDS) drivers and configured the odbc.ini, odbcinst.ini and freetds.conf files but the item always gives me the error: "Cannot connect to ODBC DSN: [SQL_ERROR]: [IM002] [0] [[unixODBC] [Driver Manager] Data source name not found, and no default driver specified]". Should something also be configured on the proxy side?

Thanks in advance. Greetings

[mcsetestac]

For completeness these are the odbc driver configuration files:



--------------------------------------------------------------------
odbc.ini

[AliasName_DB]
Driver = FreeTDS
Description = ODBC connection via FreeTDS
Trace = No
Server = Instance_IP
Port = 1433
Database = Database_Name
TDS_Version = 7.0

--------------------------------------------------------------------
odbinst.ini

[FreeTDS]
Description = TDS driver (Sybase/MS SQL)
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
CPTimeout = 5
CPReuse = 5
FileUsage = 1

--------------------------------------------------------------------
freetds.conf

[Instance_Name]
host = Instance_IP
port = 1433
tds version = 7.0

[mcsetestac]

hi, thanks.
I wanted to clean my odbc test installation .

sudo apt-get remove freetds-dev
sudo apt-get remove freetds-bin
sudo apt-get remove freetds-common
sudo apt-get remove odbcinst1debian2 libodbc1 odbcinst unixodbc


but now zabbiz server doesn't work....:-(
so reinstall this odbc

sudo apt-get install odbcinst1debian2 libodbc1 odbcinst unixodbc

starting zabbix server manually but.........

sudo service zabbix-server status:
zabbix-server.service - LSB: Start zabbix-server daemon
Loaded: loaded (/etc/init.d/zabbix-server; generated)
Active: active (exited) since Thu 2021-04-22 12:50:00 CEST; 4min 29s ago
Docs: man:systemd-sysv-generator(8)
Process: 1346 ExecStart=/etc/init.d/zabbix-server start (code=exited, status=0/SUCCESS)

Apr 22 12:50:00 srvxxxxxx systemd[1]: Starting LSB: Start zabbix-server daemon...
Apr 22 12:50:00 srvxxxxxx systemd[1]: Started LSB: Start zabbix-server daemon.

there is no log in /var/log/zabbix after my "remove" action.....

and there is no daemon for zabbix server and tcp port 10051 is obviously not listen. Please any idea? I think that with my "remove odbc driver" I generated this problem....thanks

[mcsetestac]

After odbc drivers were removed, zabbix was uninstalled....:-o ...............yhen reinstalled and everything ok. Thank you