thanks I got it, On Wed, Jan 17, 2018 at 11:46 PM, Toby Archer <[email protected]> wrote:
> I did, but it's been so long ago and I didn't keep notes of what I did > since it was before I was working in a git repo. But what I can tell you is > what's different between my cas.properties file above and now. There > honestly isn't a lot of difference, but there are two things I do see: > > cas.serviceRegistry.jpa.ddlAuto=update > cas.serviceRegistry.jpa.driverClass=com.microsoft. > sqlserver.jdbc.SQLServerDriver > > The first is ddlauto is now update instead of create-drop. And I specified > the SQL driver specifically. My gut says that my problem was probably > stemming from having a wrong SQL driver. Working with MS SQL can be quite > bother some. Give those things a try and if not I'll see what else I can > suggest. > > > > On Tuesday, January 16, 2018 at 9:23:49 PM UTC-6, casuser wrote: >> >> Hi Toby I am also having the same problem, zero services are loaded from >> the jpa service registry. Did you able to solve it? >> >> On Wednesday, July 19, 2017 at 9:13:40 PM UTC+8, Toby Archer wrote: >>> >>> 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] [mailto:[email protected]] *On Behalf Of *Toby >>>> Archer >>>> *Sent:* Tuesday, July 18, 2017 1:40 PM >>>> *To:* CAS Community <[email protected]> >>>> *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/M >>>> ailing-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/ap >>>> ereo.org/d/msgid/cas-user/33cbd9ee-3a7e-46b1-a304-e277f08497 >>>> cf%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> >>>> . >>>> >>> -- > - 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 [email protected]. > To view this discussion on the web visit https://groups.google.com/a/ > apereo.org/d/msgid/cas-user/d3cb5046-e6d6-425e-a682- > 804b7a751a4f%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/d3cb5046-e6d6-425e-a682-804b7a751a4f%40apereo.org?utm_medium=email&utm_source=footer> > . > -- -Fazla. -- - 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 [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAG9J-Y2YC2DTjZOt5RtSsN0cdnnEKFONrhtZUJ3CQ8%3DVbrv6iA%40mail.gmail.com.
