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

OLM

Member
Oct 31, 2014
12
1
3
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
 

Polystigma

Member
Jun 4, 2005
6
0
151
Same problem here.
I get a similar error when trying to auto add my own IP to the whitelist.
 

OLM

Member
Oct 31, 2014
12
1
3
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.
 

John

Active Member
Jan 1, 2014
25
2
3
cPanel Access Level
Root Administrator
Same problem here.
I get a similar error when trying to auto add my own IP to the whitelist.
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:)
 

OLM

Member
Oct 31, 2014
12
1
3
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,250
463
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.
 

Serra

Well-Known Member
Oct 27, 2005
272
21
168
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.
 

Polystigma

Member
Jun 4, 2005
6
0
151
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.
That fixed it, thanks!
 

Clarkevybz

Registered
Feb 5, 2015
1
0
76
cPanel Access Level
Root Administrator
Code:
/usr/local/cpanel/bin/hulkdsetup
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.
 

High Voltage

Registered
Nov 8, 2013
3
1
53
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.
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. :)
 

The_Hawk

Registered
Nov 28, 2013
2
0
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?
 

durangod

Well-Known Member
May 12, 2012
505
46
78
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.. :)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,250
463
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?
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.