On Thu, Jan 7, 2021 at 12:36 PM Nick Couchman <[email protected]> wrote:
> On Thu, Jan 7, 2021 at 8:45 AM Olivier Chaudet < > [email protected]> wrote: > >> 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. > > 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: [image: image.png] 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
