During the default LAMP installation of Ubuntu Gutsy Server, you will be automatically prompted to set the Mysql root user password. This is an extremely convenient feature, that consolidates an entire step. This feature among many other puts Ubuntu server edition at the top of my list for server environments. Although I currently use Debian for my server environment, I may choose to use Ubuntu to deploy a Ruby on Rails server environment.
Share, Enjoy, and Support:
With a Virtual Server your hardware is backed up completely within the VDI image. Your Mysql databases, specifically for websites that are blogs update often; more often than you would like to backup your 50 Gigabyte VDI image. To compensate, and significantly ease backup procedures have your mysql databases backed up regularly. Daily, hourly, or even after each post is recommended in order to effectively secure needed files in case a system restore is required. To backup your mysql databases you can view my previous post:
http://www.bgevolution.com/blog/index.php/cron-server-backup-scripts/
Share, Enjoy, and Support:
When a virtual server is utilizing the host systems network, and receives an independent local IP via DHCP from your router it appears to be an actual computer form the outside world. If a backup of the VDI is kept regularly it can simply replace a damaged, or hacked system in the time it takes to copy a file. Virtual servers exist as a single VDI file, therefore for blogs that utilize database backends simply copy your backup server VDI image, boot, then use your phpmyadmin to update your mysql databases from your backups; obviously this entails keeping mysql database backups. For more information about mysql backups utilizing automated cron scripts see:
http://www.bgevolution.com/blog/index.php/cron-server-backup-scripts/
Share, Enjoy, and Support:
This is a standard requirement of any new Mysql installation. First login:
mysql -u root -p
Press enter, with no characters entered, when you are prompted for the root password. The password is nothing. Then enter the following into the mysql prompt. Replace temp with your desired password:
SET PASSWORD FOR root@localhost=PASSWORD('temp');
Share, Enjoy, and Support:
While installing ISPConfig on a default Debian Gnome desktop the following dependencies were documented:
apt-get install apache2 php5 libapache2-mod-php5
apt-get install mysql-server mysql-client php5-mysql
apt-get install vsftpd quota bind flex spamassassin libmysqlclient15-dev zlib1g-dev
After these dependencies are met, ISPConfig can be compiled from source. Navigate to theISPConfig source code folder and type:./setupFollow the onscreen prompts accordingly.
If you have any issues you can follow the Howtoforge.com tutorial:
http://www.howtoforge.com/perfect_setup_debian_etch
Share, Enjoy, and Support:
Debian is great to minimize software on the hard drive. With a minimal Debian installation, and the following apt commands, you will have a completely setup LAMP system in about 5-10 minutes. Simply run the following commands to install the appropriate software.
This will install apache with php support:
apt-get install apache2 php5 libapache2-mod-php5
This will install mysql with php support:
apt-get install mysql-server mysql-client php5-mysql
These two apt installation lines will take care of everything, and your Debian system will work just as a Ubuntu LAMP installation.
Share, Enjoy, and Support: