The GridGuard Virtual Appliance uses a PostgreSQL database to store historical information. This article provides information on how to access the data in this database using third party tools either to analyze the data or generate reports.
GridGuard Server Setup - Open Firewall to access DB
Run the following commands from command line, once logged into the GridGuard Appliance via SSH
system-config-securitylevel Choose option Customize Under other ports, add entry: tcp:5432 Select OK Select OK
Windows Machine Setup
- Download and install the PostgreSQL 32-bit ODBC Driver
You can download the driver from http://ftp.postgresql.org/pub/odbc/versions/msi
- Launch Control Panel > Administrative Tools > Data Sources (ODBC)
If you are running 64 bit Windows, run C:\WINDOWS\SysWOW64\odbcad32.exe to see the 32 bit drivers
- Create a new User DSN Entry with the following attributes:
Server: GridGuard Server IP / hostname
User Name & Password: Check /etc/syferlock/gridserver/server.xml file for the username & password attributes for the Resource named 'jdbc/Store'
- Test and validate the credentials work
Microsoft Access Setup
These instructions are for MS Access 2010. Please adapt as necessary for other versions.
- Create a new Access DB
- Choose External Data Tab > ODBC Sources
- Choose Link to the data source by creating a linked table
- Switch to the 'Machine Data Source' tab & choose the PostgreSQL DSN
- Click OK. A list of tables in the grid database should be displayed at this point
- Select table(s) from the list
- Click OK
- You might be asked to select the primary key for the history table. Cancel without picking one
- Double click on the link to see the data from the column