Installing Zabbix Server 2.2.5 with EnterPriseDB Postgres9.3?

[tiarnaigh]

Hi all.
Just wondering if anyone else has run into an issue trying to get Zabbix server to install with EnterPriseDB's version of Postgres9.3 (EnterpriseDB 9.3.4.10) when installing from source?


I'm running the following install options:

[root@zbx2dal0 zabbix-2.2.5]# ./configure --enable-server --enable-agent --with-postgresql=/opt/PostgresPlus/9.3AS/bin/pg_config --enable-ipv6 --enable-java --with-net-snmp --with-libcurl --with-libxml2 --with-ssh2 --with-ldap


This all runs away fine until the following error is returned:

checking for /proc filesystem... yes
checking for file /proc/stat... yes
checking for file /proc/cpuinfo... yes
checking for file /proc/0/psinfo... no
checking for file /proc/loadavg... yes
checking for file /proc/net/dev... yes
checking for long long format... no
checking for -rdynamic linking option... yes
checking for libperfstat 5.2.0.40 fileset... no
checking for libperfstat 5.3.0.60 fileset... no
checking for architecture... linux (linux-gnu)
checking for the linux kernel version... 2.6 family (2.6.32-431.el6.x86_64)
checking size of void *... 8
checking for Oracle support... no
checking for pg_config... /opt/PostgresPlus/9.3AS/bin/pg_config
checking for PostgreSQL libraries... no
configure: error: PostgreSQL library not found
[root@zbx2dal0 zabbix-2.2.5]#


Running the pg_config above gives me the following output:

[root@zbx2dal0 zabbix-2.2.5]# /opt/PostgresPlus/9.3AS/bin/pg_config
BINDIR = /opt/PostgresPlus/9.3AS/bin
DOCDIR = /opt/PostgresPlus/9.3AS/doc
HTMLDIR = /opt/PostgresPlus/9.3AS/doc
INCLUDEDIR = /opt/PostgresPlus/9.3AS/include
PKGINCLUDEDIR = /opt/PostgresPlus/9.3AS/include
INCLUDEDIR-SERVER = /opt/PostgresPlus/9.3AS/include/server
LIBDIR = /opt/PostgresPlus/9.3AS/lib
PKGLIBDIR = /opt/PostgresPlus/9.3AS/lib
LOCALEDIR = /opt/PostgresPlus/9.3AS/share/locale
MANDIR = /opt/PostgresPlus/9.3AS/share/man
SHAREDIR = /opt/PostgresPlus/9.3AS/share
SYSCONFDIR = /opt/PostgresPlus/9.3AS/etc
PGXS = /opt/PostgresPlus/9.3AS/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--enable-debug' '--with-libs=/opt/local/Current/lib' '--with-includes=/opt/local/Current/include/libxml2:/opt/local/Current/include' '--prefix=/mnt/hgfs/edb-postgres.auto/server/staging/linux-x64' '--with-libcurl' '--with-ldap' '--with-openssl' '--with-perl' '--with-python' '--with-tcl' '--with-libmemcached' '--with-tclconfig=/opt/ActiveTcl-8.5/lib' '--with-pam' '--with-krb5' '--enable-thread-safety' '--with-libxml' '--with-ossp-uuid' '--with-oci=/opt/oracle_10.2/include' '--with-odbc=/opt/local/Current/include' '--docdir=/mnt/hgfs/edb-postgres.auto/server/staging/linux-x64/doc' '--with-libxslt' '--with-libedit-preferred' '--with-gssapi' '--with-pgport=5444' '--enable-nls' 'LD_LIBRARY_PATH=/opt/local/Current/lib'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/opt/local/20120813/5db56128-e513-11e1-9f9b-3c07547d6b4f/include/libxml2 -I/opt/local/20120813/5db56128-e513-11e1-9f9b-3c07547d6b4f/include -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -L../../../src/common -L/opt/local/20120813/5db56128-e513-11e1-9f9b-3c07547d6b4f/lib -L/opt/local/20120813/5db56128-e513-11e1-9f9b-3c07547d6b4f/lib -L/opt/local/Current/lib -Wl,--as-needed -Wl,-rpath,'/mnt/hgfs/edb-postgres.auto/server/staging/linux-x64/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lpgcommon -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -ledit -lcrypt -lxml2 -lm
VERSION = EnterpriseDB 9.3.4.10



I thought it was simply the case that the configure script was looking for the word "PostgreSQL" from the pg_config, so I tried editing the "configure" script at line 8529 as follows:

8527 if test "x$found_postgresql" = "xyes"; then
8528 #POSTGRESQL_VERSION=`$PG_CONFIG --version | sed -e 's#PostgreSQL ##'`
8529 POSTGRESQL_VERSION=`$PG_CONFIG --version | sed -e 's#EnterpriseDB ##'`
8530 fi


Again, no difference.

I created the zabbix databases as per normal using EDB and all went fine

psql -U zabbix_user -h localhost -p 5432 -d zabbix < data.sql
psql -U zabbix_user -h localhost -p 5432 -d zabbix < images.sql
psql -U zabbix_user -h localhost -p 5432 -d zabbix < schema.sql

Hence, a bit puzzled by the above.

Anyone have any ideas?

Many thanks,
Michael.

[tiarnaigh]

Still struggling with this one since.

No ideas anyone?

[tiarnaigh]

Still nothing on this? EDB is basically a standard Postgres 9.3 install, so there shouldn't be any good reason why Zabbix wouldn't work with it.

Anyone from Zabbix dev team have any ideas on how to work around this?

Thanks,
M