Hello!
I have a problem which i see in /log/mysql/error.log file.
The file consists error strings.
That is this:
zabbix server service is running
and
mysql service is running
I suggest error relates to zabbix-agent and file
But i don't know what exactly do i have to do to resolve error?
I have a problem which i see in /log/mysql/error.log file.
The file consists error strings.
That is this:
Code:
2019-08-08T08:33:28.357126Z 15338 [Note] Access denied for user 'zabbix'@'localhost' (using password: NO)
and
mysql service is running
Code:
appliance@zabbix:~$ sudo systemctl status zabbix-server.service
● zabbix-server.service - Zabbix Server
Loaded: loaded (/lib/systemd/system/zabbix-server.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2019-08-08 06:25:51 UTC; 2h 35min ago
Process: 901 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 956 (zabbix_server)
CGroup: /system.slice/zabbix-server.service
├─ 956 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
├─1247 /usr/sbin/zabbix_server: configuration syncer [synced configuration in 0.330185 sec, idle 60 sec
├─1248 /usr/sbin/zabbix_server: housekeeper [deleted 99219 hist/trends, 0 items/triggers, 0 events, 0 sessions, 0 alarms, 0 audit items in 4.423681 sec, idle for 1 hour(s)
├─1249 /usr/sbin/zabbix_server: timer #1 [updated 0 hosts, suppressed 0 events in 0.000560 sec, idle 59 sec
├─1250 /usr/sbin/zabbix_server: http poller #1 [got 0 values in 0.000457 sec, idle 5 sec
├─1251 /usr/sbin/zabbix_server: discoverer #1 [processed 0 rules in 0.000397 sec, idle 60 sec
├─1252 /usr/sbin/zabbix_server: history syncer #1 [processed 4 values, 1 triggers in 0.002105 sec, idle 1 sec
├─1253 /usr/sbin/zabbix_server: history syncer #2 [processed 0 values, 0 triggers in 0.000025 sec, idle 1 sec
├─1254 /usr/sbin/zabbix_server: history syncer #3 [processed 0 values, 0 triggers in 0.000016 sec, idle 1 sec
├─1256 /usr/sbin/zabbix_server: history syncer #4 [processed 0 values, 0 triggers in 0.000014 sec, idle 1 sec
├─1258 /usr/sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.001278 sec, idle 3 sec
├─1259 /usr/sbin/zabbix_server: java poller #1 [got 0 values in 0.000008 sec, idle 5 sec
├─1260 /usr/sbin/zabbix_server: java poller #2 [got 0 values in 0.000009 sec, idle 5 sec
├─1261 /usr/sbin/zabbix_server: java poller #3 [got 0 values in 0.000015 sec, idle 5 sec
├─1262 /usr/sbin/zabbix_server: java poller #4 [got 0 values in 0.000038 sec, idle 5 sec
├─1263 /usr/sbin/zabbix_server: java poller #5 [got 0 values in 0.000031 sec, idle 5 sec
├─1265 /usr/sbin/zabbix_server: snmp trapper [processed data in 0.000026 sec, idle 1 sec
├─1266 /usr/sbin/zabbix_server: proxy poller #1 [exchanged data with 0 proxies in 0.000015 sec, idle 5 sec
├─1269 /usr/sbin/zabbix_server: self-monitoring [processed data in 0.000027 sec, idle 1 sec
├─1270 /usr/sbin/zabbix_server: task manager [processed 0 task(s) in 0.000384 sec, idle 5 sec
├─1271 /usr/sbin/zabbix_server: poller #1 [got 0 values in 0.000048 sec, idle 1 sec
├─1272 /usr/sbin/zabbix_server: poller #2 [got 0 values in 0.000032 sec, idle 1 sec
├─1273 /usr/sbin/zabbix_server: poller #3 [got 0 values in 0.000031 sec, idle 1 sec
├─1274 /usr/sbin/zabbix_server: poller #4 [got 3 values in 0.002220 sec, idle 1 sec
├─1275 /usr/sbin/zabbix_server: poller #5 [got 0 values in 0.000027 sec, idle 1 sec
├─1276 /usr/sbin/zabbix_server: unreachable poller #1 [got 0 values in 0.000064 sec, idle 1 sec
├─1277 /usr/sbin/zabbix_server: trapper #1 [processed data in 0.000304 sec, waiting for connection
├─1278 /usr/sbin/zabbix_server: trapper #2 [processed data in 0.000172 sec, waiting for connection
├─1279 /usr/sbin/zabbix_server: trapper #3 [processed data in 0.000906 sec, waiting for connection
├─1280 /usr/sbin/zabbix_server: trapper #4 [processed data in 0.000097 sec, waiting for connection
├─1281 /usr/sbin/zabbix_server: trapper #5 [processed data in 0.000180 sec, waiting for connection
├─1282 /usr/sbin/zabbix_server: icmp pinger #1 [got 0 values in 0.000028 sec, idle 5 sec
├─1283 /usr/sbin/zabbix_server: alert manager #1 [sent 0, failed 0 alerts, idle 5.008606 sec during 5.008656 sec
├─1285 /usr/sbin/zabbix_server: alerter #1 started
├─1286 /usr/sbin/zabbix_server: alerter #2 started
├─1287 /usr/sbin/zabbix_server: alerter #3 started
├─1288 /usr/sbin/zabbix_server: preprocessing manager #1 [queued 0, processed 24 values, idle 5.006705 sec during 5.007271 sec
├─1289 /usr/sbin/zabbix_server: preprocessing worker #1 started
├─1291 /usr/sbin/zabbix_server: preprocessing worker #2 started
└─1292 /usr/sbin/zabbix_server: preprocessing worker #3 started
Aug 08 06:25:51 zabbix systemd[1]: Starting Zabbix Server...
Aug 08 06:25:51 zabbix systemd[1]: zabbix-server.service: Supervising process 956 which is not our child. We'll most likely not notice when it exits.
Aug 08 06:25:51 zabbix systemd[1]: Started Zabbix Server.
appliance@zabbix:~$ sudo systemctl mysql zabbix-server.service
Unknown operation mysql.
appliance@zabbix:~$ sudo systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2019-08-08 06:25:52 UTC; 2h 36min ago
Process: 930 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
Process: 904 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 929 (mysqld)
CGroup: /system.slice/mysql.service
└─929 /usr/sbin/mysqld
Aug 08 06:25:51 zabbix systemd[1]: Starting MySQL Community Server...
Aug 08 06:25:52 zabbix systemd[1]: Started MySQL Community Server.
I suggest error relates to zabbix-agent and file
Code:
/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
Code:
root@zabbix:/etc/zabbix/zabbix_agentd.d# cat userparameter_mysql.conf
# For all the following commands HOME should be set to the directory that has .my.cnf file with password information.
# Flexible parameter to grab global variables. On the frontend side, use keys like mysql.status[Com_insert].
# Key syntax is mysql.status[variable].
UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N | awk '{print $$2}'
# Flexible parameter to determine database or table size. On the frontend side, use keys like mysql.size[zabbix,history,data].
# Key syntax is mysql.size[<database>,<table>,<type>].
# Database may be a database name or "all". Default is "all".
# Table may be a table name or "all". Default is "all".
# Type may be "data", "index", "free" or "both". Both is a sum of data and index. Default is "both".
# Database is mandatory if a table is specified. Type may be specified always.
# Returns value in bytes.
# 'sum' on data_length or index_length alone needed when we are getting this information for whole database instead of a single table
UserParameter=mysql.size[*],bash -c 'echo "select sum($(case "$3" in both|"") echo "data_length+index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from information_schema.tables$([[ "$1" = "all" || ! "$1" ]] || echo " where table_schema=\"$1\"")$([[ "$2" = "all" || ! "$2" ]] || echo "and table_name=\"$2\"");" | HOME=/var/lib/zabbix mysql -N'
Comment