ServiceRegistry storage in a database (Postgresql) CAS 5.2

[BERNABÉ ARAGÓN]

I want storage Services in a database, I have this configuration based in https://apereo.github.io/cas/5.2.x/installation/Configuration-Properties.html#database-service-registry
but it doesnt work... it generate the tables but there are no data , how can I solve this? 

 # 

  cas.serviceRegistry.jpa.healthQuery=

 cas.serviceRegistry.jpa.isolateInternalQueries=false

 cas.serviceRegistry.jpa.url=jdbc:postgresql://172.17.103.25:5445/AhTestCentral

 cas.serviceRegistry.jpa.failFastTimeout=1

 cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.PostgreSQL94Dialect

 cas.serviceRegistry.jpa.leakThreshold=10

 cas.serviceRegistry.jpa.batchSize=1

 cas.serviceRegistry.jpa.user=utest2017

 cas.serviceRegistry.jpa.ddlAuto=update

 cas.serviceRegistry.jpa.password=2017utest@@

 cas.serviceRegistry.jpa.autocommit=false

 cas.serviceRegistry.jpa.driverClass=org.postgresql.Driver

 cas.serviceRegistry.jpa.idleTimeout=5000

 cas.serviceRegistry.jpa.dataSourceName=

 cas.serviceRegistry.jpa.dataSourceProxy=false

 Hibernate-specific properties (i.e. `hibernate.globally_quoted_identifiers`)

 cas.serviceRegistry.jpa.properties.propertyName=propertyValue

 cas.serviceRegistry.jpa.pool.suspension=false

 cas.serviceRegistry.jpa.pool.minSize=6

 cas.serviceRegistry.jpa.pool.maxSize=18

 cas.serviceRegistry.jpa.pool.maxWait=2000

PD: this tables are generated

[geoffroy desvernay]

I think you miss something like:

#cas.serviceRegistry.initFromJson=TRUE
#cas.serviceRegistry.json.location=file:/etc/cas/config/services

and (at least) one .json file there allowing the management webapp or
whetever you need.

There is one in
./target/cas/WEB-INF/classes/services/HTTPSandIMAPS-10000001.json if you
user maven overlay

Hope this helps…

--
*geoffroy desvernay*
Administration systèmes et réseaux / sécurité
Ecole Centrale de Marseille

[BERNABÉ ARAGÓN]

I added those data in this table(regexregisteredservice) and deleted all the services (.json files ) of CAS. I want this data ( JavaClient-10000025.json) in a database ..can you help me with this?