Re: Web analytics

2022-09-07 Thread Michael Jumper
On Wed, Sep 7, 2022 at 5:50 AM Antoine Besnier
 wrote:
>
> Indeed, the branding extension need a CSS selector, so it will not work for 
> the head section.
> Maybe you can unzip guacamole-1.4.0.war, modifiy the file 
> app/element/templates/blank.html, and repackage and re-deploy the war file.
>

Please do not do this - that file has a very specific purpose and
needs to be what the name suggests: blank. It is also not advisable to
make changes to the web application directly, especially through
attempting to modify the .war file itself. Instead, the extension
system should be used (as you are already attempting to do).

Does this Umami tool require that things be added with a "script" tag?
If not, Guacamole's extension system provides its own method for
adding arbitrary JavaScript, and that would be much easier than
tracking down the best place for tag insertion. See the "js" entry for
guac-manifest.json:

https://guacamole.apache.org/doc/gug/guacamole-ext.html#extension-manifest

- Mike

-
To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
For additional commands, e-mail: user-h...@guacamole.apache.org



Re: Web analytics

2022-09-07 Thread Antoine Besnier
 Indeed, the branding extension need a CSS selector, so it will not work for 
the head section.Maybe you can unzip guacamole-1.4.0.war, modifiy the file 
app/element/templates/blank.html, and repackage and re-deploy the war file.
Antoine

Le mercredi 7 septembre 2022, 12:36:33 UTC+2, Lee Doughty 
 a écrit :  
 
 I don't think the head section is modifiable in that way.. you could probably 
use "body" selector and get it to load early in the page.
On Wed, Sep 7, 2022, 2:16 AM Kiel Hurley  wrote:


We have multiple Guacamole servers and I’d like to do web analytics to see how 
much they’re being used, and when.

 

