Oratio® Installation Guide on GNU/Linux

Summary

• Requirement
• Installation
  • Installation of files
  • Apache configuration
  • Permission on files
• Postgres configuration
• Oratio® configuration
  • Create a database
  • Create an user
  • Start the program

Requirement

Oratio® is an ERP distributed with GPL licence. Oratio® uses PostgresSQL database and works in CGI modality, therefore it is accessible through an internet browser. Therefore, before the use of Oratio® it is necessary to make sure yourself that the instruments used by Oratio® are present on the server where Oratio® will be installed

List of programs

1. Perl, version 5 et+, for greater information visit the URL CPAN (Comprehensive Perl Archive Network)
2. An http server Apache
3. A database system Postgres, version 7.4 et+
4. The following Perl modules: DBD-Pg and DBI, download from CPAN
5. Perl Library to create documents in pdf format:
   - Debian systems: libpdf-api2-perl
   - other Linux/Windows systems: PDF-API2
6. LaTeX (optional) : to generate PDF documents

Installation

Files installation:

• Decompress the file .tar.gz in /usr/local folder of Linux server: tar xzvf oratio-x.x.x.tar.gz
• In folder /usr/local/oratio/ you can find all files

Apache configuration

• Create a file named oratio-httpd.conf in the configuration folder of Apache (default /etc/httpd/conf/) and insert the following text :
  Alias /oratio/ /usr/local/oratio/ <Directory /usr/local/oratio> AddHandler cgi-script .pl Options ExecCGI Includes FollowSymlinks </Directory> <Directory "/usr/local/oratio/users"> Order Deny,Allow Deny from All </Directory>
• Edit the Apache file httpd.conf adding the following text :
  # Oratio Include <ServerRoot>/oratio-httpd.conf

Permission on files

Assign the ownership of folder users and templates to Apache user (generally is apache:apache, or www, or nobody). You can control the Apache configuration file.
Therefore :
# chown apache:apache users templates
replacing eventually apache:apache with user and group used by Apache.

PostgresSQL configuration

• We advise to create an user for the database access. This user will be used in Oratio® .
• # su postgres $ createuser -d oratio
• If you want to give a password to this user (advised) :
  $ createuser -d -P oratio
• Answer 'y' for question : "Shall the new user be allowed to create more dataset? (y/n) y"
• Answer 'n' for question : "Shall the new user be allowed to create more new users? (y/n) n"

Oratio® configuration

Create a database

• Open the internet browser and go to http://localhost/oratio/admin.pl. Replace eventually localhost with server IP/name where Oratio® is installed
• Select "Pg Database Administration"
• Edit fields host, port, user and password writing IP address of database server (default localhost), the port (generally 5432), the user (oratio in this example) and the password for the access to database.
• Insert a name for the database, choose a language for the creation of chart of accounts and press Continue
• This operation can require some minutes.

Create an user

• Go to http://localhost/oratio/admin.pl. Replace eventually localhost with server IP/name where Oratio® is installed
• Go to "Add User" section
• Fill in the form
• In "Database" section, insert the some values used in the database creation
• At the end press Save

Start the program

• Go to http://localhost/oratio/login.pl. Replace eventually localhost with server IP/name where Oratio® is installed
• Insert user and password for an user created in the previous point.
• Press login
• Make reference to the Oratio® user manual given with the source files

Congratulations, you have installed your ERP Open Source, Oratio® !