Latest cpanel 11.48 broke cphulkd

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.

run

[email protected] [/var/cpanel]# /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

Leave a Reply