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

Create a technical support case if you need further support.

Migrating InterScan Messaging Security Suite (IMSS) policies to another database

    • Updated:
    • 6 Nov 2015
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Linux
    • InterScan Messaging Security Suite 7.1 Windows
    • Platform:
    • Linux - SuSE version 9
    • Unix - Solaris (Sun) version 8 (SunOS 5.8)
    • Unix - Solaris (Sun) version 9 (SunOS 5.9)
    • Windows 2000 Advanced Server
    • Windows 2000 Server
    • Windows 2003 Enterprise Server
Summary

Migrate policies to another database on InterScan Messaging Security Suite (IMSS).

Details
Public

To move policies:

  1. Back up the database from the source IMSS Server. Open a command prompt and run these commands

    C:>osql -U sa -P
    1> BACKUP DATABASE imss TO DISK='x:\imss.bak'
    2> BACKUP DATABASE imsseuq TO DISK='x:\imsseuq.bak'
    3> GO

     
    Replace “x”: the with drive letter wherein you will place the backup file. The length of time to back up depends on the size of the database. The larger the size, the longer the time to backup.
  2. Restore the database in the target IMSS Server:
    1. Copy the imss.bak and imsseuq.bak files to the target IMSS Server.
    2. Open a command prompt and run these commands:

      C:>osql -U sa -P
      1> RESTORE DATABASE imss FROM DISK='x:\imss.bak'
      2> RESTORE DATABASE imsseuq FROM DISK='x:\imsseuq.bak'
      3> GO

       
      Replace “x”: the with drive letter wherein you will place the backup file. The length of time to restore depends on the size of the database. The larger the size, the longer the time to restore.
  1. Back up the database:
    1. Go to /opt/trend/imss/PostgreSQL/bin.
    2. Type the following commands:

      /pg_dump -U sa imss > /imss.bak
      ./pg_dump -U sa imsseuq > /imsseuq.bak

  2. Restore the database:
    1. Stop all IMSS services by running this command: /opt/trend/imss/script/S99* stop.
    2. Restart PostgreSQL service by running this command: /opt/trend/imss/script/dbctl.sh restart
    3. Go to /opt/trend/imss/PostgreSQL/bin.
    4. Run the following commands. At this point, you need to drop the current database. Just make sure that you back up the database before dropping it.

      /dropdb -U sa imss
      ./dropdb -U sa imsseuq
      ./create -U sa imss
      ./create -U sa imsseuq

    5. Restore the database by copying the backed up database on / directory:

      ./psql -U sa imss < /imss.bak
      ./psql -U sa imss < /imsseuq.bak

    6. Start all the IMSS services again by running this command: /opt/trend/imss/script/S99* start
  1. Back up the database by running the following command:

    /opt/trend/imss/PostgreSQL/bin/pg_dump -U sa imss | bzip2 > YYMMDD.HHMMSS.backup.bz

  2. Recreate the database:
    1. Stop all the services by executing the command:

      /opt/trend/imss/script/imssstop.sh stop

    2. Make sure the destination Postgres database is in release 8.1.3 or above.

      To use the one that is shipped with IMSS:

      1. Run the "./isinst" command.
      2. Go to Main Menu and then press 1 to open Install Components.
      3. In the IMSS Deployment Config Menu, press 1 to Install a new IMSS server on the current machine or press 2 to Install a new database server on the current computer.
      4. Configure your password.
      5. Set the following to "NO":
        • Install Central Controller
        • Install Scanner Service
      6. Start the installation.
    3. Drop the preinstalled database of the fresh installation by running the command:

      /opt/trend/imss/PostgreSQL/bin/dropdb -h 127.0.0.1 -U sa imss

    4. Create a new database by running the following commands:

      /opt/trend/imss/PostgreSQL/bin/createdb -h 127.0.0.1 -U sa -E unicode imss
      /opt/trend/imss/PostgreSQL/bin/createlang -h 127.0.0.1 -U sa -d imss plpgsql

    5. Restore the exported database by running the command:

      bunzip2 -c YYMMDD.HHMMSS.backup.bz | /opt/trend/imss/PostgreSQL/bin/psql -U sa imss

    6. Make sure the permissions are set correctly in the /var/imss/pgdata/pg_hba.conf file.
  3. Modify the configuration files to reflect the new database.
    1. Modify the following files in all servers:

      opt/trend/imss/config/odbc.ini
      /opt/trend/imss/config/database.ini
      /opt/trend/imss/config/euqodbc.ini

    2. Modify the following file only on the Central Controller:

      /opt/trend/imss/UI/adminUI/ROOT/WEB-INF/struts-config-common.xml

    3. Set the following:

      set-propertyc
      property="url"
      value="jdbc:postgresql://127.0.0.1:5432/imss"
      set-property
      property="username"
      value="sa"
      set-property
      property="password"
      value="sa"

  4. Follow these steps if you want to move the table using EUQ:
    1. On the new database server, run the "./isinst" command.
    2. On the Main Menu, press 1 for Install components
    3. In the IMSS Deployment Config Menu, press 2 to Append components to an existing IMSS server and then set the value to "yes".
    4. In the Install Components Menu, press 4 to Modify option for EUQ Database.
    5. In the EUQ Database Config Menu, press 2 to Use an existing database server.
    6. In the Install Components Menu, press 6 to Start Installation.
    7. On the web console, go to Administration > IMSS Configuration > Connections > Database.
    8. Register a new EUQ Database.
  5. Restart all the services.
Premium
Internal
Rating:
Category:
Migrate
Solution Id:
1035593
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.