{"id":21607,"date":"2022-03-22T01:10:36","date_gmt":"2022-03-22T01:10:36","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=21607"},"modified":"2022-12-23T06:20:28","modified_gmt":"2022-12-23T06:20:28","slug":"zabbix-errors-and-solution-database","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/zabbix-errors-and-solution-database\/","title":{"rendered":"Zabbix Errors and Solution Database"},"content":{"rendered":"\n

Error 1 – Maria DB issues<\/strong><\/h3>\n\n\n\n

<\/p>\n\n\n

root@ip-172<\/span>-31<\/span>-10<\/span>-159<\/span>:\/usr\/share\/zabbix-proxy-mysql# zcat \/usr\/share\/zabbix-proxy-mysql\/schema.sql.gz | mysql -u zabbix zabbix -p<\/span>\nEnter password:\nERROR 1118<\/span> (42000<\/span>) at line 1278<\/span>: Row size too large (> 8126<\/span>). Changing some columns to TEXT or<\/span> BLOB may help. In current row format, BLOB prefix of 0<\/span> bytes is stored inline.\nroot@ip-172<\/span>-31<\/span>-10<\/span>-159<\/span>:\/usr\/share\/zabbix-proxy-mysql#<\/span>\n<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution – 1<\/h3>\n\n\n
Mysql-server or mysql client was installed and both cannot at the same time. uninstalled mysql and start from<\/span> fresh.\n\n 18<\/span>  dpkg-query -l | grep mysql\n   19<\/span>  mysql\n   20<\/span>  dpkg-query -l | grep mysql-server\n   21<\/span>  dpkg-query -l | grep mysql\n   22<\/span>  apt-get<\/span> remove mysql-client\n   23  dpkg-query -l | grep mysql\n   24  apt-get<\/span> remove mysql-client-8.0\n   25  dpkg-query -l | grep mysql\n   26  apt-get<\/span> remove mysql-common\n   27  dpkg-query -l | grep mysql\n   28  apt-get<\/span> remove mysql-client-core-8.0\n   29  dpkg-query -l | grep\n   30  dpkg-query -l | grep mysql\n   31  apt-get<\/span> remove mysql-common\n   32  dpkg-query -l | grep mysql\n\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Error 2 – mariadb<\/h3>\n\n\n
root@ip-172<\/span>-31<\/span>-25<\/span>-144<\/span>:\/home\/ubuntu# sudo apt -y install mariadb-common mariadb-server mariadb-client<\/span>\nReading package lists... Done\nBuilding dependency tree\nReading state information... Done\nSome packages could not be installed. This may mean that you have\nrequested an impossible situation or<\/span> if<\/span> you are using the unstable\ndistribution that some required packages have not yet been created\nor<\/span> been moved out of Incoming.\nThe following information may help to resolve the situation:\n\nThe following packages have unmet dependencies:\n mariadb-client : Depends: mariadb-client-10.3<\/span> (>= 1<\/span>:10.3<\/span>.29<\/span>-0<\/span>ubuntu0.20<\/span>.04<\/span>.1<\/span>) but it is not going to be installed\n mariadb-server : Depends: mariadb-server-10.3<\/span> (>= 1<\/span>:10.3<\/span>.29<\/span>-0<\/span>ubuntu0.20<\/span>.04<\/span>.1<\/span>) but it is not going to be installed\nE: Unable to correct problems, you have held broken packages.\nroot@ip-172<\/span>-31<\/span>-25<\/span>-144<\/span>:\/home\/ubuntu#<\/span>\n<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution 2 <\/h3>\n\n\n
Mysql-server was installed and both cannot at the same time. uninstalled mysql and mariadb could then be.\n\n 18<\/span>  dpkg-query -l | grep mysql\n   19<\/span>  mysql\n   20<\/span>  dpkg-query -l | grep mysql-server\n   21<\/span>  dpkg-query -l | grep mysql\n   22<\/span>  apt-get<\/span> remove mysql-client\n   23  dpkg-query -l | grep mysql\n   24  apt-get<\/span> remove mysql-client-8.0\n   25  dpkg-query -l | grep mysql\n   26  apt-get<\/span> remove mysql-common\n   27  dpkg-query -l | grep mysql\n   28  apt-get<\/span> remove mysql-client-core-8.0\n   29  dpkg-query -l | grep\n   30  dpkg-query -l | grep mysql\n   31  apt-get<\/span> remove mysql-common\n   32  dpkg-query -l | grep mysql\n\n\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Error – 3 –  libpcre2-8.so.0()(64bit) is needed<\/h3>\n\n\n
[root@ip-172<\/span>-31<\/span>-23<\/span>-45<\/span> centos]# rpm -ivh zabbix-agent-6.0.0-1.el7.x86_64.rpm<\/span>\nwarning: zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64.rpm: Header V4 RSA\/SHA512 Signature, key ID a14fe591: NOKEY\nerror: Failed dependencies:\n        libpcre2-8.<\/span>so.0<\/span>()(64<\/span>bit) is needed by zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64\n\n<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution 3 <\/h3>\n\n\n
$ yum install pcre2-devel.x86_64\n$ yum install pcre.x86_64\n<\/code><\/span><\/pre>\n\n\n
Error – 4 – Zabbix Host Not available<\/h3>\n\n\n
Received empty response from<\/span> Zabbix Agent at [13.233<\/span>.206<\/span>.103<\/span>]. Assuming that agent dropped connection because of<\/span> access permissions.\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution – 4 <\/h3>\n\n\n
This issues i faced in AWS server due to confusion of Public<\/span> IP address and<\/span> pvt IP add address. I noticed that Zabbix server request the agent using PUBLIC<\/span> ip address thus in zabbix_agentd.conf\n\nServer=3.110<\/span>.176<\/span>.72<\/span> [ RIGHT with Public<\/span> IP address ]\nServer=172.31<\/span>.10<\/span>.229<\/span> [ WRONG with PVT IP address ]<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Error 5 – Unable to connect to [127.0.0.1]:10051<\/h3>\n\n\n
$ more \/var<\/span>\/log\/zabbix\/zabbix_agentd.log\n  6072<\/span>:20220322<\/span>:013622.093<\/span> Got signal [signal:15<\/span>(SIGTERM),sender_pid:6323<\/span>,sender_uid:997<\/span>,reason:0<\/span>]. Exiting ...\n  6072<\/span>:20220322<\/span>:013622.097<\/span> Zabbix Agent stopped. Zabbix 6.0<\/span>.0<\/span> (revision 5203<\/span>d2ea7d).\n  6327<\/span>:20220322<\/span>:013622.112<\/span> Starting Zabbix Agent [Zabbix server]. Zabbix 6.0<\/span>.0<\/span> (revision 5203<\/span>d2ea7d).\n  6327<\/span>:20220322<\/span>:013622.112<\/span> **** Enabled features ****\n  6327<\/span>:20220322<\/span>:013622.113<\/span> IPv6 support:          YES\n  6327<\/span>:20220322<\/span>:013622.113<\/span> TLS support:           YES\n  6327<\/span>:20220322<\/span>:013622.113<\/span> **************************\n  6327<\/span>:20220322<\/span>:013622.113<\/span> using configuration file: \/etc\/zabbix\/zabbix_agentd.conf\n  6327<\/span>:20220322<\/span>:013622.113<\/span> agent #0 started [main process]<\/span>\n  6331<\/span>:20220322<\/span>:013622.118<\/span> agent #4 started [listener #3]<\/span>\n  6332<\/span>:20220322<\/span>:013622.120<\/span> agent #5 started [active checks #1]<\/span>\n  6328<\/span>:20220322<\/span>:013622.122<\/span> agent #1 started [collector]<\/span>\n  6329<\/span>:20220322<\/span>:013622.123<\/span> agent #2 started [listener #1]<\/span>\n  6330<\/span>:20220322<\/span>:013622.124<\/span> agent #3 started [listener #2]<\/span>\n  6332<\/span>:20220322<\/span>:013622.126<\/span> Unable to connect to [127.0<\/span>.0<\/span>.1<\/span>]:10051<\/span> [cannot connect to [[127.0<\/span>.0<\/span>.1<\/span>]:10051<\/span>]: [111<\/span>] Connection ref\nused]\n  6332<\/span>:20220322<\/span>:013622.126<\/span> Active check configuration update started to fail\n  6330<\/span>:20220322<\/span>:013631.949<\/span> failed to accept an incoming connection: connection from \"3.110.176.72\"<\/span> rejected, allowed hosts: \"1<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution – 5<\/h3>\n\n\n
\n### Option: ServerActive<\/span>\n#       List of comma delimited IP addresses or DNS names (address:port) pairs or clusters (address:port;address2:port) of Zabbix servers and Zabbix proxies for active checks.<\/span>\n#       If port is not specified, default port is used.<\/span>\n#       Cluster nodes need be separated by semicolon.<\/span>\n#       IPv6 addresses must be enclosed in square brackets if port for that host is specified.<\/span>\n#       If port is not specified, square brackets for IPv6 addresses are optional.<\/span>\n#       If this parameter is not specified, active checks are disabled.<\/span>\n#       Example for multiple servers:<\/span>\n#               ServerActive=127.0.0.1:20051,zabbix.domain,[::1]:30051,::1,[12fc::1]<\/span>\n#       Example for HA:<\/span>\n#               ServerActive=zabbix.cluster.node1;zabbix.cluster.node2:20051;zabbix.cluster.node3<\/span>\n#       Example for HA with two clusters and one server:<\/span>\n#               ServerActive=zabbix.cluster.node1;zabbix.cluster.node2:20051,zabbix.cluster2.node1;zabbix.cluster2.node2,zabbix.domain<\/span>\n#<\/span>\n# Mandatory: no<\/span>\n# Default:<\/span>\n# ServerActive=<\/span>\n\nServerActive=172.31<\/span>.10<\/span>.229<\/span>\n<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
libpcre2-8.so.0()(64bit) is needed by zabbix-agent2-6.0.2-1.el7.x86_64<\/h3>\n\n\n
[root@ip-172<\/span>-31<\/span>-31<\/span>-191<\/span> centos]# rpm -Uvh https:\/\/repo.zabbix.com\/zabbix\/6.0\/rhel\/7\/x86_64\/zabbix-agent2-6.0.2-1.el7.x86_64.rpm<\/span>\nRetrieving https:\/\/repo.zabbix.com\/zabbix\/6.0\/rhel\/7\/x86_64\/zabbix-agent2-6.0.2-1.el7.x86_64.rpm<\/span>\nwarning: \/var<\/span>\/tmp\/rpm-tmp.n6142w: Header V4 RSA\/SHA512 Signature, key ID a14fe591: NOKEY\nerror: Failed dependencies:\n        libpcre2-8.<\/span>so.0<\/span>()(64<\/span>bit) is needed by zabbix-agent2-6.0<\/span>.2<\/span>-1.<\/span>el7.x86_64\n\n<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution<\/h3>\n\n\n\n
$ yum update
$ yum install pcre2-devel.x86_64
$ yum install pcre.x86_64<\/p>\n\n\n\n
zabbix50-agent-5.0.21-1.el7.x86_64 conflicts with file from package zabbix-agent-6<\/h3>\n\n\n
Transaction check error:\r\n  file \/etc\/logrotate.d\/zabbix-agent from<\/span> install of<\/span> zabbix50-agent-5.0<\/span>.21<\/span>-1.<\/span>el7.x86_64 conflicts with<\/span> file from<\/span> package zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64\r\n  file \/var<\/span>\/log\/zabbix from<\/span> install of<\/span> zabbix50-agent-5.0<\/span>.21<\/span>-1.<\/span>el7.x86_64 conflicts with<\/span> file from<\/span> package zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64\r\n  file \/usr\/lib\/systemd\/system\/zabbix-agent.service from<\/span> install of<\/span> zabbix50-agent-5.0<\/span>.21<\/span>-1.<\/span>el7.x86_64 conflicts with<\/span> file from<\/span> package zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64\r\n  file \/usr\/sbin\/zabbix_agentd from<\/span> install of<\/span> zabbix50-agent-5.0<\/span>.21<\/span>-1.<\/span>el7.x86_64 conflicts with<\/span> file from<\/span> package zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64\r\n  file \/usr\/share\/man\/man8\/zabbix_agentd.8<\/span>.gz from<\/span> install of<\/span> zabbix50-agent-5.0<\/span>.21<\/span>-1.<\/span>el7.x86_64 conflicts with<\/span> file from<\/span> package zabbix-agent-6.0<\/span>.0<\/span>-1.<\/span>el7.x86_64\r\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Solution<\/h3>\n\n\n
$ yum remove zabbix_agent\r\n$ rpm -qa\r\n$ rpm -qa | grep zabbix\r\n$ rpm -e zabbix50-5.0.21-1.el7.x86_64\r\n$ rpm -e zabbix-agent-6.0.0-1.el7.x86_64\r\n\r\n<\/code><\/span><\/pre>\n\n