-
Incident report
-
Resolution: Fixed
-
Critical
-
None
-
None
-
zabbix-1.8.3
postgresql-9.0
freebsd-8.1-amd64
I tried a bunch of zabbix and postgresql 9.0.
Discovered the following problem - not showing pictures.
The problem is that PG9 by default uses a new type of output data BYTEA.
Here is a small patch that-be tell PG to give data in the old format.
#diff -u db.inc.php.bak db.inc.php
— db.inc.php.bak 2010-09-30 13:14:29.000000000 +0400
+++ db.inc.php 2010-09-30 14:12:21.000000000 +0400
@@ -83,6 +83,10 @@
$error = 'Error connecting to database';
$result = false;
}
+/* if pg_version exist and begins with the nines then set bytea_output = 'escape', as PG9 new hex bytea default type output. */
+ elseif(($ver = pg_version($DB['DB'])) && preg_match('/^9.*/',$ver['server']))
break;
case 'ORACLE':
$connect = '';