Transcript Installation of Parent Database

LIVE INSTALLATION
Machine Configuration for Live Server





Operating System for installing Live Application should be Windows XP or Windows 2003 Server .
Internet Connection must be there.
Static IP address required for outside office login and this address should be configured on firewall.
Port should be open either 8085 or 1467
Check JAVA application is installed or not. ( e.g. Go to Start >> Settings >> Control Panel >>
Add/Remove Program >> search J2SE Development Kit or J2SE Runtime Environment )
 If this is installed, then removed it .
Corporate web installation steps:
Part 1: Installation on live Server System.
Part 2: Installation of Parent Database (e.g Webdata) at Database Server.
Part 1: Installation on Live Server Machine
 Step1 : Download corporate.zip and setup.exe from http://www.shilpisoft.com under download option
on the desktop and extract there .
 Download setup_full.zip form www.shilpisoft.com\sunil\setup_full.zip on the desktop and extract it.
Extracted
files from
Corporate.zip
 All Extracted files are here
 Run jdk.exe.
 For running JDK , Following steps have to follow :
Tick here
 Change the path here as C:\jdk1.5.0_09
Click here to
change the path
Changed path
Click on Next
 For Setting the path of J2SE Runtime Environment ; path change To as C:\jre1.5.0_09
Default Path
Click here to change the path
Changed Path
Click on Next
 To Complete the Installation Process of JDK Setup , Click on finish.
Click on Finish
 Run Tomcat.exe from corporate folder , following steps have to do : (here you have to uncheck the
Documentation ).
Un-Tick Documentation
Click on next
 Destination folder path should be C:\Tomcat 5.5
Change this path as c:\tomcat 5.5
Changed path
Click on Next
 To Configure the Apache Tomcat , give the port no: 8085 or 1467
User Name : admin
Password : 12345 (optional)
Enter port
Enter user name
Password
Click on next
NOTE : While installing tomcat, enter the port 8085 or 1467.
 Here, the path of JREL.5.0_09, which has already installed in the system, should come automatically as :
C :\jre1.5.0_09. If this path is showing , click on Install otherwise browse the location of jre1.5.0_09 folder:
Click on Install
 Click on Finish to complete the Process.
Click on finish
 Step6 : Run setup.exe which is extracted from setup_full.zip then a folder named capexweb will be
created in C: Drive.
1. Run setup
2. Click on next
3. Click on Install
4. Click on Finish
Step7: Now run setup.exe, which was downloaded from website .
1. Click on run
2. Click on next
Click here to
change the path
if installing on
other drive (other
than c drive) and
copy capexweb
folder from c
drive to d
3. Click on next
4. Click on install
5. Click on finish
 After Successfully Installation of Jdk & Tomcat , 3 Folders i.e. jre1.5.0_09, jdk1.5.0_09 And Tomcat 5.5 will be
created in C: Drive.
 Copy web.xml file in c:\tomcat5.5\conf \ and capexweb.xml file in c:\tomcat5.5\conf\Catalina\localhost,
from xml folder which was extracted from corporate.zip .
 Change some entry in C:\capexweb\capexweb\capexmain_middle.htm. Open this file with notepad >>
<tr><td style=color:#114171>Shilpi Computers Limited</td></tr>
<tr><td style="font-size:7pt; color:#6E99D4">502 Prakashdeep Building 7 Tolstoy Marg New Delhi - 110 001
Ph Nos : 91-11-43500600 eMail : [email protected]</td></tr>
<input type="hidden" value=“SHILPI" name="dfcode">
<input type="hidden" name="dfparentdb" value="WEBDATA">
<input type="hidden" name="dfparentip" value="111.111.111.100">
 Change this values according to your company name address and contact details.
 Here, in place of dfcode value i.e. “SHILPI” give the Comp. ID given in license file .
 In place of dfparentdb value i.e. “WEBDATA” give the database name which is created as parent type in
Database Server .
 And in place of IP : Put IP address of Database Server in which Parent DataBase has been configured.
 Inform to license Dept. to get License File of configured Database with Order No, Company Name and
Database Name.
 Copy License file c:\capexweb I.e shilpi_capexweb.lic which will be give by the license department.
Part 2: Installation of Parent Database(e.g Webdata) at Database Server .
 Step1: Create a Parent Database
 Case 1: If there is a
