UPDATE `wp_posts` SET `comment_status` = 'closed', `ping_status` = 'closed';
UPDATE `wp_options` SET `option_value` = 'closed' WHERE `option_name` = 'default_comment_status';
UPDATE `wp_options` SET `option_value` = 'closed' WHERE `option_name` = 'default_ping_status';
UPDATE `wp_options` SET `option_value` = '0' WHERE `option_name` = 'users_can_register';
RENAME TABLE wp_comments To wp_comments_spam;
List all zombie
ps aux | awk '{ print $8 " " $2 }' | grep -w Z
Output:
Z 4104
Z 5320
Z 2945
Kill:
kill -9 4104
Or:
if the PID = 1 (no parent)
wait 3038 &
cPanel show this message:
login webmail Internal Server Error User is over quota
but disk space is not full
cd /var/cpanel/overquota/
ls cpusername
if found, delete it
When browse to IP, browser not showing default website but other website (client)
login to ssh
pico /usr/local/apache/conf/httpd.conf
find
Copy
Paste on top
ServerName x.x.com
DocumentRoot /usr/local/apache/htdocs
ServerAdmin x.x@x.com
suPHP_UserGroup nobody nobody
UserDir disable
jalankan command ini supaya httpd.conf yang baru diganti menjadi default apache (konfigurasi tidak hilang)
/usr/local/cpanel/bin/apache_conf_distiller –update
Login to SSH
/scripts/makecpphp
/etc/rc.d/init.d/cpanel restart
http://www.helpdesksys.com/joomla-articles/27-maximum-execution-time-of-300-seconds.html
Fatal error: Maximum execution time of 300 seconds exceeded
PHPMyAdmin will not work for uploading large mysql databases. If you attempt to upload a large mysql dataset you will often get this error
Here is the Fix
If you get this error you will need edit config.default.php inside phpmyadmin folder and look for this line
$cfg[’ExecTimeLimit’] = 300;
and replace with 0 or any larger value
$cfg[’ExecTimeLimit’] = 3600;
Normally it is located at “/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/config.default.php”,
Ref: http://24x7servermanagement.com/blog/?p=517
Donwload:
http://jeremy.zawodny.com/mysql/mytop/
Install:
tar -zxvf mytop-*
cd mytop-*
perl Makefile.PL
make
make test
make install
cd ..
rm -rf mytop-*
Fix MyTop Error
#mytop
Error in option spec: "long|!"
pico /usr/bin/mytop
Run a search for long|! and comment out the following line:
“long|!” => \$config{long_nums},
Here's the exact error from DBI. It might help you debug:
Unknown database 'test'
mysql
create database test;
32bit
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm
rpm -Uhv rpmforge-release*.rf.i386.rpm
64bit
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.x86_64.rpm
rpm -Uhv rpmforge-release*.rf.x86_64.rpm
Now that the rpmforge repository is installed, you can install the htop package easily via yum.
yum install htop
Adding New Feature Groups for a cPanel Theme
http://public.yahoo.com/~carloc/ymail.html
Yahoo Mail IP Address
http://public.yahoo.com/~vineet/ip.txt
Yahoo Mail Subnet
http://public.yahoo.com/~vineet/subnet.txt
Powered by WordPress