So, my VPS did an auto upgrade and my CpHULK went on vacation? Ok not on a vacation to Asia but i had problems viewing the my Whitelist, Blacklist and even adding new IPs.

After a little troubleshooting, i realized that while the cphulk had upgraded itself in the WHM, it doesnt seem like the database has been updated.

That being said, I also noticed that mysql was down somehow/somewhere during the upgrade.

Anyways, to fix your cphulk issues after the WHM 11.48 Upgrade

1. Login to your server via ssh (as root)

2. /usr/local/cpanel/bin/hulkdsetup command and whoola!!..

You can login to your Mysql and see the new tables added to the cphuld database.

Here is the output from my own upgrade

/usr/local/cpanel/bin/hulkdsetup
hulkdsetup: synchronizing database schema

ALTER TABLE brutes CHANGE COLUMN BRUTETIME BRUTETIME timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’
# was datetime DEFAULT NULL
ALTER TABLE brutes CHANGE COLUMN EXPTIME EXPTIME timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’
# was datetime DEFAULT NULL
ALTER TABLE good_logins CHANGE COLUMN LOGINTIME LOGINTIME timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’
# was datetime DEFAULT NULL
ALTER TABLE logins CHANGE COLUMN LOGINTIME LOGINTIME timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’
# was datetime DEFAULT NULL
ALTER TABLE report CHANGE COLUMN logintime logintime timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’
# was datetime DEFAULT NULL
CREATE TABLE ip_lists (
STARTADDRESS varbinary(16) NOT NULL DEFAULT ”,
ENDADDRESS varbinary(16) NOT NULL DEFAULT ”,
TYPE int(1) NOT NULL DEFAULT ‘0’,
COMMENT char(255) DEFAULT NULL,
PRIMARY KEY (STARTADDRESS,ENDADDRESS)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE login_track (
USER char(128) NOT NULL,
ADDRESS varbinary(16) DEFAULT NULL,
SERVICE char(64) DEFAULT NULL,
TYPE int(1) DEFAULT NULL,
LOGINTIME timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
EXPTIME timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
NOTES text,
AUTHSERVICE char(64) DEFAULT NULL,
AUTHTOKEN_HASH char(86) DEFAULT ”,
KEY EXPTIME_ADDRESS_index (EXPTIME,ADDRESS),
KEY EXPTIME_USER_SERVICE_index (EXPTIME,USER,SERVICE)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
root@ssdvps-98489 [/var/log]#

 

And the new table lists looks like …

mysql> show tables;
+——————-+
| Tables_in_cphulkd |
+——————-+
| auths             |
| blacklist         |
| brutes            |
| good_logins       |
| ip_lists          |
| login_track       |
| logins            |
| report            |
| whitelist         |
+——————-+
9 rows in set (0.00 sec)

Related articles