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 <[email protected] > <javascript:>>: > >> Ok I just wanted to make sure. Thanks! >> >> >> >> *From:* [email protected] <javascript:> [mailto:[email protected] >> <javascript:>] *On Behalf Of *Man H >> *Sent:* Friday, December 15, 2017 9:39 AM >> *To:* [email protected] <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 <[email protected] >> <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 [email protected] <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 [email protected] <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 [email protected] <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 [email protected]. 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.
