Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™
Author Message
schrags11
New Member
New Member


Joined: Oct 15, 2004
Posts: 13

PostPosted: Thu Oct 21, 2004 2:00 pm Reply with quote

When i try to add an ip address to ban under "Add Blocked IP" It doesnt add it... Am i doing something wrong?
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Thu Oct 21, 2004 5:33 pm Reply with quote

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 !
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Thu Oct 21, 2004 6:01 pm Reply with quote

Yes, if items are not added it usually means a table is not added or in sync after an upgrade.
 
View user's profile Send private message
schrags11
PostPosted: Fri Oct 22, 2004 3:02 pm Reply with quote

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)

PostPosted: Fri Oct 22, 2004 4:32 pm Reply with quote

Make sure your nuke_nsnst_blocked_ips table has a row labeled c2c .

_________________
Bob Marion
Codito Ergo Sum
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Send e-mail Visit poster's website
schrags11
PostPosted: Fri Oct 22, 2004 7:16 pm Reply with quote

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

PostPosted: Mon Oct 25, 2004 5:13 pm Reply with quote

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 
View user's profile Send private message Visit poster's website MSN Messenger
hitwalker
PostPosted: Mon Oct 25, 2004 5:23 pm Reply with quote

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
PostPosted: Mon Oct 25, 2004 5:46 pm Reply with quote

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
PostPosted: Mon Oct 25, 2004 5:50 pm Reply with quote

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... Razz
 
Tommyguns
PostPosted: Mon Oct 25, 2004 5:55 pm Reply with quote

I have tried a fresh install also -- no worky..
 
hitwalker
PostPosted: Mon Oct 25, 2004 5:58 pm Reply with quote

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
PostPosted: Mon Oct 25, 2004 7:23 pm Reply with quote

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
PostPosted: Mon Oct 25, 2004 7:35 pm Reply with quote

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
PostPosted: Mon Oct 25, 2004 9:13 pm Reply with quote

And you have the blocker type set to Block and not just email, forward, or default page?
 
Tommyguns
PostPosted: Mon Oct 25, 2004 9:27 pm Reply with quote

I have them all set at email, block & default page
 
BobMarion
PostPosted: Mon Oct 25, 2004 9:35 pm Reply with quote

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
PostPosted: Mon Oct 25, 2004 9:43 pm Reply with quote

Bingo -- that did it!! Thanks soooo much - we will donate to the cause...
 
hitwalker
PostPosted: Tue Oct 26, 2004 4:50 am Reply with quote

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
PostPosted: Tue Oct 26, 2004 6:29 am Reply with quote

It was a coding change from v2.0.2 and was miscoded. It will be corrected in v2.1.1
 
hitwalker
PostPosted: Tue Oct 26, 2004 7:31 am Reply with quote

ah i see...ahumm miscoded?.. Embarassed
Yeah....he's a busy guy huh....i corrected it to.,....
 
schrags11
PostPosted: Tue Oct 26, 2004 1:10 pm Reply with quote

It works! Thanks. I love sentinel so far... caught 2 people. :-p
 
BobMarion
PostPosted: Tue Oct 26, 2004 11:52 pm Reply with quote

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: 1159
Location: Sanbornton, NH USA

PostPosted: Wed Oct 27, 2004 12:22 am Reply with quote

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 Only registered users can see links on this board! Get registered or login!
1CMS, 100% Section 508 and W3C XHTML/CSS Compliant (Truly) 
View user's profile Send private message Visit poster's website
echo
Hangin' Around


Joined: Nov 27, 2003
Posts: 37

PostPosted: Thu Oct 28, 2004 12:43 pm Reply with quote

I had the same problem, I found this post after I ran out of hair. Cheers
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©