clean GUI install not working with MySQL, what do I miss?

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

clean GUI install not working with MySQL, what do I miss?

Toth, Francisc

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

 

 

 

 

 

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: clean GUI install not working with MySQL, what do I miss?

Colm O hEigeartaigh
What does your conf/context.xml look like?

Colm.

On Wed, Jul 26, 2017 at 12:38 PM, Toth, Francisc <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: clean GUI install not working with MySQL, what do I miss?

Toth, Francisc

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:[hidden email]]
Sent: Wednesday, July 26, 2017 2:54 PM
To: [hidden email]
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 <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: clean GUI install not working with MySQL, what do I miss?

Colm O hEigeartaigh
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 <[hidden email]> 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:[hidden email]]
Sent: Wednesday, July 26, 2017 2:54 PM
To: [hidden email]
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: clean GUI install not working with MySQL, what do I miss?

Toth, Francisc

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 J. 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:[hidden email]]
Sent: Wednesday, July 26, 2017 6:55 PM
To: Toth, Francisc <[hidden email]>
Cc: [hidden email]
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 <[hidden email]> 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:[hidden email]]
Sent: Wednesday, July 26, 2017 2:54 PM
To: [hidden email]
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 <[hidden email]> 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

Loading...