Commonspot Installation at Cornell University Library Paul Houle

Commonspot Installation at Cornell University Library Paul Houle Library Systems Thanks: James Reidy, Surinder Ghangas, Ken Friedman, Chris Manly, David De. Mello and Oya Reiger

Training Strategy Contributors Developers Designers Commonspot Oracle Apache Solaris HW The Big Picture CFMX

Context • Support 21 unit libraries and many projects • Current web server, copia, has • > 40 virtual hosts • > 170 toplevel directories • 500, 000+ hits/day • Availability, Maintainability • Separate production and test • Isolate essential from inessential • Tight control

Hardware Sun Fire V 440 Solaris 9 fibre channel Stor. Edge 6130 Array

Software • Solaris 9 • Oracle 9. 2. 0. 6 • Cold Fusion MX 6. 1 Enterprise Edition (Jrun 4) • 2 x license for 4 CPU machine • install service pack 1 • upgrade Oracle drivers from Macromedia • Apache 2. 0. 54 • mod_cuwebauth • mod_jrun 20 • Common. Spot 4. 5 sp 1 • Cornell. Custom. Auth. Z

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

CFMX Installation • Multiple instances of Coldfusion: • Used J 2 EE installation mode w/ Jrun 4 (/opt/coldfusion/jrun 4) • Install CFMX twice (/opt/coldfusion 2/jrun 4) • mv /opt/coldfusion 2/jrun 4/servers/cfusion -> /opt/coldfusion/jrun 4/servers/spottest • JRUN Management console is nice, but. . • all servers must run as same UNIX user • no per-server jvm. config • /etc/init. d/{spot, spottest}-jrun • Use –config option to specify correct jvm. config

Namespace • Two to four letter code per site: • commonspot. library. cornell. edu -> cs • dlit. library. cornell. edu -> dl • insidecul. library. cornell. edu -> ins • Commonspot gets own root directory • can install other apps • good for migration: add redirects to new site • Avoids namespace collisions inside Cold Fusion • Short names can be used to compose Solaris usernames: • cs -> smb_cs

Apache Directory Layout /spot/ apache 2/ bin/ conf/ httpd. conf vhosts. conf … commonspot/ commonspot-data/ sites/ commonspot. library. cornell. edu/ dlit. library. cornell. edu/

httpd. conf and vhost. conf httpd. conf: … Include conf/vhosts. conf: … <Virtual. Host commonspot. library. cornell. edu> Include/spot/sites/commonspot. library. cornell. edu/conf/h ost. conf </Virtual. Host> …

Virtual host directory /spottest/sites/commonspot. library. cornell. edu/ conf/ host. conf designer/ … htdocs/ logs/ access_log error_log

host. conf Server. Admin ph 18@cornell. edu Server. Name commonspot. library. cornell. edu Document. Root /spottest/sites/commonspot. library. cornell. edu/htdocs Error. Log /spottest/sites/commonspot. library. cornell. edu/logs/error_l og Custom. Log /spottest/sites/commonspot. library. cornell. edu/logs/access_ log combined Rewrite. Engine On Rewrite. Rule ^/$ /cs/ [R] Alias /commonspot/ /spottest/commonspot/

Remote Access • Designers and programmers use SAMBA to access selected files in test instance. • Files belong to smb_{site name} • Symbolic links provide controlled view: • \spot. library. cornell. edu{site_name} /spottest/sites/commonspot. library. cornell. edu/designer/ customcf ->. . /htdocs/cs/customcf renderhandlers ->. . /htdocs/cs/renderhandlers style ->. . /htdocs/cs/style templates ->. . /htdocs/cs/templates

Backups • System Backup • Weekly backup with mksysdb – keep 3 weeks back • Filesystem backup • ASDM incremental backup nightly – keep 3 version • Oracle Backup • incremental backup – every 8 hours • flush redo logs to archive • backup archive with ASDM • full backup – weekly, 5 am Saturday • shutdown oracle, take snapshot, restart oracle • mount snapshot, backup with ASDM -- Surinder Ghangas

CUWeb. Auth authentication • Developed by David Demello (ddd 1@cornell. edu) • Installation on server: • Install Cornell. Custom. Auth. Z in Commonspot Directory • Edit config. xml • (optional) put hooks in commonspot/newsite • Installation per site: • Hook files: login. cfm, after—login. cfm, custom-authentication. cfm, force-login. cfm • Edit config. xml • Key icon is glitchy, go to login. cfm instead - David De. Mello

Creating a new site New Database, UNIX and SAMBA users Surinder Ghangas Create Directories and Virtual Host, configure CUWeb. Auth Paul Houle Create Site in Commonspot James Reidy

Copy Test to Production • User db must be synchronized • Export site db from Test Oracle • Create Production Site in Commonspot • Import site db into Production Oracle • Copy site directory • Check site ids in Application. cfm • Run migration tool

Gotchas • Oracle User Permissions (see sg 14) • Be careful about installing at server root • Web. DAV and Cold. Fusion don’t mix • Windows -> UNIX: Case sensitivity • Verity indexing of PDF files doesn’t work yet

Commonspot Software Configuration: James Reidy (jgr 25@cornell. edu) Apache, Jrun, CFMX, SAMBA: Paul Houle (ph 18@cornell. edu) Oracle, Backups, Unix admin: Surinder Ghangas (sg 14@cornell. edu) Authentication: David De. Mello (ddd 1@cornell. edu) General Questions: Oya Rieger (oyr 1@cornell. edu) http: //commonspot. library. cornell. edu/