Projekt mspr@job1: Difference between revisions
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
* Create instance db2mspr | * Create instance db2mspr | ||
* Configure instance like db2inst4 on job4 | * Configure instance like db2inst4 on job4 | ||
* Create connect user db2inst2 (required because tables have this schema) | |||
* Create loader user mspr (loads data from mspr web/xml pages) | |||
* Clone mspr repository (for scripts and docs) | * Clone mspr repository (for scripts and docs) | ||
* Install pdo for db2 (see howto in database/) | * Install pdo for db2 (see howto in database/) | ||
Revision as of 16:07, 9 February 2012
How I move the MSPR site from job4 to job1
Preparation
- Install standard opensuse 12.1
- Add repositories pacman, nvidia, vlc
- Install the following packages
zypper install apache2 php5 hg apache2-mod_php5
- Install db2 express-c 9.7.4
- Create instance db2mspr
- Configure instance like db2inst4 on job4
- Create connect user db2inst2 (required because tables have this schema)
- Create loader user mspr (loads data from mspr web/xml pages)
- Clone mspr repository (for scripts and docs)
- Install pdo for db2 (see howto in database/)
Test Installation
- restore database from last backup and logs from job4 and document steps
- Create portforward public :801 to job1:80
- Enable apache to access the database
- Check if pages show correct results
- Setup cron fro data imports
- Testrun for data import
Production Switch
- disable update on job4
- restore db again
- test again
- move public :80 port