4.1. Creating databases

eXo Platform uses two datasources:

  1. Create 2 databases - one for IDM, and one for JCR - or you can use the same database for both. Leave the databases empty, the tables will be created automatically in Platform first startup.

    • If you do not need to support specific characters, it is recommended to use the character set latin1 and the collation latin1_general_cs (as eXo JCR is case sensitive). For example, in MySQL: CREATE DATABASE plf_jcr DEFAULT CHARACTER SET latin1 DEFAULT COLLATE latin1_general_cs;.

    • If you need to support specific characters, it is recommended to use the character set utf8 and the collation utf8_bin (as eXo JCR is case sensitive). For example, in MySQL: CREATE DATABASE plf_jcr DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;

  2. Grant a user the right to access the databases. The user should be allowed to access remotely from where eXo Platform is hosted.

    For example, in MySQL:

    grant all on ${dbname}.* to '$username'@'$IP' identified by '$password';
    • $IP is your app server host name that accepts wildcard (for example, 192.168.1.% = all IPs on 192.168.1.x network).

    • $username and $password are credentials that eXo Platform will use to connect to the databases.

Copyright ©. All rights reserved. eXo Platform SAS
blog comments powered byDisqus