OrangeHRM

From SME Server
Jump to navigation Jump to search
Incomplete.png Incomplete:
This article or section needs to be expanded. Please help to fill the gaps or discuss the issue on the talk page


Maintainer

Thomas Chandra (thomas DOT aria AT telkom DOT net DOT id)

Description

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 install OrangeHRM into /opt

Add PHP5 support to SME as cgi

OrangeHRM needs php5. SMEServer 7.x have php4 installed and you are advised not to upgrade to PHP5 because it will broke SMEServer system. Don’t worry, you can add PHP5 as cgi based on this howto: Add php5 support on your SME without upgrading to PHP5

Install php5-cgi support as instructed in the howto, but stop at step #3.

Install OrangeHRM

Download the package

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

Unpack it

tar xfvz  orangehrm-2.2.2.tar.gz

Move to /opt/orangehrm

mv orangehrm-2.2.2 /opt/orangehrm

Change the owner

chown -R www:www /opt/orangehrm

Create a custom template for OrangeHRM

mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
pico  /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90orangehrm

Paste the following lines into orangehrm custom template

 #OrangeHRM
 Alias /orangehrm /opt/orangehrm
 <Directory /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
 </Directory>

Save by pressing Ctrl-x, press y to save changes and press Enter

Expand the template and restart httpd

 expand-template /etc/httpd/conf/httpd.conf
 svc -t /service/httpd-e-smith


Create MySQL user and privileges

You may change 'yourpassword' with your own password

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

InnoDB

We need to enable InnoDB, smeserver disable it by default

 db configuration setprop mysqld InnoDB enabled

Do post-upgrade and reboot

 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"

Removal

 rm /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/90orangehrm
 expand-template /etc/httpd/conf/httpd.conf
 svc -t /service/httpd-e-smith
 rm -rf /opt/orangehrm

Delete orangehrmuser from mysql using phpmyadmin

Optional :

 db configuration setprop mysqld InnoDB disabled

Additional Information

See discussion about OrangeHRM installation and problems (blank PIM page, etc) here