this is obsolete doc -- see http://doc.nethence.com/ instead

Phpcompta installation on RHEL5 

Prepare the system 

Install those packages, 

yum install \

postgresql-server \

postgresql-pl \

postgresql \

php-pgsql \

php-bcmath

RHEL5 provides PostgreSQL 8.1 which isn't entough for Phpcompta. Install PostgreSQL 8.3 (http://www.enterprisedb.com/products/pgdownload.do#linux) and check it is started, 

/etc/init.d/postgresql-8.3 status

And proceed, 

su - postgres

cd /opt/PostgreSQL/8.3/bin

./createlang plpgsql template1

./psql

then, 

create user USERNAME createdb password 'PASSWORD';

^D

and logout from "postgres", 

^D

You're now "root" user again. Fix PostgreSQL configuration, 

cd /opt/PostgreSQL/8.3/data

cp pg_hba.conf pg_hba.conf.dist

vi pg_hba.conf

like, 

local   all         all                               md5

host    all         all         127.0.0.1/32          md5

host    all         all         ::1/128               md5

Deploy the website 

Extract the archive into the desired directory, 

tar xzf phpcompta-4.3-build-2462.tgz -C /home/www

mv phpcompa compta.example.com

create a temporay folder and set the permissions, 

mkdir compta.example.com/tmp

chown -R apache:apache compta.example.com

Configure Apache e.g., 

<VirtualHost *:80>

        ServerName compta.example.com

        DocumentRoot /home/www/compta.example.com

        CustomLog /var/log/httpd/compta.example.com_access.log common

        ErrorLog /var/log/httpd/compta.example.com_errors.log

        <Directory "/home/www/compta.example.com/html">

                AddDefaultCharset utf-8

                php_value include_path .:../../include:../include:addon

                AllowOverride All

        </Directory>

</VirtualHost>

note. the "html/" directory isn't the website's root dir. 

note. it could be interesting to try an alias to hide that "html/" dir. 

And apply, 

service httpd reload

Point your browser to your URL e.g. http://compa.example.com/html/ . Once configured, the default frontend login and password are, 

phpcompta/phpcompta

References 

(FR) Phpcompta : http://www.phpcompta.eu/ 

(FR) Manuel d'utilisation : http://www.phpcompta.be/download/manuel-fr.pdf 

(FR) Tutoriel 2 : Installer rapidement sous Unix : http://www.phpcompta.be/index.php?option=com_content&task=view&id=16&Itemid=28 

PostgreSQL : http://www.postgresql.org/ 

Download PostgreSQL 8.x : http://www.enterprisedb.com/products/pgdownload.do#linux