Hi Mike,

Any help on this issue ?



On Tue, Mar 28, 2017 at 8:06 PM, Anburaj Palraj <anburajrhce@gmail.com> 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.net.auth.SharingProfile> org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection<java.lang.String>) 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.net.auth.SharingProfile> org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection<java.lang.String>) 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.net.auth.SharingProfile> org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection<java.lang.String>) 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.