[
https://issues.apache.org/jira/browse/GUACAMOLE-1753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mike Jumper closed GUACAMOLE-1753.
----------------------------------
Resolution: Duplicate
> 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
> Priority: Major
>
> 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)
