Bumping this old thread because I'm encountering the same problem. As
mentioned by Marc, the solution is to manually create the tables using the
MySQL command line:
create table locks (
application_id varchar(255) not null,
expiration_date datetime,
unique_id varchar(255),
lock_Ver integer DEFAULT 0 not null,
primary key (application_id)
) engine=MyISAM;
create table Cas_Tickets (
id longtext not null,
body text,
creation_Time datetime not null,
parent_Id longtext,
principal_Id longtext,
type longtext not null,
primary key (id(200))
) engine=MyISAM;
Does the CAS project have an issue tracker? If so, I'd be happy to open an
issue relating to this.
On Friday, September 25, 2020 at 8:50:26 AM UTC-7 Marc Maurice wrote:
> Hello all,
>
> I found what may be a bug (in a library).
>
> After configuring jdbc audit and starting cas for the first time, I got
> the following error (see full exception below).
>
> Caused by: java.sql.SQLSyntaxErrorException: You have an error in your
> SQL syntax; check the manual that corresponds to your MariaDB server
> version for the right syntax to use near 'type=MyISAM' at line 11
>
> engine=MyISAM should be used instead.
>
>
> The workaround is easy : just run the SQL manually, replacing type= with
> engine= .
>
>
> Let me know if you have any advice on how to report that. It's not very
> clear to me how to report issues on CAS.
>
> Anyway, the workaround will be in mailing list archive.
>
>
> Marc
>
>
>
>
> 2020-09-25 15:22:17,380 WARN
> [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] -
> <GenerationTarget encountered exception accepting command : Error
> executing DDL "
> create table COM_AUDIT_TRAIL (
> id bigint not null auto_increment,
> AUD_ACTION longtext,
> APPLIC_CD varchar(255),
> AUD_CLIENT_IP varchar(255),
> AUD_DATE datetime not null,
> AUD_RESOURCE longtext,
> AUD_SERVER_IP varchar(255),
> AUD_USER longtext,
> primary key (id)
> ) type=MyISAM" via JDBC Statement>
> org.hibernate.tool.schema.spi.CommandAcceptanceException: Error
> executing DDL "
> create table COM_AUDIT_TRAIL (
> id bigint not null auto_increment,
> AUD_ACTION longtext,
> APPLIC_CD varchar(255),
> AUD_CLIENT_IP varchar(255),
> AUD_DATE datetime not null,
> AUD_RESOURCE longtext,
> AUD_SERVER_IP varchar(255),
> AUD_USER longtext,
> primary key (id)
> ) type=MyISAM" via JDBC Statement
> at
> org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:316)
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:469)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1249)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> at
> org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
>
>
> ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
>
>
> ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:391)
>
>
> ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:378)
>
>
> ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
>
>
> ~[spring-orm-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
>
>
> ~[spring-beans-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1108)
>
>
> ~[spring-context-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868)
>
>
> ~[spring-context-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
>
>
> ~[spring-context-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
> at
> org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
>
>
> ~[spring-boot-2.2.8.RELEASE.jar!/:2.2.8.RELEASE]
> at
> org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
>
>
> ~[spring-boot-2.2.8.RELEASE.jar!/:2.2.8.RELEASE]
> at
> org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
>
>
> ~[spring-boot-2.2.8.RELEASE.jar!/:2.2.8.RELEASE]
> at
> org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
> ~[spring-boot-2.2.8.RELEASE.jar!/:2.2.8.RELEASE]
> at
> org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:140)
>
>
> ~[spring-boot-2.2.8.RELEASE.jar!/:2.2.8.RELEASE]
> at
> org.apereo.cas.web.CasWebApplication.main(CasWebApplication.java:80)
> ~[cas-server-webapp-init-6.2.2.jar!/:6.2.2]
> at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method) ~[?:?]
> at
> jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>
>
> ~[?:?]
> at
> jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
>
> ~[?:?]
> at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
> at
> org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
>
>
> ~[cas.war:?]
> at
> org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
> ~[cas.war:?]
> at
> org.springframework.boot.loader.Launcher.launch(Launcher.java:51)
> ~[cas.war:?]
> at
> org.springframework.boot.loader.WarLauncher.main(WarLauncher.java:58)
> ~[cas.war:?]
> Caused by: java.sql.SQLSyntaxErrorException: You have an error in your
> SQL syntax; check the manual that corresponds to your MariaDB server
> version for the right syntax to use near 'type=MyISAM' at line 11
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
>
> ~[mysql-connector-java-8.0.20.jar!/:8.0.20]
> at
> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
> ~[mysql-connector-java-8.0.20.jar!/:8.0.20]
> at
> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
>
>
> ~[mysql-connector-java-8.0.20.jar!/:8.0.20]
> at
> com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
> ~[mysql-connector-java-8.0.20.jar!/:8.0.20]
> at
> com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
> ~[mysql-connector-java-8.0.20.jar!/:8.0.20]
> at
> com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
> ~[HikariCP-3.4.5.jar!/:?]
> at
> com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
>
>
> ~[HikariCP-3.4.5.jar!/:?]
> at
> org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
>
>
> ~[hibernate-core-5.4.16.Final.jar!/:5.4.16.Final]
> ... 41 more
>
>
--
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
---
You received this message because you are subscribed to the Google Groups "CAS
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/dec5cef3-4102-47ff-b06a-4c8966122619n%40apereo.org.
