Toggle navigation

OrangeHRM Image Guide

Version 3.3.3

Websoft9 OrangeHRM is a pre-configured, ready to run image for running OrangeHRM on Alibaba Cloud.

OrangeHRM is an open source HRM (HRIS) solution for small and medium sized companies used by more than 1 million users worldwide. Functionality includes employee information management, employee absence management, recruitment management, employee performance evaluation and many other HR management tools.

Software Version: Orange3.3.3
Software directory: /data/wwwroot/default/orangehrm

Basic software environment: LAMP
PHP Configuration File: /usr/local/php/etc/php.ini
Virtual host Configuration File directory: /usr/local/apache/conf/vhost
Virtual host Configuration Command: /root/oneinstack/vhost.sh

Database install directory: /usr/local/mysql
Database data directory: /data/mysql
Database Configuration File: /etc/my.cnf

After the installation of Image,please verify it

  • Login on Alibaba Cloud console,get you Internet IP Address
  • Open you Chrome or Firefox on your local PC,visit the http://Internet IP Address/
  • If verify successfully,you can enter the boot page of Websoft9 below
  • If no response from browser,please check the Security Group settings to ensure that port 80 is been allowed

This Image use MySQL for database

#default user/password:root/123456

MySQL User Guide: Click here

Step1. Create a database

1.login in MySQL:

Method 1:Use following URL to open phpMyAdmin page: http://< Public net IP >/phpMyAdmin

Method 2:Use SSH command to login in.

mysql -uroot –p                                #enter mysql console

 #default user/password:root/123456            More MySQL User Guide: Click here

 

2.create a database:

MySQL [(none)]> create database mydbname;

MySQL [(none)]> show databases;

 

3.Create a Database User and grants permissions to the User:

MySQL [(none)]> grant all privileges on mydbname.* to username@'localhost' identified by 'userpassword';

MySQL [(none)]> flush privileges;

MySQL [(none)]> exit;

before2

Step2. Add a virtual host

Use SSH Command to Add a virtual host:
[root@iZbp1i4rjdsy216yq7lgucZ ~]# cd /root/oneinstack
[root@iZbp1i4rjdsy216yq7lgucZ oneinstack]# ./vhost.sh

Step3. Install OrangeHRM

Open your domain name via browser:
1.  Click “Next”;

2. Click “I Accept”;

3. Enter your database configuration, Click “Next”;

4. Click “Next”;

5. Set admin account, Click “Next”;

6. Click “Install”;

7. Click “Next”;

8. You have successfully installed OrangeHRM, Click “Finish”;

9. Enter your admin account, Click “LOGIN”;

10.  This is the Orange HRM page.

OrangeHRM is used by a global community ranging from Africa, the Americas, Asia, Australia and Europe, hence the importance for the system to be multilingual is high.Following languages are supported

  • US English
  • French – France
  • Spanish – Spain
  • Oromo
  • Indonesian
  • Chinese – China
  • Bulgarian – Bulgaria
  • Danish – Denmark
  • Spanish – Argentina
  • Vietnamese – Viet Nam
  • Spanish – Belize
  • Thai – Thailand
  • Dutch – Netherlands

 

How to use a new language?

  1. Log in system,admin->Configuration->Localization
  2. Click then “Edit” button,and then select the language that you want to use, save it

 

How to add a new language pack?

If you can not find the language in the drop-down menu of admin panel you want,you should add a new lanuage pack and enable it.OrangeHRM language translation is based on Symfony framerowk’s (1.4) I18n functionalities. In Symfony, language files are called as dictionary files and are written according to XML Localization Interchange File Format (XLIFF).

