FSPM H2 database management using RazorSQL

ravi12

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 follows

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

 

Waiting for valubale suggestions

A_Grinkevitch

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