Ad Widget

Collapse

Zabbix 6.0 LTS - MySQL by Zabbix agent 2 from a host using Agent (active)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • akymakr
    Junior Member
    • Jan 2024
    • 1

    #1

    Zabbix 6.0 LTS - MySQL by Zabbix agent 2 from a host using Agent (active)

    Hello,

    A newbie of Zabbix here. Have been hungering to try monitoring servers and keep services running, getting alert when a service is down. We do have consents from our customers where the server stats can be sent to our Zabbix Server / Proxy.
    For now, we have set up the connections between Zabbix Server and Zabbix Proxies where they are on the same network. Only Zabbix Proxies will receive data from the agents and only proxies have port forwarding opened as they are behind NAT.

    Now I have an agent set up on a Linux server with Apache and MySQL installed. Since we didn't require our customer to setup any port forwarding since we don't want the port to be exposed, everything has to be done in active mode, which means the data is actively transferred from the agent to the proxy. Then the proxy will forward the data to the server. Our maintenance team monitors the server and wee what's going on. Perfect for now since you have a lot of active agents in the template for both Windows and Linux.





    However, I do not find any active agents for services under the Linux / Windows such as Apache and MySQL.

    So what did I try is to follow the Agent 2 setup steps for the Linux server for MySQL monitoring here: https://git.zabbix.com/projects/ZBX/...Frelease%2F6.0.

    Which means I logged into the MySQL using root, creating an account for zbx_monitor. And tested the login locally using mysql -uzbx_monitor -p and it was a success. Now I moved on to step 2 and step 3 and set up the rest including MYSQL_DSN, USERNAME, PASSWORD on the GUI of the server, of course MySQL by Zabbix Agent 2 is added to the templates list.

    Now when I click "Update", an error pops up:
    • Cannot find host interface on "<hidden>" for item key "mysql.get_status_variables["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWO RD}"]".
    Have I done anything wrong?

    I have tried and search for other topics including this forum and stackoverflow. Both the author believed that using Active Agent is impossible while both answered to change someone from passive to active. I am stuck and I don't know what that is and how to change it, and where to change it. Or they actually didn't know the situation and using Active Agent was indeed impossible?

    Threads/posts for reference:I don't want to lose hopes since both answered basically the same thing. I just need some help from you guys, thanks in advanced!
  • badimon
    Junior Member
    • Jan 2025
    • 1

    #2
    As I understand it, mysql monitoring not support "active" mode

    Comment

    • cyber
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Dec 2006
      • 4808

      #3
      Active vs passive mode is just "who is asking" ... in passive mode, proxy/server will ask agent for data (but agent has to know how to obtain data, ie all plugins have to be in place etc). In active mode agent schedules and executes those queries locally. THere is no difference in that query itself... Just who initiates it...
      That template by default uses passive items. Thats why it complains also for not finding agent interface to do the query... Your agent being in active mode does not change item setup...

      Comment

      Working...