SyferLock Help Center

Querying the GridGuard Database

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

  1. Download and install the PostgreSQL 32-bit ODBC Driver
    You can download the driver from http://ftp.postgresql.org/pub/odbc/versions/msi
  2. 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
  3. Create a new User DSN Entry with the following attributes:
    Database: grid
    Server: GridGuard Server IP / hostname
    Port: 5432
    User Name & Password: Check /etc/syferlock/gridserver/server.xml file for the username & password attributes for the Resource named 'jdbc/Store'
  4. Test and validate the credentials work

Microsoft Access Setup

These instructions are for MS Access 2010. Please adapt as necessary for other versions.

  1. Create a new Access DB
  2. Choose External Data Tab > ODBC Sources
  3. Choose Link to the data source by creating a linked table
  4. Switch to the 'Machine Data Source' tab & choose the PostgreSQL DSN
  5. Click OK. A list of tables in the grid database should be displayed at this point
  6. Select table(s) from the list
  7. Click OK
  8. You might be asked to select the primary key for the history table. Cancel without picking one
  9. Double click on the link to see the data from the column
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk