Hi Mike, Any help on this issue ?
On Tue, Mar 28, 2017 at 8:06 PM, Anburaj Palraj <anburajr...@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. > > > >