How to install SDM 14 and CABI 6.1 into 1 server

[Guan Hua Chee]

Hi,

 

I and my other team mate are having problem installing SDM 14.1 and CABI into 1 server.

System is a 64 bit server that net all requirement.

The server was installed with tomcat 8, than SDM 14 and later the patch 14.1.03.

Later when we install the CABI 6.1 it seem to either break the server or the CABI although completed the script successful does not appear on the port http://localhost:8080/jasperserver-pro.

We keep getting stuck  http error 404.

Event later changing it to the out of the box 32 bit tomcat 7 also stuck at http 404...

We am planning a reinstall again tomorrow.

Any advice will be helpful we are spending quite a number of man hours installing these application.

[Jon_Israel]

Hi Guan Hua Chee,

Few things - first, we dont recommend running CABI on the same server as SDM - both require a lot of overhead which will most likely cause performance issues for both applications.  Now, as for the issue you are having - this is because both applications are fighting for port 8080 on the machine.  What you need to do is change the tomcat port for either CABI or SDM.  I would recommend changing it for CABI.  To do this, stop apache tomcat 8, then edit the HTTP connector in the server.xml file, located in the Tomcat8\Conf directory.  

You will see the following section for the connector:

 

<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />

 

Change it to the following:

 

 <Connector port="8181" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8544" />

 

Then, start Apache Tomcat 8 back up, and you should be able to access Jasper at:

 

http://localhost:8181/jasperserver-pro

 

Hope this helps.,

Jon I.

[Vinod Subburaj]

Hi Guan Hua Chee,, 

Could you check if your able to access CA SDM url 

http://server name:8080/CAisd/pdmweb.exe 

 

~Vinod.

[Guan Hua Chee]

Hi Guys,

 

Thanks for the information. CABI completed the script successful and can make a connection to http://localhost:8080/jasperserver-pro. Just a bit slow to load the login and navigation web page.

 

I took Jon advice and separate it from the SDM server. Running CABI on the mdb database server.

 

Now I just need to look at Configure CABI JasperReports® Server r6.2.0 for CA Service Management.

 

Imported CA Service Management Content from DVD06074332E\Jasper Reports zip files.

 

Need to find out where I can get a copy of JDBC Driver com.ca.casm.jdbc.openaccess.OpenAccessDriver  and CA Service Management jar to make a connection to the sdm_ds datasource.

[Jon_Israel]

Hi Guan - you dont need a copy of the driver - it exists already within the application.  Please follow the instructions to configure Jasper for CA Service Management - you can find that here: Configure CABI JasperReports® Server r6.2.0 for CA Service Management - CA Service Management - 14.1 - CA Technologies D… 

There is no separate driver to install.

[Guan Hua Chee]

Hi Jon,

 

Think I mess up the driver on. As I install the CABI on the database server and not SDM primary server.

Can't find the driver when I keep doing Define the datasource that the CA Service Desk Manager reports use.

 

"Step 3: Configure CABI JasperReports® Server r6.2.0 for CA SDM

 2. Define the datasource that the CA Service Desk Manager reports use"

 

I found the jar files package located in DVD06074332E installer and load it up again.

 

• Define the datasource details:

JDBC Driver (required): com.ca.casm.jdbc.openaccess.OpenAccessDriver (change the JDBC Driver naming)
URL (required): jdbc:openaccess://<Point to the SDM primary server not the database server>:19987;ServerDataSource=Default

Username: Enter a valid CA SDM ( AKA Windows local account )user name.
Password: Enter a valid password for the CA SDM use

JDBC Driver: Other... ( Load DVD06074332E jar files )

Test Connection ( Test was good)

 

The rest of the steps in the document was smoothly executed.

Completed to Step 6: Generate Reports where I can pack it up and gave to administering SDM

[Aamir Khan]

its better to put on separate server to avoid single point of failure

[Guan Hua Chee]

Can't be help I only have two hardware for these installation.

[Jon_Israel]

Guan - so are you up and running on Jasper at this point?  I am unclear from your last update.

Thanks,

Jon

[Guan Hua Chee]

Hi Jon,

 

It up up and running.

 

Regards.