{"id":28963,"date":"2022-03-23T02:50:56","date_gmt":"2022-03-23T02:50:56","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=28963"},"modified":"2022-12-23T06:20:25","modified_gmt":"2022-12-23T06:20:25","slug":"zabbix-troubleshooting-guide","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/zabbix-troubleshooting-guide\/","title":{"rendered":"Zabbix Troubleshooting Guide"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Zabbix Server Troubleshooting Info<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Log Location in Linux &#8211; \/var\/log\/zabbix\/<\/li><li>Zabbix Server Configuration file &#8211; \/etc\/zabbix<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Zabbix Agent Troubleshooting Info<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Log Location in Linux &#8211; \/var\/log\/zabbix\/<\/li><li>Log Location in Windows &#8211; C:\\Program Files\\Zabbix Agent<\/li><li>Zabbix Agent Configuration file &#8211; C:\\Program Files\\Zabbix Agent<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Useful commands for Zabbix Troubleshooting<\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># Check Database details<\/span>\n$ mysql -h localhost -u zabbix -p -P <span class=\"hljs-number\">3306<\/span> -s &lt;&lt;&lt; <span class=\"hljs-string\">'show databases;'<\/span>\n\n<span class=\"hljs-comment\"># Check the Zabbix server Database is populated completly or not<\/span>\n$ zcat \/usr\/share\/doc\/zabbix-server-mysql-*\/create.sql.gz | mysql -uzabbix -pZpcBMdhntW9X7eEw zabbix\n\n<span class=\"hljs-comment\"># If you succeed then continue with table listing: Check Database Tables<\/span>\n$ mysql -h localhost -u zabbix -p -P <span class=\"hljs-number\">3306<\/span> -s &lt;&lt;&lt; <span class=\"hljs-string\">'use zabbix; show tables;'<\/span>\n\n<span class=\"hljs-comment\"># Check passwordless connection to database. <\/span>\n$ mysql -h localhost -u zabbix -p -P <span class=\"hljs-number\">3306<\/span> -s &lt;&lt;&lt; <span class=\"hljs-string\">'show grants;'<\/span>\n\n<span class=\"hljs-comment\"># Please show what zabbix packages you have installed<\/span>\n$ dpkg-query -l | grep zabbix\n\n<span class=\"hljs-comment\"># Check if log file has generated some content and it is clear from any errors or warnings:<\/span>\n$ cat \/<span class=\"hljs-keyword\">var<\/span>\/log\/zabbix_server.log\n$ cat \/<span class=\"hljs-keyword\">var<\/span>\/log\/zabbix\/zabbix_server.log\n\n<span class=\"hljs-comment\"># Start Stop zabbix-server Commands<\/span>\n$ systemctl stop zabbix-server\n$ systemctl start zabbix-server\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Zabbix Firewall Commands<\/h2>\n\n\n\n<p>Zabbix agent listens on port 10050. If you have a UFW firewall or firewalld running, consider opening the port as follows.<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">----------- On UFW Firewall ----------- \r\n$ sudo ufw allow 10050\/tcp\r\n$ sudo ufw reload\r\n\r\n----------- On Firewalld ----------- \r\n$ sudo firewall-cmd --add-port=10050\/tcp --permanent\r\n$ sudo firewall-cmd --reload\r\n<\/code><\/span><\/pre>","protected":false},"excerpt":{"rendered":"<p>Zabbix Server Troubleshooting Info Log Location in Linux &#8211; \/var\/log\/zabbix\/ Zabbix Server Configuration file &#8211; \/etc\/zabbix Zabbix Agent Troubleshooting Info Log Location in Linux &#8211; \/var\/log\/zabbix\/ Log&#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-28963","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/28963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=28963"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/28963\/revisions"}],"predecessor-version":[{"id":28977,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/28963\/revisions\/28977"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=28963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=28963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=28963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}