Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-3063

not compatible with PostGreSQL 9.x

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Critical Critical
    • 1.8.6
    • None
    • Frontend (F)
    • 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']))

      { + DBexecute('set bytea_output = escape'); + }

      break;
      case 'ORACLE':
      $connect = '';

            Unassigned Unassigned
            greenx Andrey Groshev
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: