Change IP Address and Hostname of OTUC: can't update sql acc
Posted: 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
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