Projekt mspr@job1

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/)

next task:

• Install scripts for import and web

Test Installation

• restore database from last backup and logs from job4 and document steps
• Create portforward public :801 to job1:80
• Check if pages show correct results
• Setup cron for data imports
• Testrun for data import

Production Switch

• disable update on job4
• restore db again
• test again
• move public :80 port