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