Problem installing zabbix/postgress - 'The frontend does not match Zabbix database.'

[funkytwig]

Hi. I have a default postgress/zabbix/nginx install on Ubuntu 16.04. I am following the instructions at https://www.zabbix.com/documentation...ll/db_scripts:

run folowing to create database

$ sudo -u postgres createuser --pwprompt zabbix
$ sudo -u postgres createdb -O zabbix zabbix
$ sudo -i
$ cd /usr/share/zabbix-server-pgsql
$ gzip -d *.sql.gz
$ cat schema.sql | sudo -u zabbix psql zabbix
$ cat images.sql | sudo -u zabbix psql zabbix
$ cat data.sql | sudo -u zabbix psql zabbix

Can connect with

$ PGPASSWORD=<pass> psql -d zabbix -U zabbix

Then during install when I try to connect to DB I get 'The frontend does not match Zabbix database.''

[rv_overseer]

You need to search the forum. There was a thread. It's a permission issue on the database tables. The zabbix user must be the owner for all those tables.

[funkytwig]

You need to search the forum. There was a thread. It's a permission issue on the database tables. The zabbix user must be the owner for all those tables.

I did a search on several things, including 'The frontend does not match Zabbix database.'

It was actually when I entered zabbix as the schema when I got the above error. In fact, it seems everything is owned by public, if I miss out the scheme I simply get 'Unable to select configuration.'. A search for this here returns nothing;(.

I then looked in the database for the tabels and think they are all there and are owned by zabbix:

zabbix=# SELECT * FROM pg_catalog.pg_tables where tableowner = 'zabbix';

schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers | rowsecurity
------------+----------------------------+------------+------------+------------+----------+-------------+-------------
public | screen_usrgrp | zabbix | | t | f | t | f
public | screen_user | zabbix | | t | f | t | f
public | groups | zabbix | | t | f | t | f
public | slideshow_user | zabbix | | t | f | t | f
public | screens_items | zabbix | | t | f | t | f
public | slideshow_usrgrp | zabbix | | t | f | t | f
public | screens | zabbix | | t | f | t | f
public | slideshows | zabbix | | t | f | t | f
public | httpstepitem | zabbix | | t | f | t | f
public | httpstep | zabbix | | t | f | t | f
public | interface | zabbix | | t | f | t | f
public | valuemaps | zabbix | | t | f | t | f
public | media_type | zabbix | | t | f | t | f
public | opmessage | zabbix | | t | f | t | f
public | actions | zabbix | | t | f | t | f
public | opmessage_grp | zabbix | | t | f | t | f
public | opmessage_usr | zabbix | | t | f | t | f
public | config | zabbix | | t | f | t | f
public | opconditions | zabbix | | t | f | t | f
public | opcommand_grp | zabbix | | t | f | t | f
public | opgroup | zabbix | | t | f | t | f
public | optemplate | zabbix | | t | f | t | f
public | conditions | zabbix | | t | f | t | f
public | trigger_depends | zabbix | | t | f | t | f
public | functions | zabbix | | t | f | t | f
public | graph_theme | zabbix | | t | f | f | f
public | globalmacro | zabbix | | t | f | f | f
public | mappings | zabbix | | t | f | t | f
public | hosts_groups | zabbix | | t | f | t | f
public | hosts_templates | zabbix | | t | f | t | f
public | items_applications | zabbix | | t | f | t | f
public | services | zabbix | | t | f | t | f
public | media | zabbix | | t | f | t | f
public | rights | zabbix | | t | f | t | f
public | sysmaps_links | zabbix | | t | f | t | f
public | icon_map | zabbix | | t | f | t | f
public | services_times | zabbix | | t | f | t | f
public | sysmaps_link_triggers | zabbix | | t | f | t | f
public | sysmaps_elements | zabbix | | t | f | t | f
public | sysmap_element_url | zabbix | | t | f | t | f
public | ids | zabbix | | t | f | f | f
public | alerts | zabbix | | t | f | t | f
public | regexps | zabbix | | t | f | t | f
public | sysmap_usrgrp | zabbix | | t | f | t | f
public | maintenances_hosts | zabbix | | t | f | t | f
public | maintenances_groups | zabbix | | t | f | t | f
public | timeperiods | zabbix | | t | f | t | f
public | history | zabbix | | t | f | f | f
public | history_uint | zabbix | | t | f | f | f
public | history_str | zabbix | | t | f | f | f
public | history_log | zabbix | | t | f | f | f
public | history_text | zabbix | | t | f | f | f
public | proxy_history | zabbix | | t | f | f | f
public | proxy_dhistory | zabbix | | t | f | f | f
public | trends | zabbix | | t | f | f | f
public | trends_uint | zabbix | | t | f | f | f
public | auditlog | zabbix | | t | f | t | f
public | proxy_autoreg_host | zabbix | | t | f | f | f
public | host_inventory | zabbix | | t | f | t | f
public | escalations | zabbix | | t | f | f | f
public | globalvars | zabbix | | t | f | f | f
public | housekeeper | zabbix | | t | f | f | f
public | service_alarms | zabbix | | t | f | t | f
public | autoreg_host | zabbix | | t | f | t | f
public | graph_discovery | zabbix | | t | f | t | f
public | dhosts | zabbix | | t | f | t | f
public | item_discovery | zabbix | | t | f | t | f
public | dbversion | zabbix | | f | f | f | f
public | slides | zabbix | | t | f | t | f
public | group_prototype | zabbix | | t | f | t | f
public | item_condition | zabbix | | t | f | t | f
public | group_discovery | zabbix | | t | f | t | f
public | maintenances | zabbix | | t | f | t | f
public | usrgrp | zabbix | | t | f | t | f
public | users | zabbix | | t | f | t | f
public | hosts | zabbix | | t | f | t | f
public | interface_discovery | zabbix | | t | f | t | f
public | trigger_discovery | zabbix | | t | f | t | f
public | profiles | zabbix | | t | f | t | f
public | sessions | zabbix | | t | f | t | f
public | application_template | zabbix | | t | f | t | f
public | opinventory | zabbix | | t | f | t | f
public | item_application_prototype | zabbix | | t | f | t | f
public | application_prototype | zabbix | | t | f | t | f
public | application_discovery | zabbix | | t | f | t | f
public | sysmap_url | zabbix | | t | f | t | f
public | scripts | zabbix | | t | f | t | f
public | icon_mapping | zabbix | | t | f | t | f
public | opcommand | zabbix | | t | f | t | f
public | opcommand_hst | zabbix | | t | f | t | f
public | httptest | zabbix | | t | f | t | f
public | dchecks | zabbix | | t | f | t | f
public | httptestitem | zabbix | | t | f | t | f
public | sysmap_user | zabbix | | t | f | t | f
public | host_discovery | zabbix | | t | f | t | f
public | users_groups | zabbix | | t | f | t | f
public | sysmaps | zabbix | | t | f | t | f
public | graphs_items | zabbix | | t | f | t | f
public | hostmacro | zabbix | | t | f | t | f
public | items | zabbix | | t | f | t | f
public | maintenances_windows | zabbix | | t | f | t | f
public | expressions | zabbix | | t | f | t | f
public | dservices | zabbix | | t | f | t | f
public | services_links | zabbix | | t | f | t | f
public | applications | zabbix | | t | f | t | f
public | images | zabbix | | t | f | t | f
public | events | zabbix | | t | f | t | f
public | acknowledges | zabbix | | t | f | t | f
public | triggers | zabbix | | t | f | t | f
public | auditlog_details | zabbix | | t | f | t | f
public | operations | zabbix | | t | f | t | f
public | graphs | zabbix | | t | f | t | f
public | drules | zabbix | | t | f | t | f
(113 rows)

(END)

[funkytwig]

OK, looked like I had not done

cat data.sql | sudo -u zabbix psql zabbix

Have other issues but will start another thread.

[rv_overseer]

On my postgresql database, I've got 140 tables in public for Zabbix 3.4

zabbix=# SELECT * FROM pg_catalog.pg_tables where schemaname='public';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers | rowsecurity
------------+----------------------------+------------+------------+------------+----------+-------------+-------------
public | screen_user | zabbix | | t | f | t | f
public | slideshows | zabbix | | t | f | t | f

public | triggers | zabbix | | t | f | t | f
public | rights | zabbix | | t | f | t | f
public | dashboard_usrgrp | zabbix | | t | f | t | f
(140 rows)