idscan/zabbix-server-mysql
Zabbix server uses MySQL database with Microsoft ODBC driver for SQL Server on Alpine docker images
Image
Monitoring & observability
0
5.4K
idscan/zabbix-server-mysql repository overview
zabbix-server-mysql
Zabbix server uses MySQL database with Microsoft ODBC driver for SQL Server on Alpine and Ubuntu docker images
Uses
- Official docker image Zabbix server (MySQL) LTS
- Microsoft ODBC driver for SQL Server 18
- Alpine-based:
Dockerfile - Ubuntu-based:
Dockerfile.ubuntu
Test
- Run Zabbix Server with this image idscan/zabbix-server-mysql
- Check ODBC Driver:
docker exec _container_name_ odbcinst -q -d -n "ODBC Driver 18 for SQL Server"
Result:
[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.1.1
UsageCount=1
- Create odbc.ini:
[mssql-test]
Description = MS SQL test
Driver = ODBC Driver 18 for SQL Server
Server = tcp:192.168.100.100,1433
TrustServerCertificate = Yes
- Mount our odbc.ini in docker container_name (recreate container with -v|--mount or with volume in compose):
-v /path/our/odbc.ini:/etc/odbc.ini:ro
- Check DSN:
docker exec _container_name_ odbcinst -q -s -n
Result our DSN name:
[mssql-test]
and show our DSN mssql-test:
docker exec _container_name_ odbcinst -q -s -n mssql-test
Result will show the contents of our odbc.ini:
[mssql-test]
Description = MS SQL test
Driver = ODBC Driver 18 for SQL Server
Server = tcp:192.168.100.100,1433
- Check connect:
docker exec _container_name_ isql mssql sqluser sqlpassword
Result:
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
SQL query
Create login & grant permission for zabbix:
CREATE LOGIN zabbixlogin WITH PASSWORD='*Password*';
GRANT VIEW SERVER STATE TO zabbixlogin;
GRANT VIEW ANY DEFINITION TO zabbixlogin;
permission for the "Get job status" item :
USE [msdb]
CREATE USER zabbixlogin FOR LOGIN zabbixlogin
GRANT EXECUTE ON [dbo].agent_datetime TO [zabbixlogin]
ALTER ROLE db_datareader ADD MEMBER [zabbixlogin];
Tag summary
Content type
Image
Digest
sha256:c1ded6fc2…
Size
40.3 MB
Last updated
about 1 month ago
docker pull idscan/zabbix-server-mysql