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 cas-user+unsubscr...@apereo.org. 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.
