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

[OLM]

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]

Same problem here.
I get a similar error when trying to auto add my own IP to the whitelist.

 

[OLM]

Same problem here.
I get a similar error when trying to auto add my own IP to the whitelist.

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

 

[OLM]

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]

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]

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

 

[Irksome73]

Thank you - that appeared to resolve the issue for me.

 

[cPanelMichael]

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:

/usr/local/cpanel/bin/hulkdsetup

Thank you.

 

[Serra]

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]

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:

/usr/local/cpanel/bin/hulkdsetup

Thank you.

That fixed it, thanks!

 

[Clarkevybz]

/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]

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:

/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]

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]

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]

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.