Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 3CF89200C52 for ; Mon, 10 Apr 2017 18:51:09 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 3B529160B99; Mon, 10 Apr 2017 16:51:09 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id E5627160B7F for ; Mon, 10 Apr 2017 18:51:06 +0200 (CEST) Received: (qmail 80027 invoked by uid 500); 10 Apr 2017 16:51:06 -0000 Mailing-List: contact user-help@guacamole.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@guacamole.incubator.apache.org Delivered-To: mailing list user@guacamole.incubator.apache.org Received: (qmail 80009 invoked by uid 99); 10 Apr 2017 16:51:05 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Apr 2017 16:51:05 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id E8481C0FEE for ; Mon, 10 Apr 2017 16:51:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.103 X-Spam-Level: * X-Spam-Status: No, score=1.103 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, KAM_BADIPHTTP=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.796, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id xm-NfSAP--gX for ; Mon, 10 Apr 2017 16:50:56 +0000 (UTC) Received: from mail-wr0-f172.google.com (mail-wr0-f172.google.com [209.85.128.172]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 79B805FB5B for ; Mon, 10 Apr 2017 16:50:55 +0000 (UTC) Received: by mail-wr0-f172.google.com with SMTP id c55so79447408wrc.3 for ; Mon, 10 Apr 2017 09:50:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=PzGaHvZ2+k1b2zYQqXbZfF6DbNQu8ehudwg9pTvoHh0=; b=nIjH8f6gL5tP5L7W7PTPPnYAC9A9qH9KLe6nWXSoBf5MovjgvL7RiulObB4pI5TXR2 pgoNypbYH4bLWJy/+n19KklUEFMElS0l4GZxjGAn6RJzJbb7gedQt8fdfvFndp5h8yLt JJPlOaBH5BIg4NN074qIWZ+PdEax1IC5hhgwVNyP9kFxWrreJZS3hhDlii0WBJHs+dAD 55bAKNApDXMmmn9zus79jh8yyhnEEz6FGzR7RaoVoZRbcokzIZgaDdOQTA616NBq4M45 Uc8lyqF9vX1AjXHzUQD0AtqRFWVmussnjof1/fDM/6m5QZT3N3Bp0PAahiUawvH63RGO 5URQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=PzGaHvZ2+k1b2zYQqXbZfF6DbNQu8ehudwg9pTvoHh0=; b=EzI7lzT8tciuNJGi9JgaUYfyaK0QbRjWqUz7Z5CCkbu8SxHJjbOzQuP+4d6xqT2cYV 6/diHupH0TlyP0YPhL2viXHb7r9O4jyvEMUj4GyaFwviyI6Wf+h6oFdNAdq6BqnM/6xJ WLtM5KiqturI9LITN1l4QEXEoxQ4Ch3YkuGrJGqct587H7sTnxEza98G+t+ZlrYn5E1N dPesyotneN2C+DZ8fSd36IU6l0/pjapjxkd/tg6yJF3hZYzEPUbGhfMfzgikv39ggogt qdr/nQ58uh0MXym4JZiTFRLUL+qfVMGEuUh+vHeZZkmzN8qhkob38SVbEILuxVkm/78U delg== X-Gm-Message-State: AFeK/H1UMDbQf9GSY0y+0CI6N7c0Jgp6p4LgKCUAhRNwK9WDl7s8LwXD0Nb6F3IoWeKK3UmUuZzbqAqB0GdCyQ== X-Received: by 10.223.142.143 with SMTP id q15mr25976567wrb.180.1491843053559; Mon, 10 Apr 2017 09:50:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.51.202 with HTTP; Mon, 10 Apr 2017 09:50:52 -0700 (PDT) In-Reply-To: References: From: Anburaj Palraj Date: Mon, 10 Apr 2017 22:20:52 +0530 Message-ID: Subject: Re: Not able to copy more than 200 lines in clipboard for Linux machines To: user@guacamole.incubator.apache.org Content-Type: multipart/alternative; boundary=f403045f517c44abe9054cd2c701 archived-at: Mon, 10 Apr 2017 16:51:09 -0000 --f403045f517c44abe9054cd2c701 Content-Type: text/plain; charset=UTF-8 Hi Mike, Any help on this issue ? On Tue, Mar 28, 2017 at 8:06 PM, Anburaj Palraj wrote: > Hi Mike, > > As you asked find the logs below .i have tested this on my test machine > and at this time , only one connection was there . > > [root@shinken log]# cat guacamole.txt > Mar 28 19:09:38 shinken server: 19:09:38.366 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.366 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.366 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.367 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.367 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.367 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.368 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.369 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.369 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.369 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.369 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.371 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.371 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.371 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - ==> Preparing: SELECT > connection_id, connection_name, parent_id, protocol, max_connections, > max_connections_per_user FROM guacamole_connection WHERE connection_id IN ( > ? ) ; SELECT primary_connection_id, sharing_profile_id FROM > guacamole_sharing_profile WHERE primary_connection_id IN ( ? ) ; > Mar 28 19:09:38 shinken server: 19:09:38.371 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - ==> Parameters: 59(String), > 59(String) > Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken guacd[1290]: Creating new client for protocol "ssh" > Mar 28 19:09:38 shinken server: 19:09:38.374 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.374 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG > o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public > org.apache.guacamole.net.GuacamoleTunnel org.apache.guacamole.auth. > jdbc.tunnel.AbstractGuacamoleTunnelService.getGuacamoleTunnel(org. > apache.guacamole.auth.jdbc.user.ModeledAuthenticatedUser, > org.apache.guacamole.auth.jdbc.connection.ModeledConnection,org.apache. > guacamole.protocol.GuacamoleClientInformation) throws > org.apache.guacamole.GuacamoleException] - SqlSession not set for thread: > 32, creating a new one > Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken guacd[1290]: Connection ID is > "$14e5d900-7d97-4268-9df9-bb7ce68198b1" > Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.C.select - ==> Preparing: SELECT connection_id, > parameter_name, parameter_value FROM guacamole_connection_parameter WHERE > connection_id = ? > Mar 28 19:09:38 shinken server: 19:09:38.377 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.C.select - ==> Parameters: 59(String) > Mar 28 19:09:38 shinken server: 19:09:38.379 [http-bio-8080-exec-10] DEBUG > o.a.g.a.j.c.C.select - <== Total: 7 > Mar 28 19:09:38 shinken server: 19:09:38.379 [http-bio-8080-exec-10] DEBUG > o.a.g.net.InetGuacamoleSocket - Connecting to guacd at localhost:4822. > Mar 28 19:09:38 shinken guacd[1670]: Current locale does not use UTF-8. > Some characters may not render correctly. > Mar 28 19:09:38 shinken guacd[1670]: User "@c904d101-24a2-47aa-9421-a4f116d21720" > joined connection "$14e5d900-7d97-4268-9df9-bb7ce68198b1" (1 users now > present) > Mar 28 19:09:38 shinken server: 19:09:38.435 [http-bio-8080-exec-10] DEBUG > o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public > org.apache.guacamole.net.GuacamoleTunnel org.apache.guacamole.auth. > jdbc.tunnel.AbstractGuacamoleTunnelService.getGuacamoleTunnel(org. > apache.guacamole.auth.jdbc.user.ModeledAuthenticatedUser, > org.apache.guacamole.auth.jdbc.connection.ModeledConnection,org.apache. > guacamole.protocol.GuacamoleClientInformation) throws > org.apache.guacamole.GuacamoleException] - SqlSession of thread: 32 > committing > Mar 28 19:09:38 shinken server: 19:09:38.436 [http-bio-8080-exec-10] DEBUG > o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public > org.apache.guacamole.net.GuacamoleTunnel org.apache.guacamole.auth. > jdbc.tunnel.AbstractGuacamoleTunnelService.getGuacamoleTunnel(org. > apache.guacamole.auth.jdbc.user.ModeledAuthenticatedUser, > org.apache.guacamole.auth.jdbc.connection.ModeledConnection,org.apache. > guacamole.protocol.GuacamoleClientInformation) throws > org.apache.guacamole.GuacamoleException] - SqlSession of thread: 32 > terminated its life-cycle, closing it > Mar 28 19:09:38 shinken server: 19:09:38.436 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken guacd[1670]: Recording of session will be saved to > "/root/recording/172.25.14.58.4". > Mar 28 19:09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] INFO > o.a.g.tunnel.TunnelRequestService - User "guacadmin" connected to > connection "59". > Mar 28 19:09:38 shinken guacd[1670]: Typescript of terminal session will > be saved to "/root/smg/txt/172.25.14.58.8". Timing file is > "/root/smg/txt/172.25.14.58.8.timing". > Mar 28 19:09:38 shinken server: 19:09:38.478 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.478 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.478 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.479 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.479 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.480 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.481 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.482 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.482 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.482 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.482 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.487 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.488 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.490 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.490 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.490 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.491 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.491 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.491 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.492 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.493 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.493 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.494 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.494 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.494 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.494 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.501 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.502 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.512 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.512 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.512 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.512 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.513 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.513 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.515 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.515 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.515 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.516 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.516 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.517 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.517 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.518 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.518 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.520 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.520 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.520 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - ==> Preparing: SELECT > connection_id, connection_name, parent_id, protocol, max_connections, > max_connections_per_user FROM guacamole_connection WHERE connection_id IN ( > ? ) ; SELECT primary_connection_id, sharing_profile_id FROM > guacamole_sharing_profile WHERE primary_connection_id IN ( ? ) ; > Mar 28 19:09:38 shinken server: 19:09:38.520 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - ==> Parameters: 59(String), > 59(String) > Mar 28 19:09:38 shinken server: 19:09:38.521 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.521 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.c.ConnectionMapper.select - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.521 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.526 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.526 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.528 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.528 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.528 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.528 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.529 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG > o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public > java.util.Collection > org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory. > getAll(java.util.Collection) throws > org.apache.guacamole.GuacamoleException] - SqlSession not set for thread: > 31, creating a new one > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:09:38 shinken server: 19:09:38.532 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.533 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.s.S.select - ==> Preparing: SELECT sharing_profile_id, > sharing_profile_name, primary_connection_id FROM guacamole_sharing_profile > WHERE sharing_profile_id IN ( ? ) > Mar 28 19:09:38 shinken server: 19:09:38.533 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.s.S.select - ==> Parameters: 1(String) > Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG > o.a.g.a.j.s.S.select - <== Total: 1 > Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG > o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public > java.util.Collection > org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory. > getAll(java.util.Collection) throws > org.apache.guacamole.GuacamoleException] - SqlSession of thread: 31 > committing > Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG > o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public > java.util.Collection > org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory. > getAll(java.util.Collection) throws > org.apache.guacamole.GuacamoleException] - SqlSession of thread: 31 > terminated its life-cycle, closing it > Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:09:38 shinken server: 19:09:38.537 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:09:38 shinken server: 19:09:38.537 [http-bio-8080-exec-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:09:44 shinken guacd[1670]: SSH connection successful. > Mar 28 19:10:15 shinken server: 19:10:15.156 [pool-1-thread-1] DEBUG > o.a.g.rest.auth.HashTokenSessionMap - Checking for expired sessions... > Mar 28 19:10:15 shinken server: 19:10:15.156 [pool-1-thread-1] DEBUG > o.a.g.rest.auth.HashTokenSessionMap - Session check completed in 0 ms. > Mar 28 19:10:50 shinken guacd[1290]: Connection "$14e5d900-7d97-4268-9df9-bb7ce68198b1" > removed. > Mar 28 19:10:50 shinken server: 19:10:50.666 [Thread-9] INFO o.a.g.tunnel.TunnelRequestService > - User "guacadmin" disconnected from connection "59". Duration: 72229 > milliseconds > Mar 28 19:10:50 shinken server: 19:10:50.666 [Thread-9] DEBUG > o.a.g.net.InetGuacamoleSocket - Closing socket to guacd. > Mar 28 19:10:50 shinken server: 19:10:50.667 [Thread-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG > o.a.g.a.j.c.C.insert - ==> Preparing: INSERT INTO > guacamole_connection_history ( connection_id, connection_name, > sharing_profile_id, sharing_profile_name, user_id, username, start_date, > end_date ) VALUES ( ?, ?, ?, ?, (SELECT user_id FROM guacamole_user WHERE > username = ?), ?, ?, ? ) > Mar 28 19:10:50 shinken server: 19:10:50.670 [Thread-9] DEBUG > o.a.g.a.j.c.C.insert - ==> Parameters: 59(String), NAGIOS > (172.25.14.58)(String), null, null, guacadmin(String), guacadmin(String), > 2017-03-28 19:09:38.376(Timestamp), 2017-03-28 19:10:50.667(Timestamp) > Mar 28 19:10:50 shinken server: 19:10:50.670 [Thread-9] DEBUG > o.a.g.a.j.c.C.insert - <== Updates: 1 > Mar 28 19:10:50 shinken server: 19:10:50.671 [Thread-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Committing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:10:50 shinken server: 19:10:50.672 [Thread-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:10:50 shinken server: 19:10:50.672 [Thread-9] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:10:50 shinken server: 19:10:50.672 [Thread-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:10:50 shinken server: 19:10:50.673 [Thread-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:10:50 shinken server: 19:10:50.673 [Thread-9] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:10:53 shinken server: 19:10:53.937 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:10:53 shinken server: 19:10:53.938 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:10:53 shinken server: 19:10:53.938 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:10:53 shinken server: 19:10:53.938 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:10:53 shinken server: 19:10:53.938 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:10:53 shinken server: 19:10:53.940 [http-bio-8080-exec-6] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:10:53 shinken server: 19:10:53.940 [http-bio-8080-exec-6] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:10:53 shinken server: 19:10:53.941 [http-bio-8080-exec-6] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:10:53 shinken server: 19:10:53.941 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 from > pool. > Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:10:53 shinken server: 19:10:53.943 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:10:53 shinken server: 19:10:53.943 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:10:53 shinken server: 19:10:53.944 [http-bio-8080-exec-6] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Preparing: SELECT > guacamole_system_permission.user_id, username, permission FROM > guacamole_system_permission JOIN guacamole_user ON > guacamole_system_permission.user_id = guacamole_user.user_id WHERE > guacamole_system_permission.user_id = ? AND permission = ? > Mar 28 19:10:53 shinken server: 19:10:53.944 [http-bio-8080-exec-6] DEBUG > o.a.g.a.j.p.S.selectOne - ==> Parameters: 1(Integer), ADMINISTER(String) > Mar 28 19:10:53 shinken server: 19:10:53.945 [http-bio-8080-exec-6] DEBUG > o.a.g.a.j.p.S.selectOne - <== Total: 1 > Mar 28 19:10:53 shinken server: 19:10:53.945 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC > Connection [com.mysql.jdbc.JDBC4Connection@1c657887] > Mar 28 19:10:53 shinken server: 19:10:53.946 [http-bio-8080-exec-6] DEBUG > o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc. > JDBC4Connection@1c657887] > Mar 28 19:10:53 shinken server: 19:10:53.946 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ... > Mar 28 19:10:53 shinken server: 19:10:53.946 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD! > Mar 28 19:10:53 shinken server: 19:10:53.946 [http-bio-8080-exec-6] DEBUG > o.a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool. > > > > --f403045f517c44abe9054cd2c701 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Mike,

Any help on this issue ?
=



On Tue, Mar 28, 2017 at 8:06 PM, Anburaj Palraj <an= burajrhce@gmail.com> wrote:
Hi Mike,

As you asked find the logs = below =C2=A0.i have tested this on my test machine and at this time , only = one connection was there .=C2=A0

=
[root@shinken log]# c= at =C2=A0guacamole.txt
Mar 28 19:09:38 shin= ken server: 19:09:38.366 [http-bio-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTra= nsaction - Opening JDBC Connection
Mar 28 1= 9:09:38 shinken server: 19:09:38.366 [http-bio-8080-exec-10] DEBUG o.a.i.d.= pooled.PooledDataSource - Checked out connection 476412039 from pool.<= /div>
Mar 28 19:09:38 shinken server: 19:09:38.36= 6 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Test= ing connection 476412039 ...
Mar 28 19:09:3= 8 shinken server: 19:09:38.367 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled= .PooledDataSource - Connection 476412039 is GOOD!
Mar 28 19:09:38 shinken server: 19:09:38.367 [http-bio-8080-exe= c-10] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on J= DBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.367 [http-bio-8= 080-exec-10] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> =C2=A0Preparing: SE= LECT guacamole_system_permission.user_id, username, permission FROM gu= acamole_system_permission JOIN guacamole_user ON guacamole_system_permissio= n.user_id =3D guacamole_user.user_id WHERE guacamole_system_permission= .user_id =3D ? AND permission =3D ?
Ma= r 28 19:09:38 shinken server: 19:09:38.368 [http-bio-8080-exec-10] DEBUG o.= a.g.a.j.p.S.selectOne - =3D=3D> Parameters: 1(Integer), ADMINISTER(Strin= g)
Mar 28 19:09:38 shinken server: 19:09:38= .369 [http-bio-8080-exec-10] DEBUG o.a.g.a.j.p.S.selectOne - <=3D=3D =C2= =A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 s= hinken server: 19:09:38.369 [http-bio-8080-exec-10] DEBUG o.a.i.t.jdbc.Jdbc= Transaction - Resetting autocommit to true on JDBC Connection [com.mysql.jd= bc.JDBC4Connection@1c657887]
Mar 28 19= :09:38 shinken server: 19:09:38.369 [http-bio-8080-exec-10] DEBUG o.a.i.t.j= dbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Con= nection@1c657887]
Mar 28 19:09:38 shinken s= erver: 19:09:38.369 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.Poole= dDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DE= BUG o.a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD!
Mar 28 19:09:38 shinken server: 19:09:38.370 = [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Return= ed connection 476412039 to pool.
Mar 28 19:= 09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBUG o.a.i.t.jd= bc.JdbcTransaction - Opening JDBC Connection
Mar 28 19:09:38 shinken server: 19:09:38.370 [http-bio-8080-exec-10] DEBU= G o.a.i.d.pooled.PooledDataSource - Checked out connection 476412039 f= rom pool.
Mar 28 19:09:38 shinken server: 1= 9:09:38.370 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSou= rce - Testing connection 476412039 ...
Mar = 28 19:09:38 shinken server: 19:09:38.371 [http-bio-8080-exec-10] DEBUG o.a.= i.d.pooled.PooledDataSource - Connection 476412039 is GOOD!
Mar 28 19:09:38 shinken server: 19:09:38.371 [http-bi= o-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to = false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.371 [= http-bio-8080-exec-10] DEBUG o.a.g.a.j.c.ConnectionMapper.select - =3D= =3D> =C2=A0Preparing: SELECT connection_id, connection_name, parent_id, = protocol, max_connections, max_connections_per_user FROM guacamole_connecti= on WHERE connection_id IN ( ? ) ; SELECT primary_connection_id, sharing_pro= file_id FROM guacamole_sharing_profile WHERE primary_connection_id IN ( ? )= ;
Mar 28 19:09:38 shinken server: 19:09:38= .371 [http-bio-8080-exec-10] DEBUG o.a.g.a.j.c.ConnectionMapper.select= - =3D=3D> Parameters: 59(String), 59(String)
Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] = DEBUG o.a.g.a.j.c.ConnectionMapper.select - <=3D=3D =C2=A0 =C2=A0 = =C2=A0Total: 1
Mar 28 19:09:38 shinken serv= er: 19:09:38.372 [http-bio-8080-exec-10] DEBUG o.a.g.a.j.c.ConnectionMapper= .select - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exe= c-10] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on = JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-= 8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection = [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.372 [http-bio-8080-exec-10] DE= BUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ...=
Mar 28 19:09:38 shinken server: 19:09:38.3= 73 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Con= nection 476412039 is GOOD!
Mar 28 19:09:38 = shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.<= wbr>PooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8= 080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
Mar 28 19:09:38 shinken server: 19:09:38.373= [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Check= ed out connection 476412039 from pool.
Mar = 28 19:09:38 shinken server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG o.a.= i.d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.373 [http= -bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Connection = 476412039 is GOOD!
Mar 28 19:09:38 shinken = server: 19:09:38.373 [http-bio-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransac= tion - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.= JDBC4Connection@1c657887]
Mar 28 19:09:38 s= hinken guacd[1290]: Creating new client for protocol "ssh"
<= div class=3D"gmail_extra">Mar 28 19:09:38 shinken server: 19:09:38.374 [htt= p-bio-8080-exec-10] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> =C2=A0Prepar= ing: SELECT guacamole_system_permission.user_id, username, permission = FROM guacamole_system_permission JOIN guacamole_user ON guacamole_system_pe= rmission.user_id =3D guacamole_user.user_id WHERE guacamole_system_per= mission.user_id =3D ? AND permission =3D ?
Mar 28 19:09:38 shinken server: 19:09:38.374 [http-bio-8080-exec-10] D= EBUG o.a.g.a.j.p.S.selectOne - =3D=3D> Parameters: 1(Integer), ADMINISTE= R(String)
Mar 28 19:09:38 shinken server: 1= 9:09:38.375 [http-bio-8080-exec-10] DEBUG o.a.g.a.j.p.S.selectOne - <=3D= =3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:= 09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG o.a.i.t.jd= bc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.m= ysql.jdbc.JDBC4Connection@1c657887]
Ma= r 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG o.= a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.J= DBC4Connection@1c657887]
Mar 28 19:09:38 sh= inken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec= -10] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 476412039 is G= OOD!
Mar 28 19:09:38 shinken server: 19:09:= 38.375 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource -= Returned connection 476412039 to pool.
Mar= 28 19:09:38 shinken server: 19:09:38.375 [http-bio-8080-exec-10] DEBUG o.m= .g.t.TransactionalMethodInterceptor - [Intercepted method: public org.apache.guacamole.net.G= uacamoleTunnel org.apache.guacamole.auth.jdbc.tunnel.AbstractGuac= amoleTunnelService.getGuacamoleTunnel(org.apache.guacamole.auth.j= dbc.user.ModeledAuthenticatedUser,org.apache.guacamole.auth.= jdbc.connection.ModeledConnection,org.apache.guacamole.protocol.<= wbr>GuacamoleClientInformation) throws org.apache.guacamole.GuacamoleE= xception] - SqlSession not set for thread: 32, creating a new one
Mar 28 19:09:38 shinken server: 19:09:38.376 [http-b= io-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connecti= on
Mar 28 19:09:38 shinken server: 19:09:38= .376 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - C= hecked out connection 476412039 from pool.
= Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG = o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken guacd[1290]: Connectio= n ID is "$14e5d900-7d97-4268-9df9-bb7ce68198b1"
Mar 28 19:09:38 shinken server: 19:09:38.376 [http-bio-= 8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 47641= 2039 is GOOD!
Mar 28 19:09:38 shinken serve= r: 19:09:38.376 [http-bio-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransaction = - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4= Connection@1c657887]
Mar 28 19:09:38 shinke= n server: 19:09:38.376 [http-bio-8080-exec-10] DEBUG o.a.g.a.j.c.C.select -= =3D=3D> =C2=A0Preparing: SELECT connection_id, parameter_name, paramete= r_value FROM guacamole_connection_parameter WHERE connection_id =3D ?
=
Mar 28 19:09:38 shinken server: 19:09:38.377 [ht= tp-bio-8080-exec-10] DEBUG o.a.g.a.j.c.C.select - =3D=3D> Parameters: 59= (String)
Mar 28 19:09:38 shinken server: 19= :09:38.379 [http-bio-8080-exec-10] DEBUG o.a.g.a.j.c.C.select - <=3D=3D = =C2=A0 =C2=A0 =C2=A0Total: 7
Mar 28 19:09:3= 8 shinken server: 19:09:38.379 [http-bio-8080-exec-10] DEBUG o.a.g.net.Inet= GuacamoleSocket - Connecting to guacd at localhost:4822.
Mar 28 19:09:38 shinken guacd[1670]: Current locale does not = use UTF-8. Some characters may not render correctly.
Mar 28 19:09:38 shinken guacd[1670]: User "@c904d101-24a2-47= aa-9421-a4f116d21720" joined connection "$14e5d900-7d97-4268= -9df9-bb7ce68198b1" (1 users now present)
Mar 28 19:09:38 shinken server: 19:09:38.435 [http-bio-8080-exec-1= 0] DEBUG o.m.g.t.TransactionalMethodInterceptor - [Intercepted method:= public org.apache.guacamole.ne= t.GuacamoleTunnel org.apache.guacamole.auth.jdbc.tunnel.= AbstractGuacamoleTunnelService.getGuacamoleTunnel(org.apache.guac= amole.auth.jdbc.user.ModeledAuthenticatedUser,org.apache.guacamol= e.auth.jdbc.connection.ModeledConnection,org.apache.guacamol= e.protocol.GuacamoleClientInformation) throws org.apache.guacamole.GuacamoleException] - SqlSession of thread: 32 committing
Mar 28 19:09:38 shinken server: 19:09:38.436 [http-bio-808= 0-exec-10] DEBUG o.m.g.t.TransactionalMethodInterceptor - [Intercepted= method: public org.apache.guac= amole.net.GuacamoleTunnel org.apache.guacamole.auth.jdbc.tunn= el.AbstractGuacamoleTunnelService.getGuacamoleTunnel(org.apa= che.guacamole.auth.jdbc.user.ModeledAuthenticatedUser,org.apache.= guacamole.auth.jdbc.connection.ModeledConnection,org.apache.= guacamole.protocol.GuacamoleClientInformation) throws org.apache.guaca= mole.GuacamoleException] - SqlSession of thread: 32 terminated its lif= e-cycle, closing it
Mar 28 19:09:38 shinken= server: 19:09:38.436 [http-bio-8080-exec-10] DEBUG o.a.i.t.jdbc.JdbcTransa= ction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38= shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG o.a.i.t.jdbc.Jd= bcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connectio= n@1c657887]
Mar 28 19:09:38 shinken server:= 19:09:38.437 [http-bio-8080-exec-10] DEBUG o.a.i.d.pooled.PooledDataS= ource - Testing connection 476412039 ...
Ma= r 28 19:09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG o.= a.i.d.pooled.PooledDataSource - Connection 476412039 is GOOD!
Mar 28 19:09:38 shinken guacd[1670]: Recording of s= ession will be saved to "/root/recording/172.25.14.58.4".
Mar 28 19= :09:38 shinken server: 19:09:38.437 [http-bio-8080-exec-10] DEBUG o.a.i.d.p= ooled.PooledDataSource - Returned connection 476412039 to pool.
<= div class=3D"gmail_extra">Mar 28 19:09:38 shinken server: 19:09:38.437 [htt= p-bio-8080-exec-10] INFO =C2=A0o.a.g.tunnel.TunnelRequestService - Use= r "guacadmin" connected to connection "59".
Mar 28 19:09:38 shinken guacd[1670]: Typescript of ter= minal session will be saved to "/root/smg/txt/172.25.14.58.8". Timing file is "/root/smg/txt/172.25.14.58.8.timing".
Mar 28 19:09:38 shinken server: 19:09:38.478 [= http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Con= nection
Mar 28 19:09:38 shinken server: 19:= 09:38.478 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource= - Checked out connection 476412039 from pool.
Mar 28 19:09:38 shinken server: 19:09:38.478 [http-bio-8080-exec-9] DEB= UG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ...<= /div>
Mar 28 19:09:38 shinken server: 19:09:38.47= 9 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Conne= ction 476412039 is GOOD!
Mar 28 19:09:38 sh= inken server: 19:09:38.479 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTr= ansaction - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.= JDBC4Connection@1c657887]
Mar 28 19:09= :38 shinken server: 19:09:38.480 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S= .selectOne - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission= .user_id, username, permission FROM guacamole_system_permission JOIN g= uacamole_user ON guacamole_system_permission.user_id =3D guacamole_use= r.user_id WHERE guacamole_system_permission.user_id =3D ? AND permissi= on =3D ?
Mar 28 19:09:38 shinken server: 19= :09:38.481 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D>= ; Parameters: 1(Integer), ADMINISTER(String)
Mar 28 19:09:38 shinken server: 19:09:38.482 [http-bio-8080-exec-9] DEBUG= o.a.g.a.j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.482 [http-= bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit = to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.482= [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC C= onnection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.482 [http-bio-8080-e= xec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 4764= 12039 ...
Mar 28 19:09:38 shinken server: 1= 9:09:38.487 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSour= ce - Connection 476412039 is GOOD!
Mar 28 1= 9:09:38 shinken server: 19:09:38.488 [http-bio-8080-exec-9] DEBUG o.a.i.d.p= ooled.PooledDataSource - Returned connection 476412039 to pool.
<= div class=3D"gmail_extra">Mar 28 19:09:38 shinken server: 19:09:38.490 [htt= p-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connec= tion
Mar 28 19:09:38 shinken server: 19:09:= 38.490 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - = Checked out connection 476412039 from pool.
Mar 28 19:09:38 shinken server: 19:09:38.490 [http-bio-8080-exec-9] DEBUG = o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.491 [= http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Connecti= on 476412039 is GOOD!
Mar 28 19:09:38 shink= en server: 19:09:38.491 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTrans= action - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38= shinken server: 19:09:38.491 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.se= lectOne - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission.user_id, username, permission FROM guacamole_system_permission JOIN guac= amole_user ON guacamole_system_permission.user_id =3D guacamole_user.u= ser_id WHERE guacamole_system_permission.user_id =3D ? AND permission = =3D ?
Mar 28 19:09:38 shinken server: 19:09= :38.492 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> P= arameters: 1(Integer), ADMINISTER(String)
M= ar 28 19:09:38 shinken server: 19:09:38.493 [http-bio-8080-exec-9] DEBUG o.= a.g.a.j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.493 [http-bio= -8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to = true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.494 [h= ttp-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Conn= ection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.494 [http-bio-8080-exec= -9] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 4764120= 39 ...
Mar 28 19:09:38 shinken server: 19:0= 9:38.494 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource = - Connection 476412039 is GOOD!
Mar 28 19:0= 9:38 shinken server: 19:09:38.494 [http-bio-8080-exec-9] DEBUG o.a.i.d.pool= ed.PooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:09:38 shinken server: 19:09:38.500 [http-b= io-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connectio= n
Mar 28 19:09:38 shinken server: 19:09:38.= 500 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Che= cked out connection 476412039 from pool.
Ma= r 28 19:09:38 shinken server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG o.a= .i.d.pooled.PooledDataSource - Testing connection 476412039 ...
<= div class=3D"gmail_extra">Mar 28 19:09:38 shinken server: 19:09:38.500 [htt= p-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Connection = 476412039 is GOOD!
Mar 28 19:09:38 shinken = server: 19:09:38.500 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransact= ion - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.J= DBC4Connection@1c657887]
Mar 28 19:09:38 sh= inken server: 19:09:38.501 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selec= tOne - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission.= user_id, username, permission FROM guacamole_system_permission JOIN guacamo= le_user ON guacamole_system_permission.user_id =3D guacamole_user.user= _id WHERE guacamole_system_permission.user_id =3D ? AND permission =3D= ?
Mar 28 19:09:38 shinken server: 19:09:38= .502 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> Para= meters: 1(Integer), ADMINISTER(String)
Mar = 28 19:09:38 shinken server: 19:09:38.512 [http-bio-8080-exec-9] DEBUG o.a.g= .a.j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.512 [http-bio-80= 80-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to tru= e on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.512 [http= -bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connect= ion [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.512 [http-bio-8080-exec-9]= DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 = ...
Mar 28 19:09:38 shinken server: 19:09:3= 8.513 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - C= onnection 476412039 is GOOD!
Mar 28 19:09:3= 8 shinken server: 19:09:38.513 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.= PooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:09:38 shinken server: 19:09:38.515 [http-bio-= 8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
Mar 28 19:09:38 shinken server: 19:09:38.515= [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Checke= d out connection 476412039 from pool.
Mar 2= 8 19:09:38 shinken server: 19:09:38.515 [http-bio-8080-exec-9] DEBUG o.a.i.= d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.516 [http-b= io-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 476= 412039 is GOOD!
Mar 28 19:09:38 shinken ser= ver: 19:09:38.516 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction= - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC= 4Connection@1c657887]
Mar 28 19:09:38 shink= en server: 19:09:38.517 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOn= e - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission.use= r_id, username, permission FROM guacamole_system_permission JOIN guacamole_= user ON guacamole_system_permission.user_id =3D guacamole_user.user_id= WHERE guacamole_system_permission.user_id =3D ? AND permission =3D ?<= /div>
Mar 28 19:09:38 shinken server: 19:09:38.51= 7 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> Paramet= ers: 1(Integer), ADMINISTER(String)
Mar 28 = 19:09:38 shinken server: 19:09:38.518 [http-bio-8080-exec-9] DEBUG o.a.g.a.= j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.518 [http-bio-808= 0-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true= on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.519 [http-= bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connecti= on [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] = DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 .= ..
Mar 28 19:09:38 shinken server: 19:09:38= .519 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Co= nnection 476412039 is GOOD!
Mar 28 19:09:38= shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.<= wbr>PooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:09:38 shinken server: 19:09:38.519 [http-bio-8= 080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
Mar 28 19:09:38 shinken server: 19:09:38.519 = [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Checked= out connection 476412039 from pool.
Mar 28= 19:09:38 shinken server: 19:09:38.519 [http-bio-8080-exec-9] DEBUG o.a.i.d= .pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.520 [http-bi= o-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 4764= 12039 is GOOD!
Mar 28 19:09:38 shinken serv= er: 19:09:38.520 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction = - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4= Connection@1c657887]
Mar 28 19:09:38 shinke= n server: 19:09:38.520 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.c.ConnectionM= apper.select - =3D=3D> =C2=A0Preparing: SELECT connection_id, conne= ction_name, parent_id, protocol, max_connections, max_connections_per_user = FROM guacamole_connection WHERE connection_id IN ( ? ) ; SELECT primary_con= nection_id, sharing_profile_id FROM guacamole_sharing_profile WHERE primary= _connection_id IN ( ? ) ;
Mar 28 19:09:38 s= hinken server: 19:09:38.520 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.c.Connec= tionMapper.select - =3D=3D> Parameters: 59(String), 59(String)
Mar 28 19:09:38 shinken server: 19:09:38.521 [h= ttp-bio-8080-exec-9] DEBUG o.a.g.a.j.c.ConnectionMapper.select - <= =3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 = 19:09:38 shinken server: 19:09:38.521 [http-bio-8080-exec-9] DEBUG o.a.g.a.= j.c.ConnectionMapper.select - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1<= /div>
Mar 28 19:09:38 shinken server: 19:09:38.52= 1 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting aut= ocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c6= 57887]
Mar 28 19:09:38 shinken server: 19:0= 9:38.526 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closin= g JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.526 [http-bi= o-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connect= ion 476412039 ...
Mar 28 19:09:38 shinken s= erver: 19:09:38.527 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.Pooled= DataSource - Connection 476412039 is GOOD!
= Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9] DEBUG o= .a.i.d.pooled.PooledDataSource - Returned connection 476412039 to pool= .
Mar 28 19:09:38 shinken server: 19:09:38.= 527 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDB= C Connection
Mar 28 19:09:38 shinken server= : 19:09:38.527 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataS= ource - Checked out connection 476412039 from pool.
Mar 28 19:09:38 shinken server: 19:09:38.527 [http-bio-8080-exec-9= ] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039= ...
Mar 28 19:09:38 shinken server: 19:09:= 38.528 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - = Connection 476412039 is GOOD!
Mar 28 19:09:= 38 shinken server: 19:09:38.528 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.J= dbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.= jdbc.JDBC4Connection@1c657887]
Mar 28 = 19:09:38 shinken server: 19:09:38.528 [http-bio-8080-exec-9] DEBUG o.a.g.a.= j.p.S.selectOne - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permi= ssion.user_id, username, permission FROM guacamole_system_permission J= OIN guacamole_user ON guacamole_system_permission.user_id =3D guacamol= e_user.user_id WHERE guacamole_system_permission.user_id =3D ? AND per= mission =3D ?
Mar 28 19:09:38 shinken serve= r: 19:09:38.528 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOne - =3D= =3D> Parameters: 1(Integer), ADMINISTER(String)
Mar 28 19:09:38 shinken server: 19:09:38.529 [http-bio-8080-exec-9]= DEBUG o.a.g.a.j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.530 = [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autoc= ommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657= 887]
Mar 28 19:09:38 shinken server: 19:09:= 38.530 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing = JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.530 [http-bio-= 8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Testing connectio= n 476412039 ...
Mar 28 19:09:38 shinken ser= ver: 19:09:38.530 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDa= taSource - Connection 476412039 is GOOD!
Ma= r 28 19:09:38 shinken server: 19:09:38.530 [http-bio-8080-exec-9] DEBUG o.a= .i.d.pooled.PooledDataSource - Returned connection 476412039 to pool.<= /div>
Mar 28 19:09:38 shinken server: 19:09:38.53= 0 [http-bio-8080-exec-9] DEBUG o.m.g.t.TransactionalMethodInterceptor = - [Intercepted method: public java.util.Collection<org.apache.guaca= mole.net.auth.SharingProfile> org.apache.guacamole.auth.jdbc.s= haringprofile.SharingProfileDirectory.getAll(java.util.Collection= <java.lang.String>) throws org.apache.guacamole.GuacamoleEx= ception] - SqlSession not set for thread: 31, creating a new one
Mar 28 19:09:38 shinken server: 19:09:38.531 [http-bi= o-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection=
Mar 28 19:09:38 shinken server: 19:09:38.5= 31 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Chec= ked out connection 476412039 from pool.
Mar= 28 19:09:38 shinken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG o.a.= i.d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.531 [http= -bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 4= 76412039 is GOOD!
Mar 28 19:09:38 shinken s= erver: 19:09:38.531 [http-bio-8080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransacti= on - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JD= BC4Connection@1c657887]
Mar 28 19:09:38 shi= nken server: 19:09:38.531 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.select= One - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission.u= ser_id, username, permission FROM guacamole_system_permission JOIN guacamol= e_user ON guacamole_system_permission.user_id =3D guacamole_user.user_= id WHERE guacamole_system_permission.user_id =3D ? AND permission =3D = ?
Mar 28 19:09:38 shinken server: 19:09:38.= 531 [http-bio-8080-exec-9] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> Param= eters: 1(Integer), ADMINISTER(String)
Mar 2= 8 19:09:38 shinken server: 19:09:38.532 [http-bio-8080-exec-9] DEBUG o.a.g.= a.j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:09:38 shinken server: 19:09:38.533 [http-bio-808= 0-exec-9] DEBUG o.a.g.a.j.s.S.select - =3D=3D> =C2=A0Preparing: SELECT s= haring_profile_id, sharing_profile_name, primary_connection_id FROM guacamo= le_sharing_profile WHERE sharing_profile_id IN ( ? )
Mar 28 19:09:38 shinken server: 19:09:38.533 [http-bio-8080-exec-= 9] DEBUG o.a.g.a.j.s.S.select - =3D=3D> Parameters: 1(String)
Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bi= o-8080-exec-9] DEBUG o.a.g.a.j.s.S.select - <=3D=3D =C2=A0 =C2=A0 =C2=A0= Total: 1
Mar 28 19:09:38 shinken server: 19= :09:38.534 [http-bio-8080-exec-9] DEBUG o.m.g.t.TransactionalMethodInt= erceptor - [Intercepted method: public java.util.Collection<org.apa= che.guacamole.net.auth.SharingProfile> org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.C= ollection<java.lang.String>) throws org.apache.guacamole.Gu= acamoleException] - SqlSession of thread: 31 committing
Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-ex= ec-9] DEBUG o.m.g.t.TransactionalMethodInterceptor - [Intercepted meth= od: public java.util.Collection<org.apache.guacamole.net.auth.= SharingProfile> org.apache.guacamole.auth.jdbc.sharingprofile.= SharingProfileDirectory.getAll(java.util.Collection<java.lang.= String>) throws org.apache.guacamole.GuacamoleException] - SqlSessi= on of thread: 31 terminated its life-cycle, closing it
Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exe= c-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on J= DBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8= 080-exec-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection [c= om.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:09:38 shinken server: 19:09:38.534 [http-bio-8080-exec-9] DEBUG= o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:09:38 shinken server: 19:09:38.537 = [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.PooledDataSource - Connect= ion 476412039 is GOOD!
Mar 28 19:09:38 shin= ken server: 19:09:38.537 [http-bio-8080-exec-9] DEBUG o.a.i.d.pooled.P= ooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:09:44 shinken guacd[1670]: SSH connection successfu= l.
Mar 28 19:10:15 shinken server: 19:10:15= .156 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap - Che= cking for expired sessions...
Mar 28 19:10:= 15 shinken server: 19:10:15.156 [pool-1-thread-1] DEBUG o.a.g.rest.auth.HashTokenSessionMap - Session check completed in 0 ms.
Mar 28 19:10:50 shinken guacd[1290]: Connection "$14e5d9= 00-7d97-4268-9df9-bb7ce68198b1" removed.
Mar 28 19:10:50 shinken server: 19:10:50.666 [Thread-9] INFO =C2=A0= o.a.g.tunnel.TunnelRequestService - User "guacadmin" disconn= ected from connection "59". Duration: 72229 milliseconds
Mar 28 19:10:50 shinken server: 19:10:50.666 [Threa= d-9] DEBUG o.a.g.net.InetGuacamoleSocket - Closing socket to guacd.
Mar 28 19:10:50 shinken server: 19:10:50.667 [Thre= ad-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
Mar 28 19:10:50 shinken server: 19:10:50.668 [Threa= d-9] DEBUG o.a.i.d.pooled.PooledDataSource - Checked out connection 47= 6412039 from pool.
Mar 28 19:10:50 shinken = server: 19:10:50.668 [Thread-9] DEBUG o.a.i.d.pooled.PooledDataSource = - Testing connection 476412039 ...
Mar 28 1= 9:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG o.a.i.d.pooled.P= ooledDataSource - Connection 476412039 is GOOD!
Mar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG o.a.i.t.= jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.= mysql.jdbc.JDBC4Connection@1c657887]
M= ar 28 19:10:50 shinken server: 19:10:50.668 [Thread-9] DEBUG o.a.g.a.j.c.C.= insert - =3D=3D> =C2=A0Preparing: INSERT INTO guacamole_connection_histo= ry ( connection_id, connection_name, sharing_profile_id, sharing_profile_na= me, user_id, username, start_date, end_date ) VALUES ( ?, ?, ?, ?, (SELECT = user_id FROM guacamole_user WHERE username =3D ?), ?, ?, ? )
Mar 28 19:10:50 shinken server: 19:10:50.670 [Thread-9] D= EBUG o.a.g.a.j.c.C.insert - =3D=3D> Parameters: 59(String), NAGIOS =C2= =A0(172.25.14.58)(String), null, null, guacadmin(String), guacadmin(String)= , 2017-03-28 19:09:38.376(Timestamp), 2017-03-28 19:10:50.667(Timestamp)
Mar 28 19:10:50 shinken server: 19:10:50.670 = [Thread-9] DEBUG o.a.g.a.j.c.C.insert - <=3D=3D =C2=A0 =C2=A0Updates: 1<= /div>
Mar 28 19:10:50 shinken server: 19:10:50.67= 1 [Thread-9] DEBUG o.a.i.t.jdbc.JdbcTransaction - Committing JDBC Connectio= n [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:10:50 shinken server: 19:10:50.672 [Thread-9] DEBUG o.a.i.t= .jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [co= m.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:10:50 shinken server: 19:10:50.672 [Thread-9] DEBUG o.a.i.t.jdbc= .JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connec= tion@1c657887]
Mar 28 19:10:50 shinken serv= er: 19:10:50.672 [Thread-9] DEBUG o.a.i.d.pooled.PooledDataSource - Te= sting connection 476412039 ...
Mar 28 19:10= :50 shinken server: 19:10:50.673 [Thread-9] DEBUG o.a.i.d.pooled.Poole= dDataSource - Connection 476412039 is GOOD!
Mar 28 19:10:50 shinken server: 19:10:50.673 [Thread-9] DEBUG o.a.i.d.pool= ed.PooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:10:53 shinken server: 19:10:53.937 [http-b= io-8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connectio= n
Mar 28 19:10:53 shinken server: 19:10:53.= 938 [http-bio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - Che= cked out connection 476412039 from pool.
Ma= r 28 19:10:53 shinken server: 19:10:53.938 [http-bio-8080-exec-6] DEBUG o.a= .i.d.pooled.PooledDataSource - Testing connection 476412039 ...
<= div class=3D"gmail_extra">Mar 28 19:10:53 shinken server: 19:10:53.938 [htt= p-bio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - Connection = 476412039 is GOOD!
Mar 28 19:10:53 shinken = server: 19:10:53.938 [http-bio-8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransact= ion - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.J= DBC4Connection@1c657887]
Mar 28 19:10:53 sh= inken server: 19:10:53.940 [http-bio-8080-exec-6] DEBUG o.a.g.a.j.p.S.selec= tOne - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission.= user_id, username, permission FROM guacamole_system_permission JOIN guacamo= le_user ON guacamole_system_permission.user_id =3D guacamole_user.user= _id WHERE guacamole_system_permission.user_id =3D ? AND permission =3D= ?
Mar 28 19:10:53 shinken server: 19:10:53= .940 [http-bio-8080-exec-6] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> Para= meters: 1(Integer), ADMINISTER(String)
Mar = 28 19:10:53 shinken server: 19:10:53.941 [http-bio-8080-exec-6] DEBUG o.a.g= .a.j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:10:53 shinken server: 19:10:53.941 [http-bio-80= 80-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to tru= e on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:10:53 shinken server: 19:10:53.942 [http= -bio-8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connect= ion [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6]= DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 = ...
Mar 28 19:10:53 shinken server: 19:10:5= 3.942 [http-bio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - C= onnection 476412039 is GOOD!
Mar 28 19:10:5= 3 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG o.a.i.d.pooled.= PooledDataSource - Returned connection 476412039 to pool.
Mar 28 19:10:53 shinken server: 19:10:53.942 [http-bio-= 8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
Mar 28 19:10:53 shinken server: 19:10:53.942= [http-bio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - Checke= d out connection 476412039 from pool.
Mar 2= 8 19:10:53 shinken server: 19:10:53.942 [http-bio-8080-exec-6] DEBUG o.a.i.= d.pooled.PooledDataSource - Testing connection 476412039 ...
Mar 28 19:10:53 shinken server: 19:10:53.943 [http-b= io-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - Connection 476= 412039 is GOOD!
Mar 28 19:10:53 shinken ser= ver: 19:10:53.943 [http-bio-8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction= - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC= 4Connection@1c657887]
Mar 28 19:10:53 shink= en server: 19:10:53.944 [http-bio-8080-exec-6] DEBUG o.a.g.a.j.p.S.selectOn= e - =3D=3D> =C2=A0Preparing: SELECT guacamole_system_permission.use= r_id, username, permission FROM guacamole_system_permission JOIN guacamole_= user ON guacamole_system_permission.user_id =3D guacamole_user.user_id= WHERE guacamole_system_permission.user_id =3D ? AND permission =3D ?<= /div>
Mar 28 19:10:53 shinken server: 19:10:53.94= 4 [http-bio-8080-exec-6] DEBUG o.a.g.a.j.p.S.selectOne - =3D=3D> Paramet= ers: 1(Integer), ADMINISTER(String)
Mar 28 = 19:10:53 shinken server: 19:10:53.945 [http-bio-8080-exec-6] DEBUG o.a.g.a.= j.p.S.selectOne - <=3D=3D =C2=A0 =C2=A0 =C2=A0Total: 1
Mar 28 19:10:53 shinken server: 19:10:53.945 [http-bio-808= 0-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true= on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:10:53 shinken server: 19:10:53.946 [http-= bio-8080-exec-6] DEBUG o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connecti= on [com.mysql.jdbc.JDBC4Connection@1c657887]
Mar 28 19:10:53 shinken server: 19:10:53.946 [http-bio-8080-exec-6] = DEBUG o.a.i.d.pooled.PooledDataSource - Testing connection 476412039 .= ..
Mar 28 19:10:53 shinken server: 19:10:53= .946 [http-bio-8080-exec-6] DEBUG o.a.i.d.pooled.PooledDataSource - Co= nnection 476412039 is GOOD!
Mar 28 19:10:53= shinken server: 19:10:53.946 [http-bio-8080-exec-6] DEBUG o.a.i.d.pooled.<= wbr>PooledDataSource - Returned connection 476412039 to pool.



--f403045f517c44abe9054cd2c701--