Hi! Try adding the following configuration to your guacamole.properties
mysql-ssl-mode: disable -> Lib root@guacamole:/etc/guacamole/lib# mariadb-java-client-2.7.5.jar [ ] Luciano de Oliveira --------------------------------------------------- Técnico em Telecomunicações - CFT Infraestrutura de Redes e Servidores Certificado em Cabeamento Estruturado NEXANS E-mail: [email protected] Mobile/WhatsApp: +55 51 99549-7999 ________________________________ De: [email protected] <[email protected]> Enviado: quinta-feira, 5 de outubro de 2023 13:55 Para: [email protected] <[email protected]> Assunto: MariaDB authentication error Respected members, I am a self-funded student who has just installed (compiled version) of the Apache Guacamole. I've taken a DB approach to authentication via MariaDB. When accessing the Guacamole page (http://ip:8080/guacamole) I get the following error: "An error has occurred and this action cannot be completed. If the problem persists, please notify your system administrator or check your system logs." I can see the following logs in /var/log/syslog when the request is presented: [Warning] Aborted connection 31 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication) I have attempted the following two connectors by placing them into the /etc/guacamole/lib/ folder: 1. mysql-connector-j-8.1.0.jar 2. mariadb-java-client-1.8.0.jar I have further created the following links too: 1. ln -s /etc/guacamole /usr/share/tomcat/.guacamole && ln -s /etc/guacamole/guacamole.war /usr/share/tomcat/webapps/ I have added DBs using: 1. mysql -u root -p guacamoledb < /home/ra/guacamole-auth-jdbc/mysql/schema/001-create-schema.sql 2. mysql -u root -p guacamoledb < /home/ra/guacamole-auth-jdbc/mysql/schema/002-create-admin-user.sql I added it using the root password of the OS and not the MariaDB password. I am not sure if this is what is causing the issue. When I am retrying with MariaDB password, I am getting: 1. ERROR 1050 (42S01) at line 24: Table 'guacamole_connection_group' already exists 2. ERROR 1062 (23000) at line 21: Duplicate entry 'USER-guacadmin' for key 'guacamole_entity_name_scope' I reckon this is where I am wrong, but I am uncertain. I have added a username and password in the "/etc/guacamole/guacamole.properties" that I did not use while adding the above configuration. Following are the technical details: 1. Host type: VM 2. Host (technically guest) OS: Ubuntu Server 22.04.3 LTS 3. Apacha Guacamole version: 1.5.3 4. Tomcat version: 9 5. Java version: openjdk 11.0.20.1 2023-08-24 6. MariaDB version: mariadb Ver 15.1 Distrib 10.6.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper What is the most optimal way to diagnose and rectify the error? Thank you very much. Parth D. Maniar CISSP, CDPSE, GCWN, CISM, CISA, SSCP(ret.) Student Number: 1146383. MSc in Software and Systems Security. Kellogg College, Oxford University. Mobile Number: +91-9662355555 Alternate E-Mail ID: [email protected]<mailto:[email protected]> LinkedIn: https://www.linkedin.com/in/parthmaniar/
