JPA Service Registry and MySQL (or Mariadb)

[Matthieu Marc]

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 ?