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:[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
<[email protected]<mailto:[email protected]>>
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
