DB interface - use of ODBC

[Zapnix]

Hello,

I have Zabbix 1.4 running like a charm at home with a PostgreSQL DB.

Recently I tried to install Zabbix 1.4 with Oracle as DB (on a fresh Gentoo Linux system). After hacking some ebuilds to get the dependency for libsqlora8 and the version problems I got it compiled - but it didn't do the job at all, I fear some libsqlora problem, but didn't dive into that any deeper.

After that I decided to use sqlite. Zabbix seems to compile fine, DB creation worked without any problem (in contrast to the Oracle version, where I had to modify all the .sql files) - but no chance to use, because php-sqlite3 seems not to be in (standard) portage - means that I'll either have to hack around again or to install a (Mysql or PostgreSQL) DB server.

That's the point where it seems a bit funny to me - if you guys intend to limit the DB accesses/queries to standard features, why don't you use a standard interface? Wouldn't it be easier to keep the DB interface small, standard and simple and let the custom interface outside the application? I used ODBC for a few small apps with at least an Oracle and a PostgreSQL DB without problems and was told that it works with SQLite too, why wouldn't it be an option to use it with Zabbix?

Kind regards
Ecki

[serge.fonville]

What exactly have you done to setup PostgreSQL, since with me it doesn't work.

I believe PostgreSQL is way better for the purpose of Zabbix.
Since it seems very doable, I would really like to know what is required to set it up. I am running CentOS 4.5

Thanks in advance

[Zapnix]

Hello Serge,

I did nothing really important, except that I patched the Gentoo ebuild for zabbix-1.4 (very simple patch, but have it at home, not here at work). I found that configure didn't really work with PostgreSQL because of the use of a "test -rf" (it comes from some m4 file in a subdirectory), so I simply used sed to make it a "test -r" (something like "cp configure configure.orig; sed 's/\(test -r\)f/\1/' < configure.orig > configure").

After that, it worked as expected. Please send a more detailled description if it still doesn't work for you.

Regarding the use of a distinct database, i have the problem that my server at home is PostgreSQL while at work it's either Oracle or nothing - means to use SQLite. So I thought the use of ODBC would be least limiting...

Kind regards
Ecki