CDR Tickets

Issue Number 4265
Summary Move glossifier service from Linux to Windows
Created 2017-05-10 09:36:24
Issue Type Improvement
Submitted By Kline, Bob (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2017-05-16 08:25:26
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.207941
Description

We have been running the glossifier service on a separate Linux server. In order to reduce the footprint of the CDR system, we have decided to move the glossifier service to the Windows CDR application server.

Comment entered 2017-05-16 08:25:26 by Kline, Bob (NIH/NCI) [C]

Ready for testing on DEV.

Comment entered 2017-05-16 09:00:38 by Kline, Bob (NIH/NCI) [C]

Deployment instructions:

Create new directories

  • d:/cdr/glossifier

  • d:/cdr/glossifier/cgi-bin

Install files

  • d:/Inetpub/wwwroot/cgi-bin/cdr/ClientRefresh.py

  • d:/Inetpub/wwwroot/cgi-bin/cdr/glossify-test.py

  • d:/cdr/Scheduler/tasks/glossifier_refresh.py

  • d:/cdr/glossifier/cgi-bin/glossify

  • d:/cdr/glossifier/cgi-bin/web.config

  • d:/cdr/glossifier/cgi-bin/glossifier.xml

  • d:/cdr/lib/Python/WebService.py

  • d:/cdr/Database/tables.sql

  • d:/cdr/Database/CreateLogins.sql

Create new web site (on lower tiers add second binding for glossifier-TIERNAME.cancer.gov)

Name

CDR Glossifier

Bindings

type http, host name glossifier.cancer.gov, port 80, IP address *

Path

d:\cdr\glossifier

Modify DNS
Request that CBIIT modify the F5 to direct traffic for the host name glossifier.cancer.gov (or glossifier-TIER.cancer.gov) to the Windows server instead of the Linux server currently hosting the glossifier service. Make sure they don't change port 80 to port 443 (or change any of the settings for the existing web sites).

Disable processing on the Linux server
Have CBIIT disable the cron job for the glossifier account on the Linux server (running load-glossary-terms.py).

Install/seed glossifier table

CREATE TABLE glossifier
         (pk INTEGER PRIMARY KEY,
   refreshed DATETIME NOT NULL,
       terms TEXT NOT NULL)
GO
INSERT INTO glossifier VALUES(1, GETDATE(), '')
GO
GRANT SELECT ON glossifier TO CdrGuest
GO

Schedule the glossifier refresh job

Job Name

Glossifier Service Refresh

Job Class

jobs.basic_job.BasicJob

Arguments

["glossifier_refresh.Task",{}]

Scheduling

0 23 * * *
Comment entered 2017-09-18 17:40:18 by Englisch, Volker (NIH/NCI) [C]

The glossifier is successfully running on the CDR Windows server.

Closing issue.

Elapsed: 0:00:00.001087