Query encrypted

Stimulsoft Reports.JS discussion
Post Reply
Arjune
Posts: 20
Joined: Mon Jan 28, 2019 9:26 am

Query encrypted

Post 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
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Query encrypted

Post 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.
Arjune
Posts: 20
Joined: Mon Jan 28, 2019 9:26 am

Re: Query encrypted

Post by Arjune »

Thank you, it worked :-)

Kind regards,

Arjune
Arjune
Posts: 20
Joined: Mon Jan 28, 2019 9:26 am

Re: Query encrypted

Post 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.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Query encrypted

Post by Lech Kulikowski »

Hello,

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

Thank you.
Arjune
Posts: 20
Joined: Mon Jan 28, 2019 9:26 am

Re: Query encrypted

Post 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.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Query encrypted

Post by Lech Kulikowski »

Hello,

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

Thank you.
Arjune
Posts: 20
Joined: Mon Jan 28, 2019 9:26 am

Re: Query encrypted

Post 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,
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Query encrypted

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply