Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Connect to PostgresSQL on a server hosted locally with encrypted data

Hello every body,   I'm fairly new to Power BI and I am focused on data analytics therefore technical issues are way out of my reach.  I am trying to link my PowerBI to our DB which is hosted on...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for your answer I had seen this post but it did not work for me :/

 

I will precise my issue:

 

We are using Jasypt lib to encrypt data and PBEWithMD5AndDES algorithm

We have installed pgcrypto extension and tried to call that function on encrypted column, but it did not work.

 

 

If you have a solution for me that would be amazing!

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey Anonymous, thanks for your help !

    No we use pgcrypto and try to decrypt PBEwith MD5 & DES but we can't via SQL it says :

     

    ERROR: Unsupported cipher algorithm
    ********** Error **********

    ERROR: Unsupported cipher algorithm
    SQL state: 39000

     

    We don't understand why but it feels like we will have to change encryption... 

    Leonard