Announcement: New Knowledge Base

4 June 2020: We are pleased to announce the launch of a new Knowledge Base, Changelogs for Business Security Products, where you can find more details, such as bugfixes or new features, about the most recent releases of our business-related products.

Reset policy manager admin PW after recover DB

Hi all,

 

I did a recover of our DB with the infamous REcover DB tool.

The readme told me the password was to be reset to "password"

but that doesnt work.

also using the reset PW tool doesnt help...

I get:

---------------------------------------------------------------------------------------------------------------------------------------------------------------

Warning: this tool will reset the password for your existing administrator accou nt.

Enter your new administrator password: Confirm your new administrator password: Error: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT dom ain_id FROM users WHERE username = ?]; SQL state [null]; error code [0]; Borrow prepareStatement from pool failed; nested exception is org.apache.commons.dbcp.S QLNestedException: Borrow prepareStatement from pool failed

---------------------------------------------------------------------------------------------------------------------------------------------------------------

 

And still unable to open the console.

(running PM10.20 on a win2k8r2 server)

 

KR

Jelle

Comments

  • JaysonJayson Posts: 595

    Hi Jelle,

    1. Kindly ensure that you are using the latest version of Recovery Tool.

    2. Ensure that you have stopped the F-secure Policy Manager Server service whenever you create a backup of the H2DB or restore it.
    - Services.msc > F-secure Policy Manager Server

    3. Please stop the F-secure Policy Manager Server service as well when you run the reset-admin-account.bat.

    Thanks.


    Best Regards,
    Jayson

  • JelleHJelleH Posts: 19

    Hi Jayson,

     

    I believe I have used the latest version of the DB recovery tool.

    Where can I check

     

    Stopping the f-secure services when creating the backup were all done during backup/recover/pw reset.

     

    thanks for the quick reply!

     

    KR

    Jelle

This discussion has been closed.