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
On Mon, Jun 28, 2021 at 9:11 AM Gallavardin Antoine <[email protected]> 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
-- 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
