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 <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:
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
<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
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 <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
>
>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
<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
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
