[
https://issues.apache.org/jira/browse/GUACAMOLE-919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17011779#comment-17011779
]
Mechanix commented on GUACAMOLE-919:
------------------------------------
[~mjumper] thanks for your reply. I've enabled debug logs on the guacamole
deployment:
{{12:16:16.156 [http-nio-8080-exec-8] DEBUG o.a.g.resource.ResourceServlet -
Resource not modified: "/app.css"}}
{{12:16:16.167 [http-nio-8080-exec-7] DEBUG o.a.g.resource.ResourceServlet -
Resource not modified: "/app.js"}}
{{12:16:16.361 [http-nio-8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection}}
{{12:16:16.361 [http-nio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource -
Checked out connection 52832043 from pool.}}
{{12:16:16.361 [http-nio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource -
Testing connection 52832043 ...}}
{{12:16:16.471 [http-nio-8080-exec-9] DEBUG o.a.g.resource.ResourceServlet -
Resource not modified: "/translations/en.json"}}
{{12:16:18.334 [http-nio-8080-exec-5] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection *(blank page - browser refresh page)*}}
{{12:16:19.199 [http-nio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection *(blank page - browser refresh page)*}}
{{12:16:19.376 [http-nio-8080-exec-7] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection *(blank page - browser refresh page)*}}
{{12:16:19.609 [http-nio-8080-exec-1] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection *(blank page - browser refresh page)*}}
{{12:16:19.811 [http-nio-8080-exec-3] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection *(blank page - browser refresh page)***}}
{{12:17:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Checking for expired sessions...}}
{{12:17:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Session check completed in 0 ms.}}
{{12:17:12.809 [http-nio-8080-exec-8] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection}}
{{12:18:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Checking for expired sessions...}}
{{12:18:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Session check completed in 0 ms.}}
{{12:31:52.793 [http-nio-8080-exec-6] WARN o.a.i.d.pooled.PooledDataSource -
Execution of ping query 'SELECT 1' failed: An I/O error occurred while sending
to the backend.}}
{{12:31:52.794 [http-nio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource -
Connection 52832043 is BAD: An I/O error occurred while sending to the
backend.}}
{{12:31:52.794 [http-nio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - A
bad connection (52832043) was returned from the pool, getting another
connection.}}
{{12:31:52.794 [http-nio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource -
Checked out connection 699492272 from pool.}}
{{12:31:52.794 [http-nio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource -
Testing connection 699492272 ...}}
{{12:32:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Checking for expired sessions...}}
{{12:32:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Session check completed in 0 ms.}}
{{12:33:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Checking for expired sessions...}}
{{12:33:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Session check completed in 0 ms.}}
{{12:34:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Checking for expired sessions...}}
{{12:34:12.064 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap -
Session check completed in 0 ms.}}
{{12:34:36.385 [http-nio-8080-exec-4] DEBUG o.a.g.resource.ResourceServlet -
Resource not modified: "/app.css"}}
{{12:34:36.393 [http-nio-8080-exec-2] DEBUG o.a.g.resource.ResourceServlet -
Resource not modified: "/app.js"}}
{{12:34:36.489 [http-nio-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransaction -
Opening JDBC Connection}}
{{12:34:36.563 [http-nio-8080-exec-2] DEBUG o.a.g.resource.ResourceServlet -
Resource not modified: "/translations/en.json"}}
At this point every client gets a blank page. The only thing that helps is
restarting the guacamole deployment.
Funny thing though: the blank page has following source:
{{}}{{<!DOCTYPE html>}}
{{<!--}}
{{ Licensed to the Apache Software Foundation (ASF) under one}}
{{ or more contributor license agreements. See the NOTICE file}}
{{ distributed with this work for additional information}}
{{ regarding copyright ownership. The ASF licenses this file}}
{{ to you under the Apache License, Version 2.0 (the}}
{{ "License"); you may not use this file except in compliance}}
{{ with the License. You may obtain a copy of the License
at}}{{http://www.apache.org/licenses/LICENSE-2.0}}{{Unless required by
applicable law or agreed to in writing,}}
{{ software distributed under the License is distributed on an}}
{{ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY}}
{{ KIND, either express or implied. See the License for the}}
{{ specific language governing permissions and limitations}}
{{ under the License.}}
{{-->}}
{{<html ng-app="index" ng-controller="indexController">}}
{{ <head>}}
{{ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>}}
{{ <meta http-equiv="x-ua-compatible" content="IE=edge"/>}}
{{ <meta name="viewport" content="width=device-width, initial-scale=1.0,
maximum-scale=1.0, minimum-scale=1.0, user-scalable=no,
target-densitydpi=medium-dpi"/>}}
{{ <meta name="mobile-web-app-capable" content="yes"/>}}
{{ <meta name="apple-mobile-web-app-capable" content="yes"/>}}
{{ <link rel="icon" type="image/png" href="images/logo-64.png"/>}}
{{ <link rel="icon" type="image/png" sizes="144x144"
href="images/logo-144.png"/>}}
{{ <link rel="apple-touch-icon" type="image/png" href="images/logo-144.png"/>}}
{{ <link rel="stylesheet" type="text/css" href="app.css?v=1.0.0">}}
{{ <title ng-bind="page.title | translate"></title>}}
{{ </head>}}
{{ <body ng-class="page.bodyClassName">}}{{<!-- Content for logged-in users
-->}}
{{ <div ng-if="!expectedCredentials">}}
{{ <!-- Global status/error dialog -->}}
{{ <div ng-class="\{shown: guacNotification.getStatus()}"
class="status-outer">}}
{{ <div class="status-middle">}}
{{ <guac-notification
notification="guacNotification.getStatus()"></guac-notification>}}
{{ </div>}}
{{ </div>}}
{{ <div id="content" ng-view>}}
{{ </div>}}
{{ </div>}}{{<!-- Login screen for logged-out users -->}}
{{ <guac-login ng-show="expectedCredentials"}}
{{ help-text="loginHelpText"}}
{{ form="expectedCredentials"}}
{{ values="acceptedCredentials"></guac-login>}}{{<!-- Reformat URL for
AngularJS if query parameters are present -->}}
{{ <script type="text/javascript" src="relocateParameters.js"></script>}}{{<!--
Utility libraries -->}}
{{ <script type="text/javascript"
src="webjars/jquery/3.3.1/dist/jquery.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/lodash/4.17.10/dist/lodash.min.js"></script>}}{{<!-- AngularJS
-->}}
{{ <script type="text/javascript"
src="webjars/angular/1.6.9/angular.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/angular-route/1.6.9/angular-route.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/angular-touch/1.6.9/angular-touch.min.js"></script>}}{{<!--
Internationalization -->}}
{{ <script type="text/javascript"
src="webjars/messageformat/1.0.2/messageformat.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/angular-translate/2.16.0/angular-translate.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/angular-translate-interpolation-messageformat/2.16.0/angular-translate-interpolation-messageformat.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/angular-translate-loader-static-files/2.16.0/angular-translate-loader-static-files.min.js"></script>}}{{<!--
Polyfills for the "datalist" element, Blob and the FileSaver API -->}}
{{ <script type="text/javascript"
src="webjars/blob-polyfill/1.0.20150320/Blob.js"></script>}}
{{ <script type="text/javascript"
src="webjars/datalist-polyfill/1.14.0/datalist-polyfill.min.js"></script>}}
{{ <script type="text/javascript"
src="webjars/filesaver/1.3.3/FileSaver.min.js"></script>}}{{<!-- Allow
arbitrary ordering of Angular module creation and retrieval -->}}
{{ <script type="text/javascript"
src="webjars/angular-module-shim/0.0.4/angular-module-shim.js"></script>}}{{<!--
Web application -->}}
{{ <script type="text/javascript" src="app.js?v=1.0.0"></script>}}{{</body>}}
{{</html>}}
> 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
>
> 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)
