Tag Archives: MySQL

Raspberry Pi LAMP installation guide

Posted on by

This short guide teaches you how to turn Raspberry Pi into a LAMP server.
LAMP stands for Linux Apache MySQL PHP

Step 1: update the Raspberry Pi OS to the latest version:

sudo apt-get install -y rpi-update
sudo apt-get update -y && sudo apt-get upgrade -y

Step 2: install Apache Webserver and create permissions:
sudo apt-get install -y apache2 apache2-utils
sudo groupadd -f -g33 www-data
sudo chown pi:www-data /var/www
sudo chmod 775 /var/www

Step 3: install PHP and mod_php
sudo apt-get install -y php5 libapache2-mod-php5 php5-common mysql-client
sudo apt-get install -y php-pear php5-mysql php5-curl php5-gd php5-idn php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl php5-json

Step 4: Install MySQL and phpMyAdmin

sudo apt-get install -y mysql-server
mysql_secure_installation
sudo apt-get install -y phpmyadmin

How-To setup Fedora Linux 15 as LAMP server

Aside

This short guide demonstrates how to setup Fedora 15 as a LAMP server containing Apache, PHP, Perl, Python, Ruby and MySQL.

You have to use the shell and be able to use the machine as  root.


sudo
yum install httpd
yum install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-eaccelerator php-magickwand php-magpierss php-mapserver php-mbstring php-mcrypt php-mhash php-mssql php-shout php-snmp php-soap php-tidy curl curl-devel perl-libwww-perl ImageMagick libxml2 libxml2-devel
yum install mysql mysql-devel mysql-server
yum install httpd-devel ruby ruby-devel
yum install mod_python
yum install mod_perl
yum install perl-HTML-Parser perl-DBI perl-Net-DNS perl-Digest-SHA1 perl-ExtUtils-AutoInstall perl-NetAddr-IP perl-Archive-Tar
/etc/init.d/httpd restart

Now you have got everything installed except for mod_ruby – so that`s the next step;

cd /tmp
wget http://modruby.net/archive/mod_ruby-1.3.0.tar.gz
tar zxvf mod_ruby-1.3.0.tar.gz
cd mod_ruby-1.3.0/
./configure.rb --with-apr-includes=/usr/include/apr-1
make
make install
/etc/init.d/httpd restart

You have to add mod_ruby by hand in /etc/httpd/conf.d/ruby.conf
By adding

LoadModule ruby_module modules/mod_ruby.so

Joomla! 1.5 Top Extensions Cookbook review

Posted on by

The Joomla! 1.5 Top Extensions Cookbook is one of Packt Publishing’s cookbook series meaning that it contains recipes. This book contains over 80 different recipes to use extensions to add maps, image galleries, slideshows, audio  and video players, security, forums, shopping cart, guestbook and other functionalities to your site.  Each recipe is a articles with an idea and how to work it out (step by step), just like a regular cookbook.

Joomla! is an open-source award-winning PHP/MySQL based content management system (CMS). Since its available under the GPL license it`s free to download, modify and use it for your website.

This book is written for Joomla! 1.5 users without programming or webdesign knowledge. Basic knowledge of setting it up is recommended.

For basic Joomla! Knowledge I can recommend Joomla! 1.5 Cookbook which I reviewed earlier: Joomla! 1.5 Cookbook review.

Most of the content of this book is also valid for Joomla! 1.6, although not all extensions will work fine. The same counts for users of PHP 5.3.

Continue reading →

Amazon Linux AMI as LAMP setup

Aside

The following guide demonstrates how to install Apache Webserver 2.2, PHP 5.3, MySQL Server 5.1 (Community Edition) and Perl (without mod_perl).

sudo yum install -y httpd php php-pear mysql mysql-server perl php-common php-dba php-pdo php-mysql php-xml php-xmlrpc

Then start Apache HTTPD and MySQL Server:

sudo /etc/init.d/mysqld start
sudo /etc/init.d/httpd start

And make sure it`s always loaded on startup:
sudo chkconfig --level 2345 httpd on
sudo chkconfig --level 2345 mysqld on

OpenSuSE 11.4 LAMP installation guide

Aside

The following guide demonstrates how to install Apache 2.2, PHP 5.3 and MySQL 5.1 in OpenSuSE linux version 11.4.

I will not guide you through the installationsteps, so I start  after booting the machine and logging in.

You have to be logged in as root (using the sudo command).

By entering the following code into the commandline you install MySQL, Apache, PHP and the basic/required third party modules.

sudo
yast2 -i mysql mysql-community-server mysql-client perl-DBD-mysql perl-DBI perl-Data-ShowTable
chkconfig --add mysql
/etc/init.d/mysql start
yast2 -i apache2 apache2-devel apache2-mod_perl apache2-mod_php5 apache2-prefork perl-HTML-Parser perl-URI perl-libwww-perl php5 php5-devel zlib zlib-devel
yast2 -i ImageMagick curl
yast2 -i php5-bcmath php5-bz2 php5-calendar php5-ctype php5-curl php5-dom php5-ftp php5-gd php5-gettext php5-gmp php5-iconv php5-imap php5-ldap php5-mbstring php5-mcrypt php5-mysql php5-odbc php5-openssl php5-pcntl php5-pgsql php5-posix php5-shmop php5-snmp php5-soap php5-sockets php5-sqlite php5-sysvsem php5-tokenizer php5-wddx php5-xmlrpc php5-xsl php5-zlib php5-exif php5-fastcgi php5-pear php5-sysvmsg php5-sysvshm
chkconfig --add apache2
/etc/init.d/apache2 start