How to install Cobub Razor manually?

Before you get start, ensure that you have the following:

• A web server, shared hosting or dedicated server.
• Check out the System Environment Requirements.
• Download the latest release of Cobub Razor.
• Unzip the zip file, and you will get a folder, whose name such as cobub-razor-237c064 which contains files and directories(e.g. sdk, web), you can rename cobub-razor-237c064 to a simple name such as razor as you like.

Upload the new folder – cobub-razor-237c064 to the desired location on your web server(e.g. Apache or Nginx).

Here we put it to the following directory(c:\xampp\htdocs\).

• Sql files path: under Cobub_Razor/assets/sql
• Sql files: databaseinfo.sql(for Chinese Version) and edatabaseinfo.sql(for English Version) are the basic database sql file; dataware.sql(for Chinese Version)and edataware.sql(for English Version) are the sql files for warehouse; datawarestore.sql is the sql file for stored procedures.
• Choose sql files based on the language of your selection: for example, if you would like to install a Chinese version of Cobub Razor, you should choose 3 sql files of databaseinfo.sql, dataware.sql and datawarestore.sql.
• Replace the prefix and db name (take Chinese version as example):

A. Create a blank database, for example with the name of “cobubrazor”. In this example, we will only create ONE MySQL database. Also, if you want, you can also create separate databases for basic data and warehouse.
B. Find and replace the prefix “umsinstall_” to your own prefix in databaseinfo.sql file, eg, find & replace “umsinstall_” to “razor_”.
C. Do the same thing in dataware.sql file, replace all the prefix of “umsinstall_” to your own prefix (eg. “razordw_”), please note that you could use different prefixes in databaseinfo.sql and dataware.sql file.
D. Find and replace “umsinstall_” in datawarestore.sql file to the prefix of warehouse, eg“razordw_”. And replace all occurs of “databaseprefix.umsdatainstall_” to the fomart of “databasename.basicdbprefix”, in this sample should change to “cobubrazor.razor_”.

• Import and execute the modified sql files to your blank database. You need to execute the sql files in the sequence of databaseinfo.sql→dataware.sql→datawarestore.sql.

• Configure files path: Cobub_Razor/application/config.
• Change 4 files autoload.php，config.php，database.php，routes.php as following:
• autoload.php: change $autoload['language'] = array() to $autoload['language'] = array('allview') .
• config.php: change $config['base_url'] = 'http://localhost:80/web'; to $config['base_url'] = 'webpath_2_your_cobubrazor'; and change $config['language'] = 'en_US'; to $config['language'] = 'your_language_setting'; note: you need to keep the same language choice in the sql files and setting here.
• database.php, to set your database configuration, change the following

$db['default'] ['hostname'] = 'HOSTNAME';
$db['default'] ['username'] = 'USERNAME';
$db['default'] ['password'] = 'PASSWORD';
$db['default'] ['database'] = 'DATABASE';
$db['default'] ['dbprefix'] = 'DBPREFIX';

to your own setting:

$db['default'] ['hostname'] = 'localhost';
$db['default'] ['username'] = 'cobub';
$db['default'] ['password'] = 'cobub';
$db['default'] ['database'] = 'cobubrazor ';
$db['default'] ['dbprefix'] = 'razor_';

Change data warehouse setting

$db['dw'] ['hostname'] = 'DWHOSTNAME';
$db['dw'] ['username'] = 'DWUSERNAME';
$db['dw'] ['password'] = 'DWPASSWORD';
$db['dw'] ['database'] = 'DWDATABASE';
$db['dw'] ['dbdriver'] = 'mysql';
$db['dw'] ['dbprefix'] = 'DWDBPREFIX';

to your own data ware house setting, eg

 $db['dw'] ['hostname'] = 'localhost';
$db['dw'] ['username'] = 'cobub';
$db['dw'] ['password'] = 'cobub';
$db['dw'] ['database'] = 'cobubrazor ';
$db['dw'] ['dbdriver'] = 'mysql';
$db['dw'] ['dbprefix'] = 'razordw_';

• routes.php: change $route['default_controller'] = “install/install” to $route['default_controller'] = “report/console”.