Looks good on the surface...perhaps there is a problem with whitespace or hidden characters?  It would be a good idea to use the RTMT tool to look at the AXL logs, perhaps you may spot something.  Attach here if you need help.

Hi,
 
Not the answer to your actual question, but an alternative using SOAP::Lite... TIMTOWTDI, you know ;-) The happy face is of course a colon and a D.
 
#!/usr/bin/perl
use warnings;
use strict;
use SOAP::Lite;
my $cucmip = "192.168.0.10";
my $axl_port = "8443";
my $user = "cisco";
my $password = "cisco";
BEGIN {
  sub SOAP::Transport::HTTP::Client::get_basic_credentials {
    return ($user => $password)
  };
}
my $cm = new SOAP::Lite
    encodingStyle => '',
    proxy => "https://$cucmip:$axl_port/axl/" ;
#axl request
my $res =  $cm->executeSQLQuery(SOAP:ata->name("sql" => "SELECT * FROM numplan"));
unless ($res->fault) {
 for my $row ($res->valueof('//executeSQLQueryResponse/return/row')) {
  #print "$_, ${$row}{$_}\n" foreach keys %$row;
  print "${$row}{$_}," foreach keys %$row;
  print "\n";
 }
}
else {
        print join ', ',
        $res->faultcode,
        $res->faultstring;
}
 
Cheers,
 
//Dan

Hi,
 
OK, I understand. I think SOAP::Lite is quite easy to use. I wrote a LWP-version as well, I got the same error as you at first but when I removed some of the namespace info in the XML it worked better :-) It's not the first time the samples from Cisco is broken...
 
use LWP::UserAgent;
use Data:umper;
use XML::Simple;
my $cucmip = "192.168.0.10";
my $axl_port = "8443";
my $user = "cisco";
my $password = "cisco";
my $url = "https://$cucmip:$axl_port/axl/";
my $soap = <<AXL;
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
 <SOAP-ENV:Body>
  <executeSQLQuery>
   <sql>SELECT * FROM numplan</sql>
  </executeSQLQuery>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
AXL
# Create ua
my $ua = LWP::UserAgent->new;
push @{ $ua->requests_redirectable }, 'POST';
# Create request
my $req = HTTP::Request->new(POST => $url);
$req->content_type('text/xml');
$req->header('Accept' => 'text/*');
$req->content($soap);
$req->authorization_basic($user,$password);
# Send request
my $res = $ua->request($req);
#print $res->content;
# Check response
if ($res->{_rc} == 200) {
 # Request successful
 $xml = new XML::Simple();
 $data = $xml->XMLin($res->content,KeyAttr => "return" );
 print Dumper($data);
}
 
Cheers,
 
//Dan

If you haven't seen it, the Data Dictionary documents all the tables and fields in the UCM database: http://developer.cisco.com/web/axl/docs.  All of these are accessible via <executeSQLQuery>

I figured it out...I just needed to adjust my select statement, here's an example that returns several records:
 
<sql>SELECT firstname,lastname,userid,manager,telephonenumber FROM Enduser WHERE department = 'Finance'</sql>
 
Thanks for all the help.
 
John