On 16/02/2018 17:31, Eric-R82 wrote:
I am using 2.0.7. I didn't go with the standalone, because of the of the
following note:
/Target Audience
First approach, especially with administration console and end-user; does
not require technical skills.
*Not meant for any production environment.*/
If I can ignore it and go use it in a production environment, I will try it.
I confirm that standalone is for product evaluation, not for production.
I originally tried this link:
http://syncope.apache.org/docs/getting-started.html#gui-installer
but I syncope wouldn't start in tomcat.I found
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-MicrosoftSQLServer
If you scroll up that page you will notice:
The content below is for Apache Syncope <= 1.2 - for later versions
check the "System Administration" chapter of the Reference Guide.
Why ignore such warning?
with the hope that I could use that to determine why the syncope webapp
wouldn't start. In particular I was looking to found out how to setup a
datasource in tomcat as the GUI installer warned that I need to have that
setup, but I don't know how to setup a datasource in tomcat.
To setup a DataSource in Tomcat is not exactly stuff for Syncope, but
Google can help:
*
https://stackoverflow.com/questions/15498851/configure-sql-server-connection-pool-on-tomcat
*
https://confluence.atlassian.com/conf59/configuring-a-sql-server-datasource-in-apache-tomcat-792499577.html
Essentially, you need to adapt the sample provided at
https://syncope.apache.org/docs/reference-guide.html#apache-tomcat-8-and-8-5
to MS SQL Server.
Hence:
1. place the SQL Server JDBC driver under Tomcat's lib directory
2. add to Tomcat's conf/server.xml:
<Resource name="jdbc/syncopeMasterDataSource"
auth="Container"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
type="javax.sql.DataSource"
maxActive="50"
maxIdle="10"
maxWait="15000"
username="username"
password="password"
url="jdbc:sqlserver://127.0.0.1:1433;databaseName=SQLDB;"
removeAbandoned="true"
removeAbandonedTimeout="30"
logAbandoned="true" />
3. restart Tomcat
4. start again the Syncope GUI installer
I will re-install from scratch and continue searching how to setup a Microsoft
SQL datasource in Tomcat.
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
