Print Page | Close Window

deleting quarantined messages in the Access database

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850
Printed Date: 13 March 2025 at 1:53pm


Topic: deleting quarantined messages in the Access database
Posted By: Guests
Subject: deleting quarantined messages in the Access database
Date Posted: 09 June 2003 at 1:20pm
I just loaded the beta version, and I don't see how to delete quarantined messages from the database? Am I missing something easy?


Replies:
Posted By: LogSat
Date Posted: 09 June 2003 at 1:27pm

Marking an item for deletion simply tags it as such in the database. Every hour there is a process that goes thru all tagged items and deletes them (along with all emails whose retaining period has expired).

Roberto Franceschetti
LogSat Software

Posted By: Guests
Date Posted: 09 June 2003 at 2:03pm
How would I mark it for deletion? I don't see a button for that, or can't double or right-click on the entry.

Posted By: Guests
Date Posted: 09 June 2003 at 2:33pm

Paul,
It is done when the user uses the web client. It is not done from the admin interface.

g

Posted By: LogSat
Date Posted: 09 June 2003 at 6:33pm

Paul,

Hitting the "delete" key on the keyboard will do the trick. We will add a note to make it more user-friendly.

Roberto Franceschetti
LogSat Software

Posted By: LogSat
Date Posted: 09 June 2003 at 6:34pm

George,

Actually if you hit the "delete" key on the keyboard the record will be erased. We need to work more on the GUI grid display as it's not that user-friendly...

Roberto F.
LogSat Software

Posted By: Guests
Date Posted: 09 June 2003 at 10:13pm
I take it that only works with the access database and not the SQL database.

Posted By: Guests
Date Posted: 10 June 2003 at 12:28pm

I´m having problems with my access database. Its set to store it for 1 day and the itens are still there. Pressing del doesnt work too. More than 24 hours has passed and Im still have older (more than 1 day) and deleted itens in the quarantine.

What Am I doing wrong here ?

 

Thanks,

Abel.

Posted By: LogSat
Date Posted: 10 June 2003 at 7:21pm
Abel,
 
Are you running the latest beta build .148? There was a bug in .147 that caused it not to delete emails and not to deliver the registration password to end-users who registered to access the quarantine.
 
Roberto Franceschetti
LogSat Software

Posted By: Guests
Date Posted: 11 June 2003 at 8:22am

Roberto,

I was using .147. Now I have .148 running here. And the quarantine is deleting messages older than 1 day. But the deleted messages (pressing the del key) are still there. I have some questions/suggestions about the quarantine and the number of days to store:

1) The quarantine itens are deleted, but the size of the file (access database) keep growing. Why this ?

2) The delete process seems to me to run only once per day, and not at each hour. I have a quarantine item dated 10/06/2003 00:23:07 and its 11/06/2003 09:20 AM here.

3) Can this delete process create an entry in the logs telling us, at least, how many messages were deleted and when ?

4) Can we have a "FLUSH" button to really delete the itens from the quarantine ? Like the one that we used to have in the version without database.

Thanks and keep the good work,

Abel.

 

Posted By: LogSat
Date Posted: 11 June 2003 at 8:33am
Hi Abel,
 
The Access platform is not very efficient, Microsoft does not do a very good job in recovering unused space when records are deleted, that is why they offer a "Compact database" function to shrink down the database. Unfortunately there is no solution there that we can think of, other than manually compacting it periodically. Other DB platforms (SQL/MySQL/Oracle) work much more efficiently (note that MySQL is free!).
 
I'll be checking on the delete process again. We're pretty sure it is done hourly, but bugs are always present. I'll make sure to test with Access, as to be honest most testing we do is done with MS SQL and MySQL.
 
Good ideas in having a log entry with the num of records delete, same with the "Delete NOW" button. We'll be adding them if not in the next build that addresses some access violation, in the one after.
 
Roberto Franceschetti
LogSat Software

Posted By: Guests
Date Posted: 11 June 2003 at 9:23am

Roberto,

Thanks for the quick answers.

We have 2 problems here. The first one is that I´m not a database expert so using access was the best option for me. The second one is that our database plataform is IBM-DB2, and I need to talk to the experts here about if it will be possible to use the quarantine DB into DB2. Does quarantine DB work with MSDE ?

Do you have any documentation about setting this using databases ?

Thanks again,

 

Posted By: LogSat
Date Posted: 11 June 2003 at 11:35pm

Abel,

We can't officially support DB2 yet, however SpamFilter's code is very generic and should work with most databases out there, as long as their OLE or ODBC drivers provide the capabilities SpamFilter needs. If your DBAs are able to port the SQL/Oracle/MySQL or Access in DB2, and DB2 supports, either natively or thru use of triggers, auto-number colums, it may work.

We have not tested MSDE yet, however since it's based on SQL server it may work without problems. Please let us know if it does or not if you try!

Roberto F.
LogSat Software


Print Page | Close Window