== 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 ( and a QA database -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.\prod.wrapper.conf * wrapper -i com.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.\prod.wrapper.conf * wrapper -t com.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.\prod.wrapper.conf * wrapper -r com.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