Forum SPAM Attack

Posted: Mon Jan 25, 2010 8:02 pm

Well I am under a daily SPAM attack from Russia/Latvia/Ukraine/etc; with everything from viagra to porn.

The PITA is taking each "Registered User" Forum posting and entering the (dozens daily) IP into Sentinal "Block IP" menu. (All Forums require a registered user.

Now the good folks at Stop Forum Spam - http://www.stopforumspam.com/downloads/ have provided a csv file with thousands of predetermined IPs to Block.

How do I take this file and upload into nuke_nsnst_blocked_ips table?

Currently using:
PHP Nuke 8.0 with Sentinal 2.6.01.
$gfx_chk = 4;
4: Both, users login and new users registration only

Regards,

Posted: Mon Jan 25, 2010 9:01 pm

I would do it at the server level if its such a huge file.

I believe this issue is because of a $global missing in PHPNuke proper but can't recall where.

But phpMyAdmin should be able to import the file if you would rather but back up first!

Posted: Mon Jan 25, 2010 9:17 pm

Ok, Yes I was assuming the upload would be at server with phpmyadmin,,, but I have no idea how to configure the upload as per the format of the csv file

Replace table data with file
Ignore duplicate rows
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Column names

When I attempt I recieved the following error:

Error
Invalid field count in CSV input on line 1.

Worker Joined: Aug 26, 2007 Posts: 236

I use bbantispam or Advanced Textual Confirmation since three years ago and it has stopped all spam in PHP-Nuke including forum (guests are allowed to post). To stop all types of spam put the installation code in config.php.

http://www.bbantispam.com/forum/viewtopic.php?t=305&postdays=0&postorder=asc&start=30#1635

Posted: Tue Jan 26, 2010 12:55 am

PM your email and I'll send you the sql to import the IPs.
Then let me know if there are any problems.
You did back up?
Wink

Posted: Tue Jan 26, 2010 3:10 am

Back up is complete,,, and sent you the PM of email address..

thanks so much!

registered · Posted: Tue Jan 26, 2010 6:29 am

You can ban complete countries using NukeSentinel(tm) I thought. There have also been some examples here on how to how to also do it with .htaccess. I believe the example given was for Turkey.

Posted: Tue Jan 26, 2010 10:34 am

sixonetonoffun,

Fantastic!

Upload with no errors.... +32000 banned IP addresses now in Nuke Setinal 2.6.01

I will check out the bbantispam next....

Cheers to all and next time it will be the Raven Nuke I will upgrade with,,,

~

Posted: Mon Jul 12, 2010 4:26 am

silicastorm

You might want to (if you haven't) http://www.spambotsecurity.com it reads the IPs from csv files. The author provides monthly updates and is a mod at http://www.stopforumspam.com/forum/

I'd really like to see something like this added to NukeSentinel since these ban lists are not in a nuked friendly format. The wrapper should be able to save tons of resources on a large site.

Posted: Mon Jul 19, 2010 2:17 pm

Just a note ZB BLOCK has released an update 0.4.7b 07/13/10 "Panther" Release
http://www.spambotsecurity.com/zbblock_download.php

Posted: Wed Jul 21, 2010 8:47 pm

Nice. BTW, you might want to get RavenNuke on their list... Wink

Posted: Fri Jul 23, 2010 1:54 am

I submitted a "Testimonial" with brief install instructions. We'll just have to see if its approved.

Posted: Sun Jul 25, 2010 11:27 pm

Update: Post was approved and added to the compatability list.
See:
http://www.spambotsecurity.com/forum/viewtopic.php?f=40&t=373

Posted: Sat Aug 07, 2010 8:00 am

Very nice. Thanks Six!