| Author |
Message |
schrags11
New Member
Joined: Oct 15, 2004
Posts: 13
|
 Posted:
Thu Oct 21, 2004 2:00 pm |
|
When i try to add an ip address to ban under "Add Blocked IP" It doesnt add it... Am i doing something wrong? |
| |
|
|
|
hitwalker
Sells PC To Pay For Divorce
Joined:
Posts: 5661
|
| Posted:
Thu Oct 21, 2004 5:33 pm |
|
well im not the sentinel expert here,but check your install again...
i mean the few step you have to take and adjustment in the few files....the editing part.
also check if all tables are present in your database...
thats what i would do...,and if that didnt worked i would scream hard ....BOB ! |
| |
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
| Posted:
Thu Oct 21, 2004 6:01 pm |
|
Yes, if items are not added it usually means a table is not added or in sync after an upgrade. |
| |
|
|
|
|
schrags11
|
| Posted:
Fri Oct 22, 2004 3:02 pm |
|
Ok i de-installed everything and reinstalled 2.1 from a fresh install and it still won't add it. By banning ip's i mean manual... sentinel blocked 1 by itself and added it fine, but it doesn't when i try to ban an ip manually. |
| |
|
|
|
|
BobMarion
Former Admin in Good Standing
Joined: Oct 30, 2002
Posts: 1037
Location: RedNeck Land (known as Kentucky)
|
| Posted:
Fri Oct 22, 2004 4:32 pm |
|
Make sure your nuke_nsnst_blocked_ips table has a row labeled c2c . |
_________________
Bob Marion
Codito Ergo Sum
http://www.nukescripts.net |
|
 
|
|
schrags11
|
| Posted:
Fri Oct 22, 2004 7:16 pm |
|
Yes it does. I removed all the nsnst tables manually and manually installed the nsnst.sql . Now unless im being an idiot when trying to add a banned ip... i just enter the ip addy that i want blocked into the "Blocked IP:", i didnt enter any of the other stuff. I am sure i copied all of the new 2.1 files over, but i will do it again just to make sure. |
| |
|
|
|
|
Tommyguns
Hangin' Around
Joined: Jul 07, 2004
Posts: 32
|
| Posted:
Mon Oct 25, 2004 5:13 pm |
|
I am having the same problem -- and have done all the above - any suggestions?
I can add it in the Block Range Menu -- but not the Block IP Menu.. |
Last edited by Tommyguns on Mon Oct 25, 2004 5:38 pm; edited 1 time in total |
|
 |
