installing zabbix-server-pgsql fails on initialising database

Bug #306240 reported by Theo on 2008-12-08
2
Affects Status Importance Assigned to Milestone
zabbix (Ubuntu)
Undecided
Unassigned

Bug Description

Binary package hint: zabbix-server-pgsql

Description: Ubuntu 8.04.1
Release: 8.04

Installing hardy zabbix-server-pgsql (1:1.4.2-4ubuntu3) fails with the following message

ERROR: syntax error at or near
"`" LINE 1: INSERT INTO `hosts` VALUES (10001,'Template_Linux','',0,'',1...

Details are also in /var/log/postgresql/postgresql-8.3-main.log

To manually correct the error do the following

cd /usr/share/zabbix-server
cp data.sql data-fixed.sql
# edit data-fixed.sql and remove all lines up to the blank line just before
# -- Dumping data for table `hosts`
# Ie. line 68
# Then remove all occurrences of the backtick (`) character surrounding any table
# names in the INSERT statements
# Save the file and load it into the zabbix database as follows

psql -h localhost -U zabbix -f data-fixed.sql zabbix

Several further warnings are generated which I have not had time to look at

-- Theo

PS - I selected continue after the error was reported from apt-get install...

Fabián Rodríguez (magicfab) wrote :

PLease be advised that Zabbix developers do not monitor this bug tracker, you may wish to also file a bug report upstream at
https://support.zabbix.com/

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers