subject:"\[cas\-user\] 5.1.2 to 5.2 CAS migration"

Re: [cas-user] 5.1.2 to 5.2 CAS migration

2018-10-05 Thread Yan Zhou

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  >:
>
>> Ok I just wanted to make sure. Thanks!
>>
>>  
>>
>> *From:* cas-...@apereo.org  [mailto:cas-...@apereo.org 
>> ] *On Behalf Of *Man H
>> *Sent:* Friday, December 15, 2017 9:39 AM
>> *To:* cas-...@apereo.org 
>> *Subject:* Re: [cas-user] 5.1.2 to 5.2 CAS migration
>>
>>  
>>
>> this is what I have in 5.2.0
>>
>> CREATE TABLE `RegexRegisteredService` ( 
&g

Re: [cas-user] 5.1.2 to 5.2 CAS migration

2017-12-21 Thread Man H

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 <maxwel...@fortlewis.edu>:

> Ok I just wanted to make sure. Thanks!
>
>
>
> *From:* cas-user@apereo.org [mailto:cas-user@apereo.org] *On Behalf Of *Man
> H
> *Sent:* Friday, December 15, 2017 9:39 AM
> *To:* cas-user@apereo.org
> *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 <maxwel...@fortlewis.edu>:
>
> We initialized our database by setting 
> “cas.serviceRegistry.jpa.ddlAuto=create”
>

RE: [cas-user] 5.1.2 to 5.2 CAS migration

2017-12-15 Thread Maxwell, Gary

Ok I just wanted to make sure. Thanks!

From: cas-user@apereo.org [mailto:cas-user@apereo.org] On Behalf Of Man H
Sent: Friday, December 15, 2017 9:39 AM
To: cas-user@apereo.org
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 
<maxwel...@fortlewis.edu<mailto:maxwel...@fortlewis.edu>>:
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,
[nam

Re: [cas-user] 5.1.2 to 5.2 CAS migration

2017-12-15 Thread Man H

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 :

> 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,
>
>

[cas-user] 5.1.2 to 5.2 CAS migration

2017-12-14 Thread Maxwell, Gary

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+unsubscr...@apereo.org.
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.

Re: [cas-user] 5.1.2 to 5.2 CAS migration

Re: [cas-user] 5.1.2 to 5.2 CAS migration

RE: [cas-user] 5.1.2 to 5.2 CAS migration

Re: [cas-user] 5.1.2 to 5.2 CAS migration

[cas-user] 5.1.2 to 5.2 CAS migration

5 matches

Site Navigation

Mail list logo

Footer information