Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Feature for the next new version?
  FAQ FAQ  Forum Search   Register Register  Login Login

Feature for the next new version?

 Post Reply Post Reply
Author
Steve Woolf View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Steve Woolf Quote  Post ReplyReply Direct Link To This Post Topic: Feature for the next new version?
    Posted: 08 September 2003 at 2:30pm

Hi Roberto,

In an upcoming version of SFISP can you add a filter for the reply-to field so that
emails can be blacklisted by the this field. I have notice that a lot of emails have
common key words in the reply-to field.

Thanks
- Steve.

PS, I am running version 1.2.0.201 on 2k sp 4, Mdac 2.7sp1, mysql odbc driver 3.5 and the memory usage seams to be stable.

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2003 at 5:50pm

Steve,

Thanks for the request. We can add it to the list of fields currently being checked by the existing keywords filter. That should be simple enough that we can probably include it in the next build to be released within a few days.

Roberto F.
LogSat Software

Back to Top
steve woolf View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote steve woolf Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2003 at 5:56pm

Thanks Roberto.

Instead of the keyword filter could you add it to the from-email filter?

Thanks again.

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2003 at 6:38pm

Unfortunately that is not as simple as it seems. The "mail from" is checked as soon as the remote server sends the MAIL FROM command, before any data is sent. The "Reply-To" header is sent with the data, so the "mail from" filter does not know about the "Reply-to" header yet.

Changing the inner workings of this behavior is not something we want to undertake at the moment, so for now the most we can do is to have the regular keyword filter scan for that header.

Roberto

Back to Top
steve woolf View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote steve woolf Quote  Post ReplyReply Direct Link To This Post Posted: 10 September 2003 at 9:50am

Okay, I did not know it was that complicated of a change.

I will be watching for the next build.

Thanks

Back to Top
dbr1ght View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote dbr1ght Quote  Post ReplyReply Direct Link To This Post Posted: 11 September 2003 at 9:49am
How about an option to sort quarantined email by domain (after the @)
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: 11 September 2003 at 11:07pm

This is stuff that can be done through the web using a little asp code to make the queries. If SpamFilter keeps getting bigger due to all of the wish list items it is going to get more system intensive and the price for it is going to have go up due to the cost of addtional programming and development.

If I were to make a wish list add on it would be that all of the admin GUI be through the web. This would get around the issue of either having to use terminal services or some other third party remote access program. Since a good part of the program is using web/database already it wouldn't be too far off to go all the way and just make the service with out the gui or make it work both ways. Many of the current server applications for ISP's have web interfaces. Going with a web GUI will be a step in the right direction towards a multi-platform SpamFilter.

Just my two and a half cents worth.

 

g

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: 12 September 2003 at 12:55am

Daniel,

I tend to agree with George below.  As to sorting, all that can be done in the ASP code. In you "ListSpam.asp" file, You can expand the sort options to any extent you want ...

Example:

 Select Case order_By
  Case "EmailTo"
   order_By = "EmailTo, MsgDate, Subject, EmailFrom, RejectDetails"
  Case "Subject"
   order_By = "Subject, MsgDate, EmailFrom, EmailTo, RejectDetails"
  Case "EmailFrom"
   order_By = "EmailFrom, MsgDate, EmailTo, Subject, RejectDetails"
  Case "Domain"
   order_By = "Domain, MsgDate, EmailTo, Subject, RejectDetails"
  Case "MsgDate"
   order_By = "MsgDate, EmailFrom, Subject, EmailTo, RejectDetails"
  Case "RejectDetails"
   order_By = "RejectDetails, MsgDate, EmailFrom, Subject, EmailTo"
  Case "DESC-MsgDate"
   order_By = "MsgDate DESC, EmailFrom, Subject, EmailTo, RejectDetails"
 End Select


Then, one query may look like the following ... NOTE the first line ... it sorts like you asked about:

 If (Field = "tofield") Then
  SQL = "SELECT SUBSTRING(EmailFrom, CHARINDEX('@', EmailFrom) + 1, 100) AS Domain, QuarID, EmailFrom, Subject, MsgDate, MsgID, RejectDesc,  RejectDetails, EmailTo "
  SQL = SQL & "FROM tblQuarantine, tblRejectCodes "
  SQL = SQL & "WHERE EmailTo LIKE '%" + Replace(SearchQuery, "'", "''") + "%' "
  SQL = SQL & "AND (Deliver <> 1) "
  SQL = SQL & "AND (Expire <> 1) "
  SQL = SQL & "AND (tblQuarantine.RejectID = tblRejectCodes.RejectID) "
  If SearchSpan = 1 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-1,getdate())) "
  End If
  If SearchSpan = 4 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-4,getdate())) "
  End If
  If SearchSpan = 8 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-8,getdate())) "
  End If
  If SearchSpan = 24 Then
   SQL = SQL & "AND (MsgDate >= DATEADD(hour,-24,getdate())) "
  End If
  SQL = SQL & "ORDER BY " & order_By
  Set rs = con.Execute(SQL)
  RecordCount = rs.RecordCount
 End If


I have a lot more going on so this will not work directly in you code but you can get the idea.

Dan S.

Back to Top
swoolf View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote swoolf Quote  Post ReplyReply Direct Link To This Post Posted: 02 October 2003 at 9:26pm

Hi Robert,

Did you and your team get a chance to include my request.

Thanks

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 03 October 2003 at 12:30am

Steve,

That feature has been added to the new 2.0 version that will hopefully be released in a month or two. It's not yet available in the 1.2.x builds.

Roberto F.
LogSat Software

Back to Top
steve woolf View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote steve woolf Quote  Post ReplyReply Direct Link To This Post Posted: 03 October 2003 at 10:01am
Thanks
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.242 seconds.