I came across this error today when a client called and was having difficulty with his database while running Prosper202. Prosper202 is a pay per click affiliate marketing software. If you are getting the “The table ‘202_clicks_spy’ is full” error message, then you will want to run these command from phpMyAdmin; Login to WHM, then…

I recent came across an issue where the /tmp folder was being listed as 100% full df -H | grep -vE ‘^Filesystem|tmpfs|cdrom’ /dev/sda7 2.1G 514M 1.5G 27% / /dev/sda8 124G 2.5G 115G 3% /home /dev/sdb1 156G 1.2G 146G 1% /backup /dev/sda6 2.1G 2.1G 0M 100% /tmp <

cPanel access denied for user modsec at mysql localhost If you get this email: /etc/cron.hourly/modsecparse.pl: DBI connect(’modsec:localhost’,’modsec’,…) failed: Access denied for user ‘modsec’@’localhost’ (using password: YES) at /etc/cron.hourly/modsecparse.pl line 19 Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19. and you are using old cPanel/Apache 1.3 just goto whm -> Plugins then remove and…

Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin In the past, when trying to upload a database, PHPMyAdmin will not work and will throw the error; ***Fatal error: Maximum execution time of 300 seconds exceeded*** This will usually occur when uploading very large mysql databases. To repair this issue, you will need…

Earlier a client was locked out of one of his server by cphulkd. When trying to access the servers WHM interface we were getting the following message: ————————————————————————————— This account is currently locked out because a brute force attempt was detected. Please wait 10 minutes and try again. Attempting to login again will only increase…

This is in reference to the Cpanel Package creation warning message seen here: Attempt to free unreferenced scalar The client was attempting to create packages for a reseller via WHM. WHM was showing a blank page and it did not appears that the packages were being created. In checking the CPanel error logs, located in…

Here is a command that can help you figure out what rpms are installed and what they are for. To view the installed rpm information run from the command line; rpm -qa –info |less or output the rpm information to a file for review; rpm -qa –info > rpminfo.txt

To remove invalid characters like ? & etc. in a file name, use this simple script; touch reminvchar.sh vim reminvchar.sh insert the following lines of code for i in `find . -type f` do echo $i mv $i `echo $i |tr ? _|tr = _ |tr ‘&’ ‘_’` done save the file using ‘:wq’ and…

Here is a little script I came across to create a simple html document on the fly; touch http.sh vim http.sh Insert this code into the new script and modify as needed (it can be as simple of as complex as you would like!) #!/bin/bash # make_page – A script to produce a basic HTML…

How to convert CHM to PDF in Linux 1. Install dependencies by running the following command in the terminal: sudo apt-get install htmldoc libchm-bin python-chm 2. Next, download chm2pdf by clicking here or using wget wget http://chm2pdf.googlecode.com/files/chm2pdf-0.9.1.tar.gz 3. Now extract the downloaded file. tar -xzvf chm2pdf-0.9.1.tar.gz 4. Browse to the folder you extracted and run:…