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

cpanel – change pure-ftpd port

Pure-FTP

1) Edit /etc/pure-ftpd.conf and look for the following line:

Bind

Where is a publically routable IP.  The default example, 127.0.0.1, will cause the socket to bind locally but then this connection won’t serve externally. is the new port you wish to put the service on.

2) If necessary, add the new FTP port to your server’s firewall

3) Edit /etc/chkserv.d/ftpd and change the port, which is the first comma-separated entry to the right of ‘=’ on the line in the file, to match the port you put the service on.

Finally:

/etc/init.d/pure-ftpd restart
/etc/init.d/cpanel restart (restarts tailwatchd/chkservd)

Headache: ffmpeg install on cpanel (centos 6) time consuming

luckily i found this site

http://www.9xphp.com/Thread-FFMPEG-ffmpeg-PHP-centos-5-6-easy-install

someone made a script to install ffmpeg and ffmpeg-php

also my mysql shared libraries corrupted somehow and had to reinstall it

/usr/local/cpanel/scripts/check_cpanel_rpms –fix

recompile apache/php after fixing mysql library

if you need mplayer install using rpm. forget compiling

http://wiki.centos.org/TipsAndTricks/MultimediaOnCentOS

this is the article i started with but broken dependencies and other problems so i tried looking for other sources.

http://servertune.com/kbase/?View=entry&EntryID=71

http://www.webhostingtalk.com/showthread.php?t=1289057