DONATE:2010 Fall Installation Guide

System Requirements
DONATE will be implemented and maintained by the UNHM CIS program. The DONATE Assistant must be able to access the DONATE server application by logging onto their Windows XP computers and launching the DONATE client application, enabling communication with the DONATE server application over a wired, local area network. A Windows XP computer runs the DONATE server application and Microsoft SQL server storing the DONATE database. The system will be password protected to ensure confidentiality and integrity of information.

Performance Requirements
Donate will be highly functional for general users with no required background of the underlying technologies of the system. The users of DONATE will be provided with easy to follow step-by-step documentation of how to perform tasks on the system. The DONATE system will have a comfortable, intuitive GUI (Graphical User Interface) which will simplify data input, output and interpretation.

Hardware and Software Architecture
The DONATE Interface Subsystem runs on a Windows XP client machine. The DONATE Control Subsystem is realized through PHP coding and Javascript functions which manage the logic between the GUI and the DONATE Database Subsystem, which is managed by Microsoft SQL Server DBMS which executes on a Windows server machine.

The DONATE Assistant depends on the User Interface subsystem to provide a graphic interface to initiate all DONATE functions (i.e., use cases). The User Interface subsystem depends on the Control subsystem for access, concurrency, and management services (ManageService), including management of donors, management of donations, and management of events. In doing so, the Control subsystem depends on the Database subsystem for query services, data retrieval, and data storage (DataService).



XAMPP
The XAMPP web server package contains the Apache web server, MySQL and PHP needed to run the DONATE application.

The package can be downloaded at http://sourceforge.net/projects/xampp/files

Installation
Double click the XAMPP setup icon on your desktop or downloads folder.

Once files have been extracted (this can take a while) you will receive a prompt in a terminal window. Pay no attention to the blatant spelling errors.

The first Prompt will ask if you would like a shortcut(icon) on the desktop/start-menu.
 * If you are installing on the C:\ drive just hit enter to accept the default setting.

The next Prompt asks if the installer should locate the XAMPP paths correctly.
 * Hit enter to accept the default setting.

The next prompt is important. It asks if it should make XAMPP portable.
 * For C:\ install press enter to accept the default setting.

At this point it will finish the install hit "Enter" when prompted to do so

Check the timezone and make sure it is correct or at least close enough "America/New_York" is acceptable.

Testing Install
At this point XAMPP is ready to be used.

Click the XAMPP desktop icon.

From the XAMPP-control you can start the services by clicking the "start" button. Click the Svc box next to Apache MySQL and FileZilla The start button for Tomcat will be grayed out this is acceptable.

To test that your install complete successfully.
 * Type: "localhost" into the address bar of your browser.
 * You should get a XAMPP Screen Click english unless your fluent in another language.
 * If you don't get the XAMPP page type the entire address "http://localhost/xampp/" or "http://127.0.0.1/xampp/"
 * XAMPP should congratulate you on your install, thank her its polite.

Click "Status" on the left side bar to be sure all services are running.

Accessing MySQL
The MySQL command line interface program, mysql.exe, is now installed in a bin directory in the XAMPP folder. The path to this, depending on where you put your XAMPP folder, will be something like this: C:\Program Files\Xampp\mysql\bin\mysql.exe.

To access MySQL via command line, you need to open a terminal utility (Windows Command for Windows OS or Terminal Program for MAC OS).

Using the MySQL Dump to create the database
You set up you database using a MySQL Dump file this will ensure your database has no errors from human interaction. And that it is an exact copy of the design. The syntax to create and restore a database from MySQL is remarkably simple: backup:
 * 1) mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore: NOTICE: There is only minimal difference in the syntax.
 * 1) mysql -u root -p[root_password] [database_name] < dumpfilename.sql



Manually Creating the Database and Tables in MySQL
Beginning at C:\ in the path to your MySQL bin followed by “mysql.exe –u root –p” (no quotes). This starts MySQL using the username “root” and NO password. When prompted for a password, hit enter.

Create the DONATE database using the following commands: mysql>create database donate; mysql>use donate; Start creating tables for the DONATE database by exactly following the commands in the screen shot Illustration: Create Tables.

Stop after creating the event table and receiving the Query OK message.

The next several commands will add key information that will relate tables. Enter the next set of commands, beginning after the Query OK message from the event table.