Synopsis: This article explains how to configure CensorNet's database so that you can connect to it using Crystal Reports.

Log into the command line as root and type a command line similar to that below (but read the notes first) :-

echo "host all all SOURCE_IP_ADDRESS/32 md5" >> /etc/postgresql/8.3/main/pg_hba.conf

Note: the ">>" in the above command is essential. You should replace the SOURCE_IP_ADDRESS with the IP address of the machine running Crystal Reports.

Now type these commands

cd /etc/postgresql/8.3/main

nano postgresql.conf

Press Ctrl-W

In the search text entry area type "Connection" (sans quotes) and press the RETURN key.

Press Ctrl-W followed immediately by RETURN twice more.

You should find your cursor at the start of this line

# - Connection Settings -

Underneath this line type the following line :-

listen_addresses = '*'

Press Ctrl-O and RETURN to write the file

Press Ctrl-X to exit the editor.

Reboot the CensorNet by typing

reboot

Once the CensorNet reboots your changes will take effect.

You can obtain the ODBC Driver for Windows here.

Once this has been done, and you have installed the ODBC driver, you can connect to the CensorNet's database. The database is called censornet, the username is censornet and the password is censornet.