Shining A Light on Open Source Software: Going Beyond LAMPP

1
Shining A Light on Open Source Software Going
Beyond LAMPP

• Serving Web Content UsingOpen Source Software

2
What is LAMPP?

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

3
Where can I get

• Kubuntu -
• http//www.kubuntu.org/download.phplatest
• XAMPP
• http//www.apachefriends.org/en/xampp-linux.html
• Drupal
• http//drupal.org/

• PHP Timeclock
• http//sourceforge.net/projects/timeclock/
• MRBS
• http//sourceforge.net/projects/mrbs/

4
Before we can serve content

• Well 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.

5
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

6
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 S99lamppln -s
  /opt/lampp/lampp K01lampp
• A symbolic link to XAMPPs start stop command
  has now been created

7
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

8
What is a CMS?

• CMS stands for Content Management System
• Keeps content consistent and organized
• Drupal is one of the larger, free, open source
  CMSs available

9
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

10
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

11
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'_at_'localhost' IDENTIFIED BY 'password'
• Setup the required tables

12
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

13
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'_at_'localhost' IDENTIFIED BY 'password'
• Setup the required tables
• Configure config.inc.php