umami (and it would be similar for Google Analytics) requires adding a script 
into the  section (https://umami.is/docs/collect-data). I created an 
extension with the following html file, and was hoping it would work:



https://analytics.example.com/umami.js";>

 

The Tomcat log says the extension loaded but it didn’t appear to work, as meta 
is trying to insert the line before the children of a CSS tag called “head” 
(https://guacamole.apache.org/doc/gug/guacamole-ext.html#updating-existing-html),
 which doesn’t exist.

 

I considered using the js extension resource instead of html, to copy the 
JavaScript file, but I need to include the GUID for the website so I’m not sure 
this would work.

 

Is there a way to insert the script line into the head using an extension? Or 
could there another way to achieve something similar?

 

Thanks

  

Re: Web analytics

2022-09-07 Thread Lee Doughty
I don't think the head section is modifiable in that way.. you could
probably use "body" selector and get it to load early in the page.

On Wed, Sep 7, 2022, 2:16 AM Kiel Hurley 
wrote:

> We have multiple Guacamole servers and I’d like to do web analytics to see
> how much they’re being used, and when.
>
>
>
> umami (and it would be similar for Google Analytics) requires adding a
> script into the  section (https://umami.is/docs/collect-data). I
> created an extension with the following html file, and was hoping it would
> work:
>
> 
>
> https://analytics.example.com/umami.js";>
>
>
>
> The Tomcat log says the extension loaded but it didn’t appear to work, as
> meta is trying to insert the line before the children of a CSS tag called
> “head” (
> https://guacamole.apache.org/doc/gug/guacamole-ext.html#updating-existing-html),
> which doesn’t exist.
>
>
>
> I considered using the js extension resource instead of html, to copy the
> JavaScript file, but I need to include the GUID for the website so I’m not
> sure this would work.
>
>
>
> Is there a way to insert the script line into the head using an extension?
> Or could there another way to achieve something similar?
>
>
>
> Thanks
>


RE: Guacamole RDP to W7 issues

2022-09-07 Thread Wiegman, Steve
I managed to fix the problem already. Apparently I had to choose "RDP 
Encryption" over "Any".

I was pretty sure I tried that out already, but it's working now.

Van: Wiegman, Steve 
Verzonden: woensdag 7 september 2022 11:09
Aan: user@guacamole.apache.org
Onderwerp: RE: Guacamole RDP to W7 issues

Sorry I didn't thought about the language difference.

Security mode is currently on "Any" (Ieder), but I tried all the different 
options already and none of them seem to work.
NLA is disabled on the Windows 7 client by default using a group policy. (See 
attachment)

Is there a guacd log? As far as I know, by default, Guacamole logs all messages 
to the console which Tomcat redirects to Catalina.out


Van: MAURIZI Lorenzo 
mailto:l.maur...@comune.jesi.an.it>>
Verzonden: woensdag 7 september 2022 09:05
Aan: user@guacamole.apache.org
Onderwerp: R: Guacamole RDP to W7 issues

It could be the Security mode (Beveiligins modus ?). It should be something 
different from NLA, I think Windows 7 does not support it. Leder means 
automatic?

In any case, to track down the issue, it could be useful a part of the guacd 
log instead of the catalina.out of guacamole.

Regards
Lorenzo


Da: Wiegman, Steve 
mailto:steve.wieg...@thyssenkrupp.com>>
Inviato: mercoledì 7 settembre 2022 08:56
A: user@guacamole.apache.org
Oggetto: Guacamole RDP to W7 issues

Hi all,

We recently upgraded our Guacamole server from version 0.9.14 to 1.4.0. We did 
a fresh install and didn't migrate any old data.

Everything seems to be working fine except for the Remote Desktop connections 
to Windows 7 machines. It instantly disconnects whenever we try to connect to a 
server. Windows 10 however is working just fine.


  *   The Windows 7 client and Guacamole server can both ping each-other.
  *   Port 3389 on the Windows 7 client is open. (I checked using telnet)
  *   Using other clients I can create a RDP connection to the Windows 7 client 
without any problems. It's just the RDP connection from Guacamole tot he client.

I can't really figure out what's wrong, maybe you guys see what I'm missing.

My Guacamole RDP settings:

[cid:image001.jpg@01D8C2AD.CC161680]
[Afbeelding met tekst  Automatisch gegenereerde beschrijving]

Catalina.out log (last 50 lines DEBUG):

[2022-09-07 06:51:27] [info] 06:51:27.637 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 1360630681 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Checked out connection 131714390 from pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==>  Preparing: SELECT DISTINCT ? AS entity_id, 
permission FROM guacamole_system_permission WHERE ( entity_id = ? OR entity_id 
IN ( SELECT guacamole_entity.entity_id FROM guacamole_entity JOIN 
guacamole_user_group ON guacamole_user_group.entity_id = 
guacamole_entity.entity_id WHERE type = 'USER_GROUP' AND name IN ( ? ) AND 
disabled = false ) ) AND permission = ?
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==> Parameters: 3(Integer), 3(Integer), SBA(String), 
ADMINISTER(String)
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - <==  Total: 1
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 131714390 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 

RE: Guacamole RDP to W7 issues

2022-09-07 Thread Wiegman, Steve
Sorry I didn't thought about the language difference.

Security mode is currently on "Any" (Ieder), but I tried all the different 
options already and none of them seem to work.
NLA is disabled on the Windows 7 client by default using a group policy. (See 
attachment)

Is there a guacd log? As far as I know, by default, Guacamole logs all messages 
to the console which Tomcat redirects to Catalina.out


Van: MAURIZI Lorenzo 
Verzonden: woensdag 7 september 2022 09:05
Aan: user@guacamole.apache.org
Onderwerp: R: Guacamole RDP to W7 issues

It could be the Security mode (Beveiligins modus ?). It should be something 
different from NLA, I think Windows 7 does not support it. Leder means 
automatic?

In any case, to track down the issue, it could be useful a part of the guacd 
log instead of the catalina.out of guacamole.

Regards
Lorenzo


Da: Wiegman, Steve 
mailto:steve.wieg...@thyssenkrupp.com>>
Inviato: mercoledì 7 settembre 2022 08:56
A: user@guacamole.apache.org
Oggetto: Guacamole RDP to W7 issues

Hi all,

We recently upgraded our Guacamole server from version 0.9.14 to 1.4.0. We did 
a fresh install and didn't migrate any old data.

Everything seems to be working fine except for the Remote Desktop connections 
to Windows 7 machines. It instantly disconnects whenever we try to connect to a 
server. Windows 10 however is working just fine.


  *   The Windows 7 client and Guacamole server can both ping each-other.
  *   Port 3389 on the Windows 7 client is open. (I checked using telnet)
  *   Using other clients I can create a RDP connection to the Windows 7 client 
without any problems. It's just the RDP connection from Guacamole tot he client.

I can't really figure out what's wrong, maybe you guys see what I'm missing.

My Guacamole RDP settings:

[cid:image001.jpg@01D8C2AA.25C22920]
[Afbeelding met tekst  Automatisch gegenereerde beschrijving]

Catalina.out log (last 50 lines DEBUG):

[2022-09-07 06:51:27] [info] 06:51:27.637 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 1360630681 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Checked out connection 131714390 from pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==>  Preparing: SELECT DISTINCT ? AS entity_id, 
permission FROM guacamole_system_permission WHERE ( entity_id = ? OR entity_id 
IN ( SELECT guacamole_entity.entity_id FROM guacamole_entity JOIN 
guacamole_user_group ON guacamole_user_group.entity_id = 
guacamole_entity.entity_id WHERE type = 'USER_GROUP' AND name IN ( ? ) AND 
disabled = false ) ) AND permission = ?
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==> Parameters: 3(Integer), 3(Integer), SBA(String), 
ADMINISTER(String)
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - <==  Total: 1
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 131714390 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession not set for 
thread: 26, creating a new one
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 

R: Guacamole RDP to W7 issues

2022-09-07 Thread MAURIZI Lorenzo
It could be the Security mode (Beveiligins modus ?). It should be something 
different from NLA, I think Windows 7 does not support it. Leder means 
automatic?

In any case, to track down the issue, it could be useful a part of the guacd 
log instead of the catalina.out of guacamole.

Regards
Lorenzo


Da: Wiegman, Steve 
Inviato: mercoledì 7 settembre 2022 08:56
A: user@guacamole.apache.org
Oggetto: Guacamole RDP to W7 issues

Hi all,

We recently upgraded our Guacamole server from version 0.9.14 to 1.4.0. We did 
a fresh install and didn't migrate any old data.

Everything seems to be working fine except for the Remote Desktop connections 
to Windows 7 machines. It instantly disconnects whenever we try to connect to a 
server. Windows 10 however is working just fine.


  *   The Windows 7 client and Guacamole server can both ping each-other.
  *   Port 3389 on the Windows 7 client is open. (I checked using telnet)
  *   Using other clients I can create a RDP connection to the Windows 7 client 
without any problems. It's just the RDP connection from Guacamole tot he client.

I can't really figure out what's wrong, maybe you guys see what I'm missing.

My Guacamole RDP settings:

[cid:image003.jpg@01D8C298.F10FED40]
[Afbeelding met tekst  Automatisch gegenereerde beschrijving]

Catalina.out log (last 50 lines DEBUG):

[2022-09-07 06:51:27] [info] 06:51:27.637 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 1360630681 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Checked out connection 131714390 from pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==>  Preparing: SELECT DISTINCT ? AS entity_id, 
permission FROM guacamole_system_permission WHERE ( entity_id = ? OR entity_id 
IN ( SELECT guacamole_entity.entity_id FROM guacamole_entity JOIN 
guacamole_user_group ON guacamole_user_group.entity_id = 
guacamole_entity.entity_id WHERE type = 'USER_GROUP' AND name IN ( ? ) AND 
disabled = false ) ) AND permission = ?
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==> Parameters: 3(Integer), 3(Integer), SBA(String), 
ADMINISTER(String)
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - <==  Total: 1
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 131714390 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession not set for 
thread: 26, creating a new one
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession of thread: 26 
committing
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession of thread: 26 
terminated its life-cycle, closing it
[2022-09-07 06:51:27] [info] 06:51:27.902 [http-nio-80-exec-6] INFO  
o.a.g.tunnel.TunnelRequestService - User "*" disconnected from 

Guacamole RDP to W7 issues

2022-09-07 Thread Wiegman, Steve
Hi all,

We recently upgraded our Guacamole server from version 0.9.14 to 1.4.0. We did 
a fresh install and didn't migrate any old data.

Everything seems to be working fine except for the Remote Desktop connections 
to Windows 7 machines. It instantly disconnects whenever we try to connect to a 
server. Windows 10 however is working just fine.


  *   The Windows 7 client and Guacamole server can both ping each-other.
  *   Port 3389 on the Windows 7 client is open. (I checked using telnet)
  *   Using other clients I can create a RDP connection to the Windows 7 client 
without any problems. It's just the RDP connection from Guacamole tot he client.

I can't really figure out what's wrong, maybe you guys see what I'm missing.

My Guacamole RDP settings:

[cid:image001.png@01D8C296.C9D6A540]
[Afbeelding met tekst  Automatisch gegenereerde beschrijving]

Catalina.out log (last 50 lines DEBUG):

[2022-09-07 06:51:27] [info] 06:51:27.637 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 1360630681 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Checked out connection 131714390 from pool.
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.638 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==>  Preparing: SELECT DISTINCT ? AS entity_id, 
permission FROM guacamole_system_permission WHERE ( entity_id = ? OR entity_id 
IN ( SELECT guacamole_entity.entity_id FROM guacamole_entity JOIN 
guacamole_user_group ON guacamole_user_group.entity_id = 
guacamole_entity.entity_id WHERE type = 'USER_GROUP' AND name IN ( ? ) AND 
disabled = false ) ) AND permission = ?
[2022-09-07 06:51:27] [info] 06:51:27.639 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - ==> Parameters: 3(Integer), 3(Integer), SBA(String), 
ADMINISTER(String)
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.g.a.j.p.S.selectOne - <==  Total: 1
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Closing JDBC Connection 
[com.mysql.cj.jdbc.ConnectionImpl@7d9cd56]
[2022-09-07 06:51:27] [info] 06:51:27.640 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Testing connection 131714390 ...
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Connection 131714390 is GOOD!
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.a.i.d.pooled.PooledDataSource - Returned connection 131714390 to pool.
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession not set for 
thread: 26, creating a new one
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession of thread: 26 
committing
[2022-09-07 06:51:27] [info] 06:51:27.641 [http-nio-80-exec-10] DEBUG 
o.m.g.t.TransactionalMethodInterceptor - [Intercepted method: public 
java.util.Collection 
org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.getAll(java.util.Collection)
 throws org.apache.guacamole.GuacamoleException] - SqlSession of thread: 26 
terminated its life-cycle, closing it
[2022-09-07 06:51:27] [info] 06:51:27.902 [http-nio-80-exec-6] INFO  
o.a.g.tunnel.TunnelRequestService - User "*" disconnected from connection 
"176". Duration: 342 milliseconds
[2022-09-07 06:51:27] [info] 06:51:27.902 [http-nio-80-exec-6] DEBUG 
o.a.g.net.InetGuacamoleSocket - Closing socket to guacd.
[2022-09-07 06:51:27] [info] 06:51:27.903 [http-nio-80-exec-6] DEBUG 
o.a.i.t.jdbc.JdbcTransaction - Opening JDBC Connection
[2022-09-07 06:51:27] [info] 06:51:27.903 [http-nio-80-exec-6] DEBUG 
o.a.i.d.pooled.PooledDataSource - Checked out connection 152105523 from 

Web analytics

2022-09-07 Thread Kiel Hurley
We have multiple Guacamole servers and I'd like to do web analytics to see how 
much they're being used, and when.

umami (and it would be similar for Google Analytics) requires adding a script 
into the  section (https://umami.is/docs/collect-data). I created an 
extension with the following html file, and was hoping it would work:

https://analytics.example.com/umami.js";>

The Tomcat log says the extension loaded but it didn't appear to work, as meta 
is trying to insert the line before the children of a CSS tag called "head" 
(https://guacamole.apache.org/doc/gug/guacamole-ext.html#updating-existing-html),
 which doesn't exist.

I considered using the js extension resource instead of html, to copy the 
JavaScript file, but I need to include the GUID for the website so I'm not sure 
this would work.

Is there a way to insert the script line into the head using an extension? Or 
could there another way to achieve something similar?

Thanks