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.
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
