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
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.
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.
- Export the effective TrustedHosts* entries and AllowDomain* entries.
- Go to Administration > IMSS Configuration > SMTP Routing.
- Select the Message Rule tab.
- Under the Relay Domains section, click Export and save the relaydomains.txt file.
- Under the Permitted Senders of Relayed Mail section, click Export and save the permitted_senders_of_relayed_mail.txt file.
- Back up the current configuration.
- Go to Administration > Import/Export.
- Click Export and save the file.
- 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 - Import the lists back.
- Go to Administration > IMSS Configuration > SMTP Routing.
- Select the Message Rule tab.
- Under the Relay Domains section, click Import to get the relaydomains.txt file.
- Under the Permitted Senders of Relayed Mail section, click Import to get the permitted_senders_of_relayed_mail.txt file.
- Start IMSS SMTP service and confirm if the issue is resolved.
