Today I was reviewing my server and the Eximstats database dissapeared! but I see like a new design so I assumed that Cpanel/WHM was autoupdated.
I thought it was a mistake and i have to just repair the database, but the email delivery log still works, so I do not know where this information is being pulled from.
I tried repairing the database and the repair tool deletes the database! Is like a new structure!
I am wondering if anybody knows if there is any version of exim that does not use eximstats database, if the information is pulled from a different database or file, and how to read again this database.
I need that database as I had an app developed using this database.
Thanks for your help!
2
Answers
The eximstats database structure is as follows (the default tables as per cPanel/WHM install):
This is taken from a WHM 11.52 server. It seems that in the latest cPanel/WHM version the database is not there anymore. I suggest you open a support ticket to cPanel and ask.
Meanwhile you can create the database from the table structure I have provided. Not sure if exim will log anything into it though since if they removed the database then the exim configuration could have changed and this could lead in no logging to the database.
Since version 64, cPanel moved eximstats data from MySQL to SQLite3. The new database is located in /var/cpanel/eximstats_db.sqlite3 and the tables are slightly changed. The time is now recorded as unix timestamps and a few things are gone (like the unique ids which were mostly pointless anyway). Hope this helps.