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

Create a technical support case if you need further support.

Recreating the InterScan Web Security Virtual Appliance (IWSVA) database

    • Updated:
    • 16 May 2016
    • Product/Version:
    • InterScan Web Security Virtual Appliance 6.0
    • InterScan Web Security Virtual Appliance 6.5
    • Platform:
    • Linux - Red Hat RHEL 4 64-bit
    • Linux - Red Hat RHEL 5 64-bit
    • Linux - Red Hat RHEL 6 64-bit
Summary

When you encounter issues with the IWSVA database such as browsing issue, slow communication, crash issue, and disk space issue, you can recreate the IWSVA database.

Details
Public

Perform the following procedures during off-peak hours or schedule a downtime maintenance to reduce business impact on the customer's environment. Before recreating the IWSVA database, you must back up the current database first.

A. Back up the IWSVA database:
  1. Open IWSVA SSH console and login as root.
  2. Run "su - iscan" to change the current user to iScan.
  3. Run "mkdir /tmp/backup" to create the backup directory.
  4. Run the backup script using the following command:

    /usr/iwss/bin/db_backup.sh localhost 5432 sa iwss manual /tmp/backup all

    This script creates a database backup located on the /tmp/backup folder. Below is the format of the backup filename:

    backup.all.yyyy-mm-dd (e.g. backup.all.2010-07-31)

B. Recreate the database:

  1. Open the IWSVA SSH console and login as root.
  2. Run the following commands:
    1. /etc/iscan/S99ISdatabase stop
    2. rm -rf /var/iwss/postgres/pgdata/*
    3. /usr/iwss/installdb.sh
    4. /usr/iwss/rcIwss restart

The new database password for the SA and iScan users are generated and stored in the /etc/iscan/.pgpass file.

Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Install; Update
Solution Id:
1098819
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.