SSH+Proxool+MySql:ProxoolConfig.xml配置无效,错误以本地地址为数据库地址

calvnxu0218 发布于 2015/09/01 13:35
阅读 473
收藏 0

ProxoolConfig.xml中配置的地址是:com.mysql.jdbc.Driver:jdbc:mysql://10.88.34.89:3306/tkweb?useUnicode=true&characterEncoding=UTF8
错误是:java.sql.SQLException: Access denied for user 'root'@'10.88.34.32' (using password: YES)
访问的地址根本不是proxoolconfig.xml中配置的地址,这是为什么?


[framework] 2015-08-31 19:43:26,922 - org.hibernate.connection.ProxoolConnectionProvider -2386 [main] INFO  org.hibernate.connection.ProxoolConnectionProvider  - Configuring Proxool Provider using JAXPConfigurator: ProxoolConf.xml
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.JAXPConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.JAXPConfigurator  - Configuring from reader: java.io.InputStreamReader@ec8784
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.JAXPConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.JAXPConfigurator  - SAXParserFactory class: com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.JAXPConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.JAXPConfigurator  - sax parser classcom.sun.org.apache.xerces.internal.jaxp.SAXParserImpl
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.JAXPConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.JAXPConfigurator  - XML reader class: com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.JAXPConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.JAXPConfigurator  - Setting sax feature: 'http://xml.org/sax/features/namespaces'. State: true.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.JAXPConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.JAXPConfigurator  - Setting sax feature: 'http://xml.org/sax/features/namespace-prefixes'. State: false.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Adding driver property: user=root
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Adding driver property: password=*******
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Setting property 'proxool.house-keeping-sleep-time' to value '90000'.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Setting property 'proxool.proxool.simultaneous-build-throttle' to value '20'.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Setting property 'proxool.prototype-count' to value '5'.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Setting property 'proxool.maximum-connection-count' to value '100'.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Setting property 'proxool.minimum-connection-count' to value '10'.
  [framework] 2015-08-31 19:43:26,922 - org.logicalcobwebs.proxool.configuration.XMLConfigurator -2386 [main] DEBUG org.logicalcobwebs.proxool.configuration.XMLConfigurator  - Created url: proxool.pool:com.mysql.jdbc.Driver:jdbc:mysql://10.88.34.89:3306/tkweb?useUnicode=true&characterEncoding=UTF8
  [framework] 2015-08-31 19:43:26,938 - org.logicalcobwebs.proxool.ProxoolFacade -2402 [main] INFO  org.logicalcobwebs.proxool.ProxoolFacade  - Proxool 0.9.1 (23-Aug-2008 11:10)
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Recognised proxool property: proxool.driver=com.mysql.jdbc.Driver
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Recognised proxool property: proxool.url=jdbc:mysql://10.88.34.89:3306/tkweb?useUnicode=true&characterEncoding=UTF8
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Delegating property to driver: user=root
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Delegating property to driver: password=********
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Recognised proxool property: proxool.maximum-connection-count=100
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Recognised proxool property: proxool.minimum-connection-count=10
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Recognised proxool property: proxool.house-keeping-sleep-time=90000
  [framework] 2015-08-31 19:43:26,954 - org.logicalcobwebs.proxool.pool -2418 [main] DEBUG org.logicalcobwebs.proxool.pool  - Recognised proxool property: proxool.prototype-count=5
  [framework] 2015-08-31 19:43:26,985 - org.logicalcobwebs.proxool.ShutdownHook -2449 [main] DEBUG org.logicalcobwebs.proxool.ShutdownHook  - Registered shutdownHook
  [framework] 2015-08-31 19:43:26,985 - org.logicalcobwebs.proxool.HouseKeeperController -2449 [main] DEBUG org.logicalcobwebs.proxool.HouseKeeperController  - Registering 'pool' house keeper
  [framework] 2015-08-31 19:43:26,985 - org.logicalcobwebs.proxool.HouseKeeperController -2449 [main] DEBUG org.logicalcobwebs.proxool.HouseKeeperController  - Starting a house keeper thread
  [framework] 2015-08-31 19:43:26,985 - org.hibernate.connection.ProxoolConnectionProvider -2449 [main] INFO  org.hibernate.connection.ProxoolConnectionProvider  - Configuring Proxool Provider to use pool alias: proxool.pool
  [framework] 2015-08-31 19:43:26,985 - org.hibernate.connection.ProxoolConnectionProvider -2449 [main] INFO  org.hibernate.connection.ProxoolConnectionProvider  - autocommit mode: false
  [framework] 2015-08-31 19:43:27,250 - org.hibernate.cfg.SettingsFactory -2714 [main] WARN  org.hibernate.cfg.SettingsFactory  - Could not obtain connection metadata
  java.sql.SQLException: Access denied for user 'root'@'10.88.34.32' (using password: YES)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
 at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
 at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
 at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
 at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
 at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:211)
 at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:207)
 at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
 at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
 at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
 at java.security.AccessController.doPrivileged(Native Method)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
 at java.security.AccessController.doPrivileged(Native Method)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
 at java.security.AccessController.doPrivileged(Native Method)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
 at java.security.AccessController.doPrivileged(Native Method)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
 at java.security.AccessController.doPrivileged(Native Method)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
 at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
 at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
 at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
 at org.apache.catalina.core.StandardService.start(StandardService.java:525)
 at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
 at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
 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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

加载中
返回顶部
顶部