Database ODBC Monitoring with Zabbix

Поділитися
Вставка
  • Опубліковано 18 жов 2024

КОМЕНТАРІ • 61

  • @zabbixtraining
    @zabbixtraining  3 роки тому

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

  • @zabbixtraining
    @zabbixtraining  4 роки тому +1

    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

  • @saintvittsdance
    @saintvittsdance Рік тому

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

  • @andli86
    @andli86 5 років тому +4

    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!

  • @mbulelo-damba
    @mbulelo-damba 5 років тому

    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!

  • @ricardobagnoli9893
    @ricardobagnoli9893 2 роки тому +3

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

  • @reesv01
    @reesv01 5 років тому +1

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

    • @zabbixtraining
      @zabbixtraining  4 роки тому

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

  • @sharpazn
    @sharpazn 8 місяців тому

    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
      @zabbixtraining  8 місяців тому +1

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

    • @sharpazn
      @sharpazn 8 місяців тому

      @@zabbixtraining gonna watch everything lmao but thanks!

    • @zabbixtraining
      @zabbixtraining  7 місяців тому +1

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

  • @lukashruda824
    @lukashruda824 2 місяці тому

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

  • @ranvijaymehta
    @ranvijaymehta 4 роки тому

    Thanks Dmitry for this video

  • @narendranvijayakumar3859
    @narendranvijayakumar3859 4 роки тому

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

  • @8dalight
    @8dalight 5 років тому +2

    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)

  • @NimbusDevOps
    @NimbusDevOps 4 роки тому

    A video on monitoring Sybase would be amazing

  • @ranvijaymehta
    @ranvijaymehta 4 роки тому +1

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

  • @abolfazlkaviany3966
    @abolfazlkaviany3966 8 місяців тому

    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
      @zabbixtraining  8 місяців тому

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

  • @arafatabsi6546
    @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
    @lanceeilers5061 5 років тому

    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 :-)

  • @kvicksa
    @kvicksa 5 років тому

    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
      @zabbixtraining  5 років тому

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

  • @harithm9219
    @harithm9219 3 роки тому

    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

  • @idrissoukassimou3264
    @idrissoukassimou3264 Рік тому

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

  • @luiansan30
    @luiansan30 5 років тому

    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
      @zabbixtraining  5 років тому

      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

  • @varunyadav85
    @varunyadav85 3 роки тому

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

  • @Ravindrakumar-xo1jm
    @Ravindrakumar-xo1jm 3 роки тому +1

    Oracle graph is not showing Why?
    please help

  • @Pbsk85
    @Pbsk85 3 роки тому

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

  • @jatinchugh6752
    @jatinchugh6752 5 років тому

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

  • @vanomel528
    @vanomel528 5 років тому +4

    Maybe something about zabbix API + Python?

    • @kvicksa
      @kvicksa 5 років тому +1

      +1

    • @8dalight
      @8dalight 5 років тому +1

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

    • @zabbixtraining
      @zabbixtraining  5 років тому

      Will publish this week

  • @janisgrotus4386
    @janisgrotus4386 4 роки тому

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

    • @zabbixtraining
      @zabbixtraining  4 роки тому

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

  • @mathwork4747
    @mathwork4747 5 років тому

    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
      @zabbixtraining  5 років тому

      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
      @4351-rv 5 років тому

      @@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.

  • @akhilsai3880
    @akhilsai3880 3 роки тому

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

  • @alkamird
    @alkamird 5 років тому

    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
      @zabbixtraining  4 роки тому

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

  • @RehanShaikh-vz4uj
    @RehanShaikh-vz4uj Рік тому

    How to do SQL jobs monitoring through zabbix

  • @fireflycz1230
    @fireflycz1230 5 років тому

    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
      @fireflycz1230 5 років тому

      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
      @zabbixtraining  5 років тому

      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
      @fireflycz1230 5 років тому

      @@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. :)

  • @8dalight
    @8dalight 5 років тому

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

    • @zabbixtraining
      @zabbixtraining  5 років тому

      What do you mean as treat control?

    • @8dalight
      @8dalight 5 років тому

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

  • @deniskovtun53
    @deniskovtun53 Рік тому

    senks

  • @kirosavaus6167
    @kirosavaus6167 Рік тому

    +