Database ODBC Monitoring with Zabbix

How to use Zabbix monitoring tool to monitor any database through ODBC protocol with ease.
☕ In case if you want to support this content with coffee:
☕ www.buymeacoff...
👋 SOCIAL MEDIA
→ / discord
→ / dmitrylambert
→ / dmitrylambert
→ / dmitry.lambert
Homelab and Tech KZbin channel: @DmitryLambertTech
📫 Sign Up For Newsletter And Don't Miss Out on Anything
→tinyurl.com/4s...

[@zabbixtraining]

► Grab your Monitoring Love Merchandise - teespring.com/stores/monitoring-it

[@saintvittsdance]

Dmitry, thank you so much! You lessons are more valuable than most part of lectures in my university 😀

[@andli86]

I really like your Zabbix videos! Here is a suggestion for video topic that I would like to see, Inventory (how to start with inventory, since I haven’t succeeded with this yet), Keep up your good work!

[@lukashruda824]

Great videos Dmitry, can you also make a video about MSSQL monitoring by Zabbix agent 2, please?

[@mbulelo-damba]

Hi Dmitry, I enjoy your videos. I wouldn't mind watching a video that's an hour long as long as I learn something. Keep up the good work!

[@zabbixtraining]

Thank you, I will keep that in mind :)

[@reesv01]

Awesome videos dude, really appreciate the simple, but well structured videos without any of the advanced techy stuff! Cheers :)

[@zabbixtraining]

Thanks! There was much more added since your visit :)

[@sharpazn]

I just discovered your channel, it's amazing!!! I must learn the basics of Zabbix for a new junior DBA job in 2 weeks, what videos would you recommend me to watch?

[@zabbixtraining]

Oh man it's a hard question :) There are 150 videos. Start somewhere :)

[@sharpazn]

@@zabbixtraining gonna watch everything lmao but thanks!

[@zabbixtraining]

@@sharpazn Just be careful with very old videos :) As those might be outdated for recent versions

[@8dalight]

I think it will be interesting to get a deep dive into web services monitoring. Web scenarios and HTTP agent. Thanks. By the way, keep going you're awesome)

[@zabbixtraining]

Will do

[@reesv01]

@@zabbixtraining I second this.

[@ricardobagnoli9893]

Can you make a similar video for monitoring SQL Server DBs?

[@ranvijaymehta]

Thanks Dmitry for this video

[@narendranvijayakumar3859]

You are videos are awesome. You are saving a lot time for new beginners

[@zabbixtraining]

Happy to hear that!

[@abolfazlkaviany3966]

Thank you fro the video, when in front end i test the item it gets back the mysql error IM005, while in the terminal with isql DSN , it works great, the related matters to firewall and selinux are oke

[@zabbixtraining]

Probably because fontend runs the test as "zabbix" user, but in terminal you are under "root"

[@arafatabsi6546]

Hi Dmitry, Thank you so much for making these vids, can i ask you if is it possible to monitor MSSQL databases size on a windows host? I have alreday made the connection with the windows host via zabbix agent and i want to list all databases size by running a stored procedure which exist on the windows host MSSQL In zabbix documentaion i found within Zabbix agent 2 that additional itmes keys like "Database size in bytes for MySQL and PostgreSQL" only not for MSSQL Thank you

[@lanceeilers5061]

Thanks so much , very interesting thought process how you move between the documentation to do problem solving - I am very new at data bases , kind of played around and setup but never really wrapped my head around the queries themselves , I struggle to get to the end result (which I know I want to achieve) my problem solving skills is limited , and I am very stupid most of the time , but I will work at it ... thanks again for the cool vid have a nice one (yip Inventory looks good , and possibly best configuration practices for zabbix server and how to use the documentation - I would be interested in) , thanks again best regards Lance :-)

[@NimbusDevOps]

A video on monitoring Sybase would be amazing

[@ranvijaymehta]

Please create one video. How to monitor MySQL with SSL enabled using Zabbix

[@kvicksa]

How about introduction and examples about Orabbix if you are familiar with it? Another things that I would to see is some examples on how to utilize IT Services in a useful way. Keep up the great work!

[@zabbixtraining]

I'm not a big fan of Oracle as Zabbix backend, and I don't have a test instance on which to make video.

[@zabbixtraining]

Books About Zabbix Amazon COM ► Zabbix 4 Network Monitoring 3rd Edition amzn.to/2Ra7XDE ► Zabbix Network Monitoring 2nd Edition amzn.to/2DQLWqI Amazon UK ► Zabbix 4 Network Monitoring amzn.to/2G7BCey ► Mastering Zabbix - Second Edition amzn.to/306Ru86 Amazon DE ► Zabbix 4 Network Monitoring amzn.to/2FYg3NU ► Zabbix Cookbook amzn.to/3iXuqQK

