1 / 12

Migrating Commonspot Sites

Migrating Commonspot Sites. Paul Houle Peter Hoyt Library Systems. Thanks: James Reidy, Surinder Ghangas. Context. Support 21 unit libraries and many projects Copia, our primary web server has > 50 virtual hosts Commonspot sites up and running: Transition to Fatherhood

kapono
Download Presentation

Migrating Commonspot Sites

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Migrating Commonspot Sites Paul Houle Peter Hoyt Library Systems Thanks: James Reidy, Surinder Ghangas

  2. Context • Support 21 unit libraries and many projects • Copia, our primary web server has > 50 virtual hosts • Commonspot sites up and running: • Transition to Fatherhood • Public Services Committee • Under development: • Mann Library • ASTEC (Engineering, Math & Physical Sciences and Vet) • NY Aerial Photos

  3. Hardware Sun Fire V440 Solaris 9 fibre channel StorEdge 6130 Array

  4. Software • Solaris 9 • Oracle 9.2.0.6 • Cold Fusion MX 6.1 Enterprise Edition (Jrun 4) • Apache 2 • CommonSpot 4.5sp2 • CornellCustomAuthZ

  5. Two Instances SPOT SPOTTEST http port X http port 80 /spot/ apache /spottest/ apache spot jrun spottest jrun SPOT oracle SPOTTEST oracle

  6. Database Structure SPOT SITES USERS SPOTTEST SITE A SITES USERS

  7. The problem… SPOTTEST.users SPOT.users SPOTTEST.pages

  8. Stages • Find missing users in production system • Add missing users to production system • Create mapping of test -> production user ids • Get database schema dump • Extract list of user id fields • Update user ids

  9. Schema Dump CREATE TABLE "PSA_SITE"."APPROVAL" ( "PAGEID" NUMBER(12,0) NOT NULL ENABLE, "CONTROLID" NUMBER(12,0) NOT NULL ENABLE, "ITEMID" NUMBER(12,0) DEFAULT 0, "USERGROUPID" NUMBER(12,0) NOT NULL ENABLE, "APPROVALTABLELIST" NVARCHAR2(255) NOT NULL ENABLE, "STATUS" NUMBER(12,0) DEFAULT 0, "APPROVALDATE" VARCHAR2(20), "APPROVALLEVEL" NUMBER(3,0) DEFAULT 0, "APPROVEDBY" NUMBER(12,0) DEFAULT 0, CONSTRAINT "PK__APPROVAL" PRIMARY KEY ("PAGEID", "CONTROLID", "ITEMID","USERGROUPID","APPROVALTABLELIST") )

  10. Heuristics I KEEP COLUMNS AUTHOR CHANGEBY CREATOR DELETEDBY GROUP OWNER REQUEST USER STOP COLUMNS ATTRIBORDER CATEGORY CONTROLID CHARID CONTROLLIST ELEMENTID ITEM MASK PAGE QUERYID SORTORDER TYPE VERSION HEIGHT DROP TABLES AVAILABLECONTROLS CATEGOR FORMAT LANGUAGE SITEPAGES SYSTEM TRANSACT

  11. Heuristics II • Group ids start with 1,000,000 • Look at values to see if a column contains user id’s • Is it numeric? • Do the numbers match users and groups? • LIST columns, ex. *.ITEMUSERGROUPLIST • Format: “7,12,55”

  12. Commonspot Software Configuration: James Reidy (jgr25@cornell.edu) Apache, Jrun, CFMX, SAMBA: Paul Houle (ph18@cornell.edu) Oracle, Backups, Unix admin: Surinder Ghangas (sg14@cornell.edu) General Questions: Oya Rieger (oyr1@cornell.edu) http://commonspot.library.cornell.edu/

More Related