By ivanjs on

Was testing the spam module (incredible by the way-catches all kinds of crap that was getting on a daily basis), by typing in spam words in a comment, submitted it, and then it told me my IP address had been banned due to attempting to post spam! I'm the administrator, lol.

Anyway, I didn't see anywhere in the entire administrator part where to unban my own IP address. ANyone now where that is? I'm so embarassed... :)

Comments

Ander5’s picture

Ander5 commented

Try using an anonymous proxy server to change your IP, then log in and un-ban your IP :]

ivanjs’s picture

ivanjs commented

Well, logging in isn't the problem-I can login fine, but if I try to post any comments, I get the "You posted spam and therefore are banned" message. So it's nice that it's working so well, but there's no obvious place to unban anyone.
Anyone else?

Geekronomicon
Lyzrd Stomp

ivanjs’s picture

ivanjs commented

*bump*

Geekronomicon
Lyzrd Stomp

sepeck’s picture

sepeck commented

This is kind of funny. I'm half tempted to install the spam module to see what it is you're looking at. I supose mentioning test sites at this point wouldn't be helpful?

If you have access to the database, you could look at where your ip address is stored and delete that entry/row, after suitable backup of course.

-sp
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

ivanjs’s picture

ivanjs commented

Sorry, the site is:
Geekronomicon

I looked in all the MySQL spam tables but never saw any record that said "Banned IP addresses", though I found the spam log which showed where I attempted to enter spam as a test.

I'm comfortable with MySQL, so if I could find the exact place there I could do that. However, it just seems to me that if someone provided a feature in their software (i.e. Spam Module) to Ban a user, there should be a way to UnBan a user since it says "if you feel you've been banned by mistake, contact the system administrator".

Yeah like that would help, lol.

Thanks for the reply.
J.

drupalec-1’s picture

drupalec-1 commented

ever find a solution?
-----
Drupal ecommerce, at www.drupalecommerce.com is a new site written using language that Drupal beginners and intermediate users can understand. It has about 300 unfinished pages. 2 tutorials for views module under "Modules"

AjK’s picture

AjK commented

To get going again, just switch the module off in Admin >> Modules

I had a quick look for the module (as I don't use it myself) and saw there's a new improved version 2.0 spam module. Which are you using? The older unsupported one or the newer one?

If it's the older one look in table spam_nodes.hostname for your Ip address.

If it's the newer one then http://www.kerneltrap.org/hg/drupal/4.6/spam/?f=97b255434f8d;file=spam.m... is a link to the MySQL code to create the tables. You'll need to look through that for approipate table/field.

--AjK

drupalec-1’s picture

drupalec-1 commented

we haven't used it yet but plan to
-----
Drupal ecommerce, at www.drupalecommerce.com is a new site written using language that Drupal beginners and intermediate users can understand. It has about 300 unfinished pages. 2 tutorials for views module under "Modules"

drupalec-1’s picture

drupalec-1 commented

but does this mean you can't switch the module back on again, or you'll be banned again?

it doesn't wipe the base back to zero presumably.
-----
Drupal ecommerce, at www.drupalecommerce.com is a new site written using language that Drupal beginners and intermediate users can understand. It has about 300 unfinished pages. 2 tutorials for views module under "Modules"

AjK’s picture

AjK commented

yes, if you switch it on you'll be banned again unless to read my full post and before switching on remove the offending entry from the database.

--AjK

drupalec-1’s picture

drupalec-1 commented

thankx
-----
Drupal ecommerce, at www.drupalecommerce.com is a new site written using language that Drupal beginners and intermediate users can understand. Which version to use? http://www.drupalecommerce.com/47vs46

huc’s picture

huc commented

I did the same thing today -- total brain fart on my part as I've used the module for years

Easy fix was to connect from a new IP number and then delete the old banned IP number entry from the Drupal Admin interface -- or simply allow it. I chose to Allow it since it should prevent me from shooting myself in the foot again

In my case it was easiest to just connect from the coffee shop down the street to make the change. Another option, if you have a dynamically assigned IP, is to reset the IP lease and get a new one, or contact your system admin and/or internet provider to have them assign a new one.

Overall, the fixes are easy and there are a few. I'd love to see some error checking in the Access Rules module which validates the current IP number against what's entered but it may be more work than it's worth.

HOpe that helps
Cheers
huc

Brian Huculak