12-11-2015 08:25 AM
Hi all,
I want to change the "Advertised Route String" and "Exchange Global Dial Plan Replication Data with Remote Clusters" in ILS Configuration using an AXL request. The updateIlsConfig does not have these fields. So how to change them using an AXL request?
In the updateIlsConfig request, what are the corresponding GUI field for "activateIls" "registrationServer", "activatedServers" and "deactivatedServers"?
Another question: how can I "read" the fields values ? The getIlsConfig request does not have the fields such as "use TLS Certificates", "Synchronize Cluster Every"...
Thanks,
Fabien
Solved! Go to Solution.
12-20-2015 02:24 PM
Hi,
It took me a while but I found the ILS Configuration in the table "featureconfig".
The "Advertised Route String" corresponds to "RoutingString". "Exchange Global..." corresponds to "IsURIEnabled".
The "Synchronize Cluster Every"... corresponds "PingInterval" etc.
A query for select * from featureconfig where tkfeatureconfig = 6 gives
<ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/10.5">
<return>
<row>
<keyname>RegistrationServer</keyname>
<value/>
</row>
<row>
<keyname>IsHubCluster</keyname>
<value>T</value>
</row>
<row>
<keyname>PingInterval</keyname>
<value>600</value>
</row>
<row>
<keyname>IsURIEnabled</keyname>
<value>T</value>
</row>
<row>
<keyname>RoutingString</keyname>
<value>myRoutingString</value>
</row>
<row>
<keyname>ILSState</keyname>
<value>0</value>
</row>
<row>
<keyname>ReplicationPassword</keyname>
<value/>
</row>
<row>
<keyname>HubPeerId</keyname>
<value/>
</row>
<row>
<keyname>UseTLS</keyname>
<value>T</value>
</row>
<row>
<keyname>RegistrationStartTime</keyname>
<value/>
</row>
</return>
</ns:executeSQLQueryResponse>
If not AXL request is available you could always (with caution) use executeSQLUpdate.
For example:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">
<soapenv:Header/>
<soapenv:Body>
<ns:executeSQLUpdate sequence="?">
<sql>update featureconfig set value = "myRoutingString" where keyname = "RoutingString" and tkfeatureconfig = 6</sql>
</ns:executeSQLUpdate>
</soapenv:Body>
</soapenv:Envelope>
12-20-2015 02:24 PM
Hi,
It took me a while but I found the ILS Configuration in the table "featureconfig".
The "Advertised Route String" corresponds to "RoutingString". "Exchange Global..." corresponds to "IsURIEnabled".
The "Synchronize Cluster Every"... corresponds "PingInterval" etc.
A query for select * from featureconfig where tkfeatureconfig = 6 gives
<ns:executeSQLQueryResponse xmlns:ns="http://www.cisco.com/AXL/API/10.5">
<return>
<row>
<keyname>RegistrationServer</keyname>
<value/>
</row>
<row>
<keyname>IsHubCluster</keyname>
<value>T</value>
</row>
<row>
<keyname>PingInterval</keyname>
<value>600</value>
</row>
<row>
<keyname>IsURIEnabled</keyname>
<value>T</value>
</row>
<row>
<keyname>RoutingString</keyname>
<value>myRoutingString</value>
</row>
<row>
<keyname>ILSState</keyname>
<value>0</value>
</row>
<row>
<keyname>ReplicationPassword</keyname>
<value/>
</row>
<row>
<keyname>HubPeerId</keyname>
<value/>
</row>
<row>
<keyname>UseTLS</keyname>
<value>T</value>
</row>
<row>
<keyname>RegistrationStartTime</keyname>
<value/>
</row>
</return>
</ns:executeSQLQueryResponse>
If not AXL request is available you could always (with caution) use executeSQLUpdate.
For example:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">
<soapenv:Header/>
<soapenv:Body>
<ns:executeSQLUpdate sequence="?">
<sql>update featureconfig set value = "myRoutingString" where keyname = "RoutingString" and tkfeatureconfig = 6</sql>
</ns:executeSQLUpdate>
</soapenv:Body>
</soapenv:Envelope>
12-22-2015 08:04 AM
Thank you for the answer !
01-11-2016 02:50 AM
Hi,
Just another question: where is stored the "role" value? It seems not be in featureconfig table.
Thanks,
Fabien
12-09-2016 09:52 AM
Old post so I assume you've sorted this by now, but the "value" column in the featureconfig table reflects the stored parameter value - with one exception, for some things (like "Advertised Route String" for example) that have not yet been changed from their default value, this column will indicate a null value.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide