http://www.cpanelconfig.com The complete guide to setup and manage a cPanel based server Fri, 17 Jul 2009 11:15:39 +0000 http://backend.userland.com/rss092 en For users that are behind a firewall it might be required that you enable passive ftp in your ftp server and client. While enabling passive ftp in your ftp client is simple, doing so in your ftp server configuration files might be a bit tricky if you don't know what you ... http://www.cpanelconfig.com/how-to/enabling-passive-ftp-in-pure-ftpd/ Before you update to cPanel 11.24 you shoud check a few things: MySQL Root Password --------------------------------- With cPanel 11.24 now available, it is imperative to ensure that you have set your MySQL root password before upgrading to the latest version of cPanel. If you have previously skipped this step, you can set it ... http://www.cpanelconfig.com/cpanel-administration/before-you-upgrade-to-cpanel-1124/ More then a year ago, cPanel added a future to the Exim Configuration Editor for everyone to easily select from two RBLs (spamhaus.org and spamcop.net) that can be used to filter most of the SPAM that a server receives. While this has been great for most of us (enabling a ... http://www.cpanelconfig.com/how-to/adding-a-new-rbl-to-cpanel-exim/ Recently I was asked by a customer how to change the default Apache success page (the one that you see when you just type in the hostname for example). Surprisingly (or maybe not) this is not documented anywhere on cpanel docs or forums. If you are faced with the same problem ... http://www.cpanelconfig.com/how-to/customize-apache-default-success-page/ Since I started working with cPanel server I always needed to create archives from directories. For example backing up a user's home directory. How can you do this? It's not difficult at all. For exemple to backup a user home directory you would have to run: tar -pczf rchive.tar.gz /home/USERNAME You can read more ... http://www.cpanelconfig.com/general-work-on-cpanel-servers/basic-linux-commands-for-linux-based-servers/create-a-tar-archive-from-a-directory/ In this article I will explain how to enable quotas on a cpanel server. Recently I had to setup a cpanel server that didn't have quotas enabled by default. What is the result of a server without quotas? Simple. All accounts will have unlimited diskspace. How to fix this? First of all you will have ... http://www.cpanelconfig.com/how-to/enabling-quotas/ Step 1: DNS: A Record First we’ll need to log in to WHM. Under DNS Functions, select Edit DNS Zone. Choose the domain for the zone in which you wish to edit. Add an A record mapped to asterisk (wildcard) for the subdomain and the IP Address the site is hosted ... http://www.cpanelconfig.com/how-to/setting-up-wildcard-dns-subdomains-on-cpanel/ In this article I will be explaining how to backup the MBR record of a hard-drive. The MBR record contains the partition table and bootloader. Having a backup of the MBR is useful in case you want to copy data from an older drive to a new one or in case you ... http://www.cpanelconfig.com/general-work-on-cpanel-servers/basic-linux-commands-for-linux-based-servers/backup-partition-table-and-bootloader/ What is the screen command? First of all I will start by telling you what you can do using the "screen" command. Many times as a linux sysadmin you will need to run multiple commands at once. You are probably doing this by opening multiple ssh sessions but there is a better ... http://www.cpanelconfig.com/general-work-on-cpanel-servers/basic-linux-commands-for-linux-based-servers/using-the-screen-command/ Hello. To dump a query to csv use this: mysql  --database=database --execute="select a from b where a>1;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv http://www.cpanelconfig.com/tips/mysql-execute-query-from-console-and-export-to-csv/