Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine Issue
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine Issue

 Post Reply Post Reply
Author
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine Issue
    Posted: 01 February 2010 at 9:40pm
Wade,

The non-receipt of support emails is (if the address you specified above is the one you sent the emails to) due to the incorrect domain name - we're at logsat.com, not logstat.com. If you can send the zip (or use our FTP site if larger than 8MB), we'll look at the logs to see what happened. Please also include your SpamFilter.ini file so we can look at your connection string.

As a side-note, with SQL Express you're only postponing the max size issue experienced with MS Access. SQL Express databases are limited to 4GB in size, and that can be reached quite easily especially if logging transaction in the database model (FULL recovery mode). If you're looking for a free database solution, we'd strongly recommend using MySQL. It's not as simple to use and configure as MS SQL Server, but it does do the job almost as well.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Wade View Drop Down
Newbie
Newbie


Joined: 26 January 2010
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wade Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2010 at 7:25am
I've just emailed support@logstat.com, but will paste my email here too as before it wasn't recieved.
 

Hi,

 

I’ve emailed previously regarding an issue with our Spam Filter, The problem is that our Quarantine DB is not active. From previous emails with Logstat it appears my problem is that MDB file is over 2GB therefore is stopping any information being written. I have decided that instead of using MS Access I will setup SQL express with a DSN Connection String.

 

I have tested the connection in step one which is fine, however when I come to Create / Check database tables it does the following.

 

please wait...

tblQuarantine - not found

tblMsgs - not found

tblRejectCodes - not found

tblLogins - not found

tblServers - not found

Some Database tables not found - recreating...

 

This process just sits there and doesn’t do anything more than the above, I did see a similar problem which was down to the ODBC driver which I have updated.

 

Can you shed any light on what steps I need to follow to get the above fixed?

 

Thanks

 

Wade

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2010 at 9:42am
Wade,

We did not see your email arrive. I searched our quarantine for an email from the domain you used to register on this forum, but could not find it there either. Are you certain the email was not larger than 8MB in size?

For the database, the safest way is to clear the existing quarantine database. To do so, open the database using Microsoft Access, open the table "tblQuarantine", select all of the records, and click on "Edit - Delete" to delete them. Then (always from within Access) click on "Tools - Database Utilities - Compact and Repair Database". This should compact the database reducing it to a few MB in size. If you receive a sharing error during this procedure, you may need to stop SpamFilter during the compact procedure.

Once this is done, you should greatly decrease the number of days for which SpamFilter will archive quarantined emails as to not reach the 2GB limit again. We recommend using either Microsoft SQL Server or MySQL for production environments when archiving emails as it's rather easy to reach that limit with Access.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Wade View Drop Down
Newbie
Newbie


Joined: 26 January 2010
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wade Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2010 at 7:38am
Hi Logstat,
 
I took your advice in emailing however i'm yet to get a reply.
 
I have checked the MDB file which i have noticed is over 2GB, so i imagine this is the cause of it not being able to run.
 
What do i need to do in an attempt to get this backup and running? Create a blank MDB file and put it into the same DIR? or run the compact/repair utility?
 
Thanks in advance
 
Wade
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 27 January 2010 at 10:22pm
Wade,

Have you tried to perform a "Compact and Repair" on the database by opening the database file with MS Access itself? Could you please also let us know what the file size is? Access has severe limitations on the table sizes it can use, and the database file usually cannot be larger than 2GB.

If neither of these items are an issue, could you please zip and email us your SpamFilter's activity logfile for one day, including the SpamFilter.ini file and the UDL file you are using? If the zip file is over 8MB, I'll send you a PM with the FTP credentials for our website.

Please contact us directly via email at support at logsat.com as we'll be able to help faster than thru the forums.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Wade View Drop Down
Newbie
Newbie


Joined: 26 January 2010
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wade Quote  Post ReplyReply Direct Link To This Post Posted: 27 January 2010 at 4:32am
Hi Logstat,
 
Thanks for the reply, it appears we are using MS Access. I have checked the UDL to make sure the connection can be made which it can without any problems.
 
Hope this helps, If you need any other info let me know.
 
Thanks
 
 
 
 
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 26 January 2010 at 10:58pm
Wade,

Without knowing more about your configuration, we'll take a guess on the database platform being MySQL. If so, can you try doing a "Repair table" on the tblQuarantine and the tblMsgs tables?

If this is a wrong assumption, can you please let us know what DB platform you're using?
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
Wade View Drop Down
Newbie
Newbie


Joined: 26 January 2010
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Wade Quote  Post ReplyReply Direct Link To This Post Posted: 26 January 2010 at 6:01am
Hi,
 
I've been monitoring our SPAM Filter and have come across the Quarantine DB is not running.
 
I have tested the connection string within SPAM Filter and it connect's to the database without any problems by following the three steps in the settings/database tab, I have noticed in the Activity log which states the following message.
 
(3044) Error occurred during TAddToQuarantineThread when accessing the quarantine database: Cannot open database ''.  It may not be a database that your application recognizes, or the file may be corrupt ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)
 
Apologies as i imagine the description i've given isn't exactly the best.
 
If you require any other information let me know and i'll try and get it uploaded ASAP.
 
Thanks in Advance
 
Wade
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.062 seconds.