20) How can I install OrangeHRM manually ?

From OrangeHRM

Some of the hosting providers provide access to the Mysql database server through the front end only. Possibly a control panel through the web url. If installing OrangeHRM using the web installer fails in a hosted environment specially when it says Innodb is disabled and the hosting provider says Innodb enabled, this should be the ideal way to install.

First of all verify that Innodb is indeed enabled. Execute the following command to the mysql server and check the result.

command: show engines;

Result should show something like the following.

    +------------+---------+----------------------------------------------------------------+
   | Engine     | Support | Comment                                                        |
   +------------+---------+----------------------------------------------------------------+
   | MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance         |
   | MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      |
   | InnoDB     | DEFAULT | Supports transactions, row-level locking, and foreign keys     |
   | BerkeleyDB | NO      | Supports transactions and page-level locking                   |
   | BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) |
   | EXAMPLE    | NO      | Example storage engine                                         |
   | ARCHIVE    | YES     | Archive storage engine                                         |
   | CSV        | NO      | CSV storage engine                                             |
   | ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                 |
   | FEDERATED  | YES     | Federated MySQL storage engine                                 |
   | MRG_MYISAM | YES     | Collection of identical MyISAM tables                          |
   | ISAM       | NO      | Obsolete storage engine                                        |
   +------------+---------+----------------------------------------------------------------+

Check the Support column for the Engine Innodb. If it says disabled then you have no option other than to enable this
either by your self or ask your hosting provider to enable this.
Once verified Innodb is enabled, then try the following.

1. Creating the database

1) Login to mysql server using the command line client(Mysql Console) providing the user details. Open Terminal/Command Prompt and execute the command

               * mysql -u username -p

and press enter. replace the username with the one you have and provide the password when prompted.

2) If you log in successfully, you'll be provided a command prompt like this.

3) Now type the following command to check the available databases.

               * show databases;

4) Now create a database for Orangehrm using the following command

               * create database orangedb ;

5) Use the database using the following command,

               * use orangedb;

6) Now you have an empty database. To create orangehrm 2.2.2.2 tables you have to source the dbscript.sql file found in 'orangedir/dbscript/' location.

               * source dbscript.sql ;

For above command to work, the working directory should be the 'orangedir/dbscript/'.

7) Now you should see its creating the Orangehrm tables and inserting default data. If you see any errors you have to drop the database and again follow the above steps

If you are using a web panel for managing the databases, for the above 6 steps you can just do the following

Create a blank database
Import the dbscript/dbscript.sql file which would be 92KB in size found in the orangehrm directory to the newly 
created blank database.
Check whether there are 86 tables in the database if the version of OrangeHRM is 2.4.
Create a mysql user and assign him all privileges to the orangehrm database.
Set a password to the user.
Use them in the configuration file.

2. Creating the configuration file.

8) Exit the 'Mysql Console'. Thats it now you have to create the configuration file for Orangehrm. To do this edit the file 'Conf.php-distripution' found in 'orangedir/lib/confs/'. Open it in Text Editor/Notepad and you have to change three places. Locate the following three lines in the file and change the words enclosed with quotes appropriately.

               * $this->dbname    = 'Orange-DB-Name';
               * $this->dbuser    = 'Mysql-Username';
               * $this->dbpass    = 'Password-For-That-Username';

also you have to change the line

               * $this->emailConfiguration = dirname(__FILE__).'mailConf.php';

to

               * $this->emailConfiguration = dirname(__FILE__).'/mailConf.php';

If it is the same then leave it.

9) Save the file in 'lib/confs/' as Conf.php under the Orangehrm installation directory. Open the browser and use the url you use to access Orangehrm eg: http://localhost/orangehrm

10) You'll be provided with the Login page for Orangehrm. Use demo as the username and password to login. If it didn't work then admin would work.

11) Go to Admin -> Users -> HR Admin Users to change the username demo and its password.