[@luiansan30]

Dmitry Lambert Congratulations on the project. It has helped me a lot in my day to day work. Can we suggest new videos? I am very curious to know how Zabbix works with HyperV. Since microsoft has a closed architecture, what would the LDD part of virtual machines using this platform look like? Thanks for your help and once again my congratulations, excellent work.

[@zabbixtraining]

Hey Luis, Thanks for feedback. Seems like powershell script comes handy here. As example this project: github.com/itmicus/zabbix/tree/master/Template%20Microsoft%20Hyper-V

[@harithm9219]

Hi. Need your help. I've installed odbc mysql-connector-odbc-5.2.5-8, unixODBC-2.3.1 & unixODBC-devel-2.3.1 in rhel7. It is connected when I run isql command. But when I run the sql query, for example show tables, it shows 'Segmentation fault (core dumped)'. Any idea what is the problem? What should I do? Do I need to upgrade the odbc version? I'm using zabbix 3.4

[@Ravindrakumar-xo1jm]

Oracle graph is not showing Why? please help

[@idrissoukassimou3264]

i'am trying to monitor oracle database with zabbix using ODBC but still have error while integrind db to zabbix frontend

[@varunyadav85]

how can we monitor multiple instance on same hostname and RAC database connection ? Plz provide tutorial..

[@jatinchugh6752]

Hey Dmitry, Can we use this method to fetch data from AWS RDS endpoints as well?

[@zabbixtraining]

I'm not 100% sure, but I think yes.

[@Pbsk85]

in case of a firebird database, how can I connect it to zabbix?

[@alkamird]

Thanks a lot for the videos, here are some topics, zabbix integration monitoring gitlab, jenkins,ci/cd ? and how to create macros a full example to perform our lld.

[@zabbixtraining]

Thank you for ideas. Could you clarify what exactly you would want to monitor in gitlab?

[@mathwork4747]

Thanks! I want to monitor Oracle 12 C. How it is possible? Please upload your video. I see your full video and understand it very easily. Thanks Again.

[@zabbixtraining]

Check this out www.zabbix.com/forum/zabbix-help/45104-odbc-monitoring-oracle-db Only difference between oracle and this video, is a struggle with environment variables.

[@4351-rv]

@@zabbixtraining The struggle is real. Is it safe to create the oracle environment variables(ORACLE_HOME, LD_LIBRARY_PATH, TNS_ADMIN) for Zabbix within the zabbix_server.conf file? Otherwise, where or how to set environment variables for zabbix? Please help. Thanks.

[@janisgrotus4386]

Do I have to compile zabbix from sources for odbc support. In docs I have to, but here I don't?

[@zabbixtraining]

You dont. Packages are shipped with everything supported. If you are compiling you can choose what you need and what not.

[@vanomel528]

Maybe something about zabbix API + Python?

[@kvicksa]

+1

[@8dalight]

+1. Zabbix automation using API. Bash and Python.

[@zabbixtraining]

Will publish this week

[@akhilsai3880]

how to find in which database the Zabbix is storing the data

[@fireflycz1230]

Hi, I have an issue with my Zabbix. When I set new Item and then go to latest data my zabbix server crashes. I use MySQL 8.0 Community Server for Zabbix. Could you please help me what could be wrong? Thank you very much in advance. isql command works. I can connect to db but Zabbix server is crashing repeatedly. EDIT: I looked that i do not have the driver in /usr/lib/libmyodbc5.so and /usr/lib64/libmyodbc5.so I used drivers for 8.0 not those you have in video. So, could it be the problem??

[@fireflycz1230]

Issue fixed. I searched the internet and found that there is some bug and Zabbix can use only some version of odbc connector. I installed version 5.2.7 and it works perfectly. bugs.mysql.com/bug.php?id=73709 There is descripton of the problem.

[@zabbixtraining]

Its is not really a zabbix bug. More a mysql fault. As you alreaduly did - sometimes different versions of unixodbc and connector works. Sometimes not. It can happen only if your zabbix backend db is mysql

[@fireflycz1230]

@@zabbixtraining Thank you very much for feedback and clarification. I had to use MySQL due to company restrictions. Thank you for this channel full of amazing tutorials. :)

[@RehanShaikh-vz4uj]

How to do SQL jobs monitoring through zabbix

[@8dalight]

Also it will be interesting to see a video about Zabbix Threat Control.

[@zabbixtraining]

What do you mean as treat control?

[@8dalight]

@@zabbixtraining github.com/vulnersCom/zabbix-threat-control

[@kirosavaus6167]

+

[@deniskovtun53]

senks