single database at server then no need to create webdata , use existing
database as a parent e.g NSE9798:
 Step1: Configure exiting database as parent database as system utilities >> web live setup >>
database configuration.
 Step 2: Connect parent database as: system utilities >> web live setup >> database attach (Parent).
Here Connect and add.
 Step 3: Create a Branch as “Admin” in Master >> Branch Maintenance and active that branch.
 Step 4: Now update branch in Parent Database as:
utilities >> system utilities >> weblivesetup >> Auto update common user (For branch ,Sub Branch,
client & RM/TL).
 Select branch and Database name then Proceed.
Select Branch
Select database
name
Click on Proceed
 Step 5: Start tomcat services and login web live application to ADMIN
(for Example : http://131.108.2.100:8085/capexweb/capexweb/)
Enter user id (i.e.
admin)
Enter password
Default( 12345)
Click on login
Click here
 Step 6: Run 'DbMaintenance' as shown below:
1. Click on
admin
2. Click on DBMaintenance
 Case2: If more than one databases exist :
 Create a new database i.e. Webdata.
 Follow the following Steps to create “webdata” as a parent database at Database Server.
 Step1: To create parent database "webdata“, follow the following steps:





Go to start.
Select Program.
Select Oracle-OraHome92.
Select Configuration and Migration Tool.
Select Database Configuration Assistant.
 Following window will open:
1. Click on Next.
1. Tick on Create a
Database
2. Click on next
3. Select General
Purpose.
4. Click on Next.
5. Enter Database
name(i.e. Webdata).
6. Click on Next.
7. Select Share
Server Mode.
8. Click on Next
9. Click On OK
10. Database creation
in progress.(Wait for
completion)
11. Enter same
password in each
field (e.g. s). It is
mandatory.
12. Click on Exit .
STEP2: IMPORT BLANK DATABASE
 Open liceclient .exe . Click on Download to download Blank database. For it, follow the following steps
1. Click on Downloads
2. Select Product id
3. Tick on Blank Database
4. Click on Download Now
5. This message will display.
Click on Ok
 Now, extract downloaded file(capdat.zip) from D:\capex10. We will get two file capdat.log and
capdat.dat.
Downloaded file
Extracted Files
 Step3: Add the Parent's database entries (i.e. webdata) in sql.ini of capex10 folder.

Copy this sql.ini in configured database’s package folder(for example: ).
 Step 4: Tuned database
 Run licclient.exe and click on tuned database.
Enter password
(Password must be
same as of Oracle
database creation while
installing oracle )
Select Oracle Version
Enter Database Name
Browse backup data file.(i.e.
capdat.dat)
Click on this button.
Note: Make sure that database must be created before tuning database
 Note: Do not close this window because data is importing here.
 After importing database file there will be a text document pop up and check the status of database import
This Message
should display at
the end of the
file
Step 5: Product Activation
Follow the following steps to activate product
 Step 1: Run License file( i.e.: licclient.exe) from software folder.
 Step 2: Following window will open. Click on test-I net connection and wait for the message
Click here
to check
internet
connection
 Step 4 : Following message will
display. Click on Ok.
 Step 3: Select Product Activation
Product
Activation
 Following window will open:
Select New installation.
Select Product Type.
Enter database name.
Enter database Id given by
license department.
Click on Get Activation .
Following message will
display.

Do entry of parent database in cofile.dll in d:/capex10/cofile.dll
Step 6: Now Double Click on shortcut icon of capex10 and login into parent database (webdata)
Step 8: Take backup of webdata after licensed.
 Step3: Configure databases on parent database as system utilities >> web live setup >> database
configuration.
NOTE: Click on plus(+) button to add the entry.
 In Application type : Select CAP for Application Capital & F&O.
Select FXF for FXFUTURE
 In Case of DbType Select Parent for Parent database And Child For others Database.
 Seq. No should be unique .
 Step 4: Connect parent database as: system utilities >> web live setup >> database attach (Parent) in all
databases.
 Step5: Update License Status of each database from LICCLIENT.EXE from package.
 Step6: Create a Branch as “Admin” in Master >> Branch Maintenance in each Database.
 Step7: Now update branch in Parent Database as:
utilities >> system utilities >> weblivesetup >> Auto update common user (For branch ,Sub Branch,
client & RM/TL).
 Select branch and Database name one by one then Proceed.
NOTE: Never run in ALL Database at a time.
 Step8: Start tomcat services and login web live application to ADMIN
(for Example : http://131.108.2.100:8085/capexweb/capexweb).
 Step9: Run 'DbMaintenance' from admin option available on Bottom of the Left Panel. (This option will
be highlighted on 'admin' users Only. For it , follow the following steps:
Enter user id (i.e
admin)
Enter password(i.e
12345)
Click on login
Click here
Select database in which you want to login
 Run 'DbMaintenance' in all databases as shown below:
Click on admin
Click on DB-Maintenance
Live Installation
successfully completed
For change of drive from C:\ to E:\ (Or Any other drive)
 Run jdk and tomcat files again and change the path to e:\





Add a line in c:\capexweb\ capexweb\capexmain_middle.htm
(where same lines appears)
<input type="hidden" name="dfinstaldrive" value="E">
Run setup.exe in e:\
To change drive in capexweb.xml , follow the following :
Open E:\Tomcat 5.5\conf\Catalina\localhost\ open capexweb.xml in notepad and change
c:\ to e:\
As <Context docBase=“e:/capexweb" path="/capexweb" reloadable="true"
workDir=“e:\capexweb\work">
Troubleshooting
Error 1: Index page is not opening:
Solution:
Check proxy setting may be 8080 port is using for run proxy internet.
b) Check on live application may be oracle9i server is installed , listener is using 8080 port .
c) Check java version may be installed in c:\previously.
a)
Error 2: On admin login in live , error is coming
“java.lang.NullPointerException..webusermaster “
Solution:
a) check Parent database should be login .
b) In capexmain_middle.htm check company id, db name, parent db IP (If all is okay then confirm Comp Id From
Sir)
c) Live Server and Database Server should be on the same network.
Error3: HTTP Status 404 - / capexweb/capexweb/
Solution:
a.) check capexweb.xml file in C:/Tomcat 5.5/conf/catalina/localhost/capexweb.xml
Error 4: HTTP Status 404 - / capexweb/capexweb/parentvalidatepassword/
Solution:
a.) check all jar files in C:\capexweb\WEB-INF\lib (Take all jar file from S:\lib)
How To update the version of capexweb in Live Server :
 Tell to Client to download setup.exe from http://www.shilpisoft.com/sunil/setup.exe
 Stop the Tomcat Service
 Delete the work folder from C:/capexweb
 Delete 4 jar Files i.e. capexweb.jar , commexonline.jar , fxfuture.jar , dponline.jar from
