The following error was generating to client related to eximstats sqlite database [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error ((XID f82uy4) The system received an error from the “SQLite” database “/var/cpanel/eximstats_db.sqlite3”: SQLITE_CONSTRAINT (UNIQUE constraint failed: smtp.sendunixtime, smtp.msgid, smtp.email, smtp.deliveredto, smtp.router)): INSERT INTO smtp (sendunixtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser,deliverydomain,counteddomain,countedtime,countedhour) VALUES(‘1575787697′,’1idqMb-00hujj-Ah’,’root@server.bunny.tech’,’2′,’dovecot_virtual_delivery’,’0′,’localhost’,’127.0.0.1′,’queue@bunny.tech’,’virtual_user’,’bunny’,’bunny.tech’,”,’0′,’0′) [9035] [2019-12-17 17:47:50] [Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL … Continue reading [Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql
Category: Exim
email ip does not change in /etc/mailips issue
Firstly found that there was lsattr set for the file. Tried by removing and resetting the lsattr but no use. Fix Found that in whm exim config settings this should be like this Send mail from account’s dedicated IP address Off Reference /etc/mailhelo for outgoing SMTP HELO Off Reference /etc/mailips for outgoing SMTP connections On … Continue reading email ip does not change in /etc/mailips issue
User is not authorized for Mail (Host: x.x.x.x)”. + horde
Fix The issue was that the dovecot was not working.
To check who has deleted the email account in a cPanel server
This can be easily understood from the cPanel access logs. grep domain.com /usr/local/cpanel/logs/access_log | grep delpop
Issue with cPanel not listing email accounts
Fix In these cases cd /home/user/.cpanel Remove the following files in it rm -rf email_accounts.cache email_accounts_count email_accounts.yaml email_accounts.yaml.lock Login to cPanel again The cache file will be created automatically
To delete the mails older than 30 days
/usr/bin/archivemail --quiet --delete --days 30 /home/{USER}/mail/inbox
Error : lowest numbered MX record points to local host.
While sending mails from the email account following error was getting generated and mail sending was getting failed. Fix Remove the entry for the domain from /etc/remotedomains and add the domain in /etc/localdomains
Server returned error: “[AUTH] Plaintext authentication disallowed on non-secure (SSL/TLS) connections.”
Fix Please check whether "disable_plaintext_auth= no" in /etc/dovecot/dovecot.conf to correct the issue.
exim issue : ratelimit database not available
Fix Please remove the following corrupted files from exim database and restart exim. removed `/var/spool/exim/db/ratelimit’ removed `/var/spool/exim/db/ratelimit.lockfile’ removed `/var/spool/exim/db/retry’ removed `/var/spool/exim/db/retry.lockfile’ removed `/var/spool/exim/db/wait-dk_remote_smtp’ removed `/var/spool/exim/db/wait-dk_remote_smtp.lockfile’ removed `/var/spool/exim/db/wait-remote_smtp’ removed `/var/spool/exim/db/wait-remote_smtp.lockfile’ restarted exim
Email issue : retry time not reached for any host after a long failure period
This can be fixed by removing some corrupted files from exim db which will be generated automatically. Fix cd /var/spool/exim/db rm -f retry retry.lockfile rm -f wait-remote_smtp wait-remote_smtp.lockfile service exim restart