Projekt mspr@job1: Difference between revisions

From JoBaPedia
Jump to navigation Jump to search
Line 21: Line 21:
* restore database from last backup and logs from job4 and document steps
* restore database from last backup and logs from job4 and document steps
* Create portforward public :801 to job1:80
* Create portforward public :801 to job1:80
* Enable apache to access the database
* Check if pages show correct results
* Check if pages show correct results
* Setup cron fro data imports
* Setup cron for data imports
* Testrun for data import
* Testrun for data import



Revision as of 20:20, 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/)

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