Hi Colm, Yum update mysql-server solved it. Mysql server upgraded from 5.6.36 to 5.6.37 It seems it was some sort of incompatibility. By pure luck I upgraded this first, everything else remained unchanged, less work ☺. Syncope installed fine and it works now.
Thank you very much for your help and for testing out a working setup, might help others too Francisc. From: Colm O hEigeartaigh [mailto:cohei...@apache.org] Sent: Wednesday, July 26, 2017 6:55 PM To: Toth, Francisc <francisc.t...@siemens-convergence.com> Cc: user@syncope.apache.org Subject: Re: clean GUI install not working with MySQL, what do I miss? 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 <francisc.t...@siemens-convergence.com<mailto:francisc.t...@siemens-convergence.com>> wrote: Hi Colm, Thanks for attention ☺ 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:cohei...@apache.org<mailto:cohei...@apache.org>] Sent: Wednesday, July 26, 2017 2:54 PM To: user@syncope.apache.org<mailto:user@syncope.apache.org> 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.t...@siemens-convergence.com<mailto:francisc.t...@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
