PDQ Issues

Issue Number	4328
Summary	Audio download report not working PROD
Created	2017-10-23 15:29:20
Issue Type	Bug
Submitted By	Osei-Poku, William (NIH/NCI) [C]
Assigned To	Englisch, Volker (NIH/NCI) [C]
Status	Closed
Resolved	2017-11-10 15:21:51
Resolution	Fixed
Path	/home/bkline/backups/jira/ocecdr/issue.215927

Description

When you click the audio download tool on the report menu, you get the following python script error message:

A problem occurred in a Python script.

D:\cdr\Log\tmpmpepg1.html contains the description of this error.

Comment entered 2017-10-23 15:43:38 by Englisch, Volker (NIH/NCI) [C]

Here is the error message from that file you're listing. It seems to be an authentication problem:

Traceback (most recent call last):
  File "D:\Inetpub\wwwroot\cgi-bin\cdr\FtpAudio.py", line 68, in &lt;module&gt;
    transport.connect(username=username, password=password)
  File "D:\Python\lib\site-packages\paramiko\transport.py", line 1101, in connect
    self.auth_password(username, password)
  File "D:\Python\lib\site-packages\paramiko\transport.py", line 1265, in auth_password
    return self.auth_handler.wait_for_response(my_event)
  File "D:\Python\lib\site-packages\paramiko\auth_handler.py", line 208, in wait_for_response
    raise e
AuthenticationException: Authentication failed.

Comment entered 2017-10-24 17:24:35 by Englisch, Volker (NIH/NCI) [C]

It appears that this process broke with our Feynman update when access to our SFTP server changed.
I have requested assistance from CBIIT so that we receive the proper access to the CIAT directories.

Comment entered 2017-10-31 13:26:12 by Osei-Poku, William (NIH/NCI) [C]

Hi ~volker,
Any update from CBIIT about this ticket? We have a bunch of audios waiting to be published to Cancer.gov.

Comment entered 2017-11-01 14:48:49 by Englisch, Volker (NIH/NCI) [C]

I'm still working with CBIIT on coming up with the best approach to fix this problem before I can start updating the program itself.

Comment entered 2017-11-08 13:40:09 by Englisch, Volker (NIH/NCI) [C]

CBIIT created the directories we need but we need a few more adjustments. I had a quick meeting with Stamen and we should have everything setup properly by the end of the day.

Comment entered 2017-11-09 17:58:46 by Englisch, Volker (NIH/NCI) [C]

~oseipokuw, the Audio Download originally had the ability to specify different directories to copy the files from and to. Since we don't have access to the production machines anymore these options are useless in my opinion.
Do you agree that we can drop this functionality from the download script?

Comment entered 2017-11-10 10:54:12 by Osei-Poku, William (NIH/NCI) [C]

Yes, I think you can proceed to drop it.

Comment entered 2017-11-10 15:20:21 by Englisch, Volker (NIH/NCI) [C]

I have updated the following file:

FtpAudio.py

Changes are in the local branch [cdr4328 79f50e6].

I made the changes to remove the ability to specify the directory location on the FTP server or the CDR server. I also added a check to only allow users to use this tool if they have the "Audio Download" permissions.

This is ready for testing on DEV.

Comment entered 2017-11-10 15:48:46 by Osei-Poku, William (NIH/NCI) [C]

This is ready for testing on DEV.

Verified on DEV. Thanks!

Comment entered 2017-11-16 18:33:34 by Englisch, Volker (NIH/NCI) [C]

The program has been copied to QA and is ready for testing.

Please note, the original program did not include any user permissions. I've added a new action in order to control who would be allowed to download the files. At the moment only myself and William have these permissions.
Please add users on PROD to the group AUDIO IMPORT/SPREADSHEET as needed.

Comment entered 2017-11-20 16:12:13 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2017-12-06 14:35:52 by Osei-Poku, William (NIH/NCI) [C]

Looks like this can be closed.

Elapsed: 0:00:00.001337

CDR Tickets