Page 1 of 1

Query encrypted

Posted: Thu Jan 28, 2021 3:33 pm
by Arjune
Hello,

I am currently migrating from Stimulsoft Report JS 2018 to Stimulsoft Report JS 2020.1.1.
I have the following issue: the query sent to my API used to contain the following information in the Request Payload:

Code: Select all

{ 
   command: "ExecuteQuery"
   connection: "App"
   connectionString: ""
   dataSource: "Data"
   database: "PostgreSQL"
   event: "BeginProcessData"
   queryString: ""
   rnd: 0.8243962903739386
   sender: "Viewer"
}
And now it only contains this encrypted string:

Code: Select all

rlWwo21gLJ5xVwbvEKuyL3I0MIS1MKW5VvjvL29hozIwqTyioyA0pzyhMlV6VvVfVaS1MKW5H3ElnJ5aVwbvVvjvMTS0LJWup2HvBvWDo3A0M3WyH1SZVvjvqTygMJ91qPV6ZmNjZQNfVzEuqTSGo3IlL2HvBvWOJHSMDIyOVvjvL29hozIwqTyiovV6VxSlnaIhMI9OpUNvYPWyqzIhqPV6VxWyM2yhHUWiL2Imp0EuqTRvYPWmMJ5xMKVvBvWRMKAcM25ypvVfVaWhMPV6ZP40Zmp3AmZ2BQR0ZwZ2ZQpmsD== 
Obviously, I am unable to render a report now because of this change.
Could you please tell me how to decrypt this string, or what changes have to be done to get the report rendering functionality fully working again?

Thank you.

Kind Regards,

Arjune

Re: Query encrypted

Posted: Mon Feb 01, 2021 1:32 pm
by Lech Kulikowski
Hello,

You can use the following option:
Stimulsoft.StiOptions.WebServer.encryptData = false;

Also, please check
https://github.com/stimulsoft/Samples-J ... p%20Server

Thank you.

Re: Query encrypted

Posted: Wed Mar 31, 2021 7:02 am
by Arjune
Thank you, it worked :-)

Kind regards,

Arjune

Re: Query encrypted

Posted: Fri Apr 02, 2021 8:40 am
by Arjune
If we would like to use the encryptData feature (and set it to true), could you please tell us how we have to handle que encrypted query on our server side?

Thank you.

Re: Query encrypted

Posted: Tue Apr 06, 2021 11:13 pm
by Lech Kulikowski
Hello,

There are no methods to encrypt string in your code, it is our internal methods.

Thank you.

Re: Query encrypted

Posted: Fri Apr 09, 2021 9:05 am
by Arjune
Hello Lech,

I didn't mean to encrypt the string, I would actually need to decrypt on our server side (in our .NET Core web API) the encrypted string. Is there a specific way to do it?

Thank you.

Re: Query encrypted

Posted: Mon Apr 12, 2021 9:12 pm
by Lech Kulikowski
Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

Re: Query encrypted

Posted: Thu Sep 02, 2021 6:53 am
by Arjune
Hello,

Any news regarding this topic ? It has become quite urgent on our side to use an encrypted connection string, so we now need to know how to decrypt it on server side.

Kind regards,

Re: Query encrypted

Posted: Mon Sep 06, 2021 9:11 am
by Lech Kulikowski
Hello,

Please send us your request onĀ support@stimulsoft.com.

Thank you.