Spam Filter ISP Forums : deleting quarantined messages in the Access database

Spam Filter ISP Forums : deleting quarantined messages in the Access database https://www.logsat.com/spamfilter/forums/ Wed, 11 Mar 2026 09:09:51 +0000 Wed, 11 Jun 2003 23:35:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=850 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[deleting quarantined messages in the Access database : Abel, We can't officially...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=909&title=deleting-quarantined-messages-in-the-access-database#909 Author: LogSat
Subject: 850
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

]]> Wed, 11 Jun 2003 23:35:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=909&title=deleting-quarantined-messages-in-the-access-database#909 <![CDATA[deleting quarantined messages in the Access database : Roberto, Thanks for the quick...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=891&title=deleting-quarantined-messages-in-the-access-database#891 Author: Guests
Subject: 850
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,

]]> Wed, 11 Jun 2003 09:23:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=891&title=deleting-quarantined-messages-in-the-access-database#891 <![CDATA[deleting quarantined messages in the Access database : Hi Abel, The Access platform...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=889&title=deleting-quarantined-messages-in-the-access-database#889 Author: LogSat
Subject: 850
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

]]> Wed, 11 Jun 2003 08:33:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=889&title=deleting-quarantined-messages-in-the-access-database#889 <![CDATA[deleting quarantined messages in the Access database : Roberto, I was using .147. Now...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=888&title=deleting-quarantined-messages-in-the-access-database#888 Author: Guests
Subject: 850
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.

]]> Wed, 11 Jun 2003 08:22:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=888&title=deleting-quarantined-messages-in-the-access-database#888 <![CDATA[deleting quarantined messages in the Access database : Abel, Are you running the latest...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=877&title=deleting-quarantined-messages-in-the-access-database#877 Author: LogSat
Subject: 850
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

]]> Tue, 10 Jun 2003 19:21:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=877&title=deleting-quarantined-messages-in-the-access-database#877 <![CDATA[deleting quarantined messages in the Access database : I´m having problems withmy access...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=872&title=deleting-quarantined-messages-in-the-access-database#872 Author: Guests
Subject: 850
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.

]]> Tue, 10 Jun 2003 12:28:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=872&title=deleting-quarantined-messages-in-the-access-database#872 <![CDATA[deleting quarantined messages in the Access database : I take it that only works with...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=865&title=deleting-quarantined-messages-in-the-access-database#865 Author: Guests
Subject: 850
Posted: 09 June 2003 at 10:13pm

I take it that only works with the access database and not the SQL database.]]> Mon, 09 Jun 2003 22:13:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=865&title=deleting-quarantined-messages-in-the-access-database#865 <![CDATA[deleting quarantined messages in the Access database : George, Actually if you hit the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=860&title=deleting-quarantined-messages-in-the-access-database#860 Author: LogSat
Subject: 850
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

]]> Mon, 09 Jun 2003 18:34:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=860&title=deleting-quarantined-messages-in-the-access-database#860 <![CDATA[deleting quarantined messages in the Access database : Paul, Hitting the "delete"...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=858&title=deleting-quarantined-messages-in-the-access-database#858 Author: LogSat
Subject: 850
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

]]> Mon, 09 Jun 2003 18:33:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=858&title=deleting-quarantined-messages-in-the-access-database#858 <![CDATA[deleting quarantined messages in the Access database : Paul,It is done when the user...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=854&title=deleting-quarantined-messages-in-the-access-database#854 Author: Guests
Subject: 850
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.

]]> Mon, 09 Jun 2003 14:33:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=850&PID=854&title=deleting-quarantined-messages-in-the-access-database#854