Tag Archives: MySQL

How-To setup Fedora Linux 15 as LAMP server

Aside

31

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
Reply

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

7

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

10

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

Joomla! 1.5 Cookbook review

Posted on by
Reply

Your now reading my Joomla! 1.5 Cookbook review. The book was released in October this year.

The Joomla cookbook is one of Packt Publishing’s cookbook series meaning that it contains recipes. This book contains over 60 different recipes to execute basic and advances Joomla queries. Each recipe is a small articles/paragraphs with an idea and how to work it out. Just like a regular cookbook.

I`m Ramon van Belzen, a 22 year old webdesigner from Vlissingen, the Netherlands. I’m surfing the web since 1997 and I` been programming HTML since 1998. Today I use web technologies like HTML 4, HTML 5, CSS 2 / 3, microformats, JavaScript, AJAX, jQuery and PHP/MySQL . I currently run over 10 websites, most of them as webmaster and webdesigner. The CMS systems I use include Joomla, WordPress and Drupal.
I have been offered the chance to review this book by Packt Publishing Open Source.

The book is about Joomla! 1.5. 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.
The book contains guides how to manage your Joomla site easily and conquer difficult situations.
It`s written for beginning and advanced Joomla users, with or without experience with CMS systems and webdesign (HTML) knowledge.

The first chapter of the book contains guides how to install Joomla 1.5.x using two widely used methods (cPanel and GoDaddy). It teaches how to upload, set file permissions and create a database using phpMyAdmin.

The second chapter dives deeper into phpMyAdmin`s functionality. It teaches you how to export (backup) and import (recover) databases. It also explains the basics of the MySQL database like how to view, modify and delete a table.

Chapter three explains how to install, manage and choose a Joomla! template. The chapter also mentions some sites where you can find (free) Joomla templates. Also inside the chapter is how to attach a template to a certain section of your website. Another recipe explains how to chance the template`s logo to yours.
If you want to know more about Joomla! templates have a look at Joomla! 1.5 Templates Cookbook.

Next chapter (four) is about content and menu`s. The chapter starts with changing the default WYSIWYG editor. Next is managing sections and categories. Following these recipes is the article creation and management part. Next up are the menu`s (no I’m not talking about food, although it are recipes!). Further this chapter tells you how to setup your Joomla site as a blog and how to create menu`s for extensions.

The fifth chapter is all about managing links, users and media (pictures, video, audio). It starts with explaining how the user management part works. This includes the creation, modification, deleting and blocking users. Of course it also explains how to use user groups.
Next recipes are about media management and uploading and using the link manager. The final recipe in this chapter is how to recover a lost super administration password.

Chapter six is about components, extensions and modules. It starts with the basics of modules; what they do, the difference between them and how to install/delete/manage them.

The seventh chapter explains the K2 Content Construction Kit. The K2 CCK is a nifty tool for managing websites with loads of content. First steps are the installation and configuration of this extension. Next recipes explain the use of this extension. Further in this chapter are extensions for the K2 CCK, modules like the tag cloud  and comments are explained.

The following chapter (eight) teaches how to use several handy third-party extensions like a file manager, calendar, content uploader and an improved comment system.

This book also contains an important guide how to troubleshoot website problems. This is done in chapter nine. It starts with making a plan for troubleshooting and debugging. Next are repairing database related problems and extension related problems. Following these parts are the FTP and SSH problems.

Security of your site is chapter tens content. Recipes include setting permissions, patching Joomla, blocking known bots and IPs by using a .htaccess file, blocking directory viewing, adding an error page, blocking the servers banner and changing php.ini for security reasons.

The final chapter of this book (number eleven) is about the future version of Joomla, 1.6. it starts with the Access Control List followed by working with the new category manager and it ends with the new extension manager.

The book promises that it will give solutions to all basic and advanced queries you could encounter while running a Joomla! Website. I have the idea it did. It teaches you how to make content, sort it, use several plugins, make backups and explains all features you should use if you run a Joomla! site.

What I liked about this book was that there was a picture every step. Therefore it`s difficult do make a fault with each step.

I can recommend this book for everyone who wants to learn the basics of Joomla.
As expected the book won`t tell you much about SEO, template or other advanced topics (like modules and extensions). Packt Publishing has plenty of books regarding those topics. (have a look here if you want to know more about these books)

What would I do to improve the book? I can`t think of anything right now.

Details