Making great strides getting cas up and running, but I've bumped into a new challenge with trying to get the service registry into my database. I have the following configuration:
cas.serviceRegistry.watcherEnabled=true > cas.serviceRegistry.repeatInterval=120000 > cas.serviceRegistry.startDelay=15000 > cas.serviceRegistry.initFromJson=true > cas.serviceRegistry.config.location=file:/etc/cas/config/services > > > cas.serviceRegistry.jpa.url=jdbc:sqlserver://dev-sql06.usd.edu;databaseName=CAS5 > cas.serviceRegistry.jpa.user=cas_user > cas.serviceRegistry.jpa.password=super secure password, no peeking! > cas.serviceRegistry.jpa.failFast=true > cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.SQLServerDialect > cas.serviceRegistry.jpa.autocommit=true > cas.serviceRegistry.jpa.ddlAuto=create-drop > As I understand it, this should connect to the database, specifically the database name "CAS5" in our dev sql box, create the necessary tables, and then initialize the data in those tables from the JSON files I have been using to boot strap this into working. This works up to the initializing data. CAS connects to the database just fine and creates the appropriate tables, but that's where it stops. In the logs I see: Hibernate: alter table RegisteredServiceImpl_Props drop constraint > FK1xan7uamsa94y2451jgksjkj4 > Hibernate: alter table RegisteredServiceImpl_Props drop constraint > FK5ghaknoplphay7reury7n3vcm > Hibernate: drop table hibernate_sequence > Hibernate: drop table RegexRegisteredService > Hibernate: drop table RegexRegisteredServiceProperty > Hibernate: drop table RegisteredServiceImpl_Props > Hibernate: create table hibernate_sequence (next_val numeric(19,0)) > Hibernate: insert into hibernate_sequence values ( 1 ) > Hibernate: insert into hibernate_sequence values ( 1 ) > Hibernate: create table RegexRegisteredService (expression_type > VARCHAR(15) DEFAULT 'ant' not null, id numeric(19,0) not null, > access_strategy image, attribute_release image, description varchar(255), > evaluation_order int not null, informationUrl varchar(255), logo > varchar(255), logout_type int, logout_url varchar(255), mfa_policy image, > name varchar(255) not null, privacyUrl varchar(255), proxy_policy image, > public_key image, required_handlers image, serviceId varchar(255) not null, > theme varchar(255), username_attr image, primary key (id)) > Hibernate: create table RegexRegisteredServiceProperty (id numeric(19,0) > not null, property_values image, primary key (id)) > Hibernate: create table RegisteredServiceImpl_Props > (AbstractRegisteredService_id numeric(19,0) not null, properties_id > numeric(19,0) not null, properties_KEY varchar(255) not null, primary key > (AbstractRegisteredService_id, properties_KEY)) > Hibernate: alter table RegisteredServiceImpl_Props add constraint > UK_i2mjaqjwxpvurc6aefjkx5x97 unique (properties_id) > Hibernate: alter table RegisteredServiceImpl_Props add constraint > FK1xan7uamsa94y2451jgksjkj4 foreign key (properties_id) references > RegexRegisteredServiceProperty > Hibernate: alter table RegisteredServiceImpl_Props add constraint > FK5ghaknoplphay7reury7n3vcm foreign key (AbstractRegisteredService_id) > references RegexRegisteredService > Looks good. but then I never see anything more from hibernate. Later I see: 2017-07-14 08:45:36,875 INFO > [org.apereo.cas.services.DefaultServicesManager] - <Loaded [3] service(s) > from [JsonServiceRegistryDao].> > So clearly the json files are being loaded. But why do the services then never get loaded into the database? I feel like I'm missing just one command or property some where, but I'm not sure what. "initFromJson" sound like a pretty darn likely one, but it has failed me. :( Any further advice on what's missing? -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- 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/7c094b8a-92f0-4205-bcec-6552828bc261%40apereo.org.
