Step 1: create the database

Currently, Squale supports :

Here is the way to prepare the database:

  1. Install a database

    After installing the database of your choice, create a user/scheme for Squale.

  2. Customize Squale default scripts

    In the distrib archive, you will find 3 SQL scripts in the "01-database-files/your_database/creation-scripts" folder. The one you need to customize is called "03-initSquale.sql".

    1. The servers

      The batch part of Squale, which is called Squalix, can be installed and run on several different servers to make Squale scale easily. The server names are stored in the database. Currently, there's no admin page for adding a new server, so they must be added manually in the database.

      Go in the "Table Serveur" section, you will see the following line:

              For Oracle : Insert into Serveur VALUES(serveur_sequence.NextVal, 'squaleSrv');
        
        For MySQL : Insert into Serveur (NAME) VALUES('squaleSrv');

      For each server you want to define, add a line with :

      • the name of the server where you will install a Squalix instance

      Note : the id(s) associated to each server will be used during Squalix installation.

    2. The users

      As for the servers, there's currently no admin page that can be used to add new users in the database (this will come one day!).

      Go in the "Table USERBO" section (after the server one), you will see the following lines:

              For Oracle :
        
                Insert into UserBO
                        (USERID, MATRICULE, PASSWORD,PROFILEID )
                  Values
                        (user_sequence.NextVal, 'squaleadmin','admin',(select PROFILEID from ProfileBO where NAME = 'bo.profile.name.admin'));
                
                [...]

        
        For MySQL :
        
                Insert into UserBO
                        ( MATRICULE, PASSWORD,PROFILEID )
                  Values
                        ( 'squaleadmin','admin',(select PROFILEID from ProfileBO where NAME = 'bo.profile.name.admin'));
                        
                [...]

      There, you can add as many users as you want, considering the following notes:

      • MATRICULE : login / user name (no uppercase letter for the moment)
      • PASSWORD : password
      • PROFILEID : number which represents the profile of the user. You can find these profiles in the section "table profileBO" of the script.
        • For create an administrator use : (select PROFILEID from ProfileBO where NAME = 'bo.profile.name.admin')
        • For create a default user use : (select PROFILEID from ProfileBO where NAME ='bo.profile.name.default')

        The profile manager and reader shouldn't be used here.

  3. Create the base!

    To create the database, you need to execute the 3 SQL scripts in correct order :

    1. The script to create tables and relations : 01-createDatabase.sql
    2. The script for the default values : 02-setDefaultValues.sql
    3. The script for initialization : 03-initSquale.sql

    The next step is the installation of Squale Web