tags 419042 + upstream
tags 419042 + confirmed
tags 419042 + patch
thanks
hi Christoph,
On Fri, Apr 13, 2007 at 02:39:34PM +0200, Christoph Haas wrote:
> I logged into the web interface, created a host and submitted the form.
> Then I got this output:
>
> ============================================
> Warning: pg_exec() [function.pg-exec]: Query failed: FEHLER: Fehler
> »Syntaxfehler« am Ende der Eingabe at character 36 in
> /usr/share/zabbix/include/db.inc.php on line 67
>
> Warning: pg_fetch_row() expects parameter 1 to be resource, boolean given in
> /usr/share/zabbix/include/db.inc.php on line 127
> Error getting row
> ============================================
>
> It appears to me like the web interface does not work properly with a
> PostgreSQL 8.1.8-1 backend.
i *guess* this is related to 8.1 not creating tables with OID columns unless
WITH OIDS is specified during CREATE TABLE.. which is not the case for 1.1.4.
I have to confess i did not test it using postgres 8.1.x, there are several
problems in the forums related to zabbix versions 1.1.2 - 1.1.4, newer versions
contain some fixes in order to make zabbix work on 8.1 (and are creating
tables using WITH OIDS according to the changelogs).
So well, there might also be problems if you try to add screens and the like, i
think the best solution would be to make zabbix{-server-pgsql,frontend-php}
have a Recommends on postgresql-7.4, instead of postgresql-8.1 which is known
to work (fixing the php scripts would take quite some changes and i dont want
to mess it, though).
Fabio: whats your opinion here? Are you running zabbix on postgresql-8.1?
Upstream mentions Postgresql version >7.2 as supported but not 8.x.
bye,
- michael
