Projekt mspr@job1: Difference between revisions

From JoBaPedia
Jump to navigation Jump to search
Line 15: Line 15:
* 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/)
* Enable apache to access instance db2mspr
'''next task:'''
'''next task:'''
* Install scripts for import and web
* Install scripts for import and web

Revision as of 20:21, 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/)
  • Enable apache to access instance db2mspr

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