Help:COAP-3180/week2

Week 2 - COAP 3180

Topics Covered

We will explorer (concurrently) the following topics:

Web application architecture overview

• Overview of web hosting alternatives
• Application architectures / frameworks overview
• WAMP/LAMP software bundles and applications, various options
• Use of a portable WAMP architecture (Mowes)
• The three tier model

Short overview of databases

• What is a Database and how is it used in Internet applications ?
• Relational data base management systems (RDBMS) and ownership of databases
• MySQL (databases, tables and users): First contact with this RDBMS

Portalware (Content management systems / light-weight web application frameworks)

• Short overview of typical LAMP-based systems systems (and similar)
• An overview of typical installation and configuration work.

Classroom activities

Monday

(1) Mix, download and install a Mowes combo'

(a) Download the Modular Webserver System (Mowes) server

• http://www.chsoftware.net/en/mowes/mowesportable/mowes.htm (Mix and download a server).

You will need at least the following modules

• Server software

Apache 2_SE

MySQL 5_SE

PHP5

• Mission critical application software (!!)

PHPMyAdmin

• Application software

Drupal

Joomla

ModX

Wordpress

(b) Dezip the downloaded archive to drive c:\temp2

• Ask a lab assistant or the instructor if you need help with 7zip

(c) Click on Mowes.exe

• This will install the Mowes server in the directory plus install all the downloaded application software. Be patient. This may take some time.

(d) You can add other portals by downloading a new module from MOWES. Drop the file to the top-level directory and restart the mowes application.

Getting your own copy

• You may copy the whole directory to a memory stick (may take a full hour to copy). Applications will continue to work. Mowes doesn't write anything to a system directory or the registry and will adapt to a new directory structure.
• Alternatively, you can re-enact the process at home on your personal computer...

Donwlaod again from http://www.chsoftware.net/en/mowes/mowesportable/mowes.htm

(2) A tour of the Mowes WAMP system

• The instructor will show some features of the system and relate it to an introductory talk about web applications

(3) Playing with portalware

• Use http://php.opensourcecms.com/ according to instructions
• For homework, you also should consult the portalware article

(4) Configuration of portalware (Mowes)

• Mowes packages all include the same admin login and password.

Login = admin and password = password

• You may need to figure the admin URL for each application.

Wednesday

(1) Configuration of Wordpress

• Install Wordpress (if it is not alreday present in your MOWES install !). If you have to install:
  • Get the package from http://www.chsoftware.net/en/mowes/mowesportable/mowes.htm
  • Save the file into the mowes top-level directory (should look like below)

       18348 09-24 15:25 GPL.txt
         660 09-24 15:25 Licence.txt
           0 01-12 22:08 apache2
           0 01-12 22:07 mowes
      409600 09-24 15:25 mowes.exe
           0 01-12 22:08 mysql
           0 01-12 22:08 php5
           0 01-12 22:13 www

• • (re)start the server. Wordpress will be automatically installed

• Update
  • Log in as admin (password = password)
  • Click on the update banner to automatically update Wordpress to a latest version. (also available in Tools->Upgrade)

(2) Configure wordpress

• See wordpress installation and configuration

• Change the theme

• Change the contents of the first default article, then post an article

• Remove / add links

• Add the formidable plugin (http://wordpress.org/extend/plugins/formidable/)
  • This will allow you to create forms (a bit like Zoho creator)
  • Click on the "Formidable" icon at the bottom of the left-hand "Dashboard" column in the admin interface and define a form
  • Create a page (click on pages), then add the "formidable" form inside. Use the following code to insert a form:

[ formidable id=x ]

• Add a user or two and test drive with these (using a different web browser)

(3) Installing applications that are not packaged by MOWES

• Create a database and a database user with PhpMyAdmin
• Download, dezip to mowes/www directory
• Install/configure the system according to instructions found

Students not familiar with this procedure should install a new version of wordpress.

• Make sure to dezip the system into another directory than .www/wordpress, e.g. call it .www/blog.
• Read wordpress installation and configuration

(3) Discussion about web hosting

Homework 2

Topic: High-level exploration of a portalware (CMS/CMF) / preparation of the term project

Task

Details TBA (available on Wednesday). Provisional synopsis:

Task Summary:

1. Shortly sketch out a website project for a given targent audience
2. Collect links about a portalware (not wordpress) that "may do the job" and create a resource about this select
3. Finally, try to install it on a local webserver (or a provider) and make a simple test to see if it runs

Deliverable: Produce a resource (e.g. an HTML page) that includes the following elements:

• Objectives and target population of a web site that you plan to create. Remark: This website must include some dynamic elements (e.g. the possibility to add contents for specified users)
• Create a shortlist of three CMS/CMF systems that run under PHP/MySQL
• Select the most promising one and add the following links:
  • Download page of the software
  • A link to two respectable websites that provide comments and evaluations of this system
  • Link to the installation manual
  • Link to the configuration manual (if different)
  • 2-3 links to other useful help sites
• Install the system with MOWES. If the installation fails, try to explain why.
• Create at least one form of content and explain what you had to do.
• Write a short comment about the portware you look at.

• Important: You are not allowed to choose Wordpress since I want to look at another system, but you may choose it for the term project ...)

You can create this resource in three ways:

• Create a webpage and submit the web page (you don't need to hand code HTML, just use a tool like Kompozer)
• Create a netvibes pagecast and submit the URL
• User your own personal web site and submit the URL

This homework is a preparation for the term project.

Submission Dates

• This homework is due on wednesday week 3 (before lesson start)
• Students must provide an URL or a file in the world classroom
• Each homework counts 10% in your global evaluation. The four best homeworks will be taken into account.

Evaluation

TBA.

Tips for the homework

• The easiest solution is to select a system available that is available as Mowes package, e.g.

ModX, Typolight, Drupal, Joomla, Zikula (all CMS/CMF), Wordpress (a blog),

Links and teaching materials

Software

• http://www.chsoftware.net/en/mowes/mowesportable/mowes.htm (Mix and download a server).
• See the portalware article for pointers regarding CMS/CMF systems

Teaching materials

• Slides: http://tecfa.unige.ch/guides/te/files/webdatabases-intro.pdf (PDF)
• See the next item for various links you may consult depending on your needs

Reading

I suggest that you have a look at the following articles. Reading is not mandatory, but may help you understand some concepts and issues.

• About Web hosting
  • Web Hosting Service (Wikipedia)
• Shared web hosting service

• About the LAMP/WAMP bundles
  • LAMP (software bundle) (Wikipedia) - WAMP/LAMP (this wiki)
  • Wikipedia has extensive documentation on databases, e.g. about SQL or about the MySQL RDMS.

• About Web applications, content management frameworks and systems
  • (short) Edutechwiki articles: web application, Portalware, content management system, Web application framework