Documentation main page Features Installation Administration Usage Developers FibuSQL login


FibuSQL - Installation

This document describes the installation of the FibuSQL server. FibuSQL is completely web-based, so the clients only need a web browser and network access to the server.

Preliminaries

Installation

  1. Creation of a database: On fibu-db a database has to be created (by you or your friendly system operator). No tables have to be created, this is done in a later step. You need the following information about it:
  2. Extraction of archive into target directory:
  3. First test: Open your preferred web browser and open FibuSQL's start page. The URL depends on the path you installed FibuSQL to. E. g. if you used the personal directory of user myuser and unpacked FibuSQL into public_html/fibu, the address will be http://fibu-www/~myuser/fibu/
  4. First login: Now you should see the login page of FibuSQL. Enter the database information from step 1 (leave the password field empty if no password is used) and click on "Login". If an error message about a failing database connection appears, then either the login data was wrong or the database does not allow access from fibu-www (this can only be fixed by the system administrator).
  5. Presetting the login data (optional): If you want and your security policy allows it, you can preset the login data such that users do not need to enter the login data. Open the file fibusql.conf with an ASCII editor and assign the data to the respective variables. You can also change some settings for the user interface here. The file is documented quite verbosely; please let me know if you cannot figure it out, and tell me what is not intelligible.
  6. Initialisation of the database: Choose "Administration" in the menu bar and click on "Initialize database". This will create the necessary tables (journal, account list, etc.).
    Since this step creates objects, you have to login as the owner of the database for this step. After that, FibuSQL can be used also by other database users that have the following privileges: SELECT, INSERT, UPDATE, and DELETE.