Commando Backwards: After placing the connector into the tomcat lib folder everything works now. Seems my classpath is not correctly set then, I will see about this.
Thanks for all your help! On Tue, Aug 31, 2021 at 8:48 PM Alexander Pelz <[email protected]> wrote: > Hi Nick, > > Thanks checked everything again, the last part seems to be now a driver > issue: > > ### Error querying database. Cause: java.sql.SQLException: No suitable > driver found for jdbc:mysql:// > nhmucmasql01.nethavn.net:3306/nhmucrmgw01_nethavn_net > ### The error may exist in > org/apache/guacamole/auth/jdbc/user/UserMapper.xml > ### The error may involve > org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne > ### The error occurred while executing a query > ### Cause: java.sql.SQLException: No suitable driver found for > jdbc:mysql://nhmucmasql01.nethavn.net:3306/nhmucrmgw01_nethavn_net > 20:26:54.913 [http-nio-8080-exec-5] DEBUG o.a.g.rest.RESTExceptionMapper - > Unexpected error in REST endpoint. > org.apache.ibatis.exceptions.PersistenceException: > ### Error querying database. Cause: java.sql.SQLException: No suitable > driver found for jdbc:mysql:// > nhmucmasql01.nethavn.net:3306/nhmucrmgw01_nethavn_net > > I have in the config tried to specify the mariadb connector as you > suggested, no change happens though. > I also re-installed the mysql connector: > [image: image.png] > After a restart of both guacd and tomcat still the same error as above. > Is there something I am missing? > > → ll /etc/guacamole/lib > total 2.9M > -rw-r--r-- 1 tomcat tomcat 539K Aug 31 05:12 mariadb-java-client-3.0.1.jar > -rw-r--r-- 1 root root 2.4M Aug 31 20:37 > mysql-connector-java-8.0.26.jar > > → ll /etc/guacamole/extensions > total 5.6M > -rw-r--r-- 1 tomcat tomcat 93K Aug 31 04:10 branding.jar > -rw-r--r-- 1 alexp alexp 5.5M Dec 29 2020 > guacamole-auth-jdbc-mysql-1.3.0.jar > > The correct jar is installed. > > Thank You. > > ~Alex > > > On Tue, Aug 31, 2021 at 7:27 PM Nick Couchman <[email protected]> wrote: > >> On Tue, Aug 31, 2021 at 12:02 PM Alexander Pelz <[email protected]> >> wrote: >> >>> Thanks Nick, >>> >>> The debug log-level have now given me more input on what's causing the >>> error. >>> Apparently it seems like the webapp is still trying to use the default >>> file-based auth mechanism instead of using the mysql/mariadb approach: >>> >>> 17:57:50.495 [http-nio-8080-exec-7] DEBUG >>> o.a.g.a.f.FileAuthenticationProvider - User mapping file >>> "/etc/guacamole/user-mapping.xml" does not exist and will not be read. >>> 17:57:50.500 [http-nio-8080-exec-7] DEBUG >>> o.a.g.r.auth.AuthenticationService - Anonymous authentication attempt from >>> [10.0.0.22, 10.0.0.122] failed. >>> 17:57:50.501 [http-nio-8080-exec-7] DEBUG o.a.g.rest.RESTExceptionMapper >>> - Client request rejected: Permission Denied. >>> 17:58:00.495 [http-nio-8080-exec-2] DEBUG >>> o.a.g.a.f.FileAuthenticationProvider - User mapping file >>> "/etc/guacamole/user-mapping.xml" does not exist and will not be read. >>> 17:58:00.495 [http-nio-8080-exec-2] WARN >>> o.a.g.r.auth.AuthenticationService - Authentication attempt from >>> [10.0.0.22, 10.0.0.122] for user "guacadmin" failed. >>> 17:58:00.495 [http-nio-8080-exec-2] DEBUG o.a.g.rest.RESTExceptionMapper >>> - Client request rejected: Permission Denied. >>> >>> I thought with Version 1.0.0 it was no longer required to specify an >>> authHandler? >>> >> >> Correct, the auth-handler property has been deprecated and has no effect. >> I would check the following: >> * Make sure the JDBC jar file is installed in /etc/guacamole/extensions, >> or wherever your extensions directory is. >> * Make sure permissions are correct so that the user running Tomcat can >> get to the /etc/guacamole directory (and all subdirectories). >> * Look higher up in the logs, during the startup of Tomcat (or deployment >> of the guacamole WAR file) to make sure it's loading the expected >> extensions, and see if there are any other errors, there. >> >> -Nick >> >>>
