Portal Home > Knowledgebase > Customer support > Exim mail server crash eximstats/sends database table
If you encounter high volumes of outgoing mail from one of the accounts on your server and find that SMTP has stopped logging mail stats correctly, or that SMTP is failing, try logging into your phpmyadmin as root and checking the eximstats/* tables. You may find that one or more tables report that they have crashed which causes exmin to fail eventually. Emptying the database table will clear the crash error but won't preserve the data in it but if you can't access the table(s) anyway the data is of no use.
One problem that can happen is that these tables crash as a result of high spam activity on the server, I would suggest that you check for problems there before proceediing to more drastic measures. Errors containing ${if eq{$originator_uid}{${perl{user2uid}{nobody}}}{1}{0}} appearing in the SMTP mainlog might also be associated with this issue.
Also make sure that the SMTP restriction: Restrict outgoing SMTP to root, exim, and mailman (FKA SMTP Tweak) is set so that external servers cannot send mail from accounts on your server accounts as this is a common way for spammers to send thousands of emails pertaining to be from your server which might also result in your server being blacklisted and unable to send email to common domains such as hotmail.com etc.
+44
