Transcript setting up lampp and other open source software

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
 PHP Timeclock –
– http://sourceforge.net/pr
ojects/timeclock/
 XAMPP –
– http://www.apachefriend
s.org/en/xampplinux.html
 Drupal –
– http://drupal.org/
 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