Jonathan Kwan created GUACAMOLE-1738:
----------------------------------------
Summary: Docker Guacamole 1.5.0 Mysql Connection Error
Key: GUACAMOLE-1738
URL: https://issues.apache.org/jira/browse/GUACAMOLE-1738
Project: Guacamole
Issue Type: Bug
Affects Versions: 1.5.0
Reporter: Jonathan Kwan
Fix For: 1.4.0
Ever since I upgraded my docker instance of Guacamole from 1.4.0 to 1.5.0,
Guacamole is unable to connect to my mysql instance. Previously on 1.4.0 it was
working flawlessly without issue.
I've ensure the following are up to date at the moment:
nginx - 1.22.1
mysql - 8.0.32
docker engine - 23.0.1 (i was previously on 20.x, and it was causing weird
issues with the Java components in Docker to indicate "out of memory" which
wasn't the case)
Based on the error messages my hunch is it might be to do with
guacamole-auth-jdbc-mysql-1.5.0.jar.
Below is the error message from Guacamole:
[0m 04:05:17.030 [localhost-startStop-1] INFO
o.a.g.environment.LocalEnvironment - GUACAMOLE_HOME is
"/home/guacamole/.guacamole".
[0m 04:05:17.117 [localhost-startStop-1] INFO
o.a.g.GuacamoleServletContextListener - Read configuration parameters from
"/home/guacamole/.guacamole/guacamole.properties".
[0m 04:05:17.118 [localhost-startStop-1] INFO
o.a.g.rest.auth.HashTokenSessionMap - Sessions will expire after 60 minutes of
inactivity.
[0m 04:05:17.505 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule
- Multiple extensions are installed and will be loaded in order of decreasing
priority:
[0m 04:05:17.506 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule
- - [duo] "Duo TFA Authentication Backend"
(/home/guacamole/.guacamole/extensions/guacamole-auth-duo-1.5.0.jar)
[0m 04:05:17.506 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule
- - [mysql] "MySQL Authentication"
(/home/guacamole/.guacamole/extensions/guacamole-auth-jdbc-mysql-1.5.0.jar)
[0m 04:05:17.506 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule
- To change this order, set the "extension-priority" property or rename the
extension files. The default priority of extensions is dictated by the sort
order of their filenames.
[0m 04:05:17.783 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule
- Extension "Duo TFA Authentication Backend" (duo) loaded.
[0m 04:05:17.797 [localhost-startStop-1] INFO
o.a.g.a.mysql.conf.MySQLEnvironment - Installed JDBC driver for MySQL/MariaDB
detected as "MySQL Connector/J".
[0m 04:05:18.558 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule
- Extension "MySQL Authentication" (mysql) loaded.
[0m 04:05:18.644 [localhost-startStop-1] INFO o.a.g.t.w.WebSocketTunnelModule
- Loading JSR-356 WebSocket support...
[0m 22-Feb-2023 04:05:19.453 INFO [localhost-startStop-1]
org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application
archive [/home/guacamole/tomcat/webapps/guacamole.war] has finished in [3,996]
ms
[0m 22-Feb-2023 04:05:19.454 INFO [main]
org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler
["http-nio-8080"]
[0m 22-Feb-2023 04:05:19.464 INFO [main]
org.apache.catalina.startup.Catalina.start Server startup in 4047 ms
[0m 04:05:44.963 [http-nio-8080-exec-4] WARN
o.a.g.e.AuthenticationProviderFacade - The "mysql" authentication provider has
encountered an internal error which will halt the authentication process. If
this is unexpected or you are the developer of this authentication provider,
you may wish to enable debug-level logging. If this is expected and you wish to
ignore such failures in the future, please set "skip-if-unavailable: mysql"
within your guacamole.properties.
[0m 04:05:44.967 [http-nio-8080-exec-4] ERROR o.a.g.rest.RESTExceptionMapper -
Unexpected internal error:
[0m ### Error querying database. Cause:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure
[0m
[0m The last packet successfully received from the server was 111 milliseconds
ago. The last packet sent successfully to the server was 105 milliseconds ago.
[0m ### The error may exist in
org/apache/guacamole/auth/jdbc/user/UserMapper.xml
[0m ### The error may involve
org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
[0m ### The error occurred while executing a query
[0m ### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure
[0m
[0m The last packet successfully received from the server was 111 milliseconds
ago. The last packet sent successfully to the server was 105 milliseconds ago.
[0m 04:05:54.434 [http-nio-8080-exec-1] WARN
o.a.g.e.AuthenticationProviderFacade - The "mysql" authentication provider has
encountered an internal error which will halt the authentication process. If
this is unexpected or you are the developer of this authentication provider,
you may wish to enable debug-level logging. If this is expected and you wish to
ignore such failures in the future, please set "skip-if-unavailable: mysql"
within your guacamole.properties.
[0m 04:05:54.434 [http-nio-8080-exec-1] ERROR o.a.g.rest.RESTExceptionMapper -
Unexpected internal error:
[0m ### Error querying database. Cause:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure
[0m
[0m The last packet successfully received from the server was 5 milliseconds
ago. The last packet sent successfully to the server was 5 milliseconds ago.
[0m ### The error may exist in
org/apache/guacamole/auth/jdbc/user/UserMapper.xml
[0m ### The error may involve
org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
[0m ### The error occurred while executing a query
[0m ### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure
[0m
[0m The last packet successfully received from the server was 5 milliseconds
ago. The last packet sent successfully to the server was 5 milliseconds ago.
[0m 04:10:34.913 [http-nio-8080-exec-1] WARN
o.a.g.e.AuthenticationProviderFacade - The "mysql" authentication provider has
encountered an internal error which will halt the authentication process. If
this is unexpected or you are the developer of this authentication provider,
you may wish to enable debug-level logging. If this is expected and you wish to
ignore such failures in the future, please set "skip-if-unavailable: mysql"
within your guacamole.properties.
Any assistance on this issue would be greatly appreciated, thanks!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
