Category: Exim

[Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql

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

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

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