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.

[Case 160953] Upgrades to 11.48 cannot update the cphulkd database schema

Discussion in 'Security' started by OLM, Feb 4, 2015.

  1. OLM

    OLM Member

    Joined:
    Oct 31, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi all,

    Looks like my cPanel auto updated to WHM 11.48.0 (build 8) and am now having
    issues with cPHulk.

    After the update mysql & imap failed and then recovered.

    When I checked cPHulk and tried to blacklist an IP address using the link
    provided in the email then it said the page could not be found.

    I then logged in and tried to add the IP to cPHulk from the cPHulk page and I
    get this error:

    The system failed to add an IP address to cphulkd hosts because the “cphulkd.ip_lists”
    table may be corrupted and returned the following error: DBD::mysql::db do failed:
    Table 'cphulkd.ip_lists' doesn't exist

    Probably related to the above but it shows that the whitelist and blacklist are both empty -
    I hope that doesn't mean I have lost all the blacklisted ip ranges that I had added have
    been lost??

    I have looked but haven't been able to find any information relating to the main error above.

    Any help to get this working again would be greatly appreciated!

    Thanks
     
  2. Polystigma

    Polystigma Member

    Joined:
    Jun 4, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Same problem here.
    I get a similar error when trying to auto add my own IP to the whitelist.
     
  3. OLM

    OLM Member

    Joined:
    Oct 31, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Yep can't auto add my own IP to the whitelist as the same message appears.

    Thanks for the confirmation - thought it might have been just me being a numpty :)
     
  4. OLM

    OLM Member

    Joined:
    Oct 31, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Just to add that I am receiving lots of Root Login emails from service whostmgrd with my IP address
    whenever I am logged in to cPanel.
     
  5. John

    John Active Member

    Joined:
    Jan 1, 2014
    Messages:
    25
    Likes Received:
    2
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    I was also facing the same problem in one of my cPanel server, what I did was copied the 'cphulkd.ip_lists' from another server(11.48) and restored the same.

    Table dump file is available here: https://www.dropbox.com/s/c19ct8pm5ks6r1j/cp_lists.sql?dl=0
    ==
    wget https://www.dropbox.com/s/c19ct8pm5ks6r1j/cp_lists.sql
    mysql cphulkd < cp_lists.sql
    ==

    PS: Try at your own risk:)
     
  6. OLM

    OLM Member

    Joined:
    Oct 31, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi - Just to update this - I opened a support ticket with cPanel for the first time and have to say have received a very quick and helpful response. They logged on and fixed it almost immediately and that was really appreciated!

    I believe they fixed it by running the following file: /usr/local/cpanel/bin/hulkdsetup

    Posting the above just in case it helps others with the same issue but the usual warnings apply.

    Thanks
     
  7. Irksome73

    Irksome73 Member

    Joined:
    Oct 17, 2013
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you - that appeared to resolve the issue for me.
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Internal case number 160953 is open to address an issue where if the cPanel update process cannot successfully update the schema for cPHulk, the update process will continue without properly informing the server administrator of the issue or how to resolve the problem manually. The current workaround is to run the following command:

    Code:
    /usr/local/cpanel/bin/hulkdsetup
    Thank you.
     
  9. Serra

    Serra Well-Known Member

    Joined:
    Oct 27, 2005
    Messages:
    213
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Florida
    Fix worked for me. Restored my IP whitelist as well. Nice upgrade to cPHulk, like that I can put comments on the IP list now.
     
  10. Polystigma

    Polystigma Member

    Joined:
    Jun 4, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    That fixed it, thanks!
     
  11. Clarkevybz

    Clarkevybz Registered

    Joined:
    Feb 5, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for this info, I ran into this issue this morning after an overnight update, only on one of my servers. This resolved the issue. In addition to this one website was showing a connection to mysql data base error. I simply resolved that by restarting the mysql service. I'm not sure if anyone else experience that issue as well, but I wasn't able to find much info via the error logs. All might be due to the OWASP ModSecurity rules update.
     
  12. High Voltage

    High Voltage Registered

    Joined:
    Nov 8, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I had the same problem: Dozens of duplicate root login emails flooding my inbox while logged in to WHM and corrupted message in cphulk pane. Above fixed it for me, thank you cPanelMichael. :)
     
  13. The_Hawk

    The_Hawk Registered

    Joined:
    Nov 28, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    That fix has worked for me too and CPHulk is now back up and running.

    BUT, is there now anyway to select all the entries and export them?
    Or a way to delete all the entries when you have multiple pages?
     
  14. durangod

    durangod Well-Known Member

    Joined:
    May 12, 2012
    Messages:
    251
    Likes Received:
    10
    Trophy Points:
    18
    cPanel Access Level:
    Website Owner
    thanks for the info and thanks for sharing OLM and thanks for confirming michael.. good jobs :) its a big help to get quick info when things are nuts.. :)
     
  15. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You can click on the settings icon on the right of the page and utilize the "Delete All" option to remove all IP addresses from the black list or white list.

    Thank you.
     
Loading...

Share This Page