CFM201

Technical Requirements

Operating System Options

• Windows XP Service Pack 2
• Windows Vista
• Windows 7
• Mac OS X

ColdFusion Application Server

• Download - You may need to register.
• System Requirements

Installation

Choose the default options during the installation, with the following exceptions:

• Step 3, Install Type: 'Developer Edition'
• Step 4, Install Configuration: 'Server Configuration'
• Step 10, Configure Web Servers: choose 'Built-in Web Server'.

If you have access to a networked or remote server with ColdFusion 8 or 9 and Microsoft Access, that will also work. In this case, you will need to be able to access ColdFusion Administrator to create Data Source names.

Database Choice

• Access (instructions below)
• MySQL (instructions below)

Microsoft Access 2000 or later

• If you do not have Microsoft Access, you can download a free trial of Microsoft Office Professional 2007, which includes Access 2007, from the Microsoft Web site.

MySQL 5.0

1. Download and install both the MySQL Community Server and the MySQL GUI Tools (MySQL Query Browser and MySQL Administrator).

Adobe Dreamweaver CS4

• Download - You may need to register.

Browser

At least one of the following browsers.

Browsers for Windows

• Mozilla Firefox 2.0 or greater - Download
• Internet Explorer 6 or greater - Download

Browsers for Mac OS X

• Mozilla Firefox 2.0 or greater - Download
• Safari 3.0 or greater - Download
  • Please note that accessing our online classes with Safari can cause problems. However, it is fine to preview exercise solutions using Safari.

ClassFiles

Download the class files.

1. Create a folder your web root directory called "Webucator" and extract the class files zip into that folder. Your web root is the default directory that your web server will use.
   1. Windows: This is usually located in C:\ColdFusion8\wwwroot if you are using the built-in web server, or C:\Inetpub\wwwroot if you are using IIS.
   2. Macintosh: This is usually located in Applications/ColdFusion9/wwwwroot if you are using the built-in web server, or /Library/WebServer if you are using Apache. If you are using apache, the configuration file is located at /etc/apache2/httpd.conf and is stated on the line that starts with "DocumentRoot"

1. If using MySQL, run the movieList.sql file (found in the Webucator > data folder that you previously extracted) at the MySQL prompt:
   1. Windows: Open a command promtpt (Start > Run >cmd,exe) and type: mysql --user=user_name --password=your_password < C:\ColdFusion8\wwwroot\Webucator\data\movieList.sql
   2. Macintosh: Open terminal (Applications > Utilities > Terminal) and enter: mysql --user=user_name --password=your_password < /Applications/ColdFusion8/wwwroot/Webucator/data/movieList.sql

1. Create a data source in ColdFusion administrator called "movieList" that points to the runners.mdb Access file in the data directory OR the MySQL Runners database if using MySQL.
   1. There is a good tutorial on this at http://www.quackit.com/coldfusion/tutorial/coldfusion_datasource.cfm. If you're taking an live online class, your instructor will walk you through it in class.
   2. Open your browser to http://localhost/CFIDE/Administrator/ (or http://localhost:8500 or http://localhost:3500 if using the Built-in web server).
   3. Log in using the password you provided during the installation.
   4. Click on 'Data Sources' in the left-hand menu, under the heading 'Data & Services'
   5. If you are using Access: Enter the Data Source Name as 'movieList', select the Microsoft Access Driver, and click 'Add'. Enter the path location to the runners.mdb file in the ClassFiles/Setup directory in the Database File field. This path is most likely C:\ColdFusion8\wwwroot\Webucator\data\movieList.mdb if you are using the built-in web server on Windows, or /Application/ColdFusion8/wwwroot/Webucator/data/movieList.mdb
   6. If you are using MySQL: Enter the Data Source Name as 'movieList', select the MySQL (4/5) Driver, and click 'Add'. Enter the Database 'movieList', server 'localhost', and your username and password for MySQL that you setup previously. Click the 'Submit' button.

FAQ

• If you choose to use the ColdFusion built-in web server as one of the options during the install (recommended unless already running Apache or IIS), you will need to use the port as specified on line 350 of the jrun.xml file (usually 3500 or 8500) that is located at "C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\jrun.xml". To test the setup, open the browser to http://localhost:8500/Webucator/... replacing "8500" with the appropriate port number.