Hi, How do you get cas-mangement to create tables?
I have an overlay of CAS-management 5.3.3, the following are management.properties, when I start it up, I do not see tables being created, cas-management fails because there is not any table. cas.serviceRegistry.jpa.url=jdbc:oracle:thin:@......... cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.Oracle10gDialect cas.serviceRegistry.jpa.ddlAuto=create cas.serviceRegistry.jpa.driverClass=oracle.jdbc.OracleDriver Yan On Thursday, December 21, 2017 at 2:36:24 PM UTC-5, Man H wrote: > > Hi again David > > I have to complement my previous answer. > > Previous table attributes are create by cas-server, but if you install > cas-management following table is created, which is also read by cas > server. > > > > Regards > > > CREATE TABLE `RegexRegisteredService` ( > `expression_type` varchar(50) NOT NULL DEFAULT 'regex', > `id` bigint(20) NOT NULL AUTO_INCREMENT, > `access_strategy` longblob, > `attribute_release` longblob, > `description` varchar(255) DEFAULT NULL, > `evaluation_order` int(11) NOT NULL, > `expiration_policy` longblob, > `informationUrl` varchar(255) DEFAULT NULL, > `logo` varchar(255) DEFAULT NULL, > `logout_type` int(11) DEFAULT NULL, > `logout_url` varchar(255) DEFAULT NULL, > `mfa_policy` longblob, > `name` varchar(255) NOT NULL, > `privacyUrl` varchar(255) DEFAULT NULL, > `proxy_policy` longblob, > `public_key` longblob, > `required_handlers` longblob, > `serviceId` varchar(255) NOT NULL, > `theme` varchar(255) DEFAULT NULL, > `username_attr` longblob, > `bypassApprovalPrompt` bit(1) DEFAULT NULL, > `clientId` varchar(255) DEFAULT NULL, > `clientSecret` varchar(255) DEFAULT NULL, > `generateRefreshToken` bit(1) DEFAULT NULL, > `jsonFormat` bit(1) DEFAULT NULL, > `supported_grants` longblob, > `supported_responses` longblob, > `DYNAMIC_REG_TIME` datetime DEFAULT NULL, > `dynamicallyRegistered` bit(1) DEFAULT NULL, > `encryptIdToken` bit(1) DEFAULT NULL, > `idTokenEncryptionAlg` varchar(255) DEFAULT NULL, > `idTokenEncryptionEncoding` varchar(255) DEFAULT NULL, > `implicit` bit(1) DEFAULT NULL, > `jwks` varchar(255) DEFAULT NULL, > `scopes` longblob, > `sectorIdentifierUri` varchar(255) DEFAULT NULL, > `signIdToken` bit(1) DEFAULT NULL, > `subjectType` varchar(255) DEFAULT NULL, > `addressingNamespace` varchar(255) DEFAULT NULL, > `appliesTo` varchar(255) DEFAULT NULL, > `namespace` varchar(255) DEFAULT NULL, > `policyNamespace` varchar(255) DEFAULT NULL, > `protocol` varchar(255) DEFAULT NULL, > `realm` varchar(255) DEFAULT NULL, > `tokenType` varchar(255) DEFAULT NULL, > `wsdlEndpoint` varchar(255) DEFAULT NULL, > `wsdlLocation` varchar(255) DEFAULT NULL, > `wsdlService` varchar(255) DEFAULT NULL, > `encryptAssertions` bit(1) DEFAULT NULL, > `metadataCriteriaDirection` varchar(255) DEFAULT NULL, > `metadataCriteriaPattern` varchar(255) DEFAULT NULL, > `metadataCriteriaRemoveEmptyEntitiesDescriptors` bit(1) DEFAULT NULL, > `metadataCriteriaRemoveRolelessEntityDescriptors` bit(1) DEFAULT NULL, > `metadataCriteriaRoles` varchar(255) DEFAULT NULL, > `metadataExpirationDuration` varchar(255) DEFAULT NULL, > `metadataLocation` varchar(255) DEFAULT NULL, > `metadataMaxValidity` bigint(20) DEFAULT NULL, > `metadataSignatureLocation` varchar(255) DEFAULT NULL, > `nameIdQualifier` varchar(255) DEFAULT NULL, > `requiredAuthenticationContextClass` varchar(255) DEFAULT NULL, > `requiredNameIdFormat` varchar(255) DEFAULT NULL, > `serviceProviderNameIdQualifier` varchar(255) DEFAULT NULL, > `signAssertions` bit(1) DEFAULT NULL, > `signResponses` bit(1) DEFAULT NULL, > `signingCredentialType` varchar(255) DEFAULT NULL, > `skipGeneratingAssertionNameId` bit(1) DEFAULT NULL, > `skipGeneratingSubjectConfirmationInResponseTo` bit(1) DEFAULT NULL, > `skipGeneratingSubjectConfirmationNotBefore` bit(1) DEFAULT NULL, > `skipGeneratingSubjectConfirmationNotOnOrAfter` bit(1) DEFAULT NULL, > `skipGeneratingSubjectConfirmationRecipient` bit(1) DEFAULT NULL, > PRIMARY KEY (`id`) > ) > > 2017-12-15 17:45 GMT-03:00 Maxwell, Gary <maxw...@fortlewis.edu > <javascript:>>: > >> Ok I just wanted to make sure. Thanks! >> >> >> >> *From:* cas-...@apereo.org <javascript:> [mailto:cas-...@apereo.org >> <javascript:>] *On Behalf Of *Man H >> *Sent:* Friday, December 15, 2017 9:39 AM >> *To:* cas-...@apereo.org <javascript:> >> *Subject:* Re: [cas-user] 5.1.2 to 5.2 CAS migration >> >> >> >> this is what I have in 5.2.0 >> >> CREATE TABLE `RegexRegisteredService` ( >> `expression_type` varchar(50) NOT NULL DEFAULT 'regex', >> `id` bigint(20) NOT NULL AUTO_INCREMENT, >> `access_strategy` longblob, >> `attribute_release` longblob, >> `description` varchar(255) DEFAULT NULL, >> `evaluation_order` int(11) NOT NULL, >> `expiration_policy` longblob, >> `informationUrl` varchar(255) DEFAULT NULL, >> `logo` varchar(255) DEFAULT NULL, >> `logout_type` int(11) DEFAULT NULL, >> `logout_url` varchar(255) DEFAULT NULL, >> `mfa_policy` longblob, >> `name` varchar(255) NOT NULL, >> `privacyUrl` varchar(255) DEFAULT NULL, >> `proxy_policy` longblob, >> `public_key` longblob, >> `required_handlers` longblob, >> `serviceId` varchar(255) NOT NULL, >> `theme` varchar(255) DEFAULT NULL, >> `username_attr` longblob, >> PRIMARY KEY (`id`) >> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; >> >> >> >> 2017-12-14 20:28 GMT-03:00 Maxwell, Gary <maxw...@fortlewis.edu >> <javascript:>>: >> >> We initialized our database by setting >> “cas.serviceRegistry.jpa.ddlAuto=create” in the CAS 5.2 cas.properties file >> however the following table was created. It appears a lot of columns were >> removed between 5.1.2 and 5.2. Can this be correct? >> >> >> >> CAS 5.2.0 >> >> CREATE TABLE [dbo].[RegexRegisteredService]( >> >> [expression_type] [varchar](50) NOT NULL, >> >> [id] [bigint] IDENTITY(1,1) NOT NULL, >> >> [access_strategy] [varbinary](max) NULL, >> >> [attribute_release] [varbinary](max) NULL, >> >> [description] [varchar](255) NULL, >> >> [evaluation_order] [int] NOT NULL, >> >> [expiration_policy] [varbinary](max) NULL, >> >> [informationUrl] [varchar](255) NULL, >> >> [logo] [varchar](255) NULL, >> >> [logout_type] [int] NULL, >> >> [logout_url] [varchar](255) NULL, >> >> [mfa_policy] [varbinary](max) NULL, >> >> [name] [varchar](255) NOT NULL, >> >> [privacyUrl] [varchar](255) NULL, >> >> [proxy_policy] [varbinary](max) NULL, >> >> [public_key] [varbinary](max) NULL, >> >> [required_handlers] [varbinary](max) NULL, >> >> [serviceId] [varchar](255) NOT NULL, >> >> [theme] [varchar](255) NULL, >> >> [username_attr] [varbinary](max) NULL, >> >> >> >> >> >> CAS 5.1.2 >> >> CREATE TABLE [dbo].[RegexRegisteredService]( >> >> [expression_type] [varchar](15) NOT NULL, >> >> [id] [bigint] NOT NULL, >> >> [access_strategy] [varbinary](max) NULL, >> >> [attribute_release] [varbinary](max) NULL, >> >> [description] [varchar](255) NULL, >> >> [evaluation_order] [int] NOT NULL, >> >> [informationUrl] [varchar](255) NULL, >> >> [logo] [varchar](255) NULL, >> >> [logout_type] [int] NULL, >> >> [logout_url] [varchar](255) NULL, >> >> [mfa_policy] [varbinary](max) NULL, >> >> [name] [varchar](255) NOT NULL, >> >> [privacyUrl] [varchar](255) NULL, >> >> [proxy_policy] [varbinary](max) NULL, >> >> [public_key] [varbinary](max) NULL, >> >> [required_handlers] [varbinary](max) NULL, >> >> [serviceId] [varchar](255) NOT NULL, >> >> [theme] [varchar](255) NULL, >> >> [username_attr] [varbinary](max) NULL, >> >> [bypassApprovalPrompt] [bit] NULL, >> >> [clientId] [varchar](255) NULL, >> >> [clientSecret] [varchar](255) NULL, >> >> [generateRefreshToken] [bit] NULL, >> >> [jsonFormat] [bit] NULL, >> >> [supported_grants] [varbinary](max) NULL, >> >> [supported_responses] [varbinary](max) NULL, >> >> [DYNAMIC_REG_TIME] [datetime2](7) NULL, >> >> [dynamicallyRegistered] [bit] NULL, >> >> [encryptIdToken] [bit] NULL, >> >> [idTokenEncryptionAlg] [varchar](255) NULL, >> >> [idTokenEncryptionEncoding] [varchar](255) NULL, >> >> [implicit] [bit] NULL, >> >> [jwks] [varchar](255) NULL, >> >> [scopes] [varbinary](max) NULL, >> >> [signIdToken] [bit] NULL, >> >> [encryptAssertions] [bit] NULL, >> >> [metadataCriteriaDirection] [varchar](255) NULL, >> >> [metadataCriteriaPattern] [varchar](255) NULL, >> >> [metadataCriteriaRemoveEmptyEntitiesDescriptors] [bit] >> NULL, >> >> [metadataCriteriaRemoveRolelessEntityDescriptors] [bit] >> NULL, >> >> [metadataCriteriaRoles] [varchar](255) NULL, >> >> [metadataLocation] [varchar](255) NULL, >> >> [metadataMaxValidity] [bigint] NULL, >> >> [metadataSignatureLocation] [varchar](255) NULL, >> >> [nameIdQualifier] [varchar](255) NULL, >> >> [requiredAuthenticationContextClass] [varchar](255) NULL, >> >> [requiredNameIdFormat] [varchar](255) NULL, >> >> [serviceProviderNameIdQualifier] [varchar](255) NULL, >> >> [signAssertions] [bit] NULL, >> >> [signResponses] [bit] NULL, >> >> >> >> >> >> -Gary >> >> -- >> - 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 cas-user+u...@apereo.org <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB30145F7FA1552FD561DB948D950A0%40CY4PR03MB3014.namprd03.prod.outlook.com >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB30145F7FA1552FD561DB948D950A0%40CY4PR03MB3014.namprd03.prod.outlook.com?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 cas-user+u...@apereo.org <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mid_%2BHeV-p%2BZHdWzXd70ywpxV43DwZNBNkVT%2BMGVp3VjqQ%40mail.gmail.com >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mid_%2BHeV-p%2BZHdWzXd70ywpxV43DwZNBNkVT%2BMGVp3VjqQ%40mail.gmail.com?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 cas-user+u...@apereo.org <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB3014E20AB11AA25E6E9F4F33950B0%40CY4PR03MB3014.namprd03.prod.outlook.com >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/CY4PR03MB3014E20AB11AA25E6E9F4F33950B0%40CY4PR03MB3014.namprd03.prod.outlook.com?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 cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/227ab009-a934-4687-88ad-db853e4daf17%40apereo.org.
