yes. any ideas on why it is ignoring my files and what I could do to make it not ignore my files?
On Tuesday, July 18, 2017 at 3:45:53 PM UTC-5, Misagh Moayyed wrote: > > Sounds like it’s ignoring your config location and loading the registry > from “default” JSON services that ship with CAS. > > > > --Misagh > > > > *From:* [email protected] <javascript:> [mailto:[email protected] > <javascript:>] *On Behalf Of *Toby Archer > *Sent:* Tuesday, July 18, 2017 1:40 PM > *To:* CAS Community <[email protected] <javascript:>> > *Subject:* [cas-user] Re: getting service registry to load into jpa > database > > > > So I figured out that I had two Service Registry's setup. I disabled the > Json registry and JPA took over. But I still am not getting it to init from > JSON. Any clues to that one? It seems to be doing something like that, > since there are 2 services placed in the database as soon as it spins up. > So it's loading from somewhere, but despite setting the path to the json > files. So I guess at this point my question is: I have it initializing from > Json, how can I get it to initialize from *my* Json? > > On Friday, July 14, 2017 at 9:05:14 AM UTC-5, Toby Archer wrote: > > 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] <javascript:>. > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/33cbd9ee-3a7e-46b1-a304-e277f08497cf%40apereo.org > > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/33cbd9ee-3a7e-46b1-a304-e277f08497cf%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - 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/a69838c7-6ee1-4765-aabf-847e02781ec7%40apereo.org.
