Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.8.6
    • Component/s: Frontend (F)
    • Labels:
      None
    • Environment:
      zabbix-1.8.3
      postgresql-9.0
      freebsd-8.1-amd64

      Description

      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 = '';

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: