>sigh< Still getting the error the first time the registry cleaner runs:
locks table doesn't exist.
I'm using MySQL server version 5.1.34-community, and my connector is
mysql-connector-java-5.1.6.
The host.name and the database platform are defined in cas.properties:
host.name=cas (this is the default - I left it)
ticket.cleaner.database.platform=SQL92
Here's the console log:
[...]
INFO: Deploying web application archive cas.war
Hibernate: select registered0_.id as id0_, registered0_.allowedToProxy as
allowedT2_0_, registered0_.anonymousAccess as
anonymou3_0_, registered0_.description as descript4_0_, registered0_.enabled
as enabled0_, registered0_.evaluation_order
as evaluation6_0_, registered0_.ignoreAttributes as ignoreAt7_0_,
registered0_.name as name0_, registered0_.serviceId a
s serviceId0_, registered0_.ssoEnabled as ssoEnabled0_, registered0_.theme
as theme0_ from RegisteredServiceImpl registe
red0_
2010-09-01 13:59:33,779 INFO
[org.jasig.cas.services.DefaultServicesManagerImpl] - <Loaded 0 services.>
2010-09-01 13:59:34,061 DEBUG
[org.jasig.cas.util.AutowiringSchedulerFactoryBean] - <Autowired the
following triggers defined in application context:
[periodicTicketRegistryCleanerTrigger,
periodicServiceRegistryReloaderTrigger]>
2010-09-01 13:59:34,405 INFO
[org.jasig.cas.util.AutowiringSchedulerFactoryBean] - <Starting Quartz
Scheduler now>
2010-09-01 13:59:34,546 DEBUG
[org.jasig.cas.services.web.ManageRegisteredServicesMultiActionController] -
<Found action method [public org.springframework.web.servlet.ModelAndView
org.jasig.cas.services.web.ManageRegisteredServicesMultiAct
ionController.deleteRegisteredService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)]>
2010-09-01 13:59:34,546 DEBUG
[org.jasig.cas.services.web.ManageRegisteredServicesMultiActionController] -
<Found action method [public org.springframework.web.servlet.ModelAndView
org.jasig.cas.services.web.ManageRegisteredServicesMultiActionController.manage(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)]>
Sep 1, 2010 1:59:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory docs
Sep 1, 2010 1:59:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory examples
Sep 1, 2010 1:59:35 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory ROOT
Sep 1, 2010 1:59:35 PM org.apache.coyote.http11.Http11AprProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 1, 2010 1:59:35 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8443
Sep 1, 2010 1:59:35 PM org.apache.coyote.ajp.AjpAprProtocol start
INFO: Starting Coyote AJP/1.3 on ajp-8009
Sep 1, 2010 1:59:35 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 5833 ms
2010-09-01 13:59:53,578 INFO
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
<Beginning ticket cleanup.>
2010-09-01 13:59:53,578 DEBUG
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] -
<Attempting to acquire ticket cleanup lock.>
2010-09-01 13:59:53,843 ERROR [org.quartz.core.JobRunShell] - <Job
DEFAULT.ticketRegistryCleanerJobDetail threw an unhandled Exception: >
org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
Invocation of method 'clean' on target class [
class org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner]
failed; nested exception is org.springframewor
k.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar
[SELECT UNIQUE_ID, EXPIRATION_DATE FROM LOCKS
WHERE APPLICATION_ID=? FOR UPDATE];
nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'cas_sso.locks' doesn't exist
at
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:273)
at
org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT UNIQUE_ID,
EXPIRATION_DATE FROM LOCKS WHERE APPLICATION_ID=? FOR UPDATE]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'cas_sso.locks' doesn't exist
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
at
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.acquire_aroundBody2(JdbcLockingStrategy.java:282)
at
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.acquire_aroundBody3$advice(JdbcLockingStrategy.java:44)
at
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.acquire(JdbcLockingStrategy.java:1)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy23.acquire(Unknown Source)
at
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner.clean_aroundBody0(DefaultTicketRegistryCleaner.java:71)
at
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner.clean_aroundBody1$advice(DefaultTicketRegistryCleaner.java:44)
at
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner.clean(DefaultTicketRegistryCleaner.java:1)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'cas_sso.locks' doesn't exist
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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 29 more
2010-09-01 13:59:53,843 ERROR [org.quartz.core.ErrorLogger] - <Job
(DEFAULT.ticketRegistryCleanerJobDetail threw an exception.>
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested
exception:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
Invocation of method 'clean' on target class [class
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] failed;
nested exception is org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT UNIQUE_ID,
EXPIRATION_DATE FROM LOCKS WHERE APPLICATION_ID=? FOR UPDATE]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'cas_sso.locks' doesn't exist]
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
Invocation of method 'clean' on target class [class
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] failed;
nested exception is org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT UNIQUE_ID,
EXPIRATION_DATE FROM LOCKS WHERE APPLICATION_ID=? FOR UPDATE]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'cas_sso.locks' doesn't exist
at
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:273)
at
org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
... 1 more
Caused by: org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT UNIQUE_ID,
EXPIRATION_DATE FROM LOCKS WHERE APPLICATION_ID=? FOR UPDATE]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'cas_sso.locks' doesn't exist
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
at
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.acquire_aroundBody2(JdbcLockingStrategy.java:282)
at
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.acquire_aroundBody3$advice(JdbcLockingStrategy.java:44)
at
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.acquire(JdbcLockingStrategy.java:1)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy23.acquire(Unknown Source)
at
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner.clean_aroundBody0(DefaultTicketRegistryCleaner.java:71)
at
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner.clean_aroundBody1$advice(DefaultTicketRegistryCleaner.java:44)
at
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner.clean(DefaultTicketRegistryCleaner.java:1)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'cas_sso.locks' doesn't exist
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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 29 more
--
View this message in context:
http://jasig.275507.n4.nabble.com/MySQL-Ticket-Registry-table-not-created-tp2403491p2419826.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
