130 likes | 151 Views
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). Kubuntu -
E N D
Shining A Light on Open Source Software: Going Beyond LAMPP Serving Web Content UsingOpen Source Software
What is LAMPP? • LAMPP stands for: • Linux (operating system) • Apache (web server) • MySQL (database application) • PHP (scripting language) • Perl (scripting language)
Kubuntu - http://www.kubuntu.org/download.php#latest 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/ Where can I get…
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 S99lamppln -s /opt/lampp/lampp K01lampp • A symbolic link to XAMPP’s start & stop command has now been created
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 Security Considerations
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