CDR Tickets

Issue Number 4515
Summary Database Connection Fails on Lower Tiers
Created 2018-08-28 11:09:38
Issue Type Improvement
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2018-09-28 08:49:39
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.232086
Description

CBIIT has disabled the TLS 1.0 protocol on the lower tiers which caused database access from the CDR servers to fail.

Comment entered 2018-08-28 11:14:43 by Englisch, Volker (NIH/NCI) [C]

In order to fix the DB connectivity problem a new DB driver needs to be installed. These are the steps to be performed on each server:

  1. install new ODBC DB driver

  2. install new /lib/Python/cdrdb.py file

  3. install new /Inetpub/wwwroot/cgi-bin/secure/cdrlite.py

  4. run the command fix-permissions d:/lib

  5. run the command fix-permissions d:/Inetpub

The new driver is located at

  \\nciis-p401.nci.nih.gov\cdr_deployments\msodbcsql_13.1_64.msi
Comment entered 2018-09-28 08:49:39 by Kline, Bob (NIH/NCI) [C]

TLS 1.0 has been disabled on all tiers, and our workaround for the problem has solved it.

Comment entered 2018-10-01 11:21:46 by Englisch, Volker (NIH/NCI) [C]

Weren't there some changes related to the TLS which needed to be installed? Has the TLS branch been merged into master?

Comment entered 2018-10-01 11:25:04 by Kline, Bob (NIH/NCI) [C]

I think we installed them. Are you thinking of something in particular which you suspect we may have missed? I'll create the PRs for the merge.

Comment entered 2018-10-01 11:35:19 by Englisch, Volker (NIH/NCI) [C]

I know we're OK with the installation portion but I'm thinking of the git/github portion of this ticket.

Elapsed: 0:00:00.001791