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
• Identify the hard drive/partition that is to be used 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
   • Add to c:\windows\my.ini:
     • [mysqld]
     • max_allowed_packet=16m
   • 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)

3. Create the site's database (<site> and a QA database <site>-qa )
   • SQLyog Menu-bar button to do this.
   • Create and load two copies of the database backup
     • Right-click database name and pick "restore from backup"

4. 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

5. 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: Core Business Server (prod); Core Business Server (qa)
     • 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--normally: ​http://localhost:8080 for prod and ​http://localhost:8090 for qa
   • Test a random query; ie: search for a customer

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