New spamfilter quarantine website |
Post Reply ![]() |
Author | |
jacksun ![]() Newbie ![]() Joined: 24 February 2005 Status: Offline Points: 31 |
![]() ![]() ![]() ![]() ![]() 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
|
|
![]() |
|
jacksun ![]() Newbie ![]() Joined: 24 February 2005 Status: Offline Points: 31 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
sirrar ![]() Groupie ![]() ![]() Joined: 26 January 2005 Location: Denmark Status: Offline Points: 44 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
RedSpyder ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
jacksun ![]() Newbie ![]() Joined: 24 February 2005 Status: Offline Points: 31 |
![]() ![]() ![]() ![]() ![]() |
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
|
|
![]() |
|
RedSpyder ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
jacksun ![]() Newbie ![]() Joined: 24 February 2005 Status: Offline Points: 31 |
![]() ![]() ![]() ![]() ![]() |
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
|
|
![]() |
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.207 seconds.