Yes that looks fine to me. I just tried and it worked ok with: a) syncope-installer-2.0.4-uber.jar b) mysql-5.7.18 c) mysql-connector-java-5.1.43 d) apache-tomcat-8.5.15
I'm not sure what to suggest - maybe try upgrading some of the artifacts to match the ones I used? Colm. On Wed, Jul 26, 2017 at 3:12 PM, Toth, Francisc < [email protected]> wrote: > Hi Colm, > > > > Thanks for attention J > > > > Here it is: > > > > <?xml version='1.0' encoding='utf-8'?> > > <!-- > > Licensed to the Apache Software Foundation (ASF) under one or more > > contributor license agreements. See the NOTICE file distributed with > > this work for additional information regarding copyright ownership. > > The ASF licenses this file to You under the Apache License, Version 2.0 > > (the "License"); you may not use this file except in compliance with > > the License. You may obtain a copy of the License at > > > > http://www.apache.org/licenses/LICENSE-2.0 > > > > Unless required by applicable law or agreed to in writing, software > > distributed under the License is distributed on an "AS IS" BASIS, > > WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. > > See the License for the specific language governing permissions and > > limitations under the License. > > --> > > <!-- The contents of this file will be loaded for each web application --> > > > > <Context> > > > > <!-- Default set of monitored resources. If one of these changes, > the--> > > <!-- web application will be reloaded. > --> > > > > <WatchedResource>WEB-INF/web.xml</WatchedResource> > > <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource> > > > > <!-- Uncomment this to disable session persistence across Tomcat > restarts --> > > > > <Manager pathname="" /> > > > > <!-- Uncomment this to enable Comet connection tacking (provides events > > on session expiration as well as webapp lifecycle) --> > > <!-- > > <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" > /> > > --> > > > > <Resource name="jdbc/syncopeMasterDataSource" > > 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="100" minIdle="2" maxWait="10000" initialSize="2" > > removeAbandonedTimeout="20000" removeAbandoned="true" logAbandoned="true" > > suspectTimeout="20000" timeBetweenEvictionRunsMillis="5000" > > minEvictableIdleTimeMillis="5000" defaultAutoCommit="false" > > jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor. > ConnectionState; > > org.apache.tomcat.jdbc.pool.interceptor. > StatementFinalizer" > > username="syncope" password="syncope" > > driverClassName="com.mysql.jdbc.Driver" > > url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/> > > > > </Context> > > > > *From:* Colm O hEigeartaigh [mailto:[email protected]] > *Sent:* Wednesday, July 26, 2017 2:54 PM > *To:* [email protected] > *Subject:* Re: clean GUI install not working with MySQL, what do I miss? > > > > What does your conf/context.xml look like? > > Colm. > > > > On Wed, Jul 26, 2017 at 12:38 PM, Toth, Francisc <francisc.toth@siemens- > convergence.com> wrote: > > Hi, > > Cannot install Syncope with Mysql, using the syncope installer gui; > > There are tutorials on how to do it, I followed them, I’m sure it might be > something trivial but I do not see it: > > > > CENTOS7, Java 8 (version 1.8.0_60) > > Apache Maven 3.3.9 – fresh install > > Mysql 5.6.36 – fresh install, “syncope” database created, user syncope, > password syncope, on localhost, mysqld is up, tested, all ok. > > Tomcat 8.0.26 – fresh install with mysql-connector-java-5.1.42-bin.jar > in tomcat/lib; > > tomcat/conf/context.xml configured to have the mysql <Resource> > > tomcat/bin/setenv.sh created as in tutorials, rights ok. > > Tomcat starts ok, there are no errors in catalina.out, additionally I see > in the mysql access log the > > Connect syncope@localhost on syncope > > Query /* mysql-connector-java-5.1.42 …… > > Then continuously the Query SELECT 1 > > …and so on, so I assume tomcat can access the Mysql database at least > tomcat has found the driver and it uses it; > > > > Java -jar syncope-installer-2.0.4-uber.jar starts the GUI installer, I > leave everything default, all first 7 steps go quick, I choose Mysql, > default user, password and url are ok so I leave them untouched. Then the > installer waits until it times out, I can see in the mysql access-log that > there is no request coming to mysqld. > > After timeout I have the message “Validation failed Error during > connection to database: please check inserted data. Unable to get mysql > driver!” > > > > I need here to quit the installer. There is nothing built yet, there is no > install log written. > > Any hint is welcome > > > > BR > > Francisc > > > > > > > > > > > > > > > > -- > > Colm O hEigeartaigh > > Talend Community Coder > http://coders.talend.com > -- Colm O hEigeartaigh Talend Community Coder http://coders.talend.com
