Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Using the Postgresql database package included in the selected Linux distribution with IWSS

    • Updated:
    • 14 Dec 2015
    • Product/Version:
    • InterScan Web Security Suite 3.1 Linux
    • Platform:
    • Linux - Red Hat RHEL 3 32-bit
    • Linux - Red Hat RHEL 4 32-bit
    • Linux - Red Hat RHEL 5 32-bit
    • Linux - Red Hat RHEL 6 32-bit
    • Linux - SuSE version 10
Summary

You can use the existing Postgresql database server with InterScan Web Security Suite (IWSS) for Linux to easily upgrade the database server.

Details
Public

Do the following for a Redhat distribution:

 
This procedure is tested only with Postgresql 7.x.
  1. Install these packages:
    • postgresql-server
    • postgresql
    • postgresql-odbc
    • postgresql-libs
  2. Install IWSS for Linux and then select No when asked if you want install the default database.
  3. Apply the latest IWSS patches and do not start the daemons yet.
  4. Rename the /etc/iscan/Postgresql to mv /etc/iscan/Postgresql /etc/iscan/Postgresql.bak.
  5. Open the /var/lib/pgsql/data/pg_hba.conf file using a text editor.
  6. Add the "host all all 127.0.0.1 255.255.255.255 trust" line.
  7. Save and close the file.
  8. Open the /var/lib/pgsql/data/postgresql.conf file.
  9. Change the value of "#tcpip_socket = false" to "true".
  10. Start the postgresql system by executing the "/etc/init.d/postgresql start" command.
  11. 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"

  12. Execute "chkconfig -level 2345 postgresql on" to automatically start postgresql when booting.
  13. Start all the IWSS daemons and edit the database settings to reflect the correct information.
Premium
Internal
Rating:
Category:
Configure
Solution Id:
1033629
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.