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 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
Comments
-
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 accessfalse
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
7 2Like
