标题: qc服务器ip地址变了，无法打开 [打印本页] 作者: wyalgl 时间: 2009-2-9 15:23 标题: qc服务器ip地址变了，无法打开 因为工作需要，安装qc的服务器ip地址改变了（由192.168.1.156改为192.168.1.135），其他配置都没有改变，qc服务可以支持启动，但是无法打开。我修改了数据库qcsiteadmin_db的dbservers表里面的dbserver_name字段（由192.168.1.156改为192.168.1.135），还有projects表的dbserver_name字段也该了，但是还是不行，请问怎么回事啊？谢谢！！！作者: archonwang 时间: 2009-2-9 15:44
请提供下报错看看，有可能写入了其他位置的没进行修改就不行作者: wyalgl 时间: 2009-2-9 16:17
登陆进了qc管理员界面，填入用户名、密码，然后点登陆Messages:
Failed to Login;
Failed to check authentication of user 'admin';
Cannot build directory item for key '[qcsiteadmin_db@jdbc:mercury:sqlserver://192.168.1.156:1433(td)]' in SA Global Struct Dir;
Failed to fill table struct for table null in database qcsiteadmin_db@jdbc:mercury:sqlserver://192.168.1.156:1433(td);
[Mercury][SQLServer JDBC Driver]Login has timed out.;
Stack Trace:
java.sql.SQLException: [Mercury][SQLServer JDBC Driver]Login has timed out.
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.base.BaseConnectionStartup.<init>(Unknown Source)
at com.mercury.jdbc.base.BaseConnection$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at com.mercury.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.open(Unknown Source)
at com.mercury.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:74)
wrapped in com.mercury.optane.core.CTdException:
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:665)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:491)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:316)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:299)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:264)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:135)
wrapped in com.mercury.optane.core.CTdException: Failed to fill table struct for table null in database qcsiteadmin_db@jdbc:mercury:sqlserver://192.168.1.156:1433(td)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:157)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:77)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.createDirectoryItem(CAbsTablesStructDirectory.java:129)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:81)
wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '[qcsiteadmin_db@jdbc:mercury:sqlserver://192.168.1.156:1433(td)]' in SA Global Struct Dir
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:87)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:101)
at com.mercury.td.saserver.sautil.CSaDbSchemaProperties.getDatabaseFieldsInfo(CSaDbSchemaProperties.java:114)
at com.mercury.optane.core.db.CAbsDBContext.isComparisonCaseSensitive(CAbsDBContext.java:178)
at com.mercury.optane.core.db.utils.CDbGeneralFunctions.dbLowerComparison(CDbGeneralFunctions.java:381)
at com.mercury.td.saserver.sautil.CSaServerGeneralFunctions.saDbLowerComparison(CSaServerGeneralFunctions.java:424)
at com.mercury.td.saserver.api.logics.CTdUserLogic.authenticateUserAgainstTdDB(CTdUserLogic.java:1053)
wrapped in com.mercury.optane.core.CTdException: Failed to check authentication of user 'admin'
at com.mercury.td.saserver.api.logics.CTdUserLogic.authenticateUserAgainstTdDB(CTdUserLogic.java:1077)
at com.mercury.td.saserver.api.logics.CTdUserLogic.checkUserPassword(CTdUserLogic.java:994)
at com.mercury.td.saserver.api.logics.CSessionLogic.login(CSessionLogic.java:188)
at com.mercury.td.saserver.web.CTdSiteAdminServlet.redirectLogin(CTdSiteAdminServlet.java:275)
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:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
wrapped in com.mercury.optane.core.CTdException: Failed to Login
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)作者: zte_boy 时间: 2009-2-10 08:58
地址直接用机器名字访问，不要用ip地址作者: wyalgl 时间: 2009-2-10 09:09
从报错信息看好像是数据库连接方面的错误，可是在哪里修改啊？谢谢！！！作者: bluesky115 时间: 2009-2-10 17:03
这问题我也遇到过，当时连接的是oracle数据库，重新配置下监听器就好了作者: dpdpdp 时间: 2009-3-4 15:20
APPSERVERS表中 TD_IP_ADDRESS字段
DBSERVERS表中 DBSERVER_NAME字段
DB_CNNSTR_FORMAT字段
最后一个是数据库联接字符串把中间的ip或者机器名换成新的ip作者: peterz 时间: 2009-3-4 21:08
可以修改ETC文件。使用域名解析。不要用IP作者: bill_hen 时间: 2009-3-4 23:59
错误是很显然的， Failed to fill table struct for table null in database qcsiteadmin_db@jdbc:mercury:sqlserver://192.168.1.156:1433(td);
QC 还在连接：192.168.1.156
你没有改或没改对。还有，重新启动了吗？