{"id":1124,"date":"2017-10-15T06:43:03","date_gmt":"2017-10-15T03:43:03","guid":{"rendered":"https:\/\/community.virtono.com\/?p=1124"},"modified":"2020-06-10T16:52:54","modified_gmt":"2020-06-10T13:52:54","slug":"installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql","status":"publish","type":"post","link":"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql\/","title":{"rendered":"Installing zabbix 3.0 on Ubuntu 16.04 with PostgreSQL"},"content":{"rendered":"<header class=\"entry-header\">A few days ago I installed Zabbix 3.0 under Ubuntu 16.04.\u00a0Since I would like to deal with PostgreSQL, I decided to use it as a database.<\/header>\n<div class=\"entry-content\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_73 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql\/#installation\" title=\"installation\">installation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql\/#Create_database\" title=\"Create database\">Create database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql\/#Change_PostgreSQL_configurations\" title=\"Change PostgreSQL configurations\">Change PostgreSQL configurations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql\/#Zabbix_server_in_operation\" title=\"Zabbix server in operation\">Zabbix server in operation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-zabbix-3-0-on-ubuntu-16-04-with-postgresql\/#Frontend_configuration\" title=\"Frontend configuration\">Frontend configuration<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"installation\"><\/span>installation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The first release of Zabbix&#8217;s release package is the following:<\/p>\n<div id=\"crayon-59e2d84e5c013330670870\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c013330670870-1\" class=\"crayon-line\"><span class=\"crayon-e\">wget <\/span><span class=\"crayon-v\">http<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-c\">\/\/repo.zabbix.com\/zabbix\/3.0\/ubuntu\/pool\/main\/z\/zabbix-release\/zabbix-release_3.0-1+xenial_all.deb<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>which is then installed<\/p>\n<div id=\"crayon-59e2d84e5c025323073295\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c025323073295-1\" class=\"crayon-line\"><span class=\"crayon-v\">dpkg<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">i<\/span> <span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">release_3<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-o\">+<\/span><span class=\"crayon-v\">xenial_all<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">deb<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>So now the appropriate Repo has been added and you can install zabbix<\/p>\n<div id=\"crayon-59e2d84e5c02b558881806\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<div class=\"crayon-num\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c02b558881806-1\" class=\"crayon-line\"><span class=\"crayon-e\">apt <\/span><span class=\"crayon-e\">update<\/span><\/div>\n<div id=\"crayon-59e2d84e5c02b558881806-2\" class=\"crayon-line\"><span class=\"crayon-e\">apt <\/span><span class=\"crayon-e\">install <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">server<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">pgsql <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">frontend<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">php <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">agent <\/span><span class=\"crayon-v\">libapache2<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">mod<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">php7<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-cn\">0<\/span> <span class=\"crayon-v\">php<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">bcmath <\/span><span class=\"crayon-v\">php<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">mbstring <\/span><span class=\"crayon-v\">php7<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">xml <\/span><span class=\"crayon-v\">snmp<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">mibs<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">downloader<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Create_database\"><\/span>Create database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>First, change the admin password.\u00a0To do this, you first connect to the database:<\/p>\n<div id=\"crayon-59e2d84e5c031827736631\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c031827736631-1\" class=\"crayon-line\"><span class=\"crayon-v\">sudo<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">u<\/span> <span class=\"crayon-e\">postgres <\/span><span class=\"crayon-v\">psql<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Change the password as follows<\/p>\n<div id=\"crayon-59e2d84e5c037440053754\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c037440053754-1\" class=\"crayon-line\"><span class=\"crayon-sy\">\\<\/span><span class=\"crayon-v\">password<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Enter a new password twice and you are done.\u00a0Now you create a new database and a new user and give it all rights on this:<\/p>\n<div id=\"crayon-59e2d84e5c03c077846752\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<div class=\"crayon-num\">2<\/div>\n<div class=\"crayon-num\">3<\/div>\n<div class=\"crayon-num\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c03c077846752-1\" class=\"crayon-line\"><span class=\"crayon-v\">sudo<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">u<\/span> <span class=\"crayon-e\">postgres <\/span><span class=\"crayon-e\">psql<\/span><\/div>\n<div id=\"crayon-59e2d84e5c03c077846752-2\" class=\"crayon-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-e\">DATABASE <\/span><span class=\"crayon-e\">zabbix <\/span><span class=\"crayon-e\">WITH <\/span><span class=\"crayon-v\">ENCODING<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8216;UTF-8&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-59e2d84e5c03c077846752-3\" class=\"crayon-line\"><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-e\">USER <\/span><span class=\"crayon-e\">zabbix <\/span><span class=\"crayon-e\">WITH <\/span><span class=\"crayon-i\">PASSWORD<\/span> <span class=\"crayon-s\">&#8216;$password&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div id=\"crayon-59e2d84e5c03c077846752-4\" class=\"crayon-line\"><span class=\"crayon-e\">GRANT <\/span><span class=\"crayon-e\">ALL <\/span><span class=\"crayon-e\">ON <\/span><span class=\"crayon-e\">DATABASE <\/span><span class=\"crayon-e\">zabbix <\/span><span class=\"crayon-st\">TO<\/span> <span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Now we fill the database with content.\u00a0For this, there is the file\u00a0<em>create.sql.gz<\/em>\u00a0, under\u00a0<em>\/ usr \/ share \/ doc \/ zabbix-server-pgsql \/<\/em>\u00a0.<\/p>\n<div id=\"crayon-59e2d84e5c042604925746\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c042604925746-1\" class=\"crayon-line\"><span class=\"crayon-v\">zcat<\/span> <span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">usr<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">share<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">doc<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">server<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">pgsql<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">create<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">sql<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">gz<\/span> <span class=\"crayon-o\">|<\/span> <span class=\"crayon-v\">sudo<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">u<\/span> <span class=\"crayon-e\">postgres <\/span><span class=\"crayon-e\">psql <\/span><span class=\"crayon-v\">zabbix<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">h<\/span> <span class=\"crayon-cn\">127.0.0.1<\/span> <span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-i\">d<\/span> <span class=\"crayon-v\">zabbix<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Change_PostgreSQL_configurations\"><\/span>Change PostgreSQL configurations<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>If you only access the database locally, you can skip this here.\u00a0But I wanted to access via pgadmin3.\u00a0<\/em><br \/>\nBy default the database only listens to localhost, ie 127.0.0.1.\u00a0To change this, change the following in the\u00a0<em>\/etc\/postgresql\/9.5\/main\/postgresql.conf<\/em>\u00a0file<\/p>\n<div id=\"crayon-59e2d84e5c049515276271\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c049515276271-1\" class=\"crayon-line\"><span class=\"crayon-p\"># listen_addresses = &#8216;127.0.0.1&#8217;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>after<\/p>\n<div id=\"crayon-59e2d84e5c051528146829\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c051528146829-1\" class=\"crayon-line\"><span class=\"crayon-v\">listen_addresses<\/span> <span class=\"crayon-o\">=<\/span> <span class=\"crayon-s\">&#8216;*&#8217;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Now the configuration has to be edited, which regulates the authentication\u00a0<em>\/etc\/postgresql\/9.5\/main\/pghba.conf<\/em>\u00a0.\u00a0The following line was added:<\/p>\n<div id=\"crayon-59e2d84e5c056022072256\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<div class=\"crayon-num\">2<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c056022072256-1\" class=\"crayon-line\"><span class=\"crayon-p\"># TYPE\u00a0\u00a0DATABASE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0USER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ADDRESS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 METHOD<\/span><\/div>\n<div id=\"crayon-59e2d84e5c056022072256-2\" class=\"crayon-line\"><span class=\"crayon-e\">host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-e\">all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-e\">all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span class=\"crayon-e\">all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><span class=\"crayon-v\">md5<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>This is of course still more beautiful and more restrictive, which was not necessary for my test installation now.<br \/>\nThen restart the service and afterwards you should access the database with pgadmin3<\/p>\n<div id=\"crayon-59e2d84e5c05a925378630\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c05a925378630-1\" class=\"crayon-line\"><span class=\"crayon-e\">systemctl <\/span><span class=\"crayon-e\">restart <\/span><span class=\"crayon-v\">postgresql<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Zabbix_server_in_operation\"><\/span>Zabbix server in operation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For the service to run still the access data to the database had to be entered into the \/etc\/zabbix\/zabbix_server.conf:<\/p>\n<div id=\"crayon-59e2d84e5c05d739550261\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<div class=\"crayon-num\">2<\/div>\n<div class=\"crayon-num\">3<\/div>\n<div class=\"crayon-num\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c05d739550261-1\" class=\"crayon-line\"><span class=\"crayon-v\">DBHost<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">127.0.0.1<\/span><\/div>\n<div id=\"crayon-59e2d84e5c05d739550261-2\" class=\"crayon-line\"><span class=\"crayon-v\">DBName<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-e\">zabbix<\/span><\/div>\n<div id=\"crayon-59e2d84e5c05d739550261-3\" class=\"crayon-line\"><span class=\"crayon-v\">DBUser<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-e\">zabbix<\/span><\/div>\n<div id=\"crayon-59e2d84e5c05d739550261-4\" class=\"crayon-line\"><span class=\"crayon-v\">DBPassword<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-sy\">$<\/span><span class=\"crayon-v\">password<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Then you can activate and start the service:<\/p>\n<div id=\"crayon-59e2d84e5c060026826423\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<div class=\"crayon-num\">2<\/div>\n<div class=\"crayon-num\">3<\/div>\n<div class=\"crayon-num\">4<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c060026826423-1\" class=\"crayon-line\"><span class=\"crayon-e\">systemctl <\/span><span class=\"crayon-e\">enable <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">server<\/span><\/div>\n<div id=\"crayon-59e2d84e5c060026826423-2\" class=\"crayon-line\"><span class=\"crayon-e\">systemctl <\/span><span class=\"crayon-e\">enable <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">agent<\/span><\/div>\n<div id=\"crayon-59e2d84e5c060026826423-3\" class=\"crayon-line\"><span class=\"crayon-e\">systemctl <\/span><span class=\"crayon-e\">start <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-e\">server<\/span><\/div>\n<div id=\"crayon-59e2d84e5c060026826423-4\" class=\"crayon-line\"><span class=\"crayon-e\">systemctl <\/span><span class=\"crayon-e\">start <\/span><span class=\"crayon-v\">zabbix<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">agent<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Frontend_configuration\"><\/span>Frontend configuration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>The<\/em>\u00a0following line\u00a0must be\u00a0adapted\u00a0in the\u00a0<em>\/etc\/apache2\/conf-enabled\/zabbix.conf<\/em>\u00a0file<\/p>\n<div id=\"crayon-59e2d84e5c063144184610\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c063144184610-1\" class=\"crayon-line\"><span class=\"crayon-o\">&lt;<\/span><span class=\"crayon-e\">IfModule <\/span><span class=\"crayon-v\">mod_php5<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">c<\/span><span class=\"crayon-o\">&gt;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>after<\/p>\n<div id=\"crayon-59e2d84e5c066073737624\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c066073737624-1\" class=\"crayon-line\"><span class=\"crayon-o\">&lt;<\/span><span class=\"crayon-e\">IfModule <\/span><span class=\"crayon-v\">mod_php7<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">c<\/span><span class=\"crayon-o\">&gt;<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>The apache2 must then be restarted once<\/p>\n<div id=\"crayon-59e2d84e5c069952047826\" class=\"crayon-syntax crayon-theme-sublime-text crayon-font-monospace crayon-os-pc print-yes notranslate\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-59e2d84e5c069952047826-1\" class=\"crayon-line\"><span class=\"crayon-e\">systemctl <\/span><span class=\"crayon-e\">restart <\/span><span class=\"crayon-v\">apache2<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>That was it.\u00a0Now the frontend can be accessed via the browser http: \/\/ $ ip \/ zabbix and the installation completed.<br \/>\nWhat surprised me with this installation was, that I do not remember in older Zabbix installations such a &#8220;configuration expenditure&#8221; had.\u00a0On the one hand the packages, which one still have to install manually, which, I think, were previously contained in the Dependencies and on the other hand the\u00a0<em>IfModule<\/em>\u00a0line in the apache2 configuration, which still contains php5.\u00a0I mean it is now known that the php7 in Xenial has kept moving.\u00a0But all in all, it can be done.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A few days ago I installed Zabbix 3.0 under Ubuntu 16.04.\u00a0Since I would like to deal with PostgreSQL, I decided to use it as a database. installation The first release of Zabbix&#8217;s release package is the following: 1 wget http:\/\/repo.zabbix.com\/zabbix\/3.0\/ubuntu\/pool\/main\/z\/zabbix-release\/zabbix-release_3.0-1+xenial_all.deb which is then installed 1 dpkg &#8211;i zabbix&#8211;release_3.0&#8211;1+xenial_all.deb So now<\/p>\n","protected":false},"author":4,"featured_media":1125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-1124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial-how-to"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2017\/10\/zabbix_logo_500x131.png?fit=500%2C131&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7ISfL-i8","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":3752,"url":"https:\/\/www.virtono.com\/community\/tutorial-how-to\/how-to-install-postgresql-on-ubuntu-22-04\/","url_meta":{"origin":1124,"position":0},"title":"How to install PostgreSQL on Ubuntu 22.04","author":"George B.","date":"August 21, 2023","format":false,"excerpt":"This tutorial will take you step-by-step through the installation of PostgreSQL on Ubuntu 22.04, explaining all necessary setup steps along the way. It will also show you how to create and manage your first PostgreSQL database. PostgreSQL, also known as Postgres, is an open-source relational database management system (RDBMS) that\u2026","rel":"","context":"In &quot;Tutorials&quot;","block_context":{"text":"Tutorials","link":"https:\/\/www.virtono.com\/community\/category\/tutorial-how-to\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2023\/08\/How-to-install-PostgreSQL-on-Ubuntu-22.04.png?fit=360%2C240&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1259,"url":"https:\/\/www.virtono.com\/community\/tutorial-how-to\/installing-synology-assistant-on-ubuntu\/","url_meta":{"origin":1124,"position":1},"title":"Installing Synology Assistant on Ubuntu","author":"Daniel Draga","date":"November 10, 2017","format":false,"excerpt":"This article shows\u00a0how to\u00a0install\u00a0Synology Assistant\u00a0on\u00a0Ubuntu\u00a0.\u00a0The\u00a0Synology\u00a0Assistant is a small tool to disk or RackStations to locate the local network.\u00a0It facilitates the commissioning of a new NAS and connects after entering the user information to the web interface of the device.\u00a0In addition, any number of Synology devices can be monitored.\u00a0The use of\u2026","rel":"","context":"In &quot;Tutorials&quot;","block_context":{"text":"Tutorials","link":"https:\/\/www.virtono.com\/community\/category\/tutorial-how-to\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2017\/11\/synology_logo.jpg?fit=815%2C230&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2017\/11\/synology_logo.jpg?fit=815%2C230&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2017\/11\/synology_logo.jpg?fit=815%2C230&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2017\/11\/synology_logo.jpg?fit=815%2C230&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3655,"url":"https:\/\/www.virtono.com\/community\/tutorial-how-to\/how-to-deploy-postgresql-on-k3s\/","url_meta":{"origin":1124,"position":2},"title":"How to Deploy PostgreSQL on K3s","author":"George B.","date":"July 26, 2023","format":false,"excerpt":"This guide will provide a detailed walkthrough on how to deploy PostgreSQL on K3s cluster. Everything will be covered, from the necessary steps to the deployment procedure, testing, and connection to the PostgreSQL database. K3s is a certified, lightweight Kubernetes distribution designed for the Internet of Things and edge computing.\u2026","rel":"","context":"In &quot;Tutorials&quot;","block_context":{"text":"Tutorials","link":"https:\/\/www.virtono.com\/community\/category\/tutorial-how-to\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2023\/07\/How-to-Deploy-PostgreSQL-on-K3s.png?fit=360%2C240&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1353,"url":"https:\/\/www.virtono.com\/community\/tutorial-how-to\/fio\/","url_meta":{"origin":1124,"position":3},"title":"Fio","author":"Shreyash Sharma","date":"February 23, 2018","format":false,"excerpt":"Learn about Fio: Fio Fio Basics Compile Fio Visualize Fio Logs with fio2gnuplot What is Fio? Fio\u00a0(Flexible I \/ O Tester) is an I \/ O performance benchmarking tool for Linux, other Unix systems as well as Windows.\u00a0Fio's author is\u00a0Jens Axboe\u00a0, maintainer of the block layer of the Linux kernel.In\u2026","rel":"","context":"In &quot;Tutorials&quot;","block_context":{"text":"Tutorials","link":"https:\/\/www.virtono.com\/community\/category\/tutorial-how-to\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2018\/02\/dotlayer.com-how-to-use-fio-to-measure-disk-performance-in-linux.jpeg?fit=1200%2C672&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2018\/02\/dotlayer.com-how-to-use-fio-to-measure-disk-performance-in-linux.jpeg?fit=1200%2C672&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2018\/02\/dotlayer.com-how-to-use-fio-to-measure-disk-performance-in-linux.jpeg?fit=1200%2C672&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2018\/02\/dotlayer.com-how-to-use-fio-to-measure-disk-performance-in-linux.jpeg?fit=1200%2C672&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2018\/02\/dotlayer.com-how-to-use-fio-to-measure-disk-performance-in-linux.jpeg?fit=1200%2C672&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2296,"url":"https:\/\/www.virtono.com\/community\/knowledgebase\/docker-installation\/","url_meta":{"origin":1124,"position":4},"title":"Docker Installation","author":"Shreyash Sharma","date":"March 8, 2021","format":false,"excerpt":"I suggest you get machine to follow along this part. So here's a little plug of our own: Cloud VPS, for as little as \u20ac2.95 a month. This article is a part of our complete series of articles on Docker. Click here to access the Free Series. While Docker was\u2026","rel":"","context":"In &quot;Knowledgebase&quot;","block_context":{"text":"Knowledgebase","link":"https:\/\/www.virtono.com\/community\/category\/knowledgebase\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2021\/03\/12122013Docker_twitter.png?fit=750%2C375&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2021\/03\/12122013Docker_twitter.png?fit=750%2C375&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2021\/03\/12122013Docker_twitter.png?fit=750%2C375&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2021\/03\/12122013Docker_twitter.png?fit=750%2C375&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1345,"url":"https:\/\/www.virtono.com\/community\/tutorial-how-to\/samba-sharing-with-authentication\/","url_meta":{"origin":1124,"position":5},"title":"Samba sharing with authentication","author":"Shreyash Sharma","date":"February 22, 2018","format":false,"excerpt":"Complementing a simple Samba release, this article shows how to\u00a0create a username and password based Samba share\u00a0using a\u00a0Debian\u00a08 based system.\u00a0Ubuntu\u00a016.04 and Windows 10 are used\u00a0as client software for testing the connection\u00a0. \u00a0 Installation and configuration on the Debian server These following sections show the necessary configuration steps on the Debian\u2026","rel":"","context":"In &quot;Tutorials&quot;","block_context":{"text":"Tutorials","link":"https:\/\/www.virtono.com\/community\/category\/tutorial-how-to\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.virtono.com\/community\/wp-content\/uploads\/2018\/02\/Samba-Schema.gif?fit=450%2C300&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/posts\/1124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/comments?post=1124"}],"version-history":[{"count":1,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/posts\/1124\/revisions"}],"predecessor-version":[{"id":1126,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/posts\/1124\/revisions\/1126"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/media\/1125"}],"wp:attachment":[{"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/media?parent=1124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/categories?post=1124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtono.com\/community\/wp-json\/wp\/v2\/tags?post=1124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}