Brushtail Administrator's Guide

Brushtail installation

Brushtail upgrade from 2.0/2.1 to 3.0

Brushtail can be upgraded from 2.0 or 2.1 to 3.0 using a php script.

Load the upgrade_2-3.0.php script in your web browser, something like http://localhost/intranet/sql/upgrade_2-3.0.php

The script does require:

• Version 2.0 or 2.1 of Brushtail.
• A absolute directory path that the web server has write permissions for. This will be a file uploads directory.
• A MySQL user account with all privileges. PHP4 users may need to create an account with all privileges, with password stored in the old format.

Software Requirements

• Web server with PHP . PHP (4.30 or above, register_globals = Off)
  
  
• MySQL MySQL

MySQL Database

1. Create a MySQL database for the intranet.
2. Create a MySQL user for the intranet
3. Grant this user select, delete, update, insert and lock table privileges on this database.
4. Load the file brushtail_3.0.sql, contained in the sql directory, into the MySQL database. This file contains sql statements that will create and populate the required database tables.

Configuration File

Place the intranet files in the webserver document directory. Edit the file config.php in the includes folder.

MySQL CONNECTIONS SETTINGS (Compulsory)
These paremeters must be set for the intranet to function.

$DBUSER= "usernamet";
$DBPASSWORD = "userpassword";
$DATABASE = "intranet";
$HOST = "localhost";

LOCALE SETTINGS (optional)
You can also set the language for the calendars so the month and day names display in the correct language. This example sets it to German.

$locale = setlocale(LC_ALL, 'de_DE@euro', 'de_DE', 'de', 'ge'); //GERMANY

LDAP SETTINGS (optional)
Requires php LDAP support. LDAP can be used to authenticate users. The LDAPHOST parameter. Indicates the LDAP or Active directory server. The other LDAP paramters if you want users to be able update their Windows password via the intranet. For testing LDAP authentication try using the intranet/main/ldaptest.php utility.

$LDAPHOST = "servername";

IMAP settings (optional)
Requires php IMAP support. Used for authenticating users via imap/pop3. Check php website for information on syntax. http://www.php.net/manual/en/function.imap-open.php

$MAILSERVER = "{10.10.10.10:143/imap}";

WEB BOOKINGS - patron authentication (optional)
For a fuller discussion see the web bookings page of the Administrator manual.

$WEBAUTHENTICATION = "web"; //values: none/local/web/ldap/email

if authentication is set to catalogue, specify catalogue web form parameters. This allows patrons to make bookings that are authenticated via a library system web catalogue (or any web form!)

$WEBHOST = 'webcatalogue';
$WEBPATH = '/urlpath/';
$STRINGACTION = "accept"; //values: accept/deny
$STRING = "login successfull";
$USERFIELD = "user_id";
$PASSWORDFIELD = "password";
$OTHERFIELDS["example"] = ""; //other hidden fields can be added using this format

To test these paramteters use the intranet/main/webtest.php utility. This will actually display what is outputted in respnse to the form submission. This will help you identify the "string" you will be looking for.

Log in as administrator

Delete the sql directory.

Enter the url of the intranet eg http://hostname/intranet/index.php
Log in as user name "administrator" , default password "administrator".

Change the administrator password. the Intranet got to "Intranet Administration

To change the administrator passwordgot to "Intranet Administration", then click on "User accounts" and edit the administrator account.

To configure the Intranet got to "Intranet Administration", then click on "Intranet Preferences"

See the page "Intranet Preferences" of this manual for more details.

File Uploads

Email forms