Hey, thank you so much for the Help. Now i can access the Web GUI.
Do you have a clue on how to solve the other problem i described? Because now even though i see the GUI i can still not login. When i try to login i get an error and if i then look at 'systemctl status tomcat9' i get the following: WARN o.a.g.e.AuthenticationProviderFacade - Authentication attempt ignored because the relevant authentication provider could not be loaded. Please check for errors earlier in the logs. WARN o.a.g.event.EventLoggingListener - Authentication attempt from 192.168.0.1 for user "guacadmin" failed: unknown error (no specific failure recorded) i can provide more logs and details if needed. Thanks for the help in advance, Felix Am Di., 18. Nov. 2025 um 21:35 Uhr schrieb Vincent Sherwood <[email protected]>: > 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 > > 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 > > > > 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 >
