eXo Platform uses two datasources:
One for Identity Management (IDM) service.
And the other for Java Content Repository (JCR) service.
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;
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.