Parts needed beforehand

• MySQL, SQLYog
• A working build for the customer from CORK
• A backup of customer's data from CORK
• Java 1.4

• Identify which server CORE is to be installed on

And which hard drive (parition) it is to use for the database. Must have at least ?? GB of hard drive space.

Steps

1. Install Java on customer server

2. Install MySQL on customer server
   • Make sure MySQL service is started (look for "MySQL" in the Windows Services page)
   • Install SQLyog; using SQLyog
     • set password for root@"localhost" = password('root')
   • (Go to Query command window to do this)

• Create the site's database (<site> and a QA database <site>qa )

• Create and load two copies of the database backup

3. Unpack CORE build, install (how? Unzip to ? C:\CORE ?)
   • Edit plugin.xml
     • Set up -prod and -qa domains
     • Make sure jdbc URLs point at server name (not localhost)
     • Make sure domains point at correct databases

4. Set up Windows services
   • Edit prod.wrapper.conf / qa.wrapper.conf (start from a copy of the edited prod.wrapper.conf)
     • Adjust: name/id of domain; workspace location; service name
   • Use wrapper.exe to install services (from C:\CORE\plugins)
     • wrapper -i com.<site>\prod.wrapper.conf
     • wrapper -i com.<site>qa\qa.wrapper.conf

• -i - Install; -t - starT; -r - Remove

• Start services. Use NT/XP's Services dialog to make sure the services started. (Hit Refresh a few times.)

• services are: (Remote Procedure Call (RPC) and...)
  • wrapper -t com.<site>\prod.wrapper.conf
  • wrapper -t com.<site>qa\qa.wrapper.conf

• If the services don't start, they can be removed and issues with the .conf files debugged by
  • wrapper -r com.<site>\prod.wrapper.conf
  • wrapper -r com.<site>qa\qa.wrapper.conf

5. Run CORE Workbench
   • Test queries
   • Test reports -- both web and PDF

6. Run CORE web
   • Test a random query

(what web address should be used?)

7. Install desktop shortcuts
   • CORE Workbench: Prod; CORE Workbench: QA
   • CORE Web: Prod; CORE Web: QA

(how do you get to the web again? Set up links using port 8080 for the production DB and port 8090 for QA db)