How To Remove A Single IP from cPHulk?

[AmNaik]

cPhulk acts as a safe guarding tool and a great feature that prevent servers 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 & VPS server 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:

[root@yourserver /]#mysql

Connect to MySQL database.

mysql> connect cphulkd

[or 'use cphulkd' (without quotes)]


Now list the tables:

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 :

mysql> select * from brutes;

It shows the IPs caught in the act.

mysql> select * from logins;

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

mysql> delete from brutes where IP='xxxxx';

(Replace xxxxx with your actual IP)

mysql> delete from logins where IP='xxxxx';

(Replace xxxxx with your actual IP)

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

mysql> quit

----------
That's all folks !

[Administrator]

@AmNaik Welcome to the forums :-)