Sorry if it's inappropriate for strangers to submit to this list.
Had quite a time getting the server to work with PostgreSQL 8.3 on
Ubuntu 8 -- thought it might be useful to share.
When I built/installed Postgres 8.3 source it installed into*
/usr/local/pgsql*
I needed to update ossec-hids-1.5/src/os_dbd/dbmake.sh with this path as
it is not among the current options (shown below):
for i in /usr /usr/local /usr/pgsql /usr/postgresql $1
In my case I already had Postgres installed via apt-get install.
(The binary version seems to be somewhat more robust than that built
from source.)
The binary install dir (for executables and runtime libraries) is:
/usr/lib/postgresql/8.3
Here's my hack for using the binary version.
--re-initialized the binary install and added the data directory at this
location -- this may have been unnecessary
--hand-edited the generated file: ossec-hids-1.5/src/Config.OS
so it pointed to the needed source installation path (for libpq) and the
runtime libs/exes in binary installation path: e.g.:
CDB=-I/usr/local/pgsql/include *-L/usr/lib/postgresql/8.3*
-L/usr/local/pgsql/lib -lpq -DDBD -DUPOSTGRES
Can't imagine you want to update the configuration for every
installation scheme (or to consider my hack), but it may help to put
into the notes somewhere that users may have to tweak dbmake.sh to match
their postgresql install.
Catherine Call
Charles River Analytics, Inc. (research)
