mysql cas_CAS SSO一直無法連線到MYSQL

我這兩天在試CAS SSO,可是在作MYSQL連結時

一啟動TOMCAT後就會出現錯誤

https://localhost:8443 /cas/login登入畫面也無法進入

我的語法有錯誤嗎?如果有前輩知道原因請幫忙一下,謝謝

CAS版本cas- server-3.4.2

MYSQL,資料庫:TEST,表格是app_user

deployerConfigContext.xml 如下

1.

2.

3.

4.

5.

6.

7.

8.

9.

10. com.mysql.jdbc.Driver

11. jdbc:mysql://localhost:3306/test

12. userID

13. password

14.

1)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav

a:1041)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j

ava:964)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502

)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java

:321)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl

eSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443

)

at org.apache.catalina.core.StandardService.start(StandardService.java:5

19)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710

)

at org.apache.catalina.startup.Catalina.start(Catalina.java:581)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:592)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati

ng bean with name 'authenticationManager' defined in ServletContext resource [/W

EB-INF/deployerConfigContext.xml]: Cannot create inner bean 'org.jasig.cas.adapt

ors.jdbc.QueryDatabaseAuthenticationHandler#922804' of type [org.jasig.cas.adapt

ors.jdbc.QueryDatabaseAuthenticationHandler] while setting bean property 'authen

ticationHandlers' with key [0]; nested exception is org.springframework.beans.fa

ctory.BeanCreationException: Error creating bean with name 'org.jasig.cas.adapto

rs.jdbc.QueryDatabaseAuthenticationHandler#922804' defined in ServletContext res

ource [/WEB-INF/deployerConfigContext.xml]: Cannot resolve reference to bean 'da

taSource' while setting bean property 'dataSource'; nested exception is org.spri

ngframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'dataSour

ce' is defined

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveInnerBean(BeanDefinitionValueResolver.java:281)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:120)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveManagedList(BeanDefinitionValueResolver.java:355)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:153)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:450)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:290)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:287)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:189)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:322)

... 42 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati

ng bean with name 'org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandle

r#922804' defined in ServletContext resource [/WEB-INF/deployerConfigContext.xml

]: Cannot resolve reference to bean 'dataSource' while setting bean property 'da

taSource'; nested exception is org.springframework.beans.factory.NoSuchBeanDefin

itionException: No bean named 'dataSource' is defined

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:450)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveInnerBean(BeanDefinitionValueResolver.java:270)

... 54 more

Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No b

ean named 'dataSource' is defined

at org.springframework.beans.factory.support.DefaultListableBeanFactory.

getBeanDefinition(DefaultListableBeanFactory.java:509)

at org.springframework.beans.factory.support.AbstractBeanFactory.getMerg

edLocalBeanDefinition(AbstractBeanFactory.java:1041)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:273)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:189)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:322)

... 60 more

SafeContextLoaderListener:

The Spring ContextLoaderListener we wrap threw on contextInitialized.

But for our having caught this error, the web application context would not have

initialized.

org.springframework.beans.factory.BeanCreationException: Error creating bean wit

h name 'centralAuthenticationService' defined in ServletContext resource [/WEB-I

NF/spring-configuration/applicationContext.xml]: Cannot resolve reference to bea

n 'authenticationManager' while setting bean property 'authenticationManager'; n

ested exception is org.springframework.beans.factory.BeanCreationException: Erro

r creating bean with name 'authenticationManager' defined in ServletContext reso

urce [/WEB-INF/deployerConfigContext.xml]: Cannot create inner bean 'org.jasig.c

as.adaptors.jdbc.QueryDatabaseAuthenticationHandler#922804' of type [org.jasig.c

as.adaptors.jdbc.QueryDatabaseAuthenticationHandler] while setting bean property

'authenticationHandlers' with key [0]; nested exception is org.springframework.

beans.factory.BeanCreationException: Error creating bean with name 'org.jasig.ca

s.adaptors.jdbc.QueryDatabaseAuthenticationHandler#922804' defined in ServletCon

text resource [/WEB-INF/deployerConfigContext.xml]: Cannot resolve reference to

bean 'dataSource' while setting bean property 'dataSource'; nested exception is

org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named '

dataSource' is defined

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:450)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:290)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:287)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:189)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.

preInstantiateSingletons(DefaultListableBeanFactory.java:562)

at org.springframework.context.support.AbstractApplicationContext.finish

BeanFactoryInitialization(AbstractApplicationContext.java:871)

at org.springframework.context.support.AbstractApplicationContext.refres

h(AbstractApplicationContext.java:423)

at org.springframework.web.context.ContextLoader.createWebApplicationCon

text(ContextLoader.java:272)

at org.springframework.web.context.ContextLoader.initWebApplicationConte

xt(ContextLoader.java:196)

at org.springframework.web.context.ContextLoaderListener.contextInitiali

zed(ContextLoaderListener.java:47)

at org.jasig.cas.web.init.SafeContextLoaderListener.contextInitialized_a

roundBody0(SafeContextLoaderListener.java:62)

at org.jasig.cas.web.init.SafeContextLoaderListener.contextInitialized_a

roundBody1$advice(SafeContextLoaderListener.java:44)

at org.jasig.cas.web.init.SafeContextLoaderListener.contextInitialized(S

afeContextLoaderListener.java:1)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContex

t.java:3972)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4

467)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase

.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77

1)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav

a:1041)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j

ava:964)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502

)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java

:321)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl

eSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443

)

at org.apache.catalina.core.StandardService.start(StandardService.java:5

19)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710

)

at org.apache.catalina.startup.Catalina.start(Catalina.java:581)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:592)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati

ng bean with name 'authenticationManager' defined in ServletContext resource [/W

EB-INF/deployerConfigContext.xml]: Cannot create inner bean 'org.jasig.cas.adapt

ors.jdbc.QueryDatabaseAuthenticationHandler#922804' of type [org.jasig.cas.adapt

ors.jdbc.QueryDatabaseAuthenticationHandler] while setting bean property 'authen

ticationHandlers' with key [0]; nested exception is org.springframework.beans.fa

ctory.BeanCreationException: Error creating bean with name 'org.jasig.cas.adapto

rs.jdbc.QueryDatabaseAuthenticationHandler#922804' defined in ServletContext res

ource [/WEB-INF/deployerConfigContext.xml]: Cannot resolve reference to bean 'da

taSource' while setting bean property 'dataSource'; nested exception is org.spri

ngframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'dataSour

ce' is defined

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveInnerBean(BeanDefinitionValueResolver.java:281)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:120)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveManagedList(BeanDefinitionValueResolver.java:355)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:153)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:450)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb

ject(AbstractBeanFactory.java:290)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr

y.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:287)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:189)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:322)

... 42 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creati

ng bean with name 'org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandle

r#922804' defined in ServletContext resource [/WEB-INF/deployerConfigContext.xml

]: Cannot resolve reference to bean 'dataSource' while setting bean property 'da

taSource'; nested exception is org.springframework.beans.factory.NoSuchBeanDefin

itionException: No bean named 'dataSource' is defined

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:328)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)

at org.springframework.beans.factory.support.AbstractAutowireCapableBean

Factory.createBean(AbstractAutowireCapableBeanFactory.java:450)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveInnerBean(BeanDefinitionValueResolver.java:270)

... 54 more

Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No b

ean named 'dataSource' is defined

at org.springframework.beans.factory.support.DefaultListableBeanFactory.

getBeanDefinition(DefaultListableBeanFactory.java:509)

at org.springframework.beans.factory.support.AbstractBeanFactory.getMerg

edLocalBeanDefinition(AbstractBeanFactory.java:1041)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe

an(AbstractBeanFactory.java:273)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean

(AbstractBeanFactory.java:189)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver

.resolveReference(BeanDefinitionValueResolver.java:322)

... 60 more

2010/7/13 上午 10:06:19 org.apache.catalina.core.StandardContext start

嚴重的: Error filterStart

2010/7/13 上午 10:06:19 org.apache.catalina.core.StandardContext start

嚴重的: Context [/cas] startup failed due to previous errors

2010/7/13 上午 10:06:19 org.apache.catalina.startup.HostConfig deployDirectory

資訊: Deploying web application directory docs

2010/7/13 上午 10:06:19 org.apache.catalina.startup.HostConfig deployDirectory

資訊: Deploying web application directory examples

2010/7/13 上午 10:06:19 org.apache.catalina.startup.HostConfig deployDirectory

資訊: Deploying web application directory ROOT

2010/7/13 上午 10:06:19 org.apache.coyote.http11.Http11Protocol start

資訊: Starting Coyote HTTP/1.1 on http-8080

2010/7/13 上午 10:06:19 org.apache.coyote.http11.Http11Protocol start

資訊: Starting Coyote HTTP/1.1 on http-8443

2010/7/13 上午 10:06:19 org.apache.jk.common.ChannelSocket init

資訊: JK: ajp13 listening on /0.0.0.0:8009

2010/7/13 上午 10:06:19 org.apache.jk.server.JkMain start

資訊: Jk running ID=0 time=0/46 config=null

2010/7/13 上午 10:06:19 org.apache.catalina.startup.Catalina start

資訊: Server startup in 3250 ms

问题补充:

haoxun 写道

下面给你贴出正确的配置:

感謝幫忙,我再試試

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值