Shining A Light on Open Source Software: Going Beyond LAMPP

Serving Web Content Using Open Source Software

What is LAMPP?

 LAMPP stands for: – Linux (operating system) – Apache (web server) – MySQL (database application) – PHP (scripting language) – Perl (scripting language)

Where can I get…

   Kubuntu – http://www.kubuntu.org/ download.php#latest XAMPP – – http://www.apachefriend

s.org/en/xampp linux.html

Drupal – – http://drupal.org/  PHP Timeclock – – http://sourceforge.net/pr ojects/timeclock/  MRBS – – http://sourceforge.net/pr ojects/mrbs/

Before we can serve content…

  We’ll need a webserver XAMPP includes: – 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.

How do I install XAMPP?

   Navigate to the directory where the downloaded file is located  Run the command: – tar xvfz xampp-linux-1.6.6.tar.gz -C /opt Keep in mind that Linux is case sensitive Start XAMPP as root: – sudo /opt/lampp/lampp start

What happens when I reboot?

 When you reboot the machine, XAMPP might not start automatically  To fix this, change directories to: – /etc/rc2.d

  And run these commands – n -s /opt/lampp/lampp S99lampp ln -s /opt/lampp/lampp K01lampp A symbolic link to XAMPP’s start & stop command has now been created

Security Considerations

 As a Developer: – All Apache modules are enabled – MySQL is enabled without a password – ProFTP is enabled without a password – Most options turned on by default  From a security standpoint: – System is wide open to potential attacks  Run the security command to close most of the glaring security holes – /opt/lampp/lampp security

What is a CMS?

   CMS stands for: Content Management System Keeps content consistent and organized Drupal is one of the larger, free, open source CMS’s available

How do I install Drupal?

     Copy the extracted file to /opt/lampp/htdocs Setup a database for Drupal in phpMyAdmin Setup a user and permissions for Drupal in phpMyAdmin Set permissions for /opt/lampp/htdocs/drupal/sites/default/settings.

php Run Drupal install script

Drupal housekeeping

     Create the first account Navigate to Administrator Run a status report Fix any issues noted in the report The Drupal handbook will answer most install and basic setup questions: – http://drupal.org/getting-started

PHP Timeclock

   Download and unpack file to htdocs Set up database in phpMyAdmin Setup user and permissions in phpMyAdmin under the SQL function: – GRANT SELECT, UPDATE, INSERT, DELETE, ALTER, CREATE , LOCK TABLES ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password'; – Setup the required tables

MRBS

 MRBS stands for: – Meeting Room Booking System  The Law Library uses MRBS so that students can book study rooms within the library  MRBS can be configured to work with LDAP or Active Directory

Setting up MRBS

   Download and unpack file to htdocs Set up database in phpMyAdmin Setup user and permissions in phpMyAdmin under the SQL function: – GRANT SELECT, UPDATE, INSERT, DELETE, ALTER, CREATE , LOCK TABLES ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password'; – Setup the required tables – Configure config.inc.php