WebSense Installation

Updated 26 November 2011

Instructions for installing Websense windows installation 26 November 2011 (MacOS and Linux are similar).

Downloads Required

Apache and Posgresql Support

  1. BitNami WAPP stack (get 5.3.6-0 not 1.2-5) from http://bitnami.org/stack/wappstack, or
  2. PostgresSQL with StackBuilder to install Apache and pgAdmin (postgresql-9.0.4-1-windows.exe) from http://www.enterprisedb.com/products-services-training/pgdownload#windows
  3. Maybe Firefox (if you don't have a web browser) from http://www.mozilla.com/

WebSense Application and Database

  1. websense-26Nov11.zip
  2. create_websense_database.sql
  3. create_websense_sample_trial.sql

Installation

Use the one-click installers for the Apache/Postgres systems. The following choices are suggested.

Installation dir: C:\Program Files\PostgreSQL\9.0
Password: testuser
Port: 5432
StackBuilder choice at end of installation select:
Web Development > ApachePHP v2.2.16-5.3.3-1
Web Development > phpPgAdmin v5.0.2-1

On-a-stick installation is possible, but it has proved safer to install all systems on the main C drive. If any problems arise then see the installation guides:
http://www.enterprisedb.com/resources-community/pginst-guide (for postgres) or
http://bitnami.org/files/stacks/wappstack/5.3.6-0/wappstack.pdf (for bitnami)

WebSense Application

First test the Apache server by opening a web browser and point to http://localhost:8080/index.php You should see EnterpriseDB ... server is up and running

Unzip the websense directory in the php docs directory:
"C:\Program Files\BitNami WAPPStack\apache2\htdocs\" or
"C:\Program Files\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\" Use the version of jpgraph included in the websense directory which includes a truetype subdirectory so no external font links are needed.

To test your application installation open a web browser and go to:
http://localhost/websense/testphp.php, and also
http://localhost/websense/testgraph.php

WebSense Database

Next install Postgresql and populate a database with Websense data. To use the PGadmin system open a web browser and go to http://localhost:8080/phpPGAdmin/ (postgres) or http://127.0.0.1/phppgadmin/ (bitnami) which is also http://localhost/phppgadmin/

  1. Login (postgres, testuser) and then
  2. Create database
    Name: websense
    Template: template0
    Encoding: WIN1252
  3. Create Two Roles (to manage data)
    mo (passwd mo) Yes Yes Yes Yes Yes No limit Never
    webreader (passwd webreader) No No No No Yes 25 Never
  4. Logout of phpadmin

Finally create the tables and load some data by typing the following at the command line:

"C:\Program Files\BitNami WAPPStack\postgresql\bin\psql.exe" -h localhost -p 5432 -U postgres -d websense -f create_websense_database.sql
passwd: testuser as before

"C:\Program Files\BitNami WAPPStack\postgresql\bin\psql.exe" -h localhost -p 5432 -U postgres -d websense -f create_websense_sample_trial.sql
passwd: testuser as before

You can also use psql in future to browse or update the database. Just leave off the -f (file input) flag.

Backup the database after future changes using pg_dump:

"C:\Program Files\BitNami WAPPStack\postgresql\bin\pg_dump.exe" -f websenseDATE.sql -p 5432 -U postgres websense

Link websense to your new database by opening the file opendb.php in the websense directory (E:\Program Files\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\) and checking that the pg_connect parameters match your installation:

pg_connect("host=localhost port=5432 dbname=websense user=webreader password=webreader")

To test your database installation open a web browser and point to http://localhost:8080/websense/testdb.php or http://localhost:8080/websense/testdb.php Only seems to work in firefox not explorer??

Finally

Run websense by choosing:

http://localhost/websense/

Viel Glück!