How to install OrangeHRM on SME server

Orange Human Resources Management (OrangeHRM) aims to be the world’s leading open source HRM solution for small and medium sized enterprises (SMEs) by providing a flexible and easy to use HRM system affordable for any company worldwide. The project was started during fall 2005 and the first beta release was made in January 2006. Today OrangeHRM has users worldwide enjoying a free, stable and highly usable HRM solution

In this Howto, we will not install OrangeHRM into ibays but into /opt/orangehrm instead.

OrangeHRM needs PHP5 … too bad smeserver 7.2 have php4 installed and you are advised not to upgrade to PHP5 because it will broke SMEServer system. But don’t worry, based on this howto : http://sme.firewall-services.com/spip.php?article46 you can add PHP5 as cgi .

Step 1. Install php5 as cgi

Code: [Select]

mkdir php5-cgi
cd php5-cgi

wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-imap-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-ldap-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-mysql-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-pear-5.1.2-1.sp.i386.rpm
wget http://sme.firewall-services.com/downloads/php5-cgi/php5-cgi-xmlrpc-5.1.2-1.sp.i386.rpm

yum localinstall ./*.rpm
you can ignore post-upgrade and reboot process

Code: [Select]

mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/80php5-cgi
then paste below into 80php5-cgi template fragment

Code: [Select]

ScriptAlias /php5-cgi /usr/bin/php5

order deny,allow
deny from all
allow from all
Options ExecCGI

[Ctrl-X] : Y : [Enter]

Step 2. Install OrangeHRM

Code: [Select]

wget http://optusnet.dl.sourceforge.net/sourceforge/orangehrm/orangehrm-2.2.2.tar.gz

tar xfvz orangehrm-2.2.2.tar.gz

mv orangehrm-2.2.2 /opt/orangehrm

chown -R www:www /opt/orangehrm

pico /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90orangehrmpaste below to the terminal

Code: [Select]

Alias /orangehrm /opt/orangehrm


AddHandler php5-cgi .php
Action php5-cgi /php5-cgi/php

Options FollowSymLinks
AllowOverride all
order deny,allow
deny from all
allow from all
php_admin_value open_basedir /opt/orangehrm

Ctrl-X : Y : [Enter]

Expand the template and restart httpd

Code: [Select]

expand-template /etc/httpd/conf/httpd.conf

svc -t /service/httpd-e-smith
create mysql user and privileges

Code: [Select]

mysql -e "grant all privileges on *.* to orangehrmuser@localhost identified by 'yourpassword' WITH GRANT OPTION"

mysql -e "flush privileges"
Enable InnoDB, smeserver disable it by default

Code: [Select]

db configuration setprop mysqld InnoDB enabled
Do post-upgrade and reboot

Code: [Select]

signal-event post-upgrade
signal-event reboot
Point your web browser to http://[smeserver IP]/orangehrm

Follow the instructions on screen..

Privileged database Username : orangehrmuser
Privileged database User password : yourpassword

You can ignore "Memory alocated for PHP Script warning"..


Actually I want to write this into Howto wiki, but until now my access to edit wiki has not granted by the developers/doc team

I think it is enough to share in this forum until I have access to edit the wiki.