|
hitwalker
|
| Posted:
Mon Oct 25, 2004 5:23 pm |
|
well theres nothing wrong with the script...so you might have to dig deeper to find out what the problem is....maybe both members can post any info on their stuff here so bob can compare...maybe the solution is nearby....but its a thought... |
| |
|
|
|
|
schrags11
|
| Posted:
Mon Oct 25, 2004 5:46 pm |
|
2.0.2 added fine so i must have screwed something up when upgrading. It's not the database since i started that from scratch so i will re copy all the files nd see what happens. |
| |
|
|
|
|
hitwalker
|
| Posted:
Mon Oct 25, 2004 5:50 pm |
|
well im sure upgrading works but my opinion on that is that if possible do a new install...you can put the ip's back afterwards if you like or start with an empty one.
who cares anyway cause every idiot gets banned so dont worry...  |
| |
|
|
|
|
Tommyguns
|
| Posted:
Mon Oct 25, 2004 5:55 pm |
|
I have tried a fresh install also -- no worky.. |
| |
|
|
|
|
hitwalker
|
| Posted:
Mon Oct 25, 2004 5:58 pm |
|
well then there are a few things left....
1.you forgot a piece of including stuff...
2.its related to the stuff your site runs on...
maybe both can post every info about your website..php...mysql....versions.....restrictions....everything that might help bob....when he gets online.... |
| |
|
|
|
|
BobMarion
|
| Posted:
Mon Oct 25, 2004 7:23 pm |
|
Check you nuke_nsnst_blocked_ips table and make sure it has the following:Code:CREATE TABLE IF NOT EXISTS `nuke_nsnst_blocked_ips` (
`ip_addr` varchar(15) NOT NULL default '',
`user_id` int(11) NOT NULL default '1',
`username` varchar(60) NOT NULL default '',
`user_agent` text NOT NULL,
`date` int(20) NOT NULL default '0',
`notes` text NOT NULL,
`reason` tinyint(1) NOT NULL default '0',
`query_string` text NOT NULL,
`x_forward_for` varchar(32) NOT NULL default '',
`client_ip` varchar(32) NOT NULL default '',
`remote_addr` varchar(32) NOT NULL default '',
`remote_port` varchar(11) NOT NULL default '',
`request_method` varchar(10) NOT NULL default '',
`expires` int(20) NOT NULL default '0',
`c2c` char(2) NOT NULL default '00',
PRIMARY KEY (`ip_addr`)
) TYPE=MyISAM;
|
|
| |
|
|
|
|
Tommyguns
|
| Posted:
Mon Oct 25, 2004 7:35 pm |
|
Yes sir -- it does..
Code:-- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 25, 2004 at 09:32 PM
-- Server version: 4.0.20
-- PHP Version: 4.3.9
--
-- Database: `****`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_nsnst_blocked_ips`
--
CREATE TABLE `nuke_nsnst_blocked_ips` (
`ip_addr` varchar(15) NOT NULL default '',
`user_id` int(11) NOT NULL default '1',
`username` varchar(60) NOT NULL default 'Anonymous',
`user_agent` text NOT NULL,
`date` varchar(20) NOT NULL default '0',
`notes` text NOT NULL,
`reason` tinyint(1) NOT NULL default '0',
`query_string` text NOT NULL,
`x_forward_for` varchar(32) NOT NULL default 'None',
`client_ip` varchar(32) NOT NULL default 'None',
`remote_addr` varchar(32) NOT NULL default '',
`remote_port` varchar(11) NOT NULL default 'Unknown',
`request_method` varchar(10) NOT NULL default '',
`expires` int(20) NOT NULL default '0',
`c2c` char(2) NOT NULL default '00',
PRIMARY KEY (`ip_addr`)
) TYPE=MyISAM;
|
|
| |
|
|
|
|
BobMarion
|
| Posted:
Mon Oct 25, 2004 9:13 pm |
|
And you have the blocker type set to Block and not just email, forward, or default page? |
| |
|
|
|
|
Tommyguns
|
| Posted:
Mon Oct 25, 2004 9:27 pm |
|
I have them all set at email, block & default page |
| |
|
|
|
|
BobMarion
|
| Posted:
Mon Oct 25, 2004 9:35 pm |
|
Open admin/modules/sentinel/ABBlockedIPAddSave.php in a text editor and find:Code: $db->sql_query("INSERT INTO ".$prefix."_nsnst_blocked_ips VALUES ('$xIPs', '$xuser_id', '$xusername', '$xuser_agent', '$bantime', '$xnotes', '$xreason', '$temp_qs', '$xx_forward_for', '$xclient_ip', '$xremote_addr', '$xremote_port', '$xrequest_method', '$xexpires')");
|
Change it to:Code: $db->sql_query("INSERT INTO ".$prefix."_nsnst_blocked_ips VALUES ('$xIPs', '$xuser_id', '$xusername', '$xuser_agent', '$bantime', '$xnotes', '$xreason', '$temp_qs', '$xx_forward_for', '$xclient_ip', '$xremote_addr', '$xremote_port', '$xrequest_method', '$xexpires', '00')");
|
|
| |
|
|
|
|
Tommyguns
|
| Posted:
Mon Oct 25, 2004 9:43 pm |
|
Bingo -- that did it!! Thanks soooo much - we will donate to the cause... |
| |
|
|
|
|
hitwalker
|
| Posted:
Tue Oct 26, 2004 4:50 am |
|
great it worked ....but interesting would be to know why you had to make this change to that part of the code....?
Bob ...why is that ? |
| |
|
|
|
|
Raven
|
| Posted:
Tue Oct 26, 2004 6:29 am |
|
It was a coding change from v2.0.2 and was miscoded. It will be corrected in v2.1.1 |
| |
|
|
|
|
hitwalker
|
| Posted:
Tue Oct 26, 2004 7:31 am |
|
ah i see...ahumm miscoded?.. 
Yeah....he's a busy guy huh....i corrected it to.,.... |
| |
|
|
|
|
schrags11
|
| Posted:
Tue Oct 26, 2004 1:10 pm |
|
It works! Thanks. I love sentinel so far... caught 2 people. :-p |
| |
|
|
|
|
BobMarion
|
| Posted:
Tue Oct 26, 2004 11:52 pm |
|
Miscoded/Overlooked. Either one when you consider I'm working with well over 100 files in NukeSentinel(tm) so I'm going to mis something now and then. |
| |
|
|
|
|
64bitguy
The Mouse Is Extension Of Arm
Joined: Mar 06, 2004
Posts: 1164
|
| Posted:
Wed Oct 27, 2004 12:22 am |
|
I wish I had a nickel for everytime I overlooked something little like that. I'd have a quarter just from my last release... and that's just the one's I know about... lol
Nice catch in figuring out the problem and fix guys. |
_________________
Steph Benoit
100% Section 508 and W3C HTML5 and CSS Compliant (Truly) Code, because I love compliance. |
|
|
|
|
echo
Hangin' Around
Joined: Nov 27, 2003
Posts: 37
|
| Posted:
Thu Oct 28, 2004 12:43 pm |
|
I had the same problem, I found this post after I ran out of hair.  |
| |
|
|
|
|
|
|
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
