Hi, here are the versions.
~$ cat /etc/os-release PRETTY_NAME="Debian GNU/Linux 10 (buster)" NAME="Debian GNU/Linux" VERSION_ID="10" VERSION="10 (buster)" VERSION_CODENAME=buster ID=debian HOME_URL="https://www.debian.org/"; SUPPORT_URL="https://www.debian.org/support"; BUG_REPORT_URL="https://bugs.debian.org/"; ~$ java -version openjdk version "11.0.9.1" 2020-11-04 OpenJDK Runtime Environment (build 11.0.9.1+1-post-Debian-1deb10u2) OpenJDK 64-Bit Server VM (build 11.0.9.1+1-post-Debian-1deb10u2, mixed mode, sharing) ~$ /usr/local/tomcat9/bin/version.sh Using CATALINA_BASE: /usr/local/tomcat9 Using CATALINA_HOME: /usr/local/tomcat9 Using CATALINA_TMPDIR: /usr/local/tomcat9/temp Using JRE_HOME: /usr/lib/jvm/java-11-openjdk-amd64/ Using CLASSPATH: /usr/local/tomcat9/bin/bootstrap.jar:/usr/local/tomcat9/bin/tomcat-juli.jar Using CATALINA_OPTS: NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED Server version: Apache Tomcat/9.0.41 Server built: Dec 3 2020 11:43:00 UTC Server number: 9.0.41.0 OS Name: Linux OS Version: 4.19.0-13-amd64 Architecture: amd64 JVM Version: 11.0.9.1+1-post-Debian-1deb10u2 JVM Vendor: Debian ~$ mariadb --version mariadb Ver 15.1 Distrib 10.3.27-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 And in the manifest.mf from mariadb-java-client.jar (which comes with "apt install libmariadb-java"): Bundle-Version: 2.3.0 Thanks again. I might try using packages not from debian repositories instead, or installing another OS alltogether, perhaps Ubuntu server ? Regards, --- Olivier Chaudet Service informatique du LMO - UMR 8628 Bureau 2R1, bât 307 Faculté des Sciences 91405 ORSAY (33)1.69.15.31.67. De: "Nick Couchman" <[email protected]> À: "user" <[email protected]> Envoyé: Jeudi 7 Janvier 2021 19:19:26 Objet: Re: sub-elements not displayed in the web interface On Thu, Jan 7, 2021 at 12:36 PM Nick Couchman < [ mailto:[email protected] | [email protected] ] > wrote: On Thu, Jan 7, 2021 at 8:45 AM Olivier Chaudet < [ mailto:[email protected] | [email protected] ] > wrote: BQ_BEGIN Hi, seeing you had released a new version of Guacamole, I figured I should try it and see if it solves my problem. So I scrapped the VM and reinstalled from scratch, including Debian buster and Tomcat 9. Unfortunately, it hasn't changed a thing. With the almost empty database (there are just guacadmin and two other admin accounts authenticating against LDAP), I create a new connection group "salle_0e03" and add an RDP connexion "p03e01" to it. The result is disappointing: Then I try to add it again, and receive the same error as last year: All this done in the web UI only: no direct database tampering or testing this time. I still suppose I may have done something wrong during installation, but don't see what it could be. Could it have something to do with the MariaDB connector for instance? I simply used the one coming with debian, and linked to it in guacamole home with: ln -s /usr/share/java/mariadb-java-client.jar /etc/guacamole/lib/ Apologies if you mentioned this before, but could you specify the versions of DB (MySQL/Maria) and connector you're using? I'd like to try to replicate your environment as much as possible to see if I can reproduce this issue. BQ_END So, without knowing exact details on what versions you're using, I've attempted to reproduce this behavior and cannot - it works fine for me: Here are my steps to reproduce: - Launch new Amazon Linux 2 EC2 instance, install updates, etc. - Install OpenJDK 1.8.0 from yum repository - Configure MariaDB 10.5 yum repository and install MariaDB-server - Enable and start mariadb service - Create new MariaDB database "guac" and grant access to local "guac" user (GRANT ALL ON guac.* TO 'guac'@'localhost' IDENTIFIED BY 'superSecretPassword';) - Download Tomcat and start it. - Download Apache Guacamole 1.3.0 and the JDBC authentication extension module - Download latest MariaDB Connector/J (2.6) and install into /etc/guacamole/lib - Configure /etc/guacamole/guacamole.properties with DB parameters: mysql-hostname: localhost mysql-port: 3306 mysql-database: guac mysql-username: guac mysql-password: superSecretPassword mysql-driver: mariadb - Import DB schema (001-create-schema.sql) and guacadmin account (002-create-admin-user.sql) - Deploy guacamole.war file to Tomcat - Log in to Guacamole with "guacadmin" user - Create a "Test Group" connection group - Within the "Test Group" connection group create a new VNC connection called "MyVNC" It would be useful to know exactly which versions of MariaDB Server and Maria Connector/J you're using, so that I can try those out, specifically, but at least with the latest available versions of components I am unable to reproduce the behavior you're seeing. -Nick
