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 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 *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
