Hello, I use MariaDB for services's storage. You will find in the attachment the script of creation of database. For ticket's storage I entend to use Hazelcast.
Le dimanche 19 février 2017 18:08:35 UTC+1, RJ a écrit : > > Did you try mysql/maria DB for ticket storage as well? MySQL is something > we are interested in for both service and ticket registry. Can you share > the table structure details for this? Thanks > > On Saturday, February 18, 2017 at 2:17:41 PM UTC-5, Ayé Rayé wrote: >> >> Hello hello, >> >> I did a CAS 5.0.2 installation with Cas Services Management installed >> with persistent services on MariaDB database. It seems to me that >> everything works well except that: >> Each time the Tomcat is stopped, the tables in the database containing >> the services registry are deleted. When I start the Tomcat, the tables are >> recreated and of course my previous additions of services are lost. >> >> What did I miss in my setup? Thanks for your help. >> >> >> *In cas.properties* >> cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM >> INFORMATION_SCHEMA.SYSTEM_VARIABLES >> # cas.serviceRegistry.jpa.isolateInternalQueries=false >> cas.serviceRegistry.jpa.url=jdbc:mysql:// >> 127.0.0.1:3307/cas-service-registry >> # cas.serviceRegistry.jpa.failFast=true >> cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5Dialect >> # cas.serviceRegistry.jpa.leakThreshold=10 >> # cas.serviceRegistry.jpa.batchSize=1 >> # cas.serviceRegistry.jpa.defaultCatalog= >> # cas.serviceRegistry.jpa.defaultSchema= >> cas.serviceRegistry.jpa.user=root >> # cas.serviceRegistry.jpa.ddlAuto=create-drop >> cas.serviceRegistry.jpa.password=root >> cas.serviceRegistry.jpa.autocommit=true >> cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver >> cas.serviceRegistry.jpa.idleTimeout=5000 >> >> # cas.serviceRegistry.jpa.pool.suspension=false >> # cas.serviceRegistry.jpa.pool.minSize=6 >> # cas.serviceRegistry.jpa.pool.maxSize=18 >> # cas.serviceRegistry.jpa.pool.maxIdleTime=1000 >> # cas.serviceRegistry.jpa.pool.maxWait=2000 >> >> >> in *management.properties* >> >> >> *cas.serviceRegistry.initFromJson=falsecas.serviceRegistry.jpa.healthQuery=SELECT >> >> 1 FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES# >> cas.serviceRegistry.jpa.isolateInternalQueries=false >> cas.serviceRegistry.jpa.url=jdbc:mysql://127.0.0.1:3307/cas-service-registry >> <http://127.0.0.1:3307/cas-service-registry># >> cas.serviceRegistry.jpa.failFast=true >> cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.MySQL5Dialect# >> cas.serviceRegistry.jpa.leakThreshold=10# >> cas.serviceRegistry.jpa.batchSize=1# >> cas.serviceRegistry.jpa.defaultCatalog=# >> cas.serviceRegistry.jpa.defaultSchema= cas.serviceRegistry.jpa.user=root >> cas.serviceRegistry.jpa.ddlAuto= cas.serviceRegistry.jpa.password=root >> cas.serviceRegistry.jpa.autocommit=true >> cas.serviceRegistry.jpa.driverClass=com.mysql.cj.jdbc.Driver >> cas.serviceRegistry.jpa.idleTimeout=5000# >> cas.serviceRegistry.jpa.pool.suspension=false# >> cas.serviceRegistry.jpa.pool.minSize=6# >> cas.serviceRegistry.jpa.pool.maxSize=18# >> cas.serviceRegistry.jpa.pool.maxIdleTime=1000# >> cas.serviceRegistry.jpa.pool.maxWait=2000* >> >> >> -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- 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/997b110a-a0c4-4317-a7e1-c636177d6772%40apereo.org.
-- -------------------------------------------------------- -- Hôte : 127.0.0.1 -- Version du serveur: 10.1.20-MariaDB - mariadb.org binary distribution -- SE du serveur: Win64 -- HeidiSQL Version: 9.4.0.5125 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- Export de la structure de la base pour cas-service-registry CREATE DATABASE IF NOT EXISTS `cas-service-registry` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `cas-service-registry`; -- Export de la structure de la table cas-service-registry. hibernate_sequence CREATE TABLE IF NOT EXISTS `hibernate_sequence` ( `next_val` bigint(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Les données exportées n'étaient pas sélectionnées. -- Export de la structure de la table cas-service-registry. regexregisteredservice CREATE TABLE IF NOT EXISTS `regexregisteredservice` ( `expression_type` varchar(15) NOT NULL DEFAULT 'ant', `id` bigint(20) NOT NULL, `access_strategy` longblob, `attribute_release` longblob, `description` varchar(255) NOT NULL, `evaluation_order` int(11) NOT 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, `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, `jwks` longtext, `signIdToken` bit(1) DEFAULT NULL, `encryptAssertions` bit(1) DEFAULT NULL, `metadataCriteriaDirection` longtext, `metadataCriteriaPattern` longtext, `metadataCriteriaRemoveEmptyEntitiesDescriptors` bit(1) DEFAULT NULL, `metadataCriteriaRemoveRolelessEntityDescriptors` bit(1) DEFAULT NULL, `metadataCriteriaRoles` longtext, `metadataLocation` varchar(255) DEFAULT NULL, `metadataMaxValidity` bigint(20) DEFAULT NULL, `metadataSignatureLocation` longtext, `requiredAuthenticationContextClass` longtext, `requiredNameIdFormat` longtext, `signAssertions` bit(1) DEFAULT NULL, `signResponses` bit(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Les données exportées n'étaient pas sélectionnées. -- Export de la structure de la table cas-service-registry. regexregisteredserviceproperty CREATE TABLE IF NOT EXISTS `regexregisteredserviceproperty` ( `id` bigint(20) NOT NULL, `property_values` longblob, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Les données exportées n'étaient pas sélectionnées. -- Export de la structure de la table cas-service-registry. registeredserviceimpl_props CREATE TABLE IF NOT EXISTS `registeredserviceimpl_props` ( `AbstractRegisteredService_id` bigint(20) NOT NULL, `properties_id` bigint(20) NOT NULL, `properties_KEY` varchar(255) NOT NULL, PRIMARY KEY (`AbstractRegisteredService_id`,`properties_KEY`), UNIQUE KEY `UK_i2mjaqjwxpvurc6aefjkx5x97` (`properties_id`), CONSTRAINT `FK1xan7uamsa94y2451jgksjkj4` FOREIGN KEY (`properties_id`) REFERENCES `regexregisteredserviceproperty` (`id`), CONSTRAINT `FK5ghaknoplphay7reury7n3vcm` FOREIGN KEY (`AbstractRegisteredService_id`) REFERENCES `regexregisteredservice` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Les données exportées n'étaient pas sélectionnées. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
