Error on Site for removing IP from SFDB |
Post Reply 
|
| Author | |
kp4711 
Newbie 
Joined: 04 December 2006 Location: Germany Status: Offline Points: 33 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Error on Site for removing IP from SFDBPosted: 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
|
|
 |
|
|
kp4711
Newbie
Joined: 04 December 2006 Location: Germany Status: Offline Points: 33 |
Post Options
Thanks(0)
Quote Reply
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 SFDBYour 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. 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) In the logs of this Server (it is a SPAMFILTER ISP Server) are no entry with: 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!
|
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4105 |
Post Options
Thanks(0)
Quote Reply
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..). |
|
|
|
|
kp4711
Newbie
Joined: 04 December 2006 Location: Germany Status: Offline Points: 33 |
Post Options
Thanks(0)
Quote Reply
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) 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
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4105 |
Post Options
Thanks(0)
Quote Reply
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). |
|
|
|
|
kp4711
Newbie
Joined: 04 December 2006 Location: Germany Status: Offline Points: 33 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
kp4711
Newbie
Joined: 04 December 2006 Location: Germany Status: Offline Points: 33 |
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2006 at 12:46pm |
|
UPDATE: YEAH I have seen, you have patched and solve this problem.
THANKS
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4105 |
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
Topic Options|
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.195 seconds.