Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - New Beta - SQL2000
  FAQ FAQ  Forum Search   Register Register  Login Login

New Beta - SQL2000

 Post Reply Post Reply
Author
George S. Forsyth View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote George S. Forsyth Quote  Post ReplyReply Direct Link To This Post Topic: New Beta - SQL2000
    Posted: 03 June 2003 at 3:32am

I have the new beta running and the .asp pages working. I noticed that in the admin interface, there is no check all and delete selected options in the Quarantine window. I think I would still like to have them so I could clear the Quarantine directory of emails that were sent to email accounts that are no longer valid and also users who don't use the web pages to clear their spam emails.

All in all, it is great. Once you get everything working it seem to run faster then before. My SQL server is only has 3% more load then before so performance is good.

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2003 at 11:19am

George,

I may be off base on this one but I believe the final intention is to use a web interface for the Database maintainance.  I am working on that for our install now.  My bigest problem is trying to decide  what, as an administrator, I want to see and how many per page.  We already have around 10,000 in the DB as of only 2:30 this morning! At this moment, I have to expire time set to 5 days so the list will get HUGE!

Dan S.

Back to Top
George View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote George Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2003 at 2:30pm

Dan,
I am sure you are correct about the intention, but when you have email that is quarantined that belongs to address's that don't exist it would be nice to be able to remove them earlier then the expire time. I have mine set to 3 days and have told my clients to check it at least once every two days. Had I not made a big booboo last night and not configured all my other domains to point to the new filtering server my DB would be over 5000 by now. Since I just fixed my DNS booboo it is climbing fast.

I guess I should wait on drinking the Smirnoff's until after everything is working ;^)

 

George

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2003 at 3:11pm

George,

I can't think of anything that would justify a delay in drinking the Smirnoff's (or in my case, the St. Pauli Girl).

I completely agree on the having the option to "Manually Prune" the undeliverables out but I spend a lot of time trying to write scripts to do as much of my general server "cleanups" as possible because there are not enough hours in the day to watchdog everything.  I just set my expire to 5 days and am going to see what size the DB stabalizes at.  (HEY ROBERTO...ADD A SPELL CHECKER TO THIS SO I DON'T LOOK AS BAD AS I DO! :) ).  I started collecting at about 2:30AM EDT and am up to about 14,000 messages with a DB size of 100Meg.  This seems fairly tame bur one mail bomb could change the whole picture. I still think a web admin is the way to go for my setup.

Regards

Dan

Back to Top
George View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote George Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 3:55am

Well it has been 24 hours and 13,000 blocked emails later. The SQL quarantine is great. It is so much faster then the old way. What used to take an hour to scroll through only take a few minutes now.

Since I moved everything over to the new server this Filtering proxy rocks.

Wish list items.

1) Ability to delete multiple emails in the asp page for the client. I have had a few requests for that already. Clients get so many junk emails that they don't want to have to delete each one (one at a time).

2) Reject details displayed in the asp page. I will see about doing this myself. Though my asp coding is not the greatest. Guess I'll drink a few Smirnoff's and see how creative I can get. :^) yeehaw

Back to Top
George View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote George Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 3:19pm

To modify the listspam.asp to show the keywords and other details is real easy. It only takes adding two table data fields to the page and you get the  reject details. I would post it here but don't think it will display correctly. If anyone wants the changed page send me an email at george@clipboard.com and I'll send it to you. I am sure that LogSat would add it at some time since a lot of users will want it.

g

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.102 seconds.