Superpaul209 created GUACAMOLE-1753:
---------------------------------------
Summary: Error occurred while executing a query
Key: GUACAMOLE-1753
URL: https://issues.apache.org/jira/browse/GUACAMOLE-1753
Project: Guacamole
Issue Type: Bug
Components: guacamole-auth-jdbc-mysql, guacamole-docker
Affects Versions: 1.5.0
Environment: Debian 11 with docker.
Reporter: Superpaul209
Hello,
I have an issue with the new guacamole 1.5.0 version on Docker. I have upgraded
my guacamole, guacd and mysql containers successfully but when heading to the
login page, there is an error :
An error has occurred and this action cannot be completed. If the problem
persists, please notify your system administrator or check your system logs.
When looking the system logs I can see this error with my mysql authentication
provider :
{code:java}
20/03/2023 22:19:14 [http-nio-8080-exec-2] 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.
20/03/2023 22:19:14 [http-nio-8080-exec-2] ERROR o.a.g.rest.RESTExceptionMapper
- Unexpected internal error:
20/03/2023 22:19:14 ### Error querying database. Cause:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure
20/03/2023 22:19:14 The last packet successfully received from the server was
168 milliseconds ago. The last packet sent successfully to the server was 160
milliseconds ago.
20/03/2023 22:19:14 ### The error may exist in
org/apache/guacamole/auth/jdbc/user/UserMapper.xml
20/03/2023 22:19:14 ### The error may involve
org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
20/03/2023 22:19:14 ### The error occurred while executing a query
20/03/2023 22:19:14 ### Cause:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure
20/03/2023 22:19:14 The last packet successfully received from the server was
168 milliseconds ago. The last packet sent successfully to the server was 160
milliseconds ago. {code}
This error only shows in the guacamole 1.5.0 container. When I revert the
version to the previous one (1.4.0), everything works well again.
I didn't do any changes to the database, the schema is the default one.
Any ideas how to fix this issue ?
Thank you !
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
