[ 
https://issues.apache.org/jira/browse/GUACAMOLE-553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16447994#comment-16447994
 ] 

Mathias commented on GUACAMOLE-553:
-----------------------------------

[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)

Reply via email to