Following steps can help to instal a new language pack:

  1. Downlaod the language file(.xml format) for the Language and font help
  2. using FTP to upload the language file to the symfony/apps/orangehrm/i18n/
  3. Finally, add the ISO 639-1 code and ISO 3166-1 code of the new language to symfony/plugins/orangehrmAdminPlugin/config/supported_languages.yml.
    # supported languages
    #
    # Please enter in ascending alphabetical order of 'value' (language name)
    languages:
    #  0: {key: 'fr_CA', value: 'French - Canada'}  
      1: {key: 'en_US', value: 'US English'}  
      2: {key: 'fr_FR', value: 'French - France'}
    #  3: {key: 'ja_JP', value: 'Japanese'}
      4: {key: 'es_ES', value: 'Spanish - Spain'}
      5: {key: 'om_ET', value: 'Oromo'}
      6: {key: 'id_ID', value: 'Indonesian'}
      7: {key: 'zh_CN', value: 'Chinese - China'}
      8: {key: 'bg_BG', value: 'Bulgarian - Bulgaria'}
      9: {key: 'da_DK', value: 'Danish - Denmark'}
      10: {key: 'es_AR', value: 'Spanish - Argentina'}
      11: {key: 'vi_VN', value: 'Vietnamese - Viet Nam'}
      12: {key: 'es_BZ', value: 'Spanish - Belize'}
      13: {key: 'th_TH', value: 'Thai - Thailand'}
      14: {key: 'dt_NL', value: 'Dutch - Netherlands'}
    #  14: {key: 'zz_ZZ', value: 'test - TEST'}
  4. Once all above steps are done, you have to log in as an Admin and go to Admin > Localization for applying newly added language.

This solution is from OrangeHRM Wiki

Routine backup (archives) of the database and application setup is essential to ensure failover is smooth.you can use Manual Backup as following steps:

  1. Download the entire OrangeHRM files in you root dictionary by FTP or other tools
  2. Visit http://< Internet IP Address >/phpMyAdmin,login in to the phpMyAdmin Panel
  3. Select you database,then Export
  4. Click “go” button,then download the SQL backup file

Upgrade OrangeHRM, please follow the below steps:

1) Take a backup from the existing database
2) Download the latest version of OrangeHRM and extract it to web root directory
3) Access it in the web browser and navigate to this URL – installation_path/upgrader/web/ and run the web installer

4) Click “Upgrade” link in the installation wizard
5) Select the existing version and proceed with the upgrade

Websoft9  OrangeHRM  Image have installed the phpMyadmin

phpMyAdmin install directory: /data/wwwroot/default/phpMyAdmin

Linux

Following is the step for access phpMyadmin

  1. Open Chrome or Firefox on your local PC
  2. visit the http://Internet IP Address/phpMyAdmin,you can enter the login page
  3. select you language,Username:root,Password:123456
  4. Click the button “Go”

Windows

Following is the step for access phpMyadmin

  1. User Remote Desktop Connection of Window to connect to you ECS
  2. Install a Chrome or Firefox browser on you ECS
  3. Open Chrome or Firefox on your ECS
  4. visit the http://localhost/phpMyAdmin,you can enter the login page
  5. select you language,Username:root,Password:123456
  6. Click the button “Go”

When install new extension from back-end it will not successful,may be the permissions of file and folder is not appropriate,you should change it

Web site root permissions to follow:
file 644, folder 755 ,Permissions Users and groups www
If there is a file permissions problem, execute the following three commands:

chown -R www.www /data/wwwroot/default/orangehrm
find /data/wwwroot/default/orangehrm -type d -exec chmod 755 {} \;
find /data/wwwroot/default/orangehrm -type f -exec chmod 644 {} \;

Modify the  /usr/local/php/etc/php.ini file to increase the allowed size for uploads:

; Maximum size of POST data that PHP will accept.
post_max_size = 16M
; Maximum allowed size for uploaded files.
upload_max_filesize = 16M

then,restart the apache

# service httpd restart

The PHP configuration file allows you to configure the modules enabled, the email settings or the size of the upload files. It is located at /usr/local/php/etc/php.ini.

There are some PHP settings that need to be sufficient to install.

e.g The values for PHP.ini below are suggested values only.

  • memory_limit – Minimum: 256M Recommended: 1G or better
  • upload_max_filesize – Minimum: 20M
  • post_max_size – Minimum: 20M
  • max_execution_time: At Least 120 Recommended: 300

After modifying the PHP configuration file, restart both Apache and PHP-FPM for the changes to take effect:

# service httpd restart

If you receive the message “Maximum execution time of 30 seconds exceeded”.You may also like to extend the max_execution_time for PHP and you can modify it by two methods below

Method one: edit your  /usr/local/php/etc/php.ini


; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time = 90
; Maximum amount of time each script may spend parsing request data. It's a good
; idea to limit this time on productions servers in order to eliminate unexpectedly
; long running scripts.

Method two: edit your .htaccess:


<IfModule mod_php5.c>
php_value max_execution_time 90
</IfModule>