You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by Gallavardin Antoine <an...@inrae.fr> on 2021/06/28 16:11:22 UTC
connections group issue ?
hello
I'm facing to an issue which didn't allow me to provide guacamole in my
company (for the moment) .
I'd like to use connexion group in order to be more efficient to give access
to a lot of people .
I create an organizational group called "Sciences"
I create a connection "testIAM" and "testEL" inside this group
but thoses connections disappeared in the web interface (see screenshoot)
Strange isn't it ?
I checked in mariadb database : all seems OK :
MariaDB [guacamole_db]> select connection_id,connection_name,parent_id from guacamole_connection where parent_id=8;
+---------------+-----------------+-----------+
| connection_id | connection_name | parent_id |
+---------------+-----------------+-----------+
| 17 | testIAM | 8 |
| 18 | testEL | 8 |
+---------------+-----------------+-----------+
2 rows in set (0.001 sec)
MariaDB [guacamole_db]> select * from guacamole_connection_group WHERE connection_group_id=8;
+---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
| connection_group_id | parent_id | connection_group_name | type | max_connections | max_connections_per_user | enable_session_affinity |
+---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
| 8 | NULL | SCIENCES | ORGANIZATIONAL | NULL | NULL | 0 |
+---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
1 row in set (0.000 sec)
MariaDB [guacamole_db]>
no issue in JIRA gave me any clues
Log didn't help me a lot : except this message :
[http-nio-127.0.0.1-8080-exec-6] DEBUG o.a.g.rest.RESTExceptionMapper - Client request rejected: Session not associated with authentication provider "cas".
My instance : guacamole 1.3 ( same for extension) on debian buster with Mysql
backend ( mariadb to be more precise) for configuration and CAS backend for
authentification( lemonldap-ng with TOTP)
Do you have any Idea ?
Antoine
--
Antoine Gallavardin
Re: connections group issue ?
Posted by Gallavardin Antoine <an...@inrae.fr>.
Ok , well, next version is planned in next debian released (when it's ready)
so I thinks there no chance to update .
but I was able to backport manually :
root@guacsrv:~# wget <http://ftp.fr.debian.org/debian/pool/main/m/mariadb-connector-java/libmariadb-java_2.7.2-1_all.deb>
root@guacsrv:~# dpkg -i libmariadb-java_2.7.2-1_all.deb
root@guacsrv:/etc/guacamole/lib# ln -s /usr/share/java/mariadb-java-client.jar /etc/guacamole/lib/
root@guacsrv:/etc/guacamole/lib# systemctl restart tomcat9.service
Thank again for guacamole and congratulations for the 1.3.0 version !
Antoine
Le 28/06/2021 à 23:56, Mike Jumper a écrit :
> On Mon, Jun 28, 2021 at 2:47 PM Gallavardin Antoine
<[antoine.gallavardin@inrae.fr](mailto:antoine.gallavardin@inrae.fr)> wrote:
>
>
>> woops !
>>
>> you're right, I didn't rewind enough inside mail Archives .
>>
>> Thanks a lot !
>
>>
>> juste tested and approved !
>>
>> for the next debian guy ...
>
>>
>>
>> root@guacsrv:~# ls -al /etc/guacamole/lib/
>> lrwxrwxrwx 1 root root 39 nov. 20 2020 mariadb-java-client.jar ->
/usr/share/java/mariadb-java-client.jar
>> root@guacsrv:~# rm /etc/guacamole/lib/mariadb-java-client.jar
>> root@guacsrv:~# wget
<https://dlm.mariadb.com/1658656/Connectors/java/connector-java-2.7.3/mariadb-
java-client-2.7.3.jar> -O /etc/guacamole/lib/mariadb-java-client.jar
>> 2021-06-28 23:20:52 (15,5 MB/s) — « /etc/guacamole/lib/mariadb-java-
client.jar » sauvegardé [621971/621971]
>> root@ly-bastion:~# ls -al /etc/guacamole/lib/
>> -rw-r--r-- 1 root root 621971 mai 13 16:20 mariadb-java-client.jar
>> root@ly-bastion:~# systemctl restart tomcat9.service
>>
>> Do you want me to add an issue about documentation ?
>
>
>
>
> No, I think it would be better to open a bug report with Debian such that
the package in question can be updated.
>
>
>
>
> \- Mike
>
>
>
--
Antoine Gallavardin
INRAE - SIIR Auvergne Rhone Alpes - DSI-INFRA
5 rue de la Doua
CS 20244
69625 Villeurbanne Cedex
+33 4 72 20 86 19 (ligne directe)
+33 6 43 55 13 86
\--------------------------------------------------------------------- To
unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org For additional
commands, e-mail: user-help@guacamole.apache.org
Re: connections group issue ?
Posted by Mike Jumper <mi...@glyptodon.com>.
On Mon, Jun 28, 2021 at 2:47 PM Gallavardin Antoine <
antoine.gallavardin@inrae.fr> wrote:
> woops !
>
> you're right, I didn't rewind enough inside mail Archives .
>
> Thanks a lot !
>
> juste tested and approved !
>
> for the next debian guy ...
>
> root@guacsrv:~# ls -al /etc/guacamole/lib/
> lrwxrwxrwx 1 root root 39 nov. 20 2020 mariadb-java-client.jar -> /usr/share/java/mariadb-java-client.jar
> root@guacsrv:~# rm /etc/guacamole/lib/mariadb-java-client.jar
> root@guacsrv:~# wget https://dlm.mariadb.com/1658656/Connectors/java/connector-java-2.7.3/mariadb-java-client-2.7.3.jar -O /etc/guacamole/lib/mariadb-java-client.jar
> 2021-06-28 23:20:52 (15,5 MB/s) — « /etc/guacamole/lib/mariadb-java-client.jar » sauvegardé [621971/621971]
> root@ly-bastion:~# ls -al /etc/guacamole/lib/
> -rw-r--r-- 1 root root 621971 mai 13 16:20 mariadb-java-client.jar
> root@ly-bastion:~# systemctl restart tomcat9.service
>
> Do you want me to add an issue about documentation ?
>
No, I think it would be better to open a bug report with Debian such that
the package in question can be updated.
- Mike
Re: connections group issue ?
Posted by Gallavardin Antoine <an...@inrae.fr>.
woops !
you're right, I didn't rewind enough inside mail Archives .
Thanks a lot !
juste tested and approved !
for the next debian guy ...
root@guacsrv:~# ls -al /etc/guacamole/lib/
lrwxrwxrwx 1 root root 39 nov. 20 2020 mariadb-java-client.jar -> /usr/share/java/mariadb-java-client.jar
root@guacsrv:~# rm /etc/guacamole/lib/mariadb-java-client.jar
root@guacsrv:~# wget <https://dlm.mariadb.com/1658656/Connectors/java/connector-java-2.7.3/mariadb-java-client-2.7.3.jar> -O /etc/guacamole/lib/mariadb-java-client.jar
2021-06-28 23:20:52 (15,5 MB/s) — « /etc/guacamole/lib/mariadb-java-client.jar » sauvegardé [621971/621971]
root@ly-bastion:~# ls -al /etc/guacamole/lib/
-rw-r--r-- 1 root root 621971 mai 13 16:20 mariadb-java-client.jar
root@ly-bastion:~# systemctl restart tomcat9.service
Do you want me to add an issue about documentation ?
Antoine
Le 28/06/2021 à 22:26, Mike Jumper a écrit :
> On Mon, Jun 28, 2021 at 9:11 AM Gallavardin Antoine
<[antoine.gallavardin@inrae.fr](mailto:antoine.gallavardin@inrae.fr)> wrote:
>
>
>> hello
>>
>> I'm facing to an issue which didn't allow me to provide guacamole in my
company (for the moment) .
>>
>> I'd like to use connexion group in order to be more efficient to give
access to a lot of people .
>>
>> I create an organizational group called "Sciences"
>>
>> I create a connection "testIAM" and "testEL" inside this group
>
>>
>> but thoses connections disappeared in the web interface (see screenshoot)
>>
>> 
>>
>> Strange isn't it ?
>>
>> I checked in mariadb database : all seems OK :
>>
>>
>> MariaDB [guacamole_db]> select connection_id,connection_name,parent_id
from guacamole_connection where parent_id=8;
>>
>>
>> +---------------+-----------------+-----------+
>> | connection_id | connection_name | parent_id |
>> +---------------+-----------------+-----------+
>> | 17 | testIAM | 8 |
>> | 18 | testEL | 8 |
>> +---------------+-----------------+-----------+
>>
>>
>> 2 rows in set (0.001 sec)
>>
>>
>> MariaDB [guacamole_db]> select * from guacamole_connection_group WHERE
connection_group_id=8;
>>
>>
>>
+---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
>> | connection_group_id | parent_id | connection_group_name |
type | max_connections | max_connections_per_user |
enable_session_affinity |
>>
+---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
>> | 8 | NULL | SCIENCES |
ORGANIZATIONAL | NULL | NULL
| 0 |
>>
+---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
>>
>>
>> 1 row in set (0.000 sec)
>>
>>
>> MariaDB [guacamole_db]>
>>
>> no issue in JIRA gave me any clues
>>
>> Log didn't help me a lot : except this message :
>
>>
>>
>> [http-nio-127.0.0.1-8080-exec-6] DEBUG o.a.g.rest.RESTExceptionMapper -
Client request rejected: Session not associated with authentication provider
"cas".
>>
>>
>> My instance : guacamole 1.3 ( same for extension) on debian buster with
Mysql backend ( mariadb to be more precise) for configuration and CAS backend
for authentification( lemonldap-ng with TOTP)
>>
>> Do you have any Idea ?
>
>
>
>
> There was another post to the user@ list earlier this year with exactly this
behavior, and the answer ended up being the version of the MariaDB JDBC driver
("Connector/J"):
>
>
>
>
>
<https://lists.apache.org/thread.html/rfa8095ea61f4478b7073bf63a5f275fd9068cc09333099ab78762a14%40%3Cuser.guacamole.apache.org%3E>
>
>
>
>
> Michael Jumper
>
>
> CEO, Lead Developer
>
> [Glyptodon Inc](https://glyp.to/).
>
>
>
--
Antoine Gallavardin
INRAE - SIIR Auvergne Rhone Alpes - DSI-INFRA
5 rue de la Doua
CS 20244
69625 Villeurbanne Cedex
+33 4 72 20 86 19 (ligne directe)
+33 6 43 55 13 86
Re: connections group issue ?
Posted by Mike Jumper <mi...@glyptodon.com>.
On Mon, Jun 28, 2021 at 9:11 AM Gallavardin Antoine <
antoine.gallavardin@inrae.fr> wrote:
> hello
>
> I'm facing to an issue which didn't allow me to provide guacamole in my
> company (for the moment) .
>
> I'd like to use connexion group in order to be more efficient to give
> access to a lot of people .
>
> I create an organizational group called "Sciences"
>
> I create a connection "testIAM" and "testEL" inside this group
>
> but thoses connections disappeared in the web interface (see screenshoot)
>
> Strange isn't it ?
>
> I checked in mariadb database : all seems OK :
>
> MariaDB [guacamole_db]> select connection_id,connection_name,parent_id from guacamole_connection where parent_id=8;
>
> +---------------+-----------------+-----------+
> | connection_id | connection_name | parent_id |
> +---------------+-----------------+-----------+
> | 17 | testIAM | 8 |
> | 18 | testEL | 8 |
> +---------------+-----------------+-----------+
>
> 2 rows in set (0.001 sec)
>
> MariaDB [guacamole_db]> select * from guacamole_connection_group WHERE connection_group_id=8;
>
> +---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
> | connection_group_id | parent_id | connection_group_name | type | max_connections | max_connections_per_user | enable_session_affinity |
> +---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
> | 8 | NULL | SCIENCES | ORGANIZATIONAL | NULL | NULL | 0 |
> +---------------------+-----------+-----------------------+----------------+-----------------+--------------------------+-------------------------+
>
> 1 row in set (0.000 sec)
>
> MariaDB [guacamole_db]>
>
> no issue in JIRA gave me any clues
>
> Log didn't help me a lot : except this message :
>
> [http-nio-127.0.0.1-8080-exec-6] DEBUG o.a.g.rest.RESTExceptionMapper - Client request rejected: Session not associated with authentication provider "cas".
>
> My instance : guacamole 1.3 ( same for extension) on debian buster with
> Mysql backend ( mariadb to be more precise) for configuration and CAS
> backend for authentification( lemonldap-ng with TOTP)
>
> Do you have any Idea ?
>
There was another post to the user@ list earlier this year with exactly
this behavior, and the answer ended up being the version of the MariaDB
JDBC driver ("Connector/J"):
https://lists.apache.org/thread.html/rfa8095ea61f4478b7073bf63a5f275fd9068cc09333099ab78762a14%40%3Cuser.guacamole.apache.org%3E
Michael Jumper
CEO, Lead Developer
Glyptodon Inc <https://glyp.to/>.