1372
Views
10
Comments
Solved
Platform Upgrade Private Key File Error
Question

I am currently upgrading Outsystems Platform Server-8.0.1.7 to Version 10.0.405.0 on the same server and here is what I did.

1. Uninstall Platform Version 8.0.1.7

2. Installed the Version 10.0.405.0.

3. Input the Necessary DB Credentials in the Configuration Tools.

4. Test Connections (Everything was fine).

5. Click Create/Upgrade Database and I got this Error


This Server and the configured database have different encryption keys. Copy the private.key from the Outsystems installation of a machine that was connected to this database and try again.


How do I recover the old private.key? base from the my research it should be somewhere C:\Program Files\OutSystems\Platform Server, but i could not find the old private.key. Is there any way to get this private.key file or any suggestion on how to solve this.


Private Key Error.png
2023-03-16 18-12-52
Michael Chu
Solution

Jannie du Toit wrote:

We have the same problem, does anyone have a solution?


Execute the ff: Script

delete from ossys_parameter where name = 'ClientApplicationToken';
delete from ossys_parameter where name = 'privateKeyValidation';
delete from ossys_Parameter where name = 'OutSystems.HubEdition.MobileLogin_AuthenticationHMACKey';
delete from ossys_Parameter where name = 'OutSystems.HubEdition.MobileLogin_AuthenticationEncryptKey';
delete from ossys_dbconnection;


After executing the script restart the APP Server. Then reconfigure the Configuration Tool.



UserImage.jpg
Vaishnavi Choppalli

Michael Chu wrote:

Jannie du Toit wrote:

We have the same problem, does anyone have a solution?


Execute the ff: Script

delete from ossys_parameter where name = 'ClientApplicationToken';
delete from ossys_parameter where name = 'privateKeyValidation';
delete from ossys_Parameter where name = 'OutSystems.HubEdition.MobileLogin_AuthenticationHMACKey';
delete from ossys_Parameter where name = 'OutSystems.HubEdition.MobileLogin_AuthenticationEncryptKey';
delete from ossys_dbconnection;


After executing the script restart the APP Server. Then reconfigure the Configuration Tool.



 

 Hi Micheal,

                  Where this needs to be executed? Please give a detailed explanation.



Regards,

Vaishnavi


2023-03-16 18-12-52
Michael Chu

This is solve. Thank you

UserImage.jpg
Christo Van Niekerk

Hi,

I'm having the same issue. What did you do to resolve this?

UserImage.jpg
Jannie du Toit

We have the same problem, does anyone have a solution?


UserImage.jpg
Christo Van Niekerk

Jannie du Toit wrote:

We have the same problem, does anyone have a solution?


I got it to work by uninstalling everything and starting from scratch.


2023-03-16 18-12-52
Michael Chu
Solution

Jannie du Toit wrote:

We have the same problem, does anyone have a solution?


Execute the ff: Script

delete from ossys_parameter where name = 'ClientApplicationToken';
delete from ossys_parameter where name = 'privateKeyValidation';
delete from ossys_Parameter where name = 'OutSystems.HubEdition.MobileLogin_AuthenticationHMACKey';
delete from ossys_Parameter where name = 'OutSystems.HubEdition.MobileLogin_AuthenticationEncryptKey';
delete from ossys_dbconnection;


After executing the script restart the APP Server. Then reconfigure the Configuration Tool.



2019-01-02 11-49-06
Filipe Infante

You have also uninstaled the Outsystems DB (in the DB machine) rigth ?

UserImage.jpg
Jannie du Toit

Thanks a million Michael, it worked beautifully!

UserImage.jpg
Christopher Parks

Beautiful. Thank you.

2018-06-04 08-06-09
Peter Van Den Ochtend

This will also invalidate everything you encrypted with CryptoAPI in the past right?

So copying is still the preferred way (or getting it from a backup). :)


UserImage.jpg
Jim Partin

Where does this script live?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.