06-25-2018 08:19 AM
Hello,
On 9.1 we had an application using AxlSqlToolkit , working just fine.
I'm trying to get it working after migration to 11.5, but have some issues with it.
I have downloaded and installed the new AxlSqlToolkit from 11.5,
for start I'm trying this simple query:
<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
<!ELEMENT data (sql+)>
<!ELEMENT sql EMPTY>
<!ATTLIST sql
query CDATA #IMPLIED
update CDATA #IMPLIED
>
]>
<data>
<sql query="SELECT * FROM personalphonebook WHERE fkenduser=(SELECT pkid FROM enduser WHERE userid='CustomerDir')"/>
</data>
For this I'm calling
java -cp ./classes:./lib/saaj-api.jar:./lib/saaj-impl.jar:./lib/mail.jar:./lib/activation.jar:./lib/jaxm-api.jar:./lib/jaxm-runtime.jar:./lib/xercesImpl.jar:./lib/xml-apis.jar AxlSqlToolkit ,
with parameters like
-host=$hostip -username=$uid -password=$pw \
-input=$inputfile -output=$outputfile
and I'm getting this in return:
---------------------------- SELECT * FROM personalphonebook WHERE fkenduser=(SELECT pkid FROM enduser WHERE userid='CustomerDir') ----------------------------
<?xml version="1.0" encoding="UTF-8" standalone="no"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>Incorrect password or user com.informix.asf.IfxASFRemoteException: dbaxlreadonly@lu00pvc01i901fm is not known on the database server.</faultstring><detail><axlError><axlcode>-951</axlcode><axlmessage>Incorrect password or user com.informix.asf.IfxASFRemoteException: dbaxlreadonly@lu00pvc01i901fm is not known on the database server.</axlmessage><request>executeSQLQuery</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>
The hostname lu00pvc01i901fm corresponds to the host IP, that I'm supplying in parameter.
Can anyone help ?
Thank you in advance.
06-29-2018 08:26 AM
Hi,
while working on another problem, it has just turned out that the cause was the same: upon the upgrade of CUCM from 9.1 to 11.5, some system IDs have their password expiration changed from 99999 to 90, and dbaxlreadonly is one of them. After changing back to 99999 (in /etc/shadow), the problem goes away.
The nasty thing about it is, that it will hit you only 90 days after version upgrade ...
This Cisco bug describes another issue, caused by the same: https://bst.cloudapps.cisco.com/bugsearch/bug/CSCva20411/?reffering_site=dumpcr
Cheers
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