What about guacamole-auth-jdbc-mysql-1.5.3.jar?

From: Viktor Nikolov <[email protected]>
Sent: Monday, September 4, 2023 3:24 PM
To: [email protected]
Subject: Re: "No suitable driver found for jdbc:mysql" after upgrade to 1.5.3

I can't do "sudo su tomcat", because user tomcat doesn't have a shell set.

Looking at the file privileges, they seem OK to me. Directories are executable 
for everybody, the jar with driver is readable by everybody:

viktor@nuc:/etc/guacamole$ ls -dlh /etc/guacamole /etc/guacamole/lib 
lib/mariadb-java-client-3.2.0.jar /var/lib/tomcat9/webapps/guacamole.war
drwxr-xr-x 4 root   root   4.0K Sep  4 18:47 /etc/guacamole
drwxr-xr-x 2 root   root   4.0K Sep  4 18:21 /etc/guacamole/lib
-rw-r--r-- 1 root   root   636K Sep  4 18:20 lib/mariadb-java-client-3.2.0.jar
-rw-r--r-- 1 tomcat tomcat  14M Sep  4 17:32 
/var/lib/tomcat9/webapps/guacamole.war

Viktor

On Mon, Sep 4, 2023 at 7:56 PM Mark Li 
<[email protected]<mailto:[email protected]>> wrote:
Are the permissions on the driver and directory correct? May su to the tomcat 
user and check.

Sent from my T-Mobile 5G Device
Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Viktor Nikolov <[email protected]<mailto:[email protected]>>
Sent: Monday, September 4, 2023 1:31:46 PM
To: [email protected]<mailto:[email protected]> 
<[email protected]<mailto:[email protected]>>
Subject: "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