Run Syncope in real environments
Page edited by Francesco Chicchiricco
Changes (1)
...
with {code}
entry key=openjpa.MetaDataFactory value=org.apache.syncope.core.persistence.openjpa.JBossPersistenceMappingFactory(URLs=vfs:/content/${project.build.finalName}.war/WEB-INF/classes/, Resources=META-INF/orm.xml)/
{code}
...
Full Content
Introduction
Deployment directory
Internal storage
PostgreSQL
MySQL
Oracle
Microsoft SQL Server
JEE container
Apache Tomcat 7
Set Environment
GNU / Linux - Mac OS X
Windows
context.xml
Glassfish 3.1
Update core glassfish-web.xml
JBoss AS 7.1
Use JBossPersistenceMappingFactory
Use DataSource
core web.xml
core jboss-deployment-structure
Oracle WebLogic 12
Update core web.xml
Update core weblogic.xml
Other setup tasks
Use datasource
Connect console to core
Disable console debug
Build and deploy
Test your installation
Introduction
Once you have created your project, you can start adapting it to your own needs and requirements.
Deployment directory
Currently, Syncope needs two base directories to be defined:
bundles where ConnId bundles are stored (check what a connector bundle is);
log where all system logs are written.
For example, you can create directories as follows:
$ mkdir /opt/syncope
$ mkdir /opt/syncope/bundles
$ mkdir /opt/syncope/log
Internal storage
Internal storage is a database where all information and configurations are stored.
You may want to setup some default content to be loaded on internal storage upon schema creation: for this you need to edit
core/src/main/resources/content.xml
.
Please note that Syncope core will populate internal storage with provided content only if the corresponding database is empty, i.e. does not contain any table or view.
Depending on your DBMS, you will need to change your project setup accordingly; modify the content of
core/src/main/resources/persistence.properties
as indicated in the following.
PostgreSQL
jpa.driverClassName=org.postgresql.Driver
jpa.url="" class="code-comment">//localhost:5432/syncope
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.PostgresDictionary
quartz.jobstore=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
quartz.sql=tables_postgres.sql
logback.sql=postgresql.sql
This assumes that you have a PostgreSQL instance running on localhost, listening on its default port 5432 with a database
syncope
fully accessible by user
syncope
with password
syncope
MySQL
jpa.driverClassName=com.mysql.jdbc.Driver
jpa.url="" class="code-comment">//localhost:3306/syncope?characterEncoding=UTF-8
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.MySQLDictionary
quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
quartz.sql=tables_mysql_innodb.sql
logback.sql=mysql.sql
This assumes that you have a MySQL instance running on localhost, listening on its default port 3306 with a database
syncope
fully accessible by user
syncope
with password
syncope
It also assumes that the InnoDB engine is enabled in your MySQL instance - if this is not the case, then change the value for 'quartz.sql' to
quartz.sql=tables_mysql.sql
.
Oracle
jpa.driverClassName=oracle.jdbc.OracleDriver
jpa.url=""
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.OracleDictionary
quartz.jobstore=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
quartz.sql=tables_oracle.sql
logback.sql=oracle.sql
database.schema=SYNCOPE
This assumes that you have an Oracle instance running on localhost, listening on its default port 1521 with a database
syncope
under tablespace
SYNCOPE
fully accessible by user
syncope
with password
syncope
You will also need to
create directory
core/src/main/resources/META-INF
download Oracle mapping file for the version you are building (1.1.X, 1.0.X)
rename it to
orm.xml
and copy it under the directory created above
Microsoft SQL Server
jpa.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jpa.url="" class="code-comment">//localhost:1344;database=syncope;selectMethod=cursor;sendStringParametersAsUnicode=false
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.SQLServerDictionary
quartz.jobstore=org.quartz.impl.jdbcjobstore.MSSQLDelegate
quartz.sql=tables_sqlserver.sql
logback.sql=sqlserver.sql
This assumes that you have an SQL Server instance running on localhost, listening on its default port 1344 with a database
syncope
fully accessible by user
syncope
with password
syncope
You will