[
https://issues.apache.org/jira/browse/GUACAMOLE-1983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882103#comment-17882103
]
Marcelo commented on GUACAMOLE-1983:
------------------------------------
{noformat}
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
... 74 common frames omittedCaused by:
com.mysql.cj.exceptions.CJCommunicationsException: Communications link
failureThe last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server. at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:104)
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
at
com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
at
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:88)
at com.mysql.cj.NativeSession.connect(NativeSession.java:120) at
com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:935) at
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:805)
... 95 common frames omittedCaused by: java.net.NoRouteToHostException: No
route to host (Host unreachable) at
java.net.PlainSocketImpl.socketConnect(Native Method) at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at
java.net.Socket.connect(Socket.java:607) at
com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
at
com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:62)
... 98 common frames omitted15:40:28.423 [pool-1-thread-1] DEBUG
o.a.g.rest.auth.HashTokenSessionMap - Checking for expired
sessions...15:40:28.424 [pool-1-thread-1] DEBUG
o.a.g.rest.auth.HashTokenSessionMap - Session check completed in 1
ms.15:41:28.423 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Checking for expired sessions...15:41:28.424 [pool-1-thread-1] DEBUG
o.a.g.rest.auth.HashTokenSessionMap - Session check completed in 1 ms.{noformat}
> Communications link failure
> ---------------------------
>
> Key: GUACAMOLE-1983
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-1983
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-auth-jdbc-mysql
> Affects Versions: 1.5.5
> Reporter: Marcelo
> Priority: Minor
>
> I have guacamode deployed with docker swarm
> guacamole version:
> [docker.io/guacamole/guacamole:latest|https://portainer.softpack.priv/#!/2/docker/images/docker.io~2Fguacamole~2Fguacamole%3Alatest]
> guacamoledb version:
> [docker.io/mariadb:10.9.5|https://portainer.softpack.priv/#!/2/docker/images/docker.io~2Fmariadb%3A10.9.5]
> guacad version:
> [guacamole/guacd:latest|https://portainer.softpack.priv/#!/2/docker/images/guacamole~2Fguacd%3Alatest]
> I created those containers with previous versions, but now updated everything
> as shown previously, and now, on guacamole log i have:
> {noformat}
> 16-Sep-2024 14:41:29.098 INFO [main] org.apache.coyote.AbstractProtocol.start
> Starting ProtocolHandler ["http-nio-8080"]
> 16-Sep-2024 14:41:29.115 INFO [main]
> org.apache.catalina.startup.Catalina.start Server startup in 7427 ms
> Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver
> class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered
> via the SPI and manual loading of the driver class is generally unnecessary.
> 14:42:03.723 [http-nio-8080-exec-9] 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.
> 14:42:03.732 [http-nio-8080-exec-9] ERROR o.a.g.rest.RESTExceptionMapper -
> Unexpected internal error:
> ### Error querying database. Cause:
> com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link
> failure
> The last packet sent successfully to the server was 0 milliseconds ago. The
> driver has not received any packets from the 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.cj.jdbc.exceptions.CommunicationsException:
> Communications link failure{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
