Select the scenario where the issue is occuring:
InterScan Web Security Virtual Appliance (IWSVA) 6.0 can only support up to the maximum limit of 64 custom categories. When the user uses more than the custom category limit, the action taken from the database will encounter an error and HTTP Status 500 will appear on the console.
To resolve the issue, decrease the number of custom categories:
- Connect to the IWSVA server using SSH tool such as PuTTY.
- Log in as “root”.
- Run this command: “/etc/iscan/PostgreSQL/bin/psql iwss sa”.
- Run the following command to delete all the actions for custom categories in the database:
iwss=# update tb_rule set "RuleValue" = 'url_category=11111101 11100111 00000010
0000 10000000 00100000 00000000 10000110 00001001 01010110 11010000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 0000000000000000 00000000|safe_search=00000000 00000000 00000000
00000000| override_password=|time_quota=m|' where "PolicyID" = '2'; UPDATE 1Performing the command deletes all of the actions for custom categories. You need to re-apply the action from the previous policy settings. - Check the IWSVA web console again. You should be able to see the URL Global Policy settings by now.
The error may be caused by corrupted files related to the page that is not showing up. Reset the whole page to resolve the issue:
- Connect to the IWSVA server using SSH tool such as PuTTY.
- Log in as “root”.
- Run this command: “/etc/iscan/PostgreSQL/bin/psql iwss sa”.
- Copy and paste the following sql command to reset the virus policy:
update tb_rule set "RuleValue" = 'bot_action=1|ext_exclude_list=|action=clean|
skiptype_enable_tft=false|wrs_use_scanflag=no|itrap_scan=yes|level=scanintelli|
extract_limit_size=1G|enable_blocktype_inzip=yes|apt_action=2|max_synchronous_
scan_size=65536|ext_additional_list=|trickle_max_size=819|phishing_action=1|
block_types=|pharming_action=1|skipscanning=0|ucaction=delete|wrs_scoring_action=1|
anti_phishing=yes|extract_limit_ratio=100|scan_huge_file=yes|password_protected_
zip=pass|anti_cnc=yes|extract_limit_count=50000|scanthreats=0|decompress_layer_
limit=10|anti_pharming=yes|macroscan=no|trickle_rate=1|other_block_types=|
wrs_enable=yes|max_scan_size=10240|wrs_scoring=yes|skiptype=audio/x-wav audio/
wav audio/microsoft-wave audio/x-mpeg audio/mpeg x-music/x-midi audio/mid video/
mpeg video/quicktime video/x-msvideo video/avi video/x-ms-asf video/x-ms-wmv
video/x-flv video/f4v video/mp4 image/x-icon image/jpeg image/gif image/x-xbitmap
image/png image/vnd.microsoft.icon application/vnd.rn-realmedia|wrs_threshold=M|
deferred_scanning=late|backupencode=yes|special_handling=yes|urlc_enable=yes|
wrs_ctx_enable=yes|macro_act=|anti_apt=no|' where "PolicyID"=5; - Enter “\q” to quit.
- Access the Virus/Malware Scan Rule tab again. You should be able to see the proper content of the IWSVA web UI.
Contact Trend Micro Technical Support if the issue persists.