Repository: syncope Updated Branches: refs/heads/master f27e1bb4a -> 1fa7fe115
Update 'MySQL' and 'MariaDB' DBMS configurations to allow milliseconds recording in DATETIME types and to fix 'max key length is 767 bytes' errors Project: http://git-wip-us.apache.org/repos/asf/syncope/repo Commit: http://git-wip-us.apache.org/repos/asf/syncope/commit/1fa7fe11 Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/1fa7fe11 Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/1fa7fe11 Branch: refs/heads/master Commit: 1fa7fe115309ffc71e8821644f5279a6b80c2ac8 Parents: f27e1bb Author: skylark17 <matteo.alessandr...@tirasa.net> Authored: Tue Aug 29 12:37:23 2017 +0200 Committer: skylark17 <matteo.alessandr...@tirasa.net> Committed: Tue Aug 29 12:38:48 2017 +0200 ---------------------------------------------------------------------- .../systemadministration/dbms.adoc | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/syncope/blob/1fa7fe11/src/main/asciidoc/reference-guide/workingwithapachesyncope/systemadministration/dbms.adoc ---------------------------------------------------------------------- diff --git a/src/main/asciidoc/reference-guide/workingwithapachesyncope/systemadministration/dbms.adoc b/src/main/asciidoc/reference-guide/workingwithapachesyncope/systemadministration/dbms.adoc index 4849c60..24fb944 100644 --- a/src/main/asciidoc/reference-guide/workingwithapachesyncope/systemadministration/dbms.adoc +++ b/src/main/asciidoc/reference-guide/workingwithapachesyncope/systemadministration/dbms.adoc @@ -68,13 +68,16 @@ Master.url=jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8&relaxAuto Master.schema= Master.username=syncope Master.password=syncope -Master.databasePlatform=org.apache.openjpa.jdbc.sql.MySQLDictionary(blobTypeName=LONGBLOB) +Master.databasePlatform=org.apache.openjpa.jdbc.sql.MySQLDictionary(blobTypeName=LONGBLOB,timestampTypeName=DATETIME(3)) Master.orm=META-INF/spring-orm.xml Master.audit.sql=audit_mysql_innodb.sql .... +[CAUTION] +It is important to set the collation to `utf8_general_ci` after creation of `syncope` database. + [WARNING] -This assumes that the InnoDB engine is enabled in your MariaDB instance - if this is not the case, then change the value +This assumes that the InnoDB engine is enabled in your MySQL instance - if this is not the case, then change the value for `Master.audit` to `audit.sql`. [WARNING] @@ -102,10 +105,13 @@ Master.url=jdbc:mariadb://localhost:3306/syncope?characterEncoding=UTF-8 Master.schema= Master.username=syncope Master.password=syncope -Master.databasePlatform=org.apache.openjpa.jdbc.sql.MariaDBDictionary(blobTypeName=LONGBLOB) +Master.databasePlatform=org.apache.openjpa.jdbc.sql.MariaDBDictionary(blobTypeName=LONGBLOB,timestampTypeName=DATETIME(3)) Master.orm=META-INF/spring-orm.xml .... +[CAUTION] +It is important to set the collation to `utf8_general_ci` after creation of `syncope` database. + [WARNING] This assumes that you have a MariaDB instance running on localhost, listening on its default port 3306 with a database `syncope` fully accessible by user `syncope` with password `syncope`.