5.1.2 to 5.2 CAS migration

148 views
Skip to first unread message

Maxwell, Gary

unread,
Dec 14, 2017, 6:28:41 PM12/14/17
to cas-...@apereo.org

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

Man H

unread,
Dec 15, 2017, 11:38:57 AM12/15/17
to cas-...@apereo.org
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;


--
- 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+unsubscribe@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.

Maxwell, Gary

unread,
Dec 15, 2017, 3:45:24 PM12/15/17
to cas-...@apereo.org

Ok I just wanted to make sure. Thanks!

--

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

 

--

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

Man H

unread,
Dec 21, 2017, 2:36:24 PM12/21/17
to cas-...@apereo.org
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`)
)

--

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+unsubscribe@apereo.org.

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

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

Yan Zhou

unread,
Oct 5, 2018, 2:03:24 PM10/5/18
to CAS Community, info.i...@gmail.com
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

--

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

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

--
- 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.
Reply all
Reply to author
Forward
0 new messages