MilesWeb Hosting Forum

Web Hosting Technical Support => How To's => Topic started by: AmNaik on August 12, 2015, 10:16:35 PM

Title: How To Remove A Single IP from cPHulk?
Post by: AmNaik on August 12, 2015, 10:16:35 PM
cPhulk acts as a safe guarding tool and a great feature that prevent servers (https://www.milesweb.com/server-infrastructure-management.php) from falling prey to notorious brute force login attempts.

At times authentic users might get locked out with the IP due to incorrect usage of password several times. Our technicians can quickly get your IP removed/deleted from cPHulk database via MySQL; it is not possible to do with WHM. Dedicated (https://www.milesweb.com/dedicated-servers.php) & VPS server (https://www.milesweb.com/vps-hosting.php) clients with root access can follow the below described instructions.

Log into your server from shell as the root user.

Now access MySQL with the command:


Quote
[root@yourserver /]#mysql

Connect to MySQL database.

Quote
mysql> connect cphulkd
         

[or 'use cphulkd' (without quotes)]


Now list the tables:

Quote
mysql> show tables;

Tables will be shown as like given below.

+-------------------+
| Tables_in_cphulkd |
+-------------------+
| auths             |
| blacklist         |
| brutes            |
| good_logins       |
| ip_lists          |
| known_netblocks   |
| login_track       |
| logins            |
| report            |
| whitelist         |
+-------------------+

Our concern lies with two tables namely, brutes & logins.

Access them one by one by using :

Quote
mysql> select * from brutes;

It shows the IPs caught in the act.

Quote
mysql> select * from logins;

Now to delete a single IP you can use the commands given below.

Quote
mysql> delete from brutes where IP='xxxxx';
  (Replace xxxxx with your actual IP)

Quote
mysql> delete from logins where IP='xxxxx';
   (Replace xxxxx with your actual IP)

You are done with the job, so exit the MySQL.

Quote
mysql> quit

----------
That's all folks !
Title: Re: How To Remove A Single IP from cPHulk?
Post by: Administrator on August 14, 2015, 01:21:10 PM
@AmNaik Welcome to the forums :-)