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

Create a technical support case if you need further support.

Re-creating the SQL database using initDB.bat tool

    • Updated:
    • 4 Feb 2016
    • Product/Version:
    • InterScan Web Security Suite 3.1 Linux
    • InterScan Web Security Suite 3.1 Windows
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary

The installation package of InterScan Web Security Suite (IWSS) 3.1 contains the InitDb.bat script. This batch script is located in the Disk1\dbinit directory and you can use it to re-create the IWSS SQL database and database structure.

Details
Public

To re-create the database from scratch and populate with initial data:

  1. Stop all scheduled tasks and IWSS services to make sure that nothing is accessing the IWSS database.
    The IWSS services are the following:
    • Trend Micro InterScan Web Security Suite Console
    • Trend Micro InterScan Web Security Suite for FTP
    • Trend Micro InterScan Web Security Suite for HTTP
    • Trend Micro IWSS Log Import
    • Trend Micro IWSS Metric Management Service
    • Trend Micro IWSS Notification Delivery Service
    • Trend Micro IWSS TMCM Agent Service
    • Trend Micro SNMP Service
  2. Open the command prompt and map to the Disk1\dbinit directory of the installation package. For example: C:\ cd C:\iwss_31_win_b1158\Disk1\dbinit.
  3. Run the following command:

    initDb.bat <user> <password> <iwss database instance> -f

    where:

    • <user> is the SQL user account used for IWSS. This can be the 'sa' SQL user account or Windows authentication account.
    • <password> is the password of the user account used for SQL authentication.
    • <iwss database instance> is the IWSS server IP if the SQL is on the same server as IWSS. For example, in 10.255.255.255\iwss, iwss is the database instance.

    Sample command:

    InitDb.bat sa password 10.255.255.255\iwss -f

    Re-creation of the database will start. The following output will appear:

    [NOTICE]: If you already have an old "iwss3" database in the server
    [192.255.255.255\iwss ],this program will delete this database, and create a new one from scratch!
    Do you want to continue(y|n): y
    1.Creating DSN for database creation...
    2.Deleting possible pre - existed database...
    3.Creating database ...
    4.Creating tables ...
    5.Creating procedures ...
    6.Inserting default values ...
    7.Creating default cleanup job
    Database for IWSS3.1 Windows has been successfully created and initialized!

  4. Restart all IWSS services and scheduled tasks, and then access the web console to confirm the successful re-creation of the database.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Install
Solution Id:
1099719
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.