installation and configuration of MSSQL by ODBC docker

[Eric25]

Hi.
I have zabbix server installed in the docker. I wanted to monitor the MS SQL server on a host with an agent installed.
At the very beginning I added the required MSSQL by ODBC template, but the next step is to install the Microsoft ODBC driver on the server (in my case, the container) zabbix. I am using this guide: https://www.zabbix.com/integrations/microsoft_sql
The question is whether it is possible to install a new program in an existing container? how can I do this? I tried to enter the container with the docker exec -it [container-id] bash command and manually install the driver there, but using sudo command there returns an error.

[[email protected]]

Hey Eric!

I am also struggling to resolve this doubt. Unfortunately the Zabbix documentation is not so clear in this case, perhaps this are not ready to receive this monitoring if Zabbix Proxy is a Docker.

I'll try to fix this situation and I'll let you know if I resolve

[[email protected]]

Hey Eric!

Proxy Docker still doesn't really support connecting natively.

But you can access the Proxy / Server container and install the ODBC driver inside the Container (or make a dockerfile for that)

Here is what I did:

Enter the container as root:

docker exec -it -u root container-name /bin/bash

Then:

apt update

apt install gpg curl

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

apt update

ACCEPT_EULA=Y apt-get install msodbcsql17

ACCEPT_EULA=Y apt-get install mssql-tools

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

source ~/.bashrc

then I edited the /etc/odbc.ini as:

[DSNNAME]
Driver = ODBC Driver 17 for SQL Server
Server= SERVERNAME
Port = 1433
User = user

And tested the connection with the:

isql DSNNAME user password

This shall be the result:



Then go back to Host in the Zabbix conf and set the macro parameters:



Hope this helps for a while

[mmalex]

Thank you Julio very much for your answer ,it worked for me

[PiotrJ]

Hi
I need help with the install odbc on docker compose.
I actually instaled odbc on the first container(screenshot) but in frontend i get error.
Should I instal odbc i second conrtainer or what please help.