Install/Configure Apache, PHP, CakePHP and MySQL on SUSE Linux Enterprise Server 11






Although Apache and PHP packages are already available in SLES-11 DVD but here i want to use XAMPP Software for Apache, PHP, MySQL and Perl Installation/Configuration on SUSE Linux Enterprise Server 11. Many people know from their own experience that it's not easy to install an Apache web server and it gets harder if you want to add MySQL, PHP and Perl.




XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use - just download, extract and start.




The distribution for Linux systems contains: Apache, MySQL, PHP & PEAR, Perl, ProFTPD, phpMyAdmin, OpenSSL, GD, Freetype2, libjpeg, libpng, gdbm, zlib, expat, Sablotron, libxml, Ming, Webalizer, pdf class, ncurses, mod_perl, FreeTDS, gettext, mcrypt, mhash, eAccelerator, SQLite and IMAP C-Client.




Step 1: Download XAMPP




Download the XAMPP software from their webstie freely.





Step2: Installation on SLES-11



After downloading simply type in the following commands:


  1. Go to a Command prompt and login as the system administrator root:
    # su - root



  2. Extract the downloaded archive file to /opt:
    # tar xvfz xampp-linux-1.7.2.tar.gz -C /opt










That's all. XAMPP is now installed below the /opt/lampp directory.




Step 3: Start




To start XAMPP simply call this command:


# /opt/lampp/lampp start




Ready. Apache, PHP and MySQL are running.




Step 4: Test




Type in the following URL at your web browser:


http://localhost












Now you should see the start page of XAMPP containing some links to check the status of the installed software and some small programming examples.



Here is the Directory Structure of LAMPP






Here is a list of missing security in XAMPP:


  1. The MySQL administrator (root) has no password.
  2. The MySQL daemon is accessible via network.
  3. ProFTPD uses the password "lampp" for user "nobody".
  4. PhpMyAdmin is accessible via network.
  5. Examples are accessible via network.
  6. MySQL and Apache running under the same user (nobody).


To fix most of the security weaknesses simply call the following command on the command prompt:
# /opt/lampp/lampp security








Important Files and Directories





File/Directory

Purpose




/opt/lampp/bin/

The XAMPP commands home. /opt/lampp/bin/mysql calls for example the MySQL monitor.




/opt/lampp/htdocs/

The Apache DocumentRoot directory.




/opt/lampp/etc/httpd.conf

The Apache configuration file.




/opt/lampp/etc/my.cnf

The MySQL configuration file.




/opt/lampp/etc/php.ini

The PHP configuration file.




/opt/lampp/etc/proftpd.conf

The ProFTPD configuration file. (since 0.9.5)




/opt/lampp/phpmyadmin/config.inc.php

The phpMyAdmin configuration file.






Stopping XAMPP








To stop XAMPP simply call this command:


/opt/lampp/lampp stop




CakePHP




CakePHP is a rapid development framework for PHP that provides an extensible architecture for developing, maintaining, and deploying applications. Using commonly known design patterns likeMVC and ORM within the convention over configuration paradigm, CakePHP reduces development costs and helps developers write less code.


Step1: Download




Download  CakePHP from their website.


Step2: Unzip





Extract the download archive into /opt/lampp/htdocs directory using following command.


# unzip cake_1.2.5.zip







Step3: Rename CakePHP Directory




Rename the newly extracted directory of Cake_1.2.5 to mycakephp or any other suitable name.

# mv cake_1.2.5 mycakephp




Step 4: Test




Type in the following URL at your web browser:
http://localhost/mycakephp




Now you should see the start page of CakePHP containing some error. Now step by step we solve these errors.


Step5: Set Writable Permission to tmp Directory




Change the mod of tmp directory that is placed in /opt/lampp/htdocs/mycakephp/app.
# chmod 777 -R tmp/

Now refresh your browser. you should see that now tmp directory is writable.



Step6: Configure MySQL




Now move to /opt/lampp/htdocs/mycakephp/app/config directory. In this directory rename the file named database.php.default to database.php. Use given below command to rename.
# mv database.php.default database.php


Now open database.php file and go to the end of file.
Change the login user, password and define database name in the database parameter. In my case Login user is 'Root', Password is 'blank', and Database name is 'caketodoo'. Change in both Default and Test variables.






Now refresh your browser. you should see that the database is configured and Cake is able to connect to the database.





The Directory Structure of CakePHP is:-





Installation and Configuration DONE



Comments

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more