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 schemaALTER 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=latin1CREATE 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)