installing zabbix-server-pgsql fails on initialising database
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
zabbix (Ubuntu) |
New
|
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,
Details are also in /var/log/
To manually correct the error do the following
cd /usr/share/
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...
PLease be advised that Zabbix developers do not monitor this bug tracker, you may wish to also file a bug report upstream at /support. zabbix. com/
https:/