| | 1 | == Parts needed beforehand == |
| | 2 | |
| | 3 | * MySQL, SQLYog |
| | 4 | * A working build for the customer from CORK |
| | 5 | * A backup of customer's data from CORK |
| | 6 | * Java 1.4 |
| | 7 | |
| | 8 | == Steps == |
| | 9 | |
| | 10 | 1. Install Java on customer server |
| | 11 | |
| | 12 | 2. Install MySQL on customer server |
| | 13 | * Make sure MySQL service is started |
| | 14 | * Install SQLYog; using SQLYog |
| | 15 | * set password for root@"localhost" = password('root') |
| | 16 | * Create and load two copies of the database backup |
| | 17 | * <customername>-prod |
| | 18 | * <customername>-qa |
| | 19 | |
| | 20 | 3. Unpack CORE build, install |
| | 21 | * Edit plugin.xml |
| | 22 | * Set up -prod and -qa domains |
| | 23 | * Make sure jdbc URLs point at server name (not localhost) |
| | 24 | * Make sure domains point at correct databases |
| | 25 | |
| | 26 | 4. Set up NT services |
| | 27 | * Edit prod.wrapper.conf / qa.wrapper.conf |
| | 28 | * Adjust: name/id of domain; workspace location; service name |
| | 29 | * Use wrapper.exe to install services |
| | 30 | * -i - Install; -t - starT; -r - Remove |
| | 31 | * Start services. Use NT/XP's Services dialog to make sure the services started. (Hit Refresh a few times.) |
| | 32 | |
| | 33 | 5. Run CORE Workbench |
| | 34 | * Test queries |
| | 35 | * Test reports -- both web and PDF |
| | 36 | |
| | 37 | 6. Run CORE web |
| | 38 | * Test a random query |
| | 39 | |
| | 40 | 7. Install desktop shortcuts |
| | 41 | * CORE Workbench: Prod; CORE Workbench: QA |
| | 42 | * CORE Web: Prod; CORE Web: QA |
