Do the following for a Redhat distribution:
- Install these packages:
- postgresql-server
- postgresql
- postgresql-odbc
- postgresql-libs
- Install IWSS for Linux and then select No when asked if you want install the default database.
- Apply the latest IWSS patches and do not start the daemons yet.
- Rename the /etc/iscan/Postgresql to mv /etc/iscan/Postgresql /etc/iscan/Postgresql.bak.
- Open the /var/lib/pgsql/data/pg_hba.conf file using a text editor.
- Add the "host all all 127.0.0.1 255.255.255.255 trust" line.
- Save and close the file.
- Open the /var/lib/pgsql/data/postgresql.conf file.
- Change the value of "#tcpip_socket = false" to "true".
- Start the postgresql system by executing the "/etc/init.d/postgresql start" command.
- Execute the following commands to use postgresql with IWSS:
"su postgres"
"createuser -d -P sa" (when asked to create as superuser, answer 'no')
"createdb -U sa iwss" "createlang plpgsql iwss" "/etc/iscan/sql/postgresql/install/InitDatabase.sh" - Execute "chkconfig -level 2345 postgresql on" to automatically start postgresql when booting.
- Start all the IWSS daemons and edit the database settings to reflect the correct information.