Hi Mike, Yes it is only for SSH protocol .
*you're managing to select 200+ lines of text,does this mean your terminal window is enormous and 200+ rows tall?* I managed to select 200+ lines by pressing right click with scroll up in mouse . In normal putty if i want to copy more output in terminal window i setup the below values . so that i can scroll up and copy almost all the data . [image: Inline image 1] On Mon, Apr 17, 2017 at 11:27 PM, Mike Jumper <[email protected]> wrote: > Hi Anburaj, > > No, I think there's nothing left but to try to reproduce this on our > end and see if this is a bug. It would be helpful to know whether you > are seeing this with the other protocols, or if it only occurs with > SSH, but if this is reproducible then the only possibility is that > it's a bug; connections should not die upon copying text into the > clipboard. > > If this is just SSH, and you're managing to select 200+ lines of text, > does this mean your terminal window is enormous and 200+ rows tall? > Even full screen, typical terminal window sizes tend to be around 60 - > 80 lines at most. I ask because the means by which you are selecting > so many lines of text within SSH is likely relevant to reproducing > what you're seeing. > > - Mike > > > On Mon, Apr 17, 2017 at 10:43 AM, Anburaj Palraj <[email protected]> > wrote: > > Hi Mike, > > > > Any help on this issue ? > > > > > > > > On Mon, Apr 10, 2017 at 10:20 PM, Anburaj Palraj <[email protected]> > > wrote: > >> > >> Hi Mike, > >> > >> Any help on this issue ? > >> > >> > >> > >> On Tue, Mar 28, 2017 at 8:06 PM, Anburaj Palraj <[email protected]> > >> 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. > >>> > >>> > >>> > >> > > > >
