Department of Defense Education Activity/Client computer installation steps

Following are steps to prepare a Windows XP-based computer to run the DDESS PM Study software.

Install Ruby on Rails Application Environment
Follow install steps at the Ruby on Rails site. Use install packages on thumbdrive if available.

Note: some steps require Internet connection

> cd c:\temp\rubygems-1.2.0 > ruby setup.rb > gem install rails --include-dependencies > gem install mongrel > gem install activerecord-sqlserver-adapter -s http://gems.rubyonrails.org
 * Download/install Ruby 1.8.6 using Windows installer.
 * Take defaults on all wizard pages. This will install Ruby in c:\ruby folder.
 * Install RubyGems 1.2.0, Rails and necessary support files
 * Extract contents of [[media:Rubygems-1.2.0.zip|RubyGems-1.2.0.zip]] to c:\temp folder.
 * Open a dos command window and run RubyGem setup, download Rails and install mongrel app server:
 * Install the SQL Server connection adapter.
 * Create folder: C:\ruby\lib\ruby\site_ruby\1.8\DBD\ADO. Copy the file [[media:ADO.zip|ADO.rb]] to this new folder (for background, see How to Connect to SQL Server).  Install the SQL Server adapter gem:

Install SQL Server Express Database
Follow steps on SQL Server 2008 Express Edition page to install database. Note: the page references 2008 Edition, use same procedures for SQL Server Express 2005.

Important Notes

 * During install, on Feature Selection page, click the icon to install Client Components/Connectivity Components
 * Choose mixed mode authentication option and remember password you provide for later configuration step

SQL Server Configuration Manager - Client Protocols: Enable TCP/IP?

Install SQL Server 2005 Management Studio Express

 * Access Management Studio Express installation on thumbdrive or |web download site
 * Take defaults on all install wizard pages

Configure SQL Server for DDESS
create database pms_development; create database pms_test; create database pms_production;
 * From the Start menu, launch SQL Server Management Studio Express
 * On Connect to Server dialog box, connect to SQL Server instance on local machine, e.g; COWBOYS\SQLEXPRESS. Note this name, as you will need it to configure database access for the PM Study application below.
 * In Object Explorer Window, click Databases.
 * Click New Query button and type following SQL commands in the query window, clicking Execute button after each one:

Install Software Repository Download Client

 * Install TortoiseSVN 1.5.0.13316 Subversion client from the thumbdrive or download site.
 * Take defaults on all install wizard pages
 * Restart the computer

Install PM Study Application
Note: these steps require Internet access
 * 1) Download software from the version control repository
 * 2) Open a File Explorer Window
 * 3) Create the folder path: c:\webserver\current
 * 4) Right-click on the folder and choose TortoiseSVN > Repo-browser
 * 5) In the URL window, type: http://svn.g-and-.o.com/svnroot/ddess/pms and click OK
 * 6) This will open the G&O SVN repository.  Right click on Trunk folder, and click Export
 * 7) In the Export directory text box, enter path to: c:\webserver\current.  Click OK and the application files will download

Prepare Database Access
The application uses the database.yml configuration file in the folder: c:\webserver\current\config to store database access settings. You can use Notepad to substitute values in the sample file below to reflect your configuration.

c:\webserver\current\config\database.yml development: adapter: sqlserver database: pms_development host: LMD-DTHOMAS-LT\SQLEXPRESS username: sa password:
 * 1)   Connect to SQL Server/Express

test: adapter: sqlserver database: pms_test host: LMD-DTHOMAS-LT\SQLEXPRESS username: sa password:

production: adapter: sqlserver database: pms_production host: LMD-DTHOMAS-LT\SQLEXPRESS username: sa password:

Generate the Database
Open a dos window and use the following commands to build application's database tables: > cd c:\webserver\current > rake db:migrate If the command is successful, a string of logging will scroll by in the window. If you receive an error message, it may indicate:
 * Database access permissions (in database.yml)
 * SQL Server database configuration
 * RoR SQL Server adaptor setup

Start the PM Study Application
The DDESS application is web browser based. In a dos command window, start the local web server to serve pages to your browser: > cd c:\webserver\current > mongrel_rails start -p 80 Minimize the window, but leave it open - closing the window will shut down the web server and end access to the application.

Open a web browser window and point to the following address: http://localhost/school The DDESS Preventive Maintenance home page will appear.