HP Autonomy TeamSite 7.3.2 - обновить информацию об используемой базе данных
Когда приложение Teamsite установлено заново, оно позволяет вводить данные базы данных. Однако позже, когда требуется обновить информацию для входа в базу данных, TeamSite не предоставляет ни интерфейса, ни документов для ее обновления.
Насколько я могу судить, наиболее вероятное место, которое можно изменить, это: /usr/Interwoven/CommonServices/config/private/database.properties
#
# database.properties.example
#
# Database connection information for Interwoven Registry Service.
#
# the development database schema connection info
connection.driver_class=oracle.jdbc.driver.OracleDriver
connection.url=jdbc:oracle:thin:@myhost:myport:myservicename
connection.username=iwcommon
connection.password=NBk8oBfFLHpwQ4AcM0+el8nr7qfObiBW
database.type=oracle
database.name=myservicename
database.port=myport
database.server=myhost
# orm configuration.
#
# For Microsoft SQL Server: org.hibernate.dialect.SQLServerDialect
# For Oracle: org.hibernate.dialect.OracleDialect
#
orm.dialect=org.hibernate.dialect.OracleDialect
#
# updateSchemaOnStartup=<true|false>
#
# if true, then ORM synches the mapping files with the tables in the schema.
# if false, existing schema is not changed.
#
#orm.updateSchemaOnStartup=false
Я должен обновить его до другого сервера базы данных Oracle с другим именем хоста и именем службы, но с тем же паролем. Тем не менее, ошибка аутентификации встречается после завершения изменения и перезагрузки. Вот извлеченный общий журнал службы по адресу /usr/Interwoven/ApplicationContainer/server/default/log/commonservice.log
2014-09-01 17:24:48,430 [http-0.0.0.0-8080-4] INFO org.apache.cxf.phase.PhaseInterceptorChain () - Interceptor has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Invalid ServiceId/ClientId - Authentication failed
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.handleMessage(AuthenticationInterceptor.java:121)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:92)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:283)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:128)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:174)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.doPost(AbstractCXFServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.interwoven.wcm.service.iwovregistry.common.ConfigException: Invalid ServiceId/ClientId - Authentication failed
... 28 more
2014-09-01 17:24:48,444 [http-0.0.0.0-8080-4] WARN org.hibernate.util.JDBCExceptionReporter () - SQL Error: 12505, SQLState: 66000
2014-09-01 17:24:48,444 [http-0.0.0.0-8080-4] ERROR org.hibernate.util.JDBCExceptionReporter () - Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
2014-09-01 17:24:48,444 [http-0.0.0.0-8080-4] ERROR com.interwoven.wcm.service.iwovregistry.adaptors.AbstractBackupAdaptor () - Failed to get TeamSite serviceInfo or IRService home directory when obtaining CSFactory.
com.interwoven.wcm.service.iwovregistry.common.ConfigException: Exception while reading/writing from Database [ getServiceInfoByComponentName ]
at com.interwoven.wcm.service.iwovregistry.adaptors.ServiceInfoAdaptor.getServiceInfoByComponentName(ServiceInfoAdaptor.java:674)
at com.interwoven.wcm.service.iwovregistry.adaptors.AbstractBackupAdaptor.getFactory(AbstractBackupAdaptor.java:422)
at com.interwoven.wcm.service.iwovregistry.adaptors.AbstractComponentManager.getCSClient(AbstractComponentManager.java:93)
at com.interwoven.wcm.service.iwovregistry.adaptors.AuthenticateSessionStringAdaptor.authenticateSessionString(AuthenticateSessionStringAdaptor.java:58)
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:597)
at com.interwoven.wcm.service.iwovregistry.adaptorlayer.AdaptorFactory.invokeAdaptor(AdaptorFactory.java:212)
at com.interwoven.wcm.service.iwovregistry.servicelayer.ConfigServiceImpl.execute(ConfigServiceImpl.java:92)
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.authenticateUserByClientId(AuthenticationInterceptor.java:417)
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.authenticateUser(AuthenticationInterceptor.java:309)
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.handleMessage(AuthenticationInterceptor.java:114)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:92)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:283)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:128)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:174)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.doPost(AbstractCXFServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
at com.interwoven.wcm.service.iwovregistry.adaptors.ServiceInfoAdaptor.getServiceInfoByComponentName(ServiceInfoAdaptor.java:658)
... 39 more
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 44 more
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 52 more
2014-09-01 17:24:48,446 [http-0.0.0.0-8080-4] ERROR com.interwoven.wcm.service.framework.AuthenticationInterceptor () - Error while parsing incoming message for authentication
com.interwoven.wcm.service.iwovregistry.common.ConfigException: java.lang.NullPointerException
at com.interwoven.wcm.service.iwovregistry.adaptorlayer.AdaptorFactory.invokeAdaptor(AdaptorFactory.java:264)
at com.interwoven.wcm.service.iwovregistry.servicelayer.ConfigServiceImpl.execute(ConfigServiceImpl.java:92)
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.authenticateUserByClientId(AuthenticationInterceptor.java:417)
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.authenticateUser(AuthenticationInterceptor.java:309)
at com.interwoven.wcm.service.framework.AuthenticationInterceptor.handleMessage(AuthenticationInterceptor.java:114)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:92)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:283)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:128)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:174)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.doPost(AbstractCXFServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at com.interwoven.wcm.service.iwovregistry.adaptors.AbstractComponentManager.getCSClient(AbstractComponentManager.java:94)
at com.interwoven.wcm.service.iwovregistry.adaptors.AuthenticateSessionStringAdaptor.authenticateSessionString(AuthenticateSessionStringAdaptor.java:58)
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:597)
at com.interwoven.wcm.service.iwovregistry.adaptorlayer.AdaptorFactory.invokeAdaptor(AdaptorFactory.java:212)
... 31 more
Цените, если кто-нибудь знает правильный способ изменить детали базы данных. Более того, я понятия не имею, как формируется пароль, так что это будет проблемой позже, так как политика моей компании требует регулярного обновления пароля базы данных. Большое спасибо!
1 ответ
Все версии ТС после 7.1. используйте внутреннюю базу данных для подсистемы событий, чтобы внешняя БД больше не использовалась. Внутренняя БД - ActiveMQ, файловая база данных, которая непосредственно интегрирована в TS.
Для оставшихся баз данных, если вы переименуете их, вот соответствующие файлы конфигурации, которые необходимо обновить в TeamSite:
CommonServices
CommonServices/config/private/database.properties
ReportCenter
TeamSite/tsreport/conf/spring-config.xml
ReportcenterAdv
ApplicationContainer/server/default/deploy/js-jboss-ds.xml
ApplicationContainer/server/default/deploy/report-ds.xml
Вам также нужно будет открыть таблицу IR_DBINFO в базе данных общих служб и обновить там информацию о базе данных после изменения имен.
Перезапустите TS и Reporting после внесения изменений.