Mailing List Archive: Cisco: VOIP

Informix RISDB - Connectivity

Index | Next | Previous | View Threaded

rameshbalajiv at yahoo

Jul 16, 2008, 7:05 PM

Post #1 of 5 (308 views)
Permalink

Informix RISDB - Connectivity

Hi:

I am currently working towards analyzing the database configuration of UCM 6.1 RISDB - Informix instance that resides under Linux environment.
I am unable to connect to the database using ODBC interface as I am not able to find the service that is using internally. The service description
I can see from CLI is "A Cisco DB" but I am looking for the service name
that is setup under sqlhosts or /etc/services file. I am unable to view those files as its secured or unviewable from CLI interface.

Have anybody connected the Informix RISDB using third party ODBC interface or IBM ODBC Driver and queried the database or updated, please let me know.

While I was reviewing the pages, came across AXL. If anyone done programming using AXL API, please let me know the sample code, I would like to test it to perform mass update/insert/delete operations.

Thanking You
Ramesh Vasudevan
Verizon Inc.

_______________________________________________
cisco-voip mailing list
cisco-voip[at]puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

matt at saskin

Jul 17, 2008, 4:07 AM

Post #2 of 5 (281 views)
Permalink

Re: Informix RISDB - Connectivity [In reply to]

Can't do it. If the firewall settings on the box don't stop you I'd
imagine CSA would.

You have two options for querying the database. From the command line
'utils run sql' or similar, or via the AXL/SQL interface.

-matt

Ramesh Vasudevan wrote:
> Hi:
>
> I am currently working towards analyzing the database configuration of UCM 6.1 RISDB - Informix instance that resides under Linux environment.
> I am unable to connect to the database using ODBC interface as I am not able to find the service that is using internally. The service description
> I can see from CLI is "A Cisco DB" but I am looking for the service name
> that is setup under sqlhosts or /etc/services file. I am unable to view those files as its secured or unviewable from CLI interface.
>
> Have anybody connected the Informix RISDB using third party ODBC interface or IBM ODBC Driver and queried the database or updated, please let me know.
>
> While I was reviewing the pages, came across AXL. If anyone done programming using AXL API, please let me know the sample code, I would like to test it to perform mass update/insert/delete operations.
>
> Thanking You
> Ramesh Vasudevan
> Verizon Inc.
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip[at]puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>

_______________________________________________
cisco-voip mailing list
cisco-voip[at]puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

rameshbalajiv at yahoo

Jul 17, 2008, 6:33 AM

Post #3 of 5 (278 views)
Permalink

Re: Informix RISDB - Connectivity [In reply to]

Matt:

Thank you for the information. I would like to know if you have any sample AXL/SQL to test it under lab environment.

Thank you
Ramesh V.

_______________________________________________
cisco-voip mailing list
cisco-voip[at]puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

matt at saskin

Jul 17, 2008, 11:26 AM

Post #4 of 5 (276 views)
Permalink

Re: Informix RISDB - Connectivity [In reply to]

Log into the callmanager. Application -> Plugins -> Cisco Unified
Communications Manager AXL SQL Toolkit

A google search should have some samples somewhere. I personally
haven't used the AXL SQL toolkit as I just use plain old AXL to do what
I want. AXL SQL is only useful if you want to run direct queries
against the database.

-matt

Ramesh Vasudevan wrote:
> Matt:
>
> Thank you for the information. I would like to know if you have any sample AXL/SQL to test it under lab environment.
>
> Thank you
> Ramesh V.
>
>
>
>
>
>

_______________________________________________
cisco-voip mailing list
cisco-voip[at]puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

rameshbalajiv at yahoo

Jul 17, 2008, 12:45 PM

Post #5 of 5 (275 views)
Permalink

Re: Informix RISDB - Connectivity [In reply to]

Matthew:

Thank You. I have downloaded the plug-in and ry to play around using that.

I try to run that for the sample.xml file and got the error.

C:\cisco\AXLSQL~1>java -cp .\classes;.\lib\saaj-api.jar;.\lib\saaj-impl.jar;.\li
b\mail.jar;.\lib\activation.jar;.\lib\jaxm-api.jar;.\lib\jaxm-runtime.jar;.\lib\
xercesImpl.jar;.\lib\xml-apis.jar AxlSqlToolkit -username=sampleadmin -password=samplead -host=1.2.3.4 -port 8443 -input sample.xml -output sample.response
Exception in thread "main" ja sion 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)

I downloaded JRE 1.4.2_08 as per the README but still I am getting the above error due to the version difference between what I have (runtime) and version of the AXL class that was built on. I will try with 1.4.2_05 and see whether that will work.

Ramesh V.

--- On Thu, 7/17/08, Matthew Saskin <matt[at]saskin.net> wrote:

> From: Matthew Saskin <matt[at]saskin.net>
> Subject: Re: [cisco-voip] Informix RISDB - Connectivity
> To: rameshbalajiv[at]yahoo.com
> Cc: cisco-voip[at]puck.nether.net
> Date: Thursday, July 17, 2008, 2:26 PM
> Log into the callmanager. Application -> Plugins ->
> Cisco Unified
> Communications Manager AXL SQL Toolkit
>
> A google search should have some samples somewhere. I
> personally
> haven't used the AXL SQL toolkit as I just use plain
> old AXL to do what
> I want. AXL SQL is only useful if you want to run direct
> queries
> against the database.
>
> -matt
>
> Ramesh Vasudevan wrote:
> > Matt:
> >
> > Thank you for the information. I would like to know
> if you have any sample AXL/SQL to test it under lab
> environment.
> >
> > Thank you
> > Ramesh V.
> >
> >
> >
> >
> >
> >

_______________________________________________
cisco-voip mailing list
cisco-voip[at]puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com