Print Page | Close Window

Error on Site for removing IP from SFDB

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5907
Printed Date: 31 July 2025 at 11:18am


Topic: Error on Site for removing IP from SFDB
Posted By: kp4711
Subject: Error on Site for removing IP from SFDB
Date Posted: 07 December 2006 at 2:53pm

There occur an error if you try to remove an IP from the SFDB-Database:

 Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/sfdb/why.asp, line 329

 


Replies:
Posted By: kp4711
Date Posted: 07 December 2006 at 3:07pm

oky the timeout was temp.

But on the next site I read this:
*******************************************

Remove my IP address from SFDB

Your IP address 81.90.194.14 is currently listed in the SFDB. To remove it, you will need to locate in your mail server logs one of the emails that caused your server to be listed.

Please note that unless you have solved the root cause that resulted in the blacklisting, it may be a matter of just minutes before your IP is again added to the SFDB. Should this occur, you will have to thru the delisting process from the start.

http://www.logsat.com/sfdb/why.asp?CT=1&IPSuffix=14#SFDBDetails - Below you will find further details on why your email was blocked. There may be multiple reasons of why this occurred.

To de-list your IP, you will have to enter the exact IP address of where this email was sent. Below you will find information that will help you locate the email in your logs. If your logs do not have the timestamp and IP addresses of emails that you sent, you will not be able to proceed any further.

Please find in your mail server logs the following email. Then enter the complete IP address of where the email sent:

Date / Time sent: (local time in Orlando, Florida)
Partial IP address where the email was sent: aaa.bbb
************************************************

In the logs of this Server (it is a SPAMFILTER ISP Server) are no entry with:
Date / Time sent: (local time in Orlando, Florida)
                           ^^^^^^^^^^^^^^^^^^
Partial IP address where the email was sent: aaa.bbb
                                                             ^^^^^^^^^^

I think there ist a mistake in the generation of this site.

Helpfull is: Number of user who made an entry in the SFDB for the IP-Address.

The other answer is that it can be only an NDR generated by logsat SPAMFILTER ISP. I think that is not a good idea to insert IP-Adresse in the SFDB where a SPAMFILTER ISP is running!

 

 

Posted By: LogSat
Date Posted: 07 December 2006 at 5:28pm
SpamFilter usually does not send NDR's. When SpamFilter rejects an email because it's spam, it outputs a 5xx error code to the sender's server, so in reality it is the sender, not SpamFilter, that sends out the NDR email.

In regards to checking SpamFilter's logfiles for the data above, please note that usually SpamFilter is implemented to work as an incoming SMTP server only, thus it only receives emails, it does not send them. It's in your main SMTP server's log that you'd have to find this information.

If you did implement SpamFilter so that it's used as an "outgoing SMTP server", even in this case, SpamFilter will never send emails to the internet directly. SpamFilter will always forward emails for delivery to your destination SMTP server. In this case too, you will thus need to check your main mail server's logs for the data requested by the site.

The SFDB makes no exceptions on who is listed. Our own server ended up being blacklisted once, and rightfully so as we were indeed spamming (not on purpose of course..).


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: kp4711
Date Posted: 08 December 2006 at 12:44pm

I know that SPMAFILTER ISP dont send any EMAIL directly to the internet. This was not the reason for my question.

Sorry for misunderstanding because my english is very bad.

The question was that the Site for removing an IP display the text in my last Post.

I dont have logfiles with the following entrys:

Date / Time : (local time in Orlando, Florida)
and IP-Adresse aaa.bbb

I think there mus be more detailed Information in the site like the komplöete IP-Adresse or Hostname where the email is sending to

 

Posted By: LogSat
Date Posted: 08 December 2006 at 1:51pm
There has been a long debate here as to whether or not make available the complete IP address in the above page. We decided against it, aas showing the full IP could cause the admin of the blocked site to simply look up and call the admin of the IP that received the spam and complain. For privacy concerns, we thus opted to hide the full IP and the class C, and just leave the first two octets. Those two octets, along with the time of the spam, should be enough for the admins of the blocked site to locate the right entry in their firewall and/or mail logs. Yes, then they will have the full IP, but seing that they did their homework to locate the problem, we'll feel more confident that they will do so with the willingness to really find the problem and solve it, and that they won't be contacting the reporter.

If you're having trouble locating the data because you are not performing any logging, then you'll need to start enabling logging so you can capture it. Without it, you as an admin will have a hard time locating problems originating from your network. If you are logging, but cannot locate the data in your logs, email us at support at logsat dot com, we'll provide you with more complete IP information and more examples (assuming your IP is still blacklisted  - if it stopped spamming it will already have been removed automatically).


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: kp4711
Date Posted: 11 December 2006 at 12:39pm

You don't understand me:

there is NOT displayed any part of the IP-Address only the phrase

"aaa.bbb"

on the site.

Posted By: kp4711
Date Posted: 11 December 2006 at 12:46pm

UPDATE:

YEAH I have seen, you have patched and solve this problem.

 

THANKS

 

Posted By: LogSat
Date Posted: 11 December 2006 at 7:54pm
..actually we have not made any changes to the website, but we did perform an update of our database yesterday at around 11pm GMT. In theory the delisting website should have not been affected, but it was a strange coincidence. Could you please email us at support at logsat dot com with the IP address you were trying to delist, so we can verify if there was a problem with the database yesterday?

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window