C:\capexweb\WEB-INF\lib
 Run the Set up.
 In Admin Login run DBMaintainance in all exchange in live .
How to Change the Port :




Go to C:\Tomcat 5.5\conf
Open server.xml file (open with Notepad)
Find the Connector i.e.
<Connector
port="8085"
maxHttpHeaderSize="8192"
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />
 Give the port as per clients requirement and Save the file .
How to set the path for Digital Contract Note in Live Server .
For Capital :
a.) First generate the digital contract note html file in Backoffice .
b.) Keep this file in C:\capexweb\digital\ClientCode\Date. (e.g- digital\P8A01\10032005)
For Commex :
a.) First generate the digital contract note html file in Backoffice .
b.) Keep this file in C:\capexweb\digital_com\MCX\ClientCode\Date. (e.gdigital_com\MCX\A55\20052009)
For FxFuture :
a.) First generate the digital contract note html file in Backoffice .
b.) Keep this file in C:\capexweb\digital_fx\ClientCode\Date. (e.g- digital_com\NSE\A55\20052009)
How to Set path for Download And Upload file in Live Server :
For Download :
a.) Keep file in C:\capexweb\download\capex\branch\branch_name\Date (for e.g :
download\capex\branch\P8\20051024)
For Upload :
a.) Keep file in C:\capexweb\upload\capex\Branch name\ (for NSDL or CDSL create NSDL Folder
in capexweb folder .
For Upload Cheque image of Voucher :
a.) Keep file in C:\capexweb\cheque\Branch name\
For Any Message if any branch want to give :
a.) Keep file in C:\capexweb\message\branch_Name\ (e.g message\COM)
Refer other live related Presentation for
 Path setting,
 Login type and
 Working of live