Post Installation Tasks
This chapter provides more information on configuring Axpert and installing Node.js:
Sections of this chapter:
1.2. Installing nodejs on Windows manually
1.2.1.Managing node server through console
1.3.1. Opening Web Application (If Redis is installed) (Optional)
1.4. Launching Axpert Web Application
1.1 Configuring Axpert
1. Run Axpert.exe from AxpertWebScripts folder available in your local drive.
2. If you are an Axpert Developer and you have existing project, then click the Connect to an Axpert Application button and skip Step 3.
3. If you are new to Axpert and do not have any project, then click the Create a New Axpert Application button.
4. Enter all the database details related to your Application. You will be redirected to Axpert login page.
1.2. Installing nodejs on Windows manually
1. Download the latest release of Node.js from the below mentioned site. See:
For 64 bit system, choose node-v6.11.2-x64.msi
For 32 bit system, choose node-v6.11.2-x86.msi
2. Change your working directory to AXPERT_HOME/AxpertWeb/node and run the bash script npmsetup.ps1. For example
AXPERT_HOME/AxpertWeb/node/npmsetup.ps1.
In the above syntax,
AXPERT_HOME is the location where your Axpert files are installed in your local drive.
3. Right click npmsetup.ps1 file from AXPERT_HOME/AxpertWeb/node folder and select Run with Powershell command.
To run the npmsetup.ps1 file, follow the steps mentioned below:
3.1. Type Y and press enter in the Powershell window. The user will be prompted to make changes. Press Y.
3.2. In the Powershell window, type R and press enter. Repeat this step until the command starts running.
Once you run the command successfully, all softwares get installed.
4. For 64 bit, download the oracle db instant client version 12.2 from
http://www.oracle.com/technetwork/topics/winx64soft-089540.html.
Download these files:
instantclient-basic-windows.x64-12.2.0.1.0.zip
instantclient-sdk-windows.x64-12.2.0.1.0.zip
For 32 bit, download the oracle db instant client version 12.2 from
http://www.oracle.com/technetwork/topics/winsoft-085727.html
Download these files:
instantclient-basic-nt-12.2.0.1.0.zip
instantclient-sdk-nt-12.2.0.1.0.zip
Accept the license agreement and sign up in the oracle.com or use your existing credentials to begin your download. Then, extract both the zip folders into the same folder. For example, you can use C drive with a folder structure C:\instantclient_12_2 such that sdk folder is present in C:\instantclient_12_2\sdk folder structure.
5. To set the environment and system variables, follow the steps mentioned below:
5.1. Right click My Computer/This PC and select Properties. The system window appears.
5.2. On the left navigation pane, click Advanced system settings. The System Properties window appears.
5.3. Navigate to the Advanced tab and click the Environment Variables… button. The Environment Variables window appears.
5.4. Navigate to the System variables section to select Path and click the Edit… button. The Edit environment variable window appears.
5.5. Click the New button to add the following paths in chronological order and sort the paths by clicking the Move Up button.
(1) Oracle instant client – C:\instaclient_12_2
(2) Python – %USERPROFILE%\.windows-build-tools\python27
(3) Python scripts – %USERPROFILE%\.windows-build-tools\python27\Scripts
5.6. Click the OK button.
5.7. Now, navigate to the System variables section of the Environment Variables window.
5.8. Click the New button. The New System Variable window appears.
5.9. In the Variable name field, enter OCI_LIB_DIR as the variable name.
5.10. In the Variable value field, enter the instant client path of $Oracle_instant_client_path\sdk\lib\msvc. For example
C:\instaclient_12_2\sdk\lib\msvc.
The user must follow the \sdk\lib\msvc folder structure.
5.11. Click the OK button.
5.12. To add another system variable name and variable value (OCI_INC_DIR and C:\instantclient_12_2\sdk\include) respectively, repeat steps from 5.7 to 5.11.
5.13. Close all the command prompt windows if opened any.
Navigate to AxpertWeb/node folder.
6. In the Environment Variable tab, under the System Variables section, click the New button and add the TNS_ADMIN entry. If the node server runs on the system in which the oracleDB is installed, then configure TNS_ADMIN environment variable pointing to the tnsnames.ora file location.
7. Install Microsoft Visual C++ Redistributable Packages from https://support.microsoft.com/en-us/help/3179560/update-for-visual-c-2013-and-visual-c-redistributable-package for Oracle Instant Client V12.2.
8. Edit the tnsnamenode key in the AXPERT_HOME/AxpertWeb/node/config/dbconfig.js folder according to the desired entry from the tnsnames.ora file. The node will try to query from the entry which is specified in the ‘tnsnamenode’ key.
By default, the key value will be ‘orcl’.
9. In AXPERT_HOME/AxpertWeb/node/config/dbconfig.js file, you can control the maximum number of rows returned by API using the ‘maxRows’ key.
10. In AXPERT_HOME/AxpertWeb/web.config file of the project, change the value of the key ‘nodeAPI’.
By default, the node URL will be http://127.0.0.1:3015/api/. If the node server is running remotely, you can replace 127.0.0.1 with the relevant node server IP address and if the homebuilderimagepath is hosted remotely, you can replace the existing URL http://127.0.0.1:3015/images/userfiles/ with http://nodeserverIP:3015/images/userfiles/.
Make sure that the port number 3015 is enabled so that it can be accessed outside the network.
11. Run npmInstall.bat file from AXPERT_HOME/AxpertWeb/node folder
For example
AXPERT_HOME/AxpertWeb/node/npmInstall.bat
If you see any errors while running npm command, you can change the name of oci.dll into _oci.dll inside the C:\Windows\System32 folder.
12. If the npm installation is successful and if you use the Oracle database, open the command prompt and change the directory to AXPERT_HOME/AxpertWeb/node.
Enter ‘node initializeSetup.js “schema username” “schema password” “service_name”‘ in command prompt
For example, you can enter the command in this format. ‘node initializeSetup issuetrack log orcl’
If you use MySql/MariaDB, Open the command prompt and change the directory to AxpertWeb/node.
Enter ‘node initializeSetupMysql.js “schema username” “schema password” “host_ip”‘ in command prompt.
For example, you can enter the command in this format. ‘node initializeSetupMysql issuetrack log 127.0.0.1’.
13. If you are using MariaDB/MySql database, open the command prompt and change your working directory to MYSQL_INSTALLED_PATH\bin.
MYSQL_INSTALLED_PATH is the location, where the MySQL is installed in your system.
Run mysql -u SCHEMA_USERNAME -p DATABASE_NAME < “AXPERT_WEB_FOLDER\migration\MigrateMysqlProcedure.sql” in the command prompt and press Enter.
The system will now prompt the user to enter the schema password.
14. Run installForever.bat file from AXPERT_HOME/AxpertWeb/node folder.
For example
AXPERT_HOME/AxpertWeb/node/installForever.bat
15. Navigate to the AXPERT_HOME/AxpertWeb\node\config\dbConfig.js file and perform the following:
a)For Oracle database, tnsnamenode key must be the tnsNode(Service Name) entry referring to the Oracle database. Eg: “orcl”
b)For MySQL / MariaDB database, host key must have the database IP. Eg: “192.168.2.25”
Save the changes and close the text editor.
16. Double click the nodeAppStart.bat file from AXPERT_HOME/AxpertWeb/node folder to start the node server.
1.2.1.Managing node server through console
a) To check if the node is running properly, type [your_IP_Address]: 3015 in your browser and press Enter so that you can verify whether the server is successfully installed or not.
Success message appears as follows: {“status”:”Server is running successfully”}
b) If you want to stop the node server, double click nodeAppStop.bat file from AXPERT_HOME/AxpertWeb/node folder.
c) If the node server runs on any public windows server, there might be a possibility of particular ports getting blocked. For example, if your node server runs in port 5667, then ensure that this port is accessible from other systems as well.
d) All access error gets stored as .log file in the AXPERT_HOME/AxpertWeb/node/applicationlog/dd-mm-yyyy-error.log folder.
e) All access result gets stored as .log file in AXPERT_HOME/AxpertWeb/node/applicationlog/dd-mm-yyyy-results.log folder.
f) Set the desired port for node server by modifying the applicationport key in the AXPERT_HOME/AxpertWeb/node/config/dbconfig.js folder.
1.3. Redis Caching (Optional)
1. Follow the Documents: Linux(Linux Redis Installation & Configuration.rtf) or Windows(Windows Redis Installation & Configuration.rtf) for Redis Caching.
2. Open Run command, enter inetmgr and click OK.
3. On the left pane, click Sites > Default Web Site > AxpertWeb.
4. Right Click AxpertWeb and click Explore.
5. Change following keys in web.config file after every installation or update:
a) redisIP
b) redisPass
1.3.1. Opening Web Application (If Redis is installed) (Optional)
Usually, this step will be automatically performed by OS.
1. Open Run command, enter inetmgr as a run command and click Ok.
2. Click Application Pools link in Left Pane.
3. Click AxpertWebScripts in Center Pane to open a Actions pop up window.
4. In the Actions pop up window, click Recycle in right pane.
5. Click AxpertWeb in Center Pane.
6. From Actions, click Recycle in right pane.
1.4. Launching Axpert Web Application
1. Launch web browser.
2. Enter http://localhost/<site name> in the address bar to launch the Axpert Web Application.
