I am an Apache Syncope newbie, and I am having one helluva time trying to get
Apache Syncope to work.
The overall thing is that I have a web-app that has it's own MySQL database,
and I have my own user and roles tables.
I don't want to code my own user management, so I was going to have Syncope
running as an iDM, so I could authenticate and manage my users through this
tool. I would delete my user and roles tables in place of Syncope tables.
Initially, I would use the "syncope" database to get it up and running, then
I would change the database name to something I want, update the
configuration, and then add the rest of my own tables for the rest of my
web-app. That way, I have one database for my user/roles and whatever else
syncope does, and then I'd add my other tables. Anyway, that was the
plan.....
So First, I started off with doing a maven build which is the "preferred"
way to setup Syncope for maximum flexibility and production use. I was able
to use maven to create the project, build it, and create all the WAR files.
The second step says to then check the "Reference" documentation which IMHO
does NOT tell you what you need to do in order to configure Syncope fully
... if at all.
I did create a syncope database in MySQL, I created a syncope_user and a
syncope_pass, and made sure it had all the correct permissions and could
login locally.
With this process, here is what I added to the Tomcat 8.5 conf.xml file:
<Resource name="jdbc/syncopeDataSource"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="true"
validationQuery="SELECT 1"
validationInterval="30000"
maxActive="50"
minIdle="2"
maxWait="10000"
initialSize="2"
removeAbandonedTimeout="20000"
removeAbandoned="true"
logAbandoned="true"
suspectTimeout="20000"
timeBetweenEvictionRunsMillis="5000"
minEvictableIdleTimeMillis="5000"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="syncope_user"
password="syncope_pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/syncope?serverTimezone=UTC" />
Funny thing is ... the standalone Syncope/Tomcat doesn't have this
configuration, nor does the GUI Installer version.
One final issue about the maven build is that the tomcat lib is using this
driver: mysql-connector-java-6.0.6.jar do we need a 5.x.x driver?
Second, the next process was to use the GUI installer, which seemed to go
well. I did make sure I updated my tomcat-users.xml file and added the role
and user that was needed. I did specify MySQL as the database, I did specify
the location for the log, the bundles, etc ... again, where was this
documentation when we do the maven build because it was NOT obvious in the
"Reference" documentation.
The process of the using the GUI Installer also did not work as expected. I
got a lot of database errors. There seems to be an issue with the EDT time
zone, and I am wondering where that is coming from? If you look at the
existing Tomcat context.xml file, it does say that the serverTimeZone
parameter is specifically UTC.
If I followed the directions closely, then Apache Syncope Console should be
working correctly, but it's NOT coming up.
Thirdly and Finally, I am going to try to use the StandAlone Syncope with
Tomcat to just try and get it to work, and this will be fine to test, but I
understand it is not ideal for Production.
I would really like to get the Maven build configured correctly so I can use
it for testing AND Production. Please help me get Syncope working correctly
so I can use it with my Syncope MySQL database.
Thanks!
--
Sent from: http://syncope-user.1051894.n5.nabble.com/
