Thomas Chandra (thomas DOT aria AT telkom DOT net DOT id)
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.
Download the package
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
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"
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"
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
db configuration setprop mysqld InnoDB disabled
See discussion about OrangeHRM installation and problems (blank PIM page, etc) here