More IPs for your banning pleasure

Private Joined: Jan 18, 2005 Posts: 47

Out of curiosity, I have to ask if this would actually work. Most people I know have dynamic i.ps. So everytime they go ont he internet they have a different i.p.

Aren't you just banning people who probably aren't the people who tried to access your, whatever?

Posted: Sat Apr 23, 2005 4:58 am

that is correct, but the ip is shared between about 5 people so that means he would get the ip again in few short days. and if the person who didnt hacked wants to access the site he can alwasy disconnect and connect again.

Sergeant Joined: Nov 25, 2004 Posts: 84

the entire HD file.
http://lloyd.groundhost.net/modules.php?name=Downloads&d_op=getit&lid=24
SQL File
http://lloyd.groundhost.net/modules.php?name=Downloads&d_op=getit&lid=23
IN ONE BIG FILE (OLDER VERSION)
http://lloyd.groundhost.net/modules.php?name=Downloads&d_op=getit&lid=15

Posted: Sat Apr 30, 2005 9:26 pm

I attempted to run the SQL version of the ip ban list thru and this is the error that I got:

Code:

SQL-query:

CREATE TABLE nuke_banned_ip(

`id` int( 11 ) NOT NULL default '',
`ip_address` varchar( 15 ) NOT NULL default '',
`reason` varchar( 255 ) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
PRIMARY KEY ( `id` )

=============================
MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

I'm running phpnuke 7.6 with Chatserv patch 2.9 and NukeSentinel 2.2.0.
MySQL Version: 4.0.22-standard

Any ideas?

Sergeant Joined: Nov 25, 2004 Posts: 84

what version are you using of the SQL file?

Posted: Fri May 06, 2005 6:51 am

host.denySQLphpnukebanned_ipv1.0.3

Sergeant Joined: Nov 25, 2004 Posts: 84

try it in php myadmin

Posted: Thu May 19, 2005 6:17 am

fisicouk wrote:

try it in php myadmin

I was using php myadmin when this error occured.

Thanks anyway though,
Killer

Posted: Wed Jun 01, 2005 3:47 pm

So how do i add these to sentinel?

Nuke Soldier Joined: Jun 07, 2005 Posts: 19

I have just download it and upload it to my web.
Feel allready safe. Thanks for the great job.
YOU GUYS ARE GREAT...

Sergeant Joined: Nov 25, 2004 Posts: 84

Fatal1ty wrote:

So how do i add these to sentinel?

you canta ddd it to sentinal yet
you can add it to the nuke blocked IP table

hop along to my site and look in the DL section under IPban list

http://lloyd.groundhost.net

Corporal Joined: Jun 29, 2005 Posts: 57

I get the same error when i run the sql insert into the table. Sad

Nuke Cadet Joined: Sep 17, 2003 Posts: 4

v1.0.3
change PRIMARY KEY (`id`);
to PRIMARY KEY (`id`),

Change the semi-colon to a comma. This is at the head of the first file.

Amanda

Nuke Cadet Joined: Sep 17, 2003 Posts: 4

Other problems;
16401-16499 duplicate entries
the second occurrence of 20720 should be 20744

The change in table structure means you can no longer add individual IP's from the control panel. The original default table structure has 'id' as auto-increment.

On my system, after loading the first file, clicking on "ban-ip" from the control panel returns an empty page. I have no idea why as yet.

Amanda

Nuke Cadet Joined: Aug 06, 2004 Posts: 7

i convertet the host.deny to .htaccess for those who want it:
(i can't get hosts.deny to work Sad

)

http://mastrboy.servebeer.com/htacces.deny

just write

Code:

grep DENY htaccess.deny >> .htaccess

this will add the context of htaccess.deny to your htacces file without removing the old context of the file Wink

it's really easy to covert it; just use the search and replace function in notepad Smile

(thinking of converting it to IPTABLES DROP also, i think that would be the best solution)

edit: (forgot to convert the * .. will do a update soon)