Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - New spamfilter quarantine website
  FAQ FAQ  Forum Search   Register Register  Login Login

New spamfilter quarantine website

 Post Reply Post Reply
Author
jacksun View Drop Down
Newbie
Newbie


Joined: 24 February 2005
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote jacksun Quote  Post ReplyReply Direct Link To This Post Topic: New spamfilter quarantine website
    Posted: 08 April 2005 at 12:29pm
After much work and significant input from many on this forum (Milkshake,Desperado, and many others) I have put together a working quarantine website with most of the commonly requested functionality.
This includes password recovery, notification and reminder scripts (can be run automatically, not sure how yet), ability to turn auto notify and reminders on and off by users, select all messages, and all the basics in the original pages.
I have put these up for download in 1 zip file, with a short instruction sheet at http://www.inetsecurity.info.
They are the first news story and you must select "Read More" to get to the download link. 
 
Please note these are not supported by me or by Logsat. Questions about them may be posted to this forum, but there are no guarantees a resolution will be provided.
 
***New*** I forgot about the need to add 2 columns to tbllogins in the database notify and reminder both with default values of -1 (on). I have added this to the instructions.
Alternatively you can use the included spamfilter.mdb which I just added to the new download that has the new fields set.
*** end new ***
 
Enjoy and thanks to all who helped me with these!
Wayne
Back to Top
jacksun View Drop Down
Newbie
Newbie


Joined: 24 February 2005
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote jacksun Quote  Post ReplyReply Direct Link To This Post Posted: 11 April 2005 at 9:57am
Here is a VBS script to automatically run the auto_notify.asp and the auto_reminder.asp.
 
You need to change the URL and point it to your website and page as well as change the email address for errors to be sent to. Place these files in a directory that has execute permissions. You can rename them as you see fit.
 
Then use scheduler to run these scripts at whatever interval you want. When selecting the program to run hen setting up your schedule just use "Browse" and select the file you saved this code as.
 
Save the following as myscriptname.vbs where "myscriptname is whatever you like.
 
 
Option Explicit
On Error Resume Next
 
' Declare our vars
Dim objWinHttp, strURL
 
' Request URL from 1st Command Line Argument.  This is
' a nice option so you can use the same file to
' schedule any number of differnet scripts just by
' changing the command line parameter.
strURL = WScript.Arguments(0)
 
' Could also hard code if you want:
strURL = "http://yourserverurl/auto_reminder.asp"
 
' For more WinHTTP v5.0 info, including where to get
' the component, see our HTTP sample:
' http://www.asp101.com/samples/winhttp5.asp
Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5")
objWinHttp.Open "GET", strURL
objWinHttp.Send
 
' Get the Status and compare it to the expected 200
' which is the code for a successful HTTP request:
' http://www.asp101.com/resources/httpcodes.asp
If objWinHttp.Status <> 200 Then
 ' If it's not 200 we throw an error... we'll
 ' check for it and others later.
 Err.Raise 1, "HttpRequester", "Invalid HTTP Response Code"
End If
 
' Since in this example I could really care less about
' what's returned, I never even check it, but in
' general checking for some expected text or some sort
' of status result from the ASP script would be a good
' idea.  Use objWinHttp.ResponseText
 
Set objWinHttp = Nothing
 
If Err.Number <> 0 Then
 ' Something has gone wrong... do whatever is
 ' appropriate for your given situation... I'm
 ' emailing someone:
 Dim objMessage
 Set objMessage = Server.CreateObject("CDO.Message")
 objMessage.To       = "Your Name <youremail@domain.com>"
 objMessage.From     = "Your Name <youremail@domain.com>"
 objMessage.Subject  = "An Error Has Occurred in a " _
  & "Scheduled Task"
 objMessage.TextBody = "Error #: " & Err.Number & vbCrLf _
  & "From: " & Err.Source & vbCrLf _
  & "Desc: " & Err.Description & vbCrLf _
  & "Time: " & Now()
       
 objMessage.Send
 Set objMessage = Nothing
End If
Back to Top
sirrar View Drop Down
Groupie
Groupie
Avatar

Joined: 26 January 2005
Location: Denmark
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote sirrar Quote  Post ReplyReply Direct Link To This Post Posted: 24 April 2005 at 4:30am

Hi again

 

Thankyou very much for the "new" asp version.

I found no problems setting up the ASP.

I had problems getting the reminder and notify to run via a scheduled task though.

I'm running it all on a Windows 2003 server. In my case I had to put in two characters to get it to work. (Change version winhttprequest.5 to 5.1)

Diden't work at my place:

Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5")

Does work at my place:

Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5.1")



Edited by sirrar
Best regards...
Torsten Egebirk MCTIP: EA/SA - MCSE - MCSA - CCA - CCNA
Back to Top
RedSpyder View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote RedSpyder Quote  Post ReplyReply Direct Link To This Post Posted: 08 May 2005 at 1:50pm
Hi,

I think I am pretty close on getting this to work.  The only problem is when I register, I don't get an email with the password.  Could it be the 2 columns that need to be added?

If I need to add 2 new columns, what names should they be?  Also if I set them as text I can't set the default value of -1.

I think I am close.  Where do I troubleshoot login passwords not be sent out?

Thanks for the help...would definately pay for some help on this :)

RedSpyder
Back to Top
jacksun View Drop Down
Newbie
Newbie


Joined: 24 February 2005
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote jacksun Quote  Post ReplyReply Direct Link To This Post Posted: 09 May 2005 at 11:00am
Hi RedSpyder, are you running the trial version or a licensed version? If licensed check spam filter activity tab for these emails. There are a couple of places you need to ensure an email address is changed in the pages or spamfilter will reject the email with a "empty email from" message.
If you are running trial then that is why this is happening.
 
Wayne
Back to Top
RedSpyder View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote RedSpyder Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2005 at 2:52pm
Hi Jacksun,

Been using your program for a while.  The only problem we have is on the auto-notify.  Is there a way that once a message has been sent on the auto-notify to have some way that it won't send another reminder for the same message?

I turned off the instant notifciation because in a 12 hour time frame people would get a ton of messages all for the same spam message.

Am I doing anything wrong?

Thanks,

RedSpyder
Back to Top
jacksun View Drop Down
Newbie
Newbie


Joined: 24 February 2005
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote jacksun Quote  Post ReplyReply Direct Link To This Post Posted: 05 June 2005 at 2:50pm
Hi RedSpyder, we were having the same issue so your not doing anything wrong. It would take programming beyond my capabilities to do this. I think it would need to add a flag to the DB on the first message about new spam, then query for that flag during future reminders.
Once I educated our users they could turn this on and off by themselves in the quarantine interface it was better, and then I just changed the schedule to fire it off every hour instead of every 5 minutes on the auto notify. In most cases I think users have turned this off.
I left the reminder script at every 6 hours for now.
 
Wayne
 
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.207 seconds.