Rocket U2 | UniVerse & UniData

 View Only

 UOPY: Fails to decrypt record value - error: 06065064

Andrew Jackson's profile image
Andrew Jackson posted 05-21-2023 23:42

Hello everyone,

Firstly, I have to say that this is my first experience of attempting to use UOPY so please forgive any obvious mistakes on my part.   The issue which I am looking for some guidance on is as follows:

I can log into Universe via an ssh terminal, issue command such as:

SELECT CDC.CARD WITH ID = "1234567890123456" TO 1

This selects one record into list number one and outputs the ID and CARDNUM values.   CARDNUM Is a calculated field and is decrypted / displayed correctly when the operations are performed as above.

However, when using UOPY, I replicate the above using something similar to the below:
cmd=uopy.Command(f'LIST {filename} CARDNUM FROM {list_number}',ses)

Inspecting the cmd object shows that there's an error in decrypting the value, with the full error message as follows:
error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto/evp/evp_enc.c:570

I understand that the Command objects should be running on the server so assumed the decryption via UOPY would return the same results as per the command line but that's not what I am currently experiencing.

If anyone has any thoughts on an approach I might try, I'd be very happy to hear them.

Thanks in advance.