One way to make your data legible is to apply cell shading to every other row in a range. Excel’s Conditional Formatting feature (available in Excel or later) makes this a simple task. Select the range that you want to format Choose Format, Conditional Formatting In the Conditional Formatting dialog box, select Formula Is from […]
Spammers love nothing more than launching dictionary attacks on unsuspecting domains using the ‘catch-all’ feature. This causes multiple problems — the main issues are excessive server load, disk usage, and spam volume. The worse issue is that once spammers catch on to the fact your domain has a catch-all, they will launch spam campaigns with […]
It actually couldn’t be easier. Before you get yourself caught up in dependency hell and start breaking all kinds of things, try the following ‘all in one’ command: /scripts/installimagemagick
In addition to the correct chmod of files and folders (see part 1), you must ensure that all public_html files and folders have the correct (user and group) ownership. The following Perl code will eliminate nobody/root ownership. Place the Perl script into your /home directory and execute it. #!/usr/bin/perl -w my @dirs = grep -d,<*>; […]
If you get Invalid License File when you login to cpanel after a hostname or IP change you need to update your cpanel license file by: Login to shell and run the following from command line: /usr/local/cpanel/cpkeyclt
The following command can be used to repair and optimize all tables in a MySQL database. This can be useful on a busy server with many tables after a hard reboot or otherwise unclean shutdown. mysqlcheck -u root -p –auto-repair –optimize –all-databases
Cpanel w/suphp – how to fix and properly set permissions of all user files and folders so they execute properly.
Work getting you down? Do what I do and listen to some internet radio without any commercials. One of the better sites I’ve come across is myfreenetradio.com http://www.MyFreeNetRadio.com
The following command can be used to create a .tar.gz archive, commonly referred to as a ‘tarball’ file. tar -pczf name_of_your_archive.tar.gz file1 file2 directory1 directory2 ect…
CSF Download Link