I was trying to make Service registry work with mysql (or mariadb). I am using CAS version 5.2.1.
I had 2 problems : *Problem 1 *: Specified key was too long; max key length is 767 bytes when creating table RegisteredServiceImpl_Props *Solution* : use mysql 5.7 (need to be verified) or mariadb 10.2.2 *Problem 2* : table SamlRegisteredService_AttributeNameFormats is using a reserved keyword as column name : key. *Solution* : use this configuration to tell hibernate to quote identifiers cas.serviceRegistry.jpa.properties.hibernate.globally_quoted_identifiers= true I think the two solutions need to appear in documentation but don't know exactly where. Maybee in Installation > JPA Service Registry or in Installation > Service Management ? -- - 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/9585088b-8494-41e4-81a1-9d2da37b47cf%40apereo.org.
