Informix queries via ODBC

[shikamarunara]

Hello,

     A while ago I set upon configuring a Debian server to use ODBC and PDO to query our CUCCX server for use as a basic wallboard.  I got it working and would now like to extend this our CUCM publisher.  For CUCCX, the DB Schema document was very valuable because it gave information on the database name as well as a pretty thorough description of the tables.  I'm looking for the same information for CUCM.  I've read some of the CUCM Data Dictionary, but I still have questions on how to find the relevant information for the DSN.

    So, for the CUCCX Wallboard project, one roadblock was in adding the Informix servername to the DSN.  There are certain rules, such as hyphens are turned into underscores, etc.  For CUCM, I cut to the chase and pulled a db replication trace to look at what Informix server names were being used, but I would like a verification to make sure I am on the right track.  Server names seem to prepended with a "g" and the version number of the server seems to be appended as well, so;

Servername:

abc-011-c78-vs01

Informix server name:

g_abc_011_c78_vs01_ccm8_6_1_20000_1

Does this look correct?

Also, for UCCX, there is a default ucchruser account that is used for the purpose of DB queries.  What kind of account should I create to do this?  What kind of rights role should it have?

What is the database name on CUCM that I can add to the DSN?  Is there a document like the UCCX DB Schema doc that I can use?  Any help is very much appreciated.

[William Bell · Accepted solution]

You won't be able to open an ODBC (or JDBC) connection to the CUCM cluster. If you want to access data in the Informix database then you need ot use the AXL/SOAP API.

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/devguide/8_6_1/axl.html

HTH

-Bill
(b) http://ucguerrilla.com
(t) @ucguerrilla

Please remember to rate helpful responses and identify helpful or correct answers.

[shikamarunara]

Hi WIlliam,

     I've been reading up on your posts and been reading some of your posts.  Do you have a tutorial on how you configure access to the database by any chance?  I'm interesting in connecting to CUCM from PHP, not sure if this is an option.

[William Bell · Accepted solution]

I have written a couple of applications using ASP.NET that integrate with the AXL/SOAP interface. So,

I don't see why you couldn't use PHP but I have little experience in that territory.

HTH

-Bill
(b) http://ucguerrilla.com
(t) @ucguerrilla

Please remember to rate helpful responses and identify helpful or correct answers.

[shikamarunara]

William,

     Can you send me a link to a sample?  Just looking for something to pull CDR records to a page.

[shikamarunara]

Hi William,

     I spent more time on your site and I must confess it's very cool.  Lots of really good information on there.  So, update to my query situation;  I've figured out the SQL string I should run to get the information I'm looking for;

run sql car select datetimeOrigination, dateTimeConnect, dateTimeDisconnect, callingPartyNumber, finalCalledPartyNumber from tbl_billing_data where finalCalledPartyNumber like 'XXXXX' or callingpartynumber like 'XXXXX' order by datetimeOrigination

I understand that this statement will proabably not do me much good in rendering the information to a web page, but it's a start.  I also found some PHP code that will use AXL, a gentleman had posted it here;

http://ict-all.blogspot.com/2011/04/accessing-ccm-soapaxl-interface.html

But the link he's using in this example is https:///realtimeservice/services/RisPort?wsdl, which I do not believe will work for CDR queries.  My understanding is that I need to use

https://<8443>

I'm not sure what the port 8443 reference is for since it seems to work without it.

So, my guess is that I should be using the second link for CDR queries. 

Does the account used in the AXL query only need the Standard AXL API Access role?  I seem to be pulling information when my account is using Super User, but not when using an account that only has the Standard AXL API Access role (not sure if I need to add another role to the group).  Beyond that, do you have a tutorial on how to put together a SOAP query for this kind of situation?