Hi Felix, The solution is quite simple. You need to switch to the MySQL driver.
There is a bug in an interface library (mybatis guice) that Guacamole 1.6 uses for database access. See https://github.com/mybatis/guice/issues/589 for reference. It doesn't allow the MariaDB driver to be found. The fix was only ever released in the next major release of the library, but that version requires Tomcat 10 which Guacamole 1.6 does not support. Vincent ________________________________ From: Felix Maier <[email protected]> Sent: Tuesday 18 November 2025 20:24 To: [email protected] <[email protected]> Subject: Issue with Guacamole 1.6.0 – MariaDB JDBC driver not detected / Login not working / database output appears corrupted You don't often get email from [email protected]. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> Hello everyone, I am experiencing an issue with my Apache Guacamole setup and would appreciate your help. Guacamole version: 1.6.0 Guacamole Server (guacd): 1.6.0 Guacamole Client (webapp): 1.6.0 (running on Tomcat 9) Operating system (server): Ubuntu-based Linux Database: MariaDB (external Galera cluster) Authentication method: MySQL authentication extension ________________________________ Problem description: Guacamole fails to load the MySQL/MariaDB JDBC driver. So i am not able to access the Web GUI In Tomcat’s catalina.out I receive: ### Error querying database. Cause: java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.0.22:3306/guacamole_db<http://192.168.0.22:3306/guacamole_db> However, if I manually add the following line in guacamole.properties: mysql-driver: org.mariadb.jdbc.Driver Guacamole successfully connects to the database. But I still cannot log in, even though the database connection works. Additionally, I am unsure whether the Guacamole database schema was correctly loaded on my Galera Cluster. When I run: SELECT * FROM guacamole_user; I get output with strange or corrupted characters in the password_hash and password_salt columns, for example: | password_hash | =�Fp�xe�Զӷ�Ў���i8E�a�x | | password_salt | ��J[*m | I am not sure if this is expected or if my database setup is corrupted. I am using an external MariaDB Galera cluster, and I want to verify that the tables and data were created correctly. ________________________________ Steps to reproduce: 1. Installed guacd and guacamole-client (1.6.0). 2. Configured MariaDB on a Galera cluster and created the guacamole_db. 3. Imported the Guacamole schema. 4. Deployed the guacamole.war on Tomcat 9. 5. Placed the MySQL JDBC driver under /etc/guacamole/lib/ (and also tried /usr/share/tomcat9/lib/). 6. Started Tomcat → error appears. ________________________________ Error messages / Logs: From /var/log/tomcat9/catalina.out: No suitable driver found for jdbc:mysql://192.168.0.22:3306/guacamole_db<http://192.168.0.22:3306/guacamole_db> What I have tried so far: * Verified JDBC driver placement * Tried different JDBC driver versions * Restarted Tomcat several times * Checked permissions for /etc/guacamole/ * Verified database connectivity manually (MariaDB / Galera cluster works) * Verified that schema import completed without explicit errors ________________________________ If needed, I can provide additional logs or configuration details. Thank you in advance! Best regards, Felix IT Solutions Email Disclaimer - The information contained in this email message, including any files transmitted with it, is confidential and may be legally privileged. This e-mail is intended only for the personal attention of the stated addressee(s). Any access to this email, including any files transmitted with it, by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the accuracy or completeness of the information contained in this email or any files transmitted with it. If you have received this email in error, please inform the sender immediately and delete it and all copies from your system. You may not forward this email without the permission of the authorised sender. The views expressed in this email are those of the author, and do not necessarily represent the views of IT Solutions or its affiliates. Internet communications are not secure and IT Solutions cannot therefore accept legal responsibility for the contents of this message nor for any damage caused by viruses. This email has been scanned at the originating end. For further information on IT Solutions visit https://www.itsolutions.ie
