Topic: HOWTO Install OrangeHRM on SME 7.x

[thomasch]

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
<Directory /usr/bin/php5>
order deny,allow
deny from all
allow from all
Options ExecCGI
</Directory>
[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

<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>
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.

[jester]

Thanx for this!

[cactus]

Please put the OrangeHRM part in the wiki. You do not need to put the PHP5 section there as the installation procedure is already outlined in the link you supplied in you post.

[jester]

Cactus,
Read the last 3 lines in thomasch post 

[cactus]

Cactus,
Read the last 3 lines in thomasch post 

Oops, missed that in the amount of lines probably.

To get access to the wiki please apply for it using the bugtracker. The development team will than grant you access to the wiki using your forums account.

[thomasch]

Oops, missed that in the amount of lines probably.

To get access to the wiki please apply for it using the bugtracker. The development team will than grant you access to the wiki using your forums account.

I did apply, its quite a long time a go... the request still there.
Dev team, can u help me grant the access? Thanks

[crobruncato]

Thanks for bringing this application to my attention - this is great. I'm trying the install, but I'm unable to add employees. I go into the PIM module, and when I click add, nothing happens. Are there any log files or anything I can check?

Thanks!
Rob

[Bud]

Installation went Fine.

All the OrangeHRM Modules are working except for the PIM Module. Whan I want to add an Employee all I get is a white screen. I have asked for help on the Orange HRM Forum but with no reply.

Please Help

I need to get this Module working Urgently.

[Bud]

Please guys any help on the PIM Module. I cannot enter any Data as it just Displays a White Screen. Please advise what I need to do? 

[Bud]

Ok no Problem I solved it. 

Working GREAT

[crobruncato]

Bud
This is the same problem I'm having - How did you fix it?

Thanks
Rob

[shawnbishop]

Hi Guys

I just found out that the OrangeHRM wont display information in a default install of Mozilla Firefox, that is I cant edit the Company name etc..open it in IE and it works....


...bugger...

[Bud]

crobruncato
Ok this is what I did.

Notice what thomasch said about during the Installation. He mentioned "You can ignore "Memory alocated for PHP Script warning "

According to the OrangeHRM Developers they Recommend that you allocate 16M per Module to get the Application (PIM etc.) to work Correctly. As the Application is by Default installed to use 8M per Module this is what the Problem is.

I would like to thank " thomasch " though for doing all the Leg Work in showing what needs to be done to get this Application to work on the SME Server.

Follow these Steps, As we are installing "php5" we need to edit Just ONE File.

Use PuTTY or WinSCP and EDIT the File " /etc//php5/php.ini "
On about Line 304 (The Heading will say Resource Limits) change " memory_limit = 8M " to " memory_limit = 32M "

I set mine to 32M and am having NO Problems. You can Change yours to 16M or whatever works for you.

Hope this Helps

[shawnbishop]

That confuses me...

So if we keep the MEM=8M, it works in IE, only when I raise it to 32M does it work in Firefox??

[crobruncato]

crobruncato
Ok this is what I did.

Notice what thomasch said about during the Installation. He mentioned "You can ignore "Memory alocated for PHP Script warning "

According to the OrangeHRM Developers they Recommend that you allocate 16M per Module to get the Application (PIM etc.) to work Correctly. As the Application is by Default installed to use 8M per Module this is what the Problem is.

I would like to thank " thomasch " though for doing all the Leg Work in showing what needs to be done to get this Application to work on the SME Server.

Follow these Steps, As we are installing "php5" we need to edit Just ONE File.

Use PuTTY or WinSCP and EDIT the File " /etc//php5/php.ini "
On about Line 304 (The Heading will say Resource Limits) change " memory_limit = 8M " to " memory_limit = 32M "

I set mine to 32M and am having NO Problems. You can Change yours to 16M or whatever works for you.

Hope this Helps

Bud - Thanks! I'll give it a try.

[thomasch]

Hi,

I do not use OrangeHRM on daily basis and my installation of OrangeHRM went away with my old server.
I am pretty busy with my job (I have a company to run). So, I can't check the correctness of the page.
Any correction/addition to the wiki are welcome.

All I can do to maintain the howto now is add a link of this forum topic to the wiki page.

Sorry for the inconvenience.

thomas

[Bud]

Please Help Guys

I tried to install OrangeHRM 2.3 onto a SME7.3 Server. When I get to the " http://myserver/orangehrm " installation screen after I entered all the Relevant Info I get an Error " Access denied for user 'root'@'localhost' (using password: YES). Please Check Priviledged Database Username and Password Correct."

Please Help 

[Bud]

Hi Guys

Any Help on my Database Creation Problem for OrangeHRM 2.3 on a Fresh New Updated 7.3 Server. Whan I go to Install and Enter all the Details I get and Error

" Access denied for user 'root'@'localhost' (using password: YES). Please Check Priviledged Database Username and Password Correct."

It will not Create the MySQL Database and I'm giving it my Root Username and Root Password as well as the Username and Password as mentioned in
thomasch's how to install OrangeHRM.

Sorry for the Request I'm a bit of a Noob with MySQL 

[Bud]

hope you guys can help with installation of orangehrm on new sme 7.4 server

1. i have installed php5 as per " http://wiki.contribs.org/PHP5 "
2. i have created an ibay called " orangehrm " using " smesitemaker " with a database called " orangehrm "
3. copied all the orangehrm (orangehrm-2.2.2.tar.gz) files to the orangehrm ibay
4. i have used the installation example as per " http://wiki.contribs.org/OrangeHRM "

however when i point my firefox browser to " http://smeserver/orangehrm " i get an error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, admin@smeserver.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

any help greatly appreciated

[cactus]

Have a look at the logfiles, you will most likely find a clue in the /var/log/httpd/error_log or acccess_log files.

[Bud]

cactus thanks for your help

in my error_log i get

[Wed May 05 12:49:32 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 12:49:36 2010] [error] [client 192.168.0.38] access to /opt/orangehrm/ failed, reason: SSL connection required
[Wed May 05 12:49:41 2010] [error] [client 192.168.0.38] access to /opt/orangehrm/ failed, reason: SSL connection required
[Wed May 05 12:49:46 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 12:52:45 2010] [error] [client 192.168.0.38] access to /opt/orangehrm/ failed, reason: SSL connection required

what now?

[cactus]

in my error_log i get

[Wed May 05 12:49:32 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 12:49:36 2010] [error] [client 192.168.0.38] access to /opt/orangehrm/ failed, reason: SSL connection required
[Wed May 05 12:49:41 2010] [error] [client 192.168.0.38] access to /opt/orangehrm/ failed, reason: SSL connection required
[Wed May 05 12:49:46 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 12:52:45 2010] [error] [client 192.168.0.38] access to /opt/orangehrm/ failed, reason: SSL connection required

what now?

According to the above you seem to not use a SSL connection, eg. using https://. What is the full URL you are using to access your installation?

[Bud]

cactus thanks for the quick response

whether i use http://myserverIP/orangehrm/ or https://myserverip/orangehrm/ i still get the same error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, admin@mysmeserver.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


what to do ?

[cactus]

whether i use http://myserverIP/orangehrm/ or https://myserverip/orangehrm/ i still get the same error
what to do ?

Did anything change in the logfiles? What do they say when you access the site over https? Please keep in mind that we are not behind your server.

[Bud]

cactus thanks again, sorry i should have given you the error log info ( /var/log/httpd/error_log )

this is the last entry in the log after i tried to " https://myserverip/orangehrm/ "

[Wed May 05 13:56:40 2010] [error] [client 192.168.0.38] Premature end of script headers: php

hope this helps 

[cactus]

cactus thanks again, sorry i should have given you the error log info ( /var/log/httpd/error_log )

this is the last entry in the log after i tried to " https://myserverip/orangehrm/ "

[Wed May 05 13:56:40 2010] [error] [client 192.168.0.38] Premature end of script headers: php

hope this helps 

No not really as it has no context. Please post a little more of the error_log file, the part leading up to this as well as a snippet of the access_log file from around the same time.

[Bud]

cactus here you go

error_log

[Wed May 05 14:13:11 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 14:13:29 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 14:14:05 2010] [error] [client 192.168.0.38] Premature end of script headers: php
[Wed May 05 14:14:26 2010] [error] [client 192.168.0.38] Premature end of script headers: php

access_log

mysme.com 192.168.0.38 - - [05/May/2010:14:14:05 +0200] "GET /orangehrm/ HTTP/1.1" 500 538 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18"
mysme.cocom 192.168.0.38 - - [05/May/2010:14:14:26 +0200] "GET /orangehrm HTTP/1.1" 301 239 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18"
mysme.com 192.168.0.38 - - [05/May/2010:14:14:26 +0200] "GET /orangehrm/ HTTP/1.1" 500 538 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18"

hope this helps

[cactus]

It seems you have lost the SSL error so we are already one step further. Unfortunately the premature end of script header is a very general one. Please follow the instructions from this link. It will configure PHP to display a more extensive error message in your browser, perhaps we can gain some more information from that.

Please retry to access the site after you have followed the instructions and post back any errors displayed in your browser.

[Bud]

cactus thanks for the info

did what you said and i received this from

error_log

[Wed May 05 14:27:15 2010] [warn] RSA server certificate CommonName (CN) `smebox.mysme.com' does NOT match server name!?
[Wed May 05 14:27:15 2010] [notice] Apache configured -- resuming normal operations
[Wed May 05 14:28:05 2010] [notice] Graceful restart requested, doing restart
[Wed May 05 14:28:05 2010] [warn] The Alias directive in /etc/httpd/conf/httpd.conf at line 1057 will probably never match because it overlaps an earlier Alias.
[Wed May 05 14:28:05 2010] [notice] Digest: generating secret for digest authentication ...
[Wed May 05 14:28:05 2010] [notice] Digest: done
[Wed May 05 14:28:05 2010] [warn] RSA server certificate CommonName (CN) `smebox.mysme.com' does NOT match server name!?
[Wed May 05 14:28:05 2010] [notice] Apache configured -- resuming normal operations

?

[cactus]

cactus thanks for the info

did what you said and i received this from

And did you access your website? Did it output anything to the browser? What you just posted is just the result of your webserver starting up.

[Bud]

cactus

used ie browser and getting the same result ( https://myserverip/orangehrm/ )

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, admin@devsys.co.za and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

[cactus]

Pffff... not sure what is happening here. Can you look if there is anything listed in /var/log/messages perhaps? I am out of clues, but somehow we need to find what is causing the internal server error.

[Bud]

cactus thanks for your help

will start with new sme server and go from there