Use Crystal Reports with the Log Server

If your organization uses Crystal Reports, you can use the Log Server database as a source of information. You must install third-party software for this functionality. For better performance, we recommend that you install Crystal Reports on a separate computer from the Log Server.

In these procedures, 192.168.0.1 is the IP address of the Log Server, and 192.168.0.2 is the IP address of the remote client. These are only example IP addresses. Make sure you replace them with the correct IP addresses of your Log Server and remote client when you complete these procedures.

Configure Your Log Server Computer

  1. Stop the Log Server and the PostgreSQL database services.
  2. Open the PostgreSQL configuration file in a text editor:
    • Windows 10 — C:\ProgramData\WatchGuard\logs\data\postgresql.conf
    • Windows 8 — C:\ProgramData\WatchGuard\logs\data\postgresql.conf
    • Windows 7 — C:\Users\<username>\Documents\My WatchGuard\logs\data\postgresql.conf
  3. To allow database connections from other computers, in the postgresql.conf file, change the Log Server listen_addresses setting to:
    listen_addresses = '*'
    Or
    listen_addresses = 'localhost, 192.168.0.1'
    If necessary, remove the comment symbol (#) from the beginning of the line.
  4. Save postgresql.conf.
  5. Open the pg_hba.conf file.
  6. Add a line similar to:

host all all 192.68.0.2/32 md5

In this example, 192.168.0.2 is the remote client from which you want to allow access.

  1. Restart the PostgreSQL and Log Server services.

Configure the Crystal Reports Computer

  1. Install Crystal Reports on a separate computer from the Log Server computer.
  2. Download and install the ODBC driver for PostgreSQL.
  3. From the Windows Start Menu, select Control Panel > Administrative Tools > Data Sources (ODBC).
  4. On the User DSN tab, click Add.
  5. Select PostgreSQL Unicode.
  6. Configure the connection with this information:
    • Data Source — PostgreSQL30W
    • Database — wglog
    • Server — 127.0.0.1
    • Port — 5432
    • User name — wguser
    • Password — <Administrator passphrase>
  7. Click Test to test the connection.
  8. Open Crystal Reports.
  9. Select Database > Log On or Off Server > Create New Connection > ODBC (RDO).
  10. Select the data source you created in Steps 3–7 and create the connection.

You can also use the WatchGuard Web Services API to export data for Crystal Reports. For more information, go to Use the Web Services API to Retrieve Log and Report Data.

Related Topics

About Firebox Logging and Notification

Set Up Your Log Server

Use Scripts, Utilities, and Third-Party Software with the Log Server