SQL Server work with Zabbix Server ??

[didavoli]

Hello Guys.
I´m new in Zabbix implementation, then I have a dubbit about database SQL Server. Normaly, Zabbix Server work with MySQL (Database), so I will want know, if I can to use SQL Server with Zabbix Server and not MySQL. Is possible? Can some help me this information, please? Thanks so much by all information.

[Atsushi]

You can use MySQL, PostgreSQL, Oracle, DB2 as the backend database for Zabbix server.
Microsoft SQL Server is not supported as a backend database.

https://www.zabbix.com/documentation/3.0/manual/installation/requirements#software

[didavoli]

You can use MySQL, PostgreSQL, Oracle, DB2 as the backend database for Zabbix server.
Microsoft SQL Server is not supported as a backend database.
https://www.zabbix.com/documentation...ments#software

If I use ODBC Drive to conversation with SQL Server ? This post I found maybe a possible solution - https://docs.microsoft.com/en-us/sql...for-sql-server

Some have this experience this and tell me if this stable work ?
Thanks all.

[kaspars.mednis]

Microsoft SQL server is not supported by zabbix_server...

I'm almost sure this will not work, because you can execute SQL queries on MsSQL database from *nix system with ODBC driver, but thats all.

I think zabbix server internal engine is not compatible with MsSQL specific SQL queries/stored procedures etc.

Zabbix server anyway works only on *nix systems... why not install free MySQL DB there ?
for small to medium size installations it can work on the same server

are you planning very large Zabbix installation with thousands values per second ?
Oracle is also supported, but that is another topic....

Regards,
kaspars

[didavoli]

I have a medium size network. During this days, I had some issues using MySQL until found this post https://bugs.launchpad.net/ubuntu/+s...6/+bug/1435823 . Then, we reinstall a old version on Ubuntu Server 14.04 with Zabbix 3.4.3 but working MySQL 5.5 (until now, any problem). Wich 2 days, this database (version 5.6 / 5.7). My question about SQL Server work together Zabbix, how suggestion, but using OBDC (agent) how intermedium between Zabbix <-> SQL Server, not directly Zabbix accessing/consulting SQL Server. This topology, some have if work fine ? Thanks all by information passed and news.

[SBO]

If for whatever reason you have troubles with MySQL, you can use another supported database, like postgresql.
Trying to use something not supported, with some weird bridge/translator/connector/whatever will lead you for sure, sooner or later, to failure.

[didavoli]

I will try now (during this days), work Ubuntu Server 14.04 with Zabbix 3.4.2 using MySQL 5.5 .... I will return with information, ok guys ?

[SBO]

If you can, use Ubuntu 16.04, it's the latest LTS, no real reason to use the 14.04, as far as I know.
And if you have any trouble, sure, come back here to post.

[allexpetrov]

Hello didavoli,

I would suggest you to user MariaDB(MySQL fork) or PostgreSQL just because if you will run into the troubles, then you will have a lot information from the community or from zabbix.org

Why not use latest MySQL ? And if you can - please go with the latest Ubuntu LTS, right now it is 16.04

Regards,
Aleksejs!

[didavoli]

Hi guys. I´m returning with final result my issue. We install Ubuntu Server 14.04 with MySQL 5.5 - Zabbix 3.4.2 ... So, during this days, haven´t more any problem. Other problem that we have is "Can´t initialize configuration cache". View log below:

root@jagux003:/home/administrator# tail -f /var/log/zabbix/zabbix_server.log
2852:20171030:070134.106 SMTP authentication: YES
2852:20171030:070134.106 Jabber notifications: YES
2852:20171030:070134.106 Ez Texting notifications: YES
2852:20171030:070134.106 ODBC: YES
2852:20171030:070134.106 SSH2 support: YES
2852:20171030:070134.106 IPv6 support: YES
2852:20171030:070134.106 TLS support: YES
2852:20171030:070134.106 ******************************
2852:20171030:070134.106 using configuration file: /etc/zabbix/zabbix_server.conf
2852:20171030:070134.116 cannot initialize configuration cache: cannot get private shared memory of size 342255207 for configuration cache: [22] Invalid argument


To solve this issue, apply command "sysctl -w kernel.shmmax=536870912".

https://www.zabbix.com/forum/showthread.php?t=14445

Thanks everybody.