RE: clean GUI install not working with MySQL, what do I miss?
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 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 mailto:francisc.t...@siemens-convergence.com>> wrote: Hi Colm, Thanks for attention ☺ Here it is: WEB-INF/web.xml ${catalina.base}/conf/web.xml 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 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 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
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> wrote: > Hi Colm, > > > > Thanks for attention J > > > > Here it is: > > > > > > > > > > > > > > > > > > > > > > WEB-INF/web.xml > > ${catalina.base}/conf/web.xml > > > > > > > > > > > > > > > > > > > auth="Container" > > type="javax.sql.DataSource" > > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > > testWhileIdle="true" > > testOnBorrow="true" testOnReturn="true" > > validationQuery="SELECT 1" validationInterval="3" > > maxActive="100" minIdle="2" maxWait="1" initialSize="2" > > removeAbandonedTimeout="2" removeAbandoned="true" logAbandoned="true" > > suspectTimeout="2" 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"/> > > > > > > > > *From:* Colm O hEigeartaigh [mailto:cohei...@apache.org] > *Sent:* Wednesday, July 26, 2017 2:54 PM > *To:* 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 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 > >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
RE: clean GUI install not working with MySQL, what do I miss?
Hi Colm, Thanks for attention ☺ Here it is: WEB-INF/web.xml ${catalina.base}/conf/web.xml From: Colm O hEigeartaigh [mailto:cohei...@apache.org] Sent: Wednesday, July 26, 2017 2:54 PM To: 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 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 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
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> 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 > >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
clean GUI install not working with MySQL, what do I miss?
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 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