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

Create a technical support case if you need further support.

SMTP service takes a long time to start in InterScan Messaging Security Suite (IMSS)

    • Updated:
    • 27 Mar 2014
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Windows
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2008 Enterprise
Summary
The IMSS does not accept mails until the SMTP service is fully started. However, the SMTP service starts slowly and may consume all the CPU resources during startup.
Details
Public
The tsmtpd process takes a long time and consumes most of the CPU resources to load because the tb_mta_config has more than 60, 000 TrustedHost* entries and more than 4, 000 AllowDomain* entries.
These numbers are too high since the effective entries are only 66 TrustedHostCount and 662 AllowDomainCount. The huge number of entries can be caused by frequently importing new lists while IMSS fails to purge the old lists.
As a workaround:
Note: Make sure to back up the database first before doing the procedure below.
  1. Export the effective TrustedHosts* entries and AllowDomain* entries.
    1. Go to Administration > IMSS Configuration > SMTP Routing.
    2. Select the Message Rule tab.
    3. Under the Relay Domains section, click Export and save the relaydomains.txt file.
    4. Under the Permitted Senders of Relayed Mail section, click Export and save the permitted_senders_of_relayed_mail.txt file.
  2. Back up the current configuration.
    1. Go to Administration > Import/Export.
    2. Click Export and save the file.
  3. Stop the IMSS SMTP service, and then use the following osql command lines to remove all the TrustedHost* entries and AllowDomain* entries in the database:
    c:\osql -L -------------List the installed SQL instance, you might get empty result, repeatedly run this command until you get a list
    c:\osql -E -S <IMSS database instance name> -d imss ----------------------Connect to IMSS database instance and remove all TrustedHosts<ID> and AllowDomain<ID>:
    1> delete from tb_mta_config where name like 'TrustedHosts0%'
    2> go
    1> delete from tb_mta_config where name like 'TrustedHosts1%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts2%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts3%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts4%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts5%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts6%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts7%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts8%'
    2>go
    1> delete from tb_mta_config where name like 'TrustedHosts9%'
    2>go
    1> delete from tb_mta_config where name like 'AllowDomain0%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain1%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain2%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain3%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain4%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain5%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain6%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain7%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain8%'
    2> go
    1> delete from tb_mta_config where name like 'AllowDomain9%'
    2> go
  4. Import the lists back.
    1. Go to Administration > IMSS Configuration > SMTP Routing.
    2. Select the Message Rule tab.
    3. Under the Relay Domains section, click Import to get the relaydomains.txt file.
    4. Under the Permitted Senders of Relayed Mail section, click Import to get the permitted_senders_of_relayed_mail.txt file.
  5. Start IMSS SMTP service and confirm if the issue is resolved.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1102859
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.