The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Location of cpHulk blacklist file

Discussion in 'Security' started by Richard Repucci, Apr 23, 2015.

  1. Richard Repucci

    Richard Repucci Registered

    Joined:
    Apr 23, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    US
    cPanel Access Level:
    Root Administrator
    Could anyone tell me where the cpHulk blacklist file is located on a Linux server so I can edit it directly?

    We have over 3,000 entries and I would like to review / edit to see if converting entris to /24 or /16 ranges make sense.

    Thanks
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    The whitelisted and blacklisted IPs are stored in "ip_lists" table of the cphulk database as VARBINARY entries - in order to "read" them via a select statement, you will need to use the INET6_NTOA() mysql function (only available in 5.6.3+). EX:

    Code:
    mysql cphulkd;
    SELECT INET6_NTOA(`STARTADDRESS`), INET6_NTOA(`ENDADDRESS`), `COMMENT` from `ip_lists` WHERE TYPE = 1;" (fetches the whitelisted IPs)
    Thank you.
     
Loading...

Share This Page