deleting quarantined messages in the Access database |
Post Reply ![]() |
Author | |
Paul ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() 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?
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
Paul ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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.
|
|
![]() |
|
George ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
Paul, g |
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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 ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
|
George ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
I take it that only works with the access database and not the SQL database.
|
|
![]() |
|
abel ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
Abel ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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.
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
Abel ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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,
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.236 seconds.