FSPM H2 database management using RazorSQL

Hai all,

 

I am trying to login to H2 database ofor fetching some data in FSPM using RazorSQL program. What will be the parameters in the connection page, Which looks like as followsIMG_20170811_130955.jpg

What will be the default values or which parameters can be used which I customized during installation of FSPM server.

 

Waiting for valubale suggestions

Best Answer

  • A-GrinkevitchA-Grinkevitch Posts: 162 F-Secure Employee
    Accepted Answer

    Hi ravi12,

     

    It is possible to enable direct access to H2 DB using additional_java_args parameters:

    Property name

    Value type

    Description

    Default value

    odbcConnectorEnabled

    Boolean

    Enables or disables the access to Policy Manager Server database via ODBC

    false

    odbcConnector.pgAllowOthers

    Boolean

    When enabled, allows for remote clients to access the database
    When disabled, only the clients residing on the same computer have the access

    false

    odbcConnector.pgPort

    Number

    Specifies the port number to connect to

    5435

     

    Check article https://community.f-secure.com/t5/Business/Policy-Manager-advanced/ta-p/11869 that describes how to specify them.

    If you need just to check something without need to fetch data regularly, probably built-in H2 Database Console will be enough for your needs and without any additional configurations. Same article on link above describes how to enable it.

     

    If you need detailed instructions, please contact F-Secure support.

     

    Alexander

    Lakshroot_1
This discussion has been closed.