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

Create a technical support case if you need further support.

InterScan Messaging Virtual Appliance (IMSVA) rollback procedure for KB 1110914

    • Updated:
    • 16 Jan 2020
    • Product/Version:
    • InterScan Messaging Virtual Appliance 9.1,9.0,8.5,8.2
    • Platform:
    • N/A
Summary

This article provides the rollback procedure for the KB article: Enabling ATSE Macro Threat Detection feature in InterScan Messaging Virtual Appliance (IMSVA).

Details
Public

To perform the rollback, do the following:

  1. Enter the Admin database:

    /opt/trend/imss/PostgreSQL/bin/psql imss sa

    1. Check the current value:

      imss=# select * from tb_global_setting where name='detection_aggressive_level';
       section |            name            | value | inifile  |      notes       
      ---------+----------------------------+-------+----------+------------------
       general | detection_aggressive_level | 3     | imss.ini |                 
      (1 row)
      
    2. Update the value to "4":

      imss=# update tb_global_setting set value='4' where name = 'detection_aggressive_level';
      UPDATE 1
      
    3. Confirm the new value:

      imss=# select * from tb_global_setting where name='detection_aggressive_level';         
       section |            name            | value | inifile  |      notes       
      ---------+----------------------------+-------+----------+------------------
       general | detection_aggressive_level | 4     | imss.ini |                 
      (1 row)
      
    4. Revert to the original value of "3":

      imss=# update tb_global_setting set value='3' where name = 'detection_aggressive_level';
      UPDATE 1
      
    5. Confirm if the value is reverted to "3":

      imss=# select * from tb_global_setting where name='detection_aggressive_level';         
       section |            name            | value | inifile  |      notes       
      ---------+----------------------------+-------+----------+------------------
       general | detection_aggressive_level | 3     | imss.ini |                 
      (1 row)
      
    1. Check if the following row exists:

      imss=# select * from tb_global_setting where name = 'rules_included';                   
       section | name | value | inifile | notes
      ---------+------+-------+---------+-------
      (0 rows)
      
    2. Insert new values:

      imss=# insert into tb_global_setting values('general','rules_included','HEUR_VBA.O1;HEUR_VBA.O2;HEUR_VBA.D;HEUR_VBA.E;HEUR_VBA.E2;HEUR_VBA.E3', 'imss.ini', NULL);
      INSERT 0 1
      
    3. Confirm if the new row is added:

      imss=# select * from tb_global_setting where name = 'rules_included';                                                                                             
       section |      name      |                                 value                                 | inifile  | notes
      ---------+----------------+-----------------------------------------------------------------------+----------+-------
       general | rules_included | HEUR_VBA.O1;HEUR_VBA.O2;HEUR_VBA.D;HEUR_VBA.E;HEUR_VBA.E2;HEUR_VBA.E3 | imss.ini |
      (1 row)
      
    4. Delete the new row:

      imss=# delete from tb_global_setting where name = 'rules_included';
      DELETE 1
      
    5. Confirm if the new row is deleted:

      imss=# select * from tb_global_setting where name = 'rules_included';
       section | name | value | inifile | notes
      ---------+------+-------+---------+-------
      (0 rows)
      
    6. Quit the database.

      imss=# \q

Premium
Internal
Partner
Rating:
Category:
Configure; Troubleshoot
Solution Id:
000233684
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.