ProjectButler Installation Guide


Andreas Krennmair

1. Requirements

ProjectButler depends on PHP4 and MySQL, and of course you need a web server such as Apache. To enable PHP4 to interact with MySQL, install PEAR. One some systems it's included with PHP4, but e.g. Debian has an own package for it.

You have to install them before you can even begin installing ProjectButler, but they should come with most major Linux distributions, anyway. Optionally, you can also install OpenLDAP to handle all contacts through it. If you want LDAP, don't forget to install LDAP support for PHP4!

2. Installation of ProjectButler

2.1. Download Tarball

You can download the ProjectButler tarball from http://projectbutler.sf.net/.

2.2. Extract Tarball

Extract this tarball to your web server's DocumentRoot, e.g. /var/www. ProjectButler will extract into a subdirectory named "projectbutler".

2.3. Configure Database Settings

Create a file named /etc/projectbutler/db_info.inc, which should look like this:

<?php
  define("DBTYPE","mysql");
  define("DBHOST","databasehost");
  define("DBUSER","databaseuser");
  define("DBPASSWORD","password");
  define("DBNAME","ProjectButler");
?>

This configuration file should be fairly self-explaining. DBHOST is the host on which MySQL is running (e.g. localhost). DBUSER is the user that ProjectButler shall use to connect to MySQL, and it shall authenticate with the password given in DBPASSWORD. The database it should use is configured via DBNAME. You can use any name for this database.

2.4. Create Database

Now you need to create the database inside MySQL. Be sure to use the same database name you configured before (in our example "ProjectButler")! You can create the database with the following command:

mysqladmin -u root create ProjectButler

2.5. Create Tables and Basis Data

Now, you can create the tables that are required by ProjectButler. We have prepared a dump file which will do this for you. You can find it in the extracted directory, in the subdirectory "sql". The dump file is named base.sql. To create the tables and insert basis data, issue the following command:

mysql -u root ProjectButler < /var/www/projectbutler/sql/base.sql

The dump file for the table structure of ProjectButler 0.2 is included as base-0.2.sql. It isn't needed anymore, and is only kept for historic reasons.

2.6. Upgrade Tables (Optional)

If you have version 0.2 of ProjectButler running on your system, you need to upgrade the tables before being able to use ProjectButler 0.3. For this, you need to run the following command:

mysql -u root ProjectButler < /var/www/projectbutler/sql/upgrade-0.2-0.3.sql

2.7. Set Language

Edit secrets/lang_info.inc and set your preferred language. Currently, the only languages available are English (set "en") and German (unset $lang, since it is the default language). For an example on how to create more translations, look at includes/lang/en.php.

2.8. Test ProjectButler

Start your favorite browser and enter the URL of your ProjectButler installation. If everything went OK, you can login with the user "admin" and the password "passme". From there on, you can change your password, and create more users.


Copyleft 2002 WebDynamite This document is distributed under the terms of the GNU Free Documentation License.


This document was generated using AFT v5.0793