[
https://issues.apache.org/jira/browse/GUACAMOLE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17024123#comment-17024123
]
Nick Couchman commented on GUACAMOLE-919:
-----------------------------------------
[~mechanix] [~DouglasHeriot]: Hey, guys,
While I do not doubt that you're running into problems, I do not believe the
issues you are seeing are a bug in the Guacamole code. I think it's much more
likely that they occur somewhere in the JDBC code, and are due to timeout
and/or latency issues within the JDBC connections. This seems particularly
likely based on [~DouglasHeriot]'s information about the DB being hosted over a
DX link between an on-premise install of Guacamole Client (Tomcat) and a
cloud-hosted database.
That said, it seems like the best course of action would be to re-classify this
as a feature request for the ability to configure the JDBC timeout. It looks
like the MyBastis code (what handles much of Guacamole Client's JDBC support)
allows you to configure timeouts in various ways, and this might help
situations where the database is slower to respond than is normally expected.
I'll try to see if I can reproduce the issues you are seeing, and put together
a PR that you can try out that allows for configuring one or more timeout
values.
> An I/O error occurred while sending to the backend
> --------------------------------------------------
>
> Key: GUACAMOLE-919
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-919
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-auth-jdbc-postgresql
> Affects Versions: 1.0.0
> Reporter: Mechanix
> Priority: Major
> Attachments: image-2020-01-27-15-19-26-634.png
>
>
> Hi,
> we use guacamole with postgresql and openid extension. Guacamole and guacd is
> deployed inside a k8s cluster.
> For some reason, the authentication doesn't succeed sporadically; there is
> only a blank page and this error message in the guacamole log:
> *[pool-1-thread-1] WARN o.a.i.d.pooled.PooledDataSource - Execution of ping
> query 'SELECT 1' failed: An I/O error occurred while sending to the backend.*
> I suspect there is a weird timeout happening between guacamole and postgresql
> but could figure out why.
> Any hints are much appreciated. Thanks
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
