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 >>End of sudoedit /etc/guacamole/guacamole.properties. I'm using the latest tomcat 9 with OpenJDk11 → ll /opt/tomcat/ total 24 drwxr-xr-x 3 tomcat tomcat 4096 Aug 31 00:09 . drwxr-xr-x 3 root root 4096 Aug 31 00:06 .. drwxr-xr-x 9 tomcat tomcat 4096 Aug 31 00:27 apache-tomcat-9.0.52 -rw-r--r-- 1 tomcat tomcat 220 Nov 13 2014 .bash_logout -rw-r--r-- 1 tomcat tomcat 3526 May 15 2017 .bashrc lrwxrwxrwx 1 tomcat tomcat 20 Aug 31 00:09 current -> apache-tomcat-9.0.52 -rw-r--r-- 1 tomcat tomcat 807 Apr 18 2019 .profile → la /opt/tomcat/current/webapps total 32 drwxr-x--- 8 tomcat tomcat 4096 Aug 31 00:26 . drwxr-xr-x 9 tomcat tomcat 4096 Aug 31 00:27 .. drwxr-x--- 15 tomcat tomcat 4096 Aug 31 00:08 docs drwxr-x--- 7 tomcat tomcat 4096 Aug 31 00:08 examples drwxr-x--- 11 tomcat tomcat 4096 Aug 31 00:26 guacamole lrwxrwxrwx 1 root root 28 Aug 31 00:26 guacamole.war -> /etc/guacamole/guacamole.war drwxr-x--- 6 tomcat tomcat 4096 Aug 31 00:08 host-manager drwxr-x--- 6 tomcat tomcat 4096 Aug 31 00:08 manager drwxr-x--- 3 tomcat tomcat 4096 Aug 31 00:08 ROOT ----------------------- *Now to the actual problem:* I am unable to login using the default created credentials (guacadmin), Logs tell this: 31-Aug-2021 07:00:25.065 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/tomcat/apache-tomcat-9.0.52/webapps/examples] has finished in [130] ms 31-Aug-2021 07:00:25.067 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 31-Aug-2021 07:00:25.079 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [2559] milliseconds 07:00:40.240 [http-nio-8080-exec-6] 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. 07:00:40.241 [http-nio-8080-exec-6] 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. 07:00:48.997 [http-nio-8080-exec-4] 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. 07:00:48.998 [http-nio-8080-exec-4] 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. 07:00:49.115 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.18060.0.0.1) 07:00:49.116 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.7) 07:00:49.116 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.2) 07:00:49.116 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.319) 07:00:49.116 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.3) 07:00:49.117 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.18) 07:00:49.117 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.473) 07:00:49.117 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.474) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.o.DefaultLdapCodecService - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.4203.1.10.1) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.18060.0.0.1) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.7) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.2) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.319) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.3) 07:00:49.118 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.18) 07:00:49.119 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.473) 07:00:49.119 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.474) 07:00:49.119 [http-nio-8080-exec-4] INFO o.a.d.a.l.c.StockCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.4203.1.10.1) 07:00:49.120 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.841) 07:00:49.121 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.841) 07:00:49.121 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.2239) 07:00:49.122 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.417) 07:00:49.122 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.528) 07:00:49.122 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.42.2.27.8.5.1) 07:00:49.122 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.42.2.27.8.5.1) 07:00:49.123 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.2.840.113556.1.4.1413) 07:00:49.123 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.4203.1.9.1.3) 07:00:49.123 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.4203.1.9.1.1) 07:00:49.123 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.4.1.4203.1.9.1.2) 07:00:49.123 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (1.3.6.1.1.21.2) 07:00:49.124 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.9) 07:00:49.124 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06000_REGISTERED_CONTROL_FACTORY (2.16.840.1.113730.3.4.10) 07:00:49.125 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.1.8) 07:00:49.125 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.18060.0.1.8) 07:00:49.126 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.1.21.3) 07:00:49.126 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.18060.0.1.5) 07:00:49.127 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.18060.0.1.3) 07:00:49.127 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.1466.20036) 07:00:49.127 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.4203.1.11.1) 07:00:49.128 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.1466.20037) 07:00:49.129 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.1.21.1) 07:00:49.129 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.18060.0.1.6) 07:00:49.130 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06001_REGISTERED_EXTENDED_OP_FACTORY (1.3.6.1.4.1.4203.1.11.3) 07:00:49.130 [http-nio-8080-exec-4] INFO o.a.d.a.l.e.ExtrasCodecFactoryUtil - MSG_06002_REGISTERED_INTERMEDIATE_FACTORY (1.3.6.1.4.1.4203.1.9.1.4) 07:00:49.204 [http-nio-8080-exec-4] WARN o.a.g.r.auth.AuthenticationService - Authentication attempt from [10.0.0.22, 10.0.0.122] for user "guacadmin" failed. I however have no previous errors in the log except that. Even though I set tomcat logs to debug, the guacamole app seems to be unaffected. Can you please share what settings I can tweak to get debug logging? I have confirmed that I can access the database from another pc and also via mariadb-client on the guacamole server: # alexp at nhmucrmgw01 in ~ [7:04:07] → mariadb -h nhmucmasql01.nethavn.net -u nhmucrmgw01_dbuser -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 34 Server version: 10.5.11-MariaDB-1 Debian 11 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> ------------------------------------------- Any help why the login does not work and how I can solve this is greatly appreciated. Thank You! Regards, Alexander / Aebian
