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 software from a third party for this functionality. Also, we recommend that you install Crystal Reports on a separate computer from the Log Server for better performance.
In these procedures, we use 192.168.0.1 for the IP address of the Log Server, and 192.168.0.2 for 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
- Stop the Log Server and the PostgreSQL database services.
- Open the PostgreSQL configuration file in a text editor:
- Windows 8 — C:\ProgramData\WatchGuard\logs\data\postgresql.conf
- Windows 7 — C:\Users\<username>\Documents\My WatchGuard\logs\data\postgresql.conf
- Windows XP — C:\Documents and Settings\WatchGuard\logs\data\postgresql.conf
- To allow database connections from other computers, in the postgresql.conf file, change the Log Server listen_addresses setting to:
listen_addresses = '*'
listen_addresses = 'localhost, 192.168.0.1'
If necessary, remove the comment symbol (#) from the beginning of the line.
- Save postgresql.conf.
- Open the pg_hba.conf file.
- Add a line similar to:
host all all 220.127.116.11/32 md5
In this example, 192.168.0.2 is the remote client from which you want to allow access.
- Restart the PostgreSQL and Log Server services.
Configure the Crystal Reports Computer
- Install Crystal Reports on a separate computer from the Log Server computer.
- Download and install the ODBC driver for PostgreSQL.
- From the Windows Start Menu, select Control Panel > Administrative Tools > Data Sources (ODBC).
- On the User DSN tab, click Add.
- Select PostgreSQL Unicode.
- Configure the connection with this information:
- Data Source — PostgreSQL30W
- Database — wglog
- Server — 127.0.0.1
- Port — 5432
- User name — wguser
- Password — <Administrator passphrase>
- Click Test to test the connection.
- Open Crystal Reports.
- Select Database > Log On or Off Server > Create New Connection > ODBC (RDO).
- 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, see Use the Web Services API to Retrieve Log and Report Data.