You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@syncope.apache.org by sk...@apache.org on 2017/08/29 10:39:50 UTC
syncope git commit: Update 'MySQL' and 'MariaDB' DBMS configurations
to allow milliseconds recording in DATETIME types and to fix 'max key length
is 767 bytes' errors
Repository: syncope
Updated Branches:
refs/heads/2_0_X 201f22a11 -> 468e80a88
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/468e80a8
Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/468e80a8
Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/468e80a8
Branch: refs/heads/2_0_X
Commit: 468e80a88350ee2404a2813ab4f52e2588011d18
Parents: 201f22a
Author: skylark17 <ma...@tirasa.net>
Authored: Tue Aug 29 12:37:23 2017 +0200
Committer: skylark17 <ma...@tirasa.net>
Committed: Tue Aug 29 12:37:23 2017 +0200
----------------------------------------------------------------------
.../systemadministration/dbms.adoc | 12 +++++++++---
1 file changed, 9 insertions(+), 3 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/syncope/blob/468e80a8/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`.