FSPM H2 database management using RazorSQL

Aspirant

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
F-Secure

Re: FSPM H2 database management using RazorSQL

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

1 REPLY 1
Highlighted
F-Secure

Re: FSPM H2 database management using RazorSQL

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