Change IP Address and Hostname of OTUC: can't update sql acc

Post Reply
orottler
Member
Posts: 2
Joined: 17 Jan 2011 13:57

Change IP Address and Hostname of OTUC: can't update sql acc

Post by orottler » 06 Mar 2013 09:19

Hallo,

tried to Change IP Address and Hostname of OTUC in Administration 4.0-007.001. No easy way over host/nnsswitch/logical links for different reasons (follow only dns, grap links in startscripts as extra servers, an unbelieveable amount of different places in conf and xml files with explicit IP. Managed a up to the sybase database in webadmin. No idea for a workaround, doesnt know even the sybase account login and password for the dbconsole.

Try to change from otuc to otuc4-1
----------------------------------------------
started dbserv9 already withe the new one

dbsrv9 -ud -m -n otuc4-1 /opt/Alcatel/Sybase/db/ALARMS.db /opt/Alcatel/Sybase/db/CUSTO.db /opt/Alcatel/Sybase/db/DIRECTORIES.db /opt/Alcatel/Sybase/db/dta.db /opt/Alcatel/Sybase/db/OSS.db /opt/Alcatel/Sybase/db/OTS.db /opt/Alcatel/Sybase/db/ROUTING.db

Treied to cghange service SQL server over webadmin: can't update sql account

/var/log/messages
Mar 5 18:13:37 otuc SQLAnywhere(otuc4-1): Connection terminated abnormally

/opt/Alcatel/logs/Tomcat/WebAdmin/AdminServer.log:

2013-03-05 18:15:43,354 WARN AdmReqAnalyzerTopology - a_rottler_o1 2CBE1C2816BCB50CE567D417EE13B636.exttomcat1 Exception in updateTopologyFull : java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: Can't update sql account.
2013-03-05 18:15:43,354 FATAL AdmIApplicationDefinition - a_rottler_o1 2CBE1C2816BCB50CE567D417EE13B636.exttomcat1 Exception during retrieve label : class com.alcatel.wadmin.ihm.jsformatter.ComIException / message = [jsLabel[2029]]
2013-03-05 18:15:43,354 ERROR AdmIApplicationDefinition - a_rottler_o1 2CBE1C2816BCB50CE567D417EE13B636.exttomcat1 action error! class com.alcatel.wadmin.ihm.jsformatter.ComIException / message = [jsLabel[2029]]
at com.alcatel.wadmin.ihm.topology.AdmITopologyModificationAction.action(AdmITopologyModificationAction.java:82)
at com.alcatel.wadmin.ihm.ComIApplicationDefinition.action(ComIApplicationDefinition.java:277)
at com.alcatel.wadmin.ihm.ComIApplicationDefinition.loadPage(ComIApplicationDefinition.java:483)
at org.apache.jsp.en.admLoadPage_gui_jsp._jspService(admLoadPage_gui_jsp.java:105)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
at com.alcatel.wadmin.ihm.ComIForward.doForward(ComIForward.java:31)
at com.alcatel.wadmin.AdminServer.service(AdminServer.java:204)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:542)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:444)
at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:472)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
at java.lang.Thread.run(Thread.java:595)

/opt/Alcatel/logs/DataAccess/dta.log:

2013-03-05 18:15:43,352 ERROR DtaJndiKernel - [2532]An error occured during updateTopologyjava.lang.Exception: Can't update sql account.
at com.alcatel.dataaccess.base.storage.DtaJdbcStorageManager.updateAccountSqlDatabase(DtaJdbcStorageManager.java:335)
at com.alcatel.dataaccess.kernel.DtaJdoKernel.updateAccountSqlDatabase(DtaJdoKernel.java:147)
at com.alcatel.dataaccess.kernel.DtaJndiKernel.updateSqlAccount(DtaJndiKernel.java:4352)
at com.alcatel.dataaccess.kernel.DtaJndiKernel.updateSqlServer(DtaJndiKernel.java:4335)
at com.alcatel.dataaccess.kernel.DtaJndiKernel.updateTopology(DtaJndiKernel.java:1891)
at com.alcatel.dataaccess.kernel.DtaJndiKernel.updateTopology(DtaJndiKernel.java:1865)
at com.alcatel.dataaccess.rmi.rmiadmin.reqanalyzer.DtaRmiTopologyRequest.updateTopology(DtaRmiTopologyRequest.java:162)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)

/opt/Alcatel/logs/Events_Server/traces.log/opt/Alcatel/logs/Events_Server/traces.log

05 Mar 2013 13:38:51,232 ERROR [ECS-Main] (DataAccessService.java:150) - no ACS data defined - dtaPublicServer (acServices.length == 0) || (acServices[0] == null)
05 Mar 2013 13:38:51,279 INFO [ECS-Main] (DataAccessService.java:217) - RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: Method parameter cannot be null:DtaPublicCACS.extractPublicACSByDisplayName - String pDisplayName
05 Mar 2013 13:39:01,282 INFO [ECS-Main] (DataAccessService.java:208) - Connecting to primary DTA at rmi://localhost:5009/DataAccessServer
05 Mar 2013 13:39:01,290 ERROR [ECS-Main] (DataAccessService.java:150) - no ACS data defined - dtaPublicServer (acServices.length == 0) || (acServices[0] == null)


/opt/Alcatel/OmniPCXTSA/dyn/otuc4-1@3595/log/ev130305.txt
18h31:19.152 Error: 1 ??? 1 REQUEST_PENDING startRouting on ots 3595
18h31:38 Error fetching information: [iODBC][Driver Manager]Connect not open

User avatar
cavagnaro
Alcatel Unleashed Certified Guru
Alcatel Unleashed Certified Guru
Posts: 7001
Joined: 14 Sep 2005 19:45
Location: Brasil, Porto Alegre
Contact:

Re: Change IP Address and Hostname of OTUC: can't update sql

Post by cavagnaro » 07 Mar 2013 08:42

You can only change IP address, for hostname you have to do a full reinstall as many configuration files do write the server name on it and obviously now will fail.
Ignorance is not the problem, the problem is the one who doesn't want to learn

OTUC/ICS ACFE/ACSE R3.0/4.0/5.0/6.0
Certified Genesys CIV 8.5
Certified Genesys Troubleshooting 8.5
Certified Genesys BEP 8.x
Genesys Developer

Post Reply

Return to “OTUC”