Maybe you should use

jdbc:mariadb://

instead of
jdbc:mysql://

??

According to this page, https://mariadb.com/kb/en/about-mariadb-connector-j/ ,


jdbc:mysql scheme compatibility
MariaDB Connector/J 3.0 only accepts jdbc:mariadb: as the protocol in 
connection strings by default. When both MariaDB Connector/J and the MySQL 
drivers are found in the class-path, using jdbc:mariadb: as the protocol helps 
to ensure that Java chooses MariaDB Connector/J.
Connector/J still allows jdbc:mysql: as the protocol in connection strings when 
the permitMysqlScheme option is set. For example:
jdbc:mysql://HOST/DATABASE?permitMysqlScheme
(2.x version did permit connection URLs beginning with both jdbc:mariadb and 
jdbc:mysql)

HTH

Regards
Lorenzo

Da: Viktor Nikolov <[email protected]>
Inviato: lunedì 4 settembre 2023 19:32
A: [email protected]
Oggetto: "No suitable driver found for jdbc:mysql" after upgrade to 1.5.3

Hi!

My Guacamole installation stopped working after the upgrade from 1.4.0 to 
1.5.3.  :-(

I'm getting the "No suitable driver found for jdbc:mysql" when the Guacamole 
starts.
Please see attached catalina.out (logging level: debug).

I'm using native installation on Ubuntu 22.04.3 running Tomcat 9.0.58 with 
MariaDB 10.6 authentication and I believe I did everything according to the 
manual.

I compiled and installed guacd from sources.
I downloaded guacamole-1.5.3.war and copied it to 
/var/lib/tomcat9/webapps/guacamole.war .
I downloaded guacamole-auth-jdbc-1.5.3.tar.gz, extracted it and copied 
guacamole-auth-jdbc-mysql-1.5.3.jar to /etc/guacamole/extensions . I deleted 
the jar with previous version.
I downloaded recommended MariaDB Connector/J 3.2, 
mariadb-java-client-3.2.0.jar, and copied it to /etc/guacamole/lib . I deleted 
the jar with previous version.
I rebooted the system.
I didn't make any changes to guacamole.properties. It worked fine with 1.4.0. 
Parameter mysql-driver is set to mariadb (see the attachment).

What am I missing???

Viktor

Reply via email to