1.4.2 fails to install with Postgresql

[hsn]

There is problem in table names used in data.sql , some data fails to import into PostgreSQL database. They should be "hosts" instead of `hosts`.

Following installation procedure with PGSQL fails:

sanatana# cat data.sql | psql -U zabbix zabbix
INSERT 404144 1
INSERT 404145 1
INSERT 404146 1
INSERT 404147 1
INSERT 404148 1
INSERT 404149 1
INSERT 404150 1
INSERT 404151 1
INSERT 404152 1
INSERT 404153 1
INSERT 404154 1
INSERT 404155 1
INSERT 404156 1
INSERT 404157 1
INSERT 404158 1
INSERT 404159 1
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10001,'Template_Linux','',0,'',1...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10002,'Template_Windows','',0,''...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10003,'Template_App_MySQL','',0,...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10004,'Template_Standalone','',0...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10007,'Template_SNMPv2_Device','...
^
ERROR: syntax error at or near "`"
LINE 1: INSERT INTO `hosts` VALUES (10008,'Template_FreeBSD','Templa...

Can someone post fix?

[sauron]

Use PostgreSQL 8.1.x

[hsn]

I am using pgsql 8.2, I cant use 8.1 because other apps require 8.2

[Alexei]

Thanks for reporting this!

[Sasha]

Thank you! This is fixed.

You may try the latest code from http://www.zabbix.com/developers.php

[aromli]

Problem install Zabbix on Centos 5

i got problem when execute this command :

#./configure --enable-server --enable-agent --with-mysql --with-net-snmp --with-jabber --with-libcurl

and error occurs and display below message :
#checking for IKSEMEL... configure: error: Not found Jabber library

please anyone help me out this problem.. thanks.

Romli

[krims0n]

Try installing the iksemel-devel package.

[walterg74]

Thank you! This is fixed.

You may try the latest code from http://www.zabbix.com/developers.php

Hi!

Would you mind explaining to me the difference between the 2 "nightly" builds available for download?

Thnx!!

[walterg74]

I dl the nightly version, and while the erros did go away, I got a lot of warnings regarding the use of: \\....

I also get a LOT of those errors when trying to run the images_pgsql.sql script.

Any idea?

[thresh]

inserting images_psql.sql still doesnt work (tried 1.4 from developers page from 19 Nov)... with pgsql 8.2

WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (1,1,'Hub','\\211PNG\\015\\012\\03...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34941 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (2,1,'Hub (small)','\\211PNG\\015\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34942 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (3,1,'Network','\\211PNG\\015\\012...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34943 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (4,1,'Network (small)','\\211PNG\\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34944 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (5,1,'Notebook','\\211PNG\\015\\01...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34945 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (6,1,'Notebook (small)','\\211PNG\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34946 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (7,1,'Phone','\\211PNG\\015\\012\\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34947 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (8,1,'Phone (small)','\\211PNG\\01...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34949 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (9,1,'Printer','\\211PNG\\015\\012...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34950 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (10,1,'Printer (small)','\\211PNG\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34951 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (11,1,'Router','\\211PNG\\015\\012...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34952 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (12,1,'Router (small)','\\211PNG\\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34953 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (13,1,'Satellite','\\211PNG\\015\\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34954 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: ...SERT INTO images VALUES (14,1,'Satellite (small)','\\211PNG\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34956 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (15,1,'Server','\\211PNG\\015\\012...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34957 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (16,1,'Server (small)','\\211PNG\\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34958 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (17,1,'UPS','\\211PNG\\015\\012\\0...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34959 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (18,1,'UPS (small)','\\211PNG\\015...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34961 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: INSERT INTO images VALUES (19,1,'Workstation','\\211PNG\\015...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34962 1
WARNING: nonstandard use of \\ in a string literal
LINE 1: ...RT INTO images VALUES (20,1,'Workstation (small)','\\211PNG\...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 34964 1