MailWatch database issue, no message information in web interface.

Report bugs and workarounds
Post Reply
User avatar
bikertrash
Posts: 49
Joined: 03 Feb 2016 12:53
Location: San Diego, CA
Contact:

MailWatch database issue, no message information in web interface.

Post by bikertrash »

EFA-3.0.2.6

This VMWare appliance has been running beautifully for many years. This issue did crop up though after an update a while back but now it looks like it's come back. Filtering is still working just fine, virus blocking and all. But when trying to view message information from within the MailWatch web interface nothing is shown other than (see attached) :
01-26-2019-EFA-Filter.jpg
01-26-2019-EFA-Filter.jpg (121.71 KiB) Viewed 4318 times
Received on:
Received by:
Received From:
(with the pertinent information of course)

When trying to looking at the database and table permissions from Webmin, this error is thrown: DBI connect failed : Access denied for user 'mailwatch'@'localhost' to database 'mysql'

I have seen this in the past after an update (as I mentioned above) and if I recall it was a pretty easy fix. But right now, not even the root user has access to modify the database or add user permissions to the database or the tables or even dump it to a flat file to restore to a new deployment. The link that is usually embedded for the recipient to report the message as Spam is also not being appended to incoming mail... even though it appears that it is being checked correctly.

Does this sound like a familiar issue to anyone? If so... what was the fix?
"If it ain't broke, it needs a lot more fix'n."
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: MailWatch database issue, no message information in web interface.

Post by shawniverson »

Could it be the GeoIP issue?

viewtopic.php?f=13&t=3311
User avatar
bikertrash
Posts: 49
Joined: 03 Feb 2016 12:53
Location: San Diego, CA
Contact:

Re: MailWatch database issue, no message information in web interface.

Post by bikertrash »

Hi shawniverson,

Wow. I just searched that log file... and am seeing this:

PHP Notice: Uninitialized string offset: 1 in /var/www/html/mailscanner/lib/geoip.inc on line 1757

But reading that thread... I'm still not clear on the solution. If I need to upgrade to 4.x, I'm afraid I'll lose all the history since I can't dump / backup the database.

If all else fails though... it's not really that big of a loss to me to just deploy a new appliance and start over.
"If it ain't broke, it needs a lot more fix'n."
User avatar
bikertrash
Posts: 49
Joined: 03 Feb 2016 12:53
Location: San Diego, CA
Contact:

Re: MailWatch database issue, no message information in web interface.

Post by bikertrash »

Um... never mind... I think...

I removed the GeoIP.dat file from two locations that it showed up and *poof*... problem solved.

Thank you! You made my day... :D
"If it ain't broke, it needs a lot more fix'n."
Arwen_1988
Posts: 1
Joined: 15 Feb 2019 11:32

Re: MailWatch database issue, no message information in web interface.

Post by Arwen_1988 »

bikertrash wrote: 26 Jan 2019 17:36 Um... never mind... I think...

I removed the GeoIP.dat file from two locations that it showed up and *poof*... problem solved.

Thank you! You made my day... :D

Saved my ass xD
Thank you so much :) If you ever come visit Bulgaria i`ll buy you two beers ^^
Post Reply