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

on the desktop and extract there .

and

setup.exe

from

http://www.shilpisoft.com

under download option 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

Documentation ).

from corporate folder

,

following steps have to do : (here you have to uncheck the 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) NOTE : While installing tomcat, enter the port 8085 or 1467.

Enter port Enter user name Password Click on next

 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

3. 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

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 >> Shilpi Computers Limited 502 Prakashdeep Building 7 Tolstoy Marg New Delhi - 110 001 Ph Nos : 91-11-43500600 eMail : [email protected]

value="111.111.111.100">  C hange 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.

Database Name.

to get License File of configured Database with Order No, Company Name and  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 database configuration.

as parent database as system

utilities >> web live setup >>



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 DB Maintenance



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.

capdat.dat.

We will get two file

capdat.log and

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 ) Browse backup data file.(i.e

. capdat.dat

)

Note:

Make sure that database must be created before tuning database Select Oracle Version Enter Database Name Click on this button.



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: Step 2:

Run License file( i.e.: licclient.exe) from software folder.

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

Seq. No DbType

Select Parent for Parent database And Child For others Database. 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

Select database in which you want to login Click here

 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) 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

Troubleshooting Error 1: Index page is not opening: Solution:

a) b) c) Check proxy setting may be 8080 port is using for run proxy internet.

Check on live application may be oracle9i server is installed , listener is using 8080 port .

Check java version may be installed in c:\previously.

Error 2: Solution:

a) b) c) check Parent database should be login .

In capexmain_middle.htm check company id, db name, parent db IP (If all is okay then confirm Comp Id From Sir) 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.

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.g digital_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