hi! new in zabbix and had been learning a lot in the last days.
I am able to get data from remote hosts correctly by Zabbix Agent Active.
I started to work with getting data from mysql but im failing in doing so.
anyone have a clue where im doing wrong? herelast info when i print: zabbix_agentd --print but all mysql data is not arriving, everything else is ok.
<row>
<field name="Variable_name">Threads_running</field>
<field name="Value">2</field>
</row>
<row>
<field name="Variable_name">Uptime</field>
<field name="Value">466</field>
</row>
<row>
<field name="Variable_name">Uptime_since_flush_status</field>
<field name="Value">466</field>
</row>
</resultset>]
mysql.version [t|mysqladmin Ver 8.0.28-0ubuntu0.21.10.3 for Linux on x86_64 ((Ubuntu))
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 8.0.28-0ubuntu0.21.10.3
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 7 min 46 sec
Threads: 2 Questions: 45 Slow queries: 0 Opens: 185 Flush tables: 3 Open tables: 104 Queries per second avg: 0.096]
mysql.db.discovery [t|information_schema
mysql
performance_schema
sys]
mysql.dbsize [t|0]
mysql.replication.discovery [t|<?xml version="1.0"?>
<resultset statement="show slave status
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset>]
mysql.slave_status [t|<?xml version="1.0"?>
<resultset statement="show slave status
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset>]
test.ping [t|5]
I am able to get data from remote hosts correctly by Zabbix Agent Active.
I started to work with getting data from mysql but im failing in doing so.
anyone have a clue where im doing wrong? herelast info when i print: zabbix_agentd --print but all mysql data is not arriving, everything else is ok.
<row>
<field name="Variable_name">Threads_running</field>
<field name="Value">2</field>
</row>
<row>
<field name="Variable_name">Uptime</field>
<field name="Value">466</field>
</row>
<row>
<field name="Variable_name">Uptime_since_flush_status</field>
<field name="Value">466</field>
</row>
</resultset>]
mysql.version [t|mysqladmin Ver 8.0.28-0ubuntu0.21.10.3 for Linux on x86_64 ((Ubuntu))
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 8.0.28-0ubuntu0.21.10.3
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 7 min 46 sec
Threads: 2 Questions: 45 Slow queries: 0 Opens: 185 Flush tables: 3 Open tables: 104 Queries per second avg: 0.096]
mysql.db.discovery [t|information_schema
mysql
performance_schema
sys]
mysql.dbsize [t|0]
mysql.replication.discovery [t|<?xml version="1.0"?>
<resultset statement="show slave status
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset>]
mysql.slave_status [t|<?xml version="1.0"?>
<resultset statement="show slave status
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset>]
test.ping [t|5]