Hello, If I'm not mistaken, the correct SQL statement should be :
select password from tableuser where user_id = ? ? does not need to be wrapped with ' Rgds. Le 12/01/2012 10:18, sumeetpingale a écrit :
Hello Sir,
I want to connect MySQL to CAS server 3.4.11
I am using Tomcat 5.5, but i am not able to connect
The sql statement provided in the deployerConfigContext.xml may be wrong
Here is the SQL statement
<bean
class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler">
<property name="dataSource" ref="dataSource" />
<property name="sql" value="select password from tableuser where
user_id = '?' " />
</bean>
</list>
</property>
</bean>
and here is the cas.log
012-01-11 16:33:54,986 INFO
[org.jasig.cas.services.DefaultServicesManagerImpl] - Loaded 4 services.
2012-01-11 16:33:56,368 INFO
[org.jasig.cas.util.AutowiringSchedulerFactoryBean] - Starting Quartz
Scheduler now
2012-01-11 16:34:00,758 INFO
[org.jasig.cas.services.DefaultServicesManagerImpl] - Loaded 4 services.
2012-01-11 16:34:02,044 INFO
[org.jasig.cas.util.AutowiringSchedulerFactoryBean] - Starting Quartz
Scheduler now
2012-01-11 16:34:04,633 INFO [org.jasig.cas.web.flow.InitialFlowSetupAction]
- Setting path for cookies to: /cas/
2012-01-11 16:34:04,633 INFO [org.jasig.cas.web.flow.InitialFlowSetupAction]
- Setting path for cookies to: /cas/
2012-01-11 16:34:11,538 INFO
[com.github.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - Audit
trail record BEGIN
=============================================================
WHO: [username: sumeetp]
WHAT: supplied credentials: [username: sumeetp]
ACTION: AUTHENTICATION_FAILED
APPLICATION: CAS
WHEN: Wed Jan 11 16:34:11 IST 2012
CLIENT IP ADDRESS: 0:0:0:0:0:0:0:1
SERVER IP ADDRESS: 0.0.0.0
=============================================================
2012-01-11 16:34:11,539 INFO
[com.github.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - Audit
trail record BEGIN
=============================================================
WHO: [username: sumeetp]
WHAT: SQL must not be null
ACTION: TICKET_GRANTING_TICKET_NOT_CREATED
APPLICATION: CAS
WHEN: Wed Jan 11 16:34:11 IST 2012
CLIENT IP ADDRESS: 0:0:0:0:0:0:0:1
SERVER IP ADDRESS: 0.0.0.0
=============================================================
2012-01-11 16:34:14,686 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
Beginning ticket cleanup.
2012-01-11 16:34:14,686 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] - 0
tickets found to be removed.
2012-01-11 16:34:14,686 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
Finished ticket cleanup.
2012-01-11 16:34:20,312 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
Beginning ticket cleanup.
2012-01-11 16:34:20,314 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] - 0
tickets found to be removed.
2012-01-11 16:34:20,314 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
Finished ticket cleanup.
2012-01-11 16:35:49,825 INFO
[org.jasig.cas.util.AutowiringSchedulerFactoryBean] - Shutting down Quartz
Scheduler
2012-01-11 16:35:50,237 INFO
[org.jasig.cas.util.AutowiringSchedulerFactoryBean] - Shutting down Quartz
Scheduler
Please suggest some example
--
View this message in context:
http://jasig.275507.n4.nabble.com/CAS-to-MySQL-connection-tp4288338p4288338.html
Sent from the CAS Users mailing list archive at Nabble.com.
-- Philippe MARASSE Service Informatique - Centre Hospitalier Henri Laborit BP 587 - 370 avenue Jacques Coeur 86021 Poitiers Cedex Tel : 05.49.44.57.19
smime.p7s
Description: Signature cryptographique S/MIME
