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