I actually have both on the system installed. The MySQL connector via the .deb package it came with and the mariadb connector using the libs folder in /etc/guacamole. However even after specifying the driver parameter and restarting guacd and tomcat there is still no change in login.
31-Aug-2021 17:43:27.589 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [2433] milliseconds 17:43:27.793 [http-nio-8080-exec-5] 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. 17:43:27.794 [http-nio-8080-exec-5] 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. 17:43:31.033 [http-nio-8080-exec-2] 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. 17:43:31.033 [http-nio-8080-exec-2] 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. 17:43:31.034 [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. Guac presents the standard "invalid login" msg: [image: image.png] To be sure I have removed all entries for ldap in the .properties and also moved the extensions module for ldap away to be sure it isn't that. Any other hints? ~Alex On Tue, Aug 31, 2021 at 1:52 PM Nick Couchman <[email protected]> wrote: > On Tue, Aug 31, 2021 at 1:17 AM [email protected] <[email protected]> > wrote: > >> Greetings, >> >> I built guacamole from source today and wanted to use MySQL (MariaDB) >> auth in conjunction with LDAP. >> For that purpose I have gone through the docs and configured guac >> hopefully right. However, I have a login-issue. Issue and log are down >> below after the infos from my system. >> >> OS: Debian 11 (bullseye), stable x64 >> Hostname of guacamole server is nhmucrmgw01. >> >> → java --version >> openjdk 11.0.12 2021-07-20 >> OpenJDK Runtime Environment (build 11.0.12+7-post-Debian-2) >> OpenJDK 64-Bit Server VM (build 11.0.12+7-post-Debian-2, mixed mode, >> sharing) >> >> → ll /etc/guacamole >> total 12M >> drwxr-xr-x 2 root root 4.0K Aug 31 05:10 extensions >> -rw-r--r-- 1 root root 746 Aug 31 06:41 guacamole.properties >> -rw-r--r-- 1 root root 12M Dec 29 2020 guacamole.war >> drwxr-xr-x 2 root root 4.0K Aug 31 05:12 lib >> >> → ll /etc/guacamole/lib >> total 540K >> -rw-r--r-- 1 root root 539K Aug 31 05:12 mariadb-java-client-3.0.1.jar >> >> → ll /etc/guacamole/extensions >> total 13M >> -rw-r--r-- 1 root root 93K Aug 31 04:10 branding.jar >> -rw-r--r-- 1 root root 5.5M Aug 31 05:10 >> guacamole-auth-jdbc-sqlserver-1.3.0.jar >> -rw-r--r-- 1 root root 7.3M Dec 29 2020 guacamole-auth-ldap-1.3.0.jar >> >> >>Start of >> sudoedit /etc/guacamole/guacamole.properties: >> >> guacd-hostname: 127.0.0.1 >> guacd-port: 4822 >> >> #MariaDB Settings >> mysql-hostname: nhmucmasql01.nethavn.net >> mysql-port: 3306 >> mysql-database: nhmucrmgw01_nethavn_net >> mysql-username: nhmucrmgw01_dbuser >> mysql-password: $password-redacted >> mysql-user-required: true >> mysql-auto-create-accounts: true >> >> > Looks like you're using the MariaDB driver, but you haven't set the > "mysql-driver" property. There was a recent change that will be part of the > next release that allows Guacamole to auto-detect which driver is present; > however, this is not part of the current (1.3.0) release or any previous > ones. The default driver is MySQL, so i you're using the MariaDB > Connector/J you'll need to specify: > > mysql-driver: mariadb > > -Nick > >>
