You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@guacamole.apache.org by "Mathias (JIRA)" <ji...@apache.org> on 2018/04/23 11:32:00 UTC
[jira] [Comment Edited] (GUACAMOLE-553) Docker image need a new
MySQL JDBC driver for MySQL 8.0
[ https://issues.apache.org/jira/browse/GUACAMOLE-553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16447994#comment-16447994 ]
Mathias edited comment on GUACAMOLE-553 at 4/23/18 11:31 AM:
-------------------------------------------------------------
[Docker MySQL|https://hub.docker.com/_/mysql/] latest version is switch to version 8.0.11. Guacamole can't connect to MySQL 8.0. After replace the MySQL [Connector-J version 5.1.46|https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz] inside the docker guacamole container and a restart, Guacamole connects perfectly again.
{code:log}
11:04:29.015 [http-nio-8080-exec-1] ERROR o.a.g.rest.RESTExceptionWrapper - Unexpected internal error:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
: Could not create connection to database server.
### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
### The error occurred while executing a query
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connect
ion to database server.
23-Apr-2018 11:04:29.022 SEVERE [http-nio-8080-exec-1] com.sun.jersey.spi.container.ContainerResponse.log
Exception Mapped exception to response: 500 (Internal Server Error)
org.apache.guacamole.rest.APIException
at org.apache.guacamole.rest.RESTExceptionWrapper.invoke(RESTExceptionWrapper.java:196)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:6
0)
{code}
was (Author: mathiasm):
[https://hub.docker.com/_/mysql/|Docker MySQL] latest version is switch to version 8.0.11. Guacamole can't connect to MySQL 8.0. After replace the MySQL [https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz|Connector-J version 5.1.46] inside the docker guacamole container and a restart, Guacamole connects perfectly again.
{code:java}
11:04:29.015 [http-nio-8080-exec-1] ERROR o.a.g.rest.RESTExceptionWrapper - Unexpected internal error:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
: Could not create connection to database server.
### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
### The error occurred while executing a query
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connect
ion to database server.
23-Apr-2018 11:04:29.022 SEVERE [http-nio-8080-exec-1] com.sun.jersey.spi.container.ContainerResponse.log
Exception Mapped exception to response: 500 (Internal Server Error)
org.apache.guacamole.rest.APIException
at org.apache.guacamole.rest.RESTExceptionWrapper.invoke(RESTExceptionWrapper.java:196)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:6
0)
{code}
> Docker image need a new MySQL JDBC driver for MySQL 8.0
> -------------------------------------------------------
>
> Key: GUACAMOLE-553
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-553
> Project: Guacamole
> Issue Type: Improvement
> Components: guacamole-docker
> Affects Versions: 0.9.14
> Reporter: Mathias
> Priority: Minor
>
> The Docker image need a MySQL JDBC driver update to be compatible with MySQL 8.
> Driver file "mysql-connector-java-5.1.35-bin.jar" must replaced with "mysql-connector-java-5.1.46-bin.jar" to get a connection with MySQL 8.0.11.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)