On Mon, Jan 8, 2024 at 5:21 AM Guillaume CHOLLIER < [email protected]> wrote:
> Hello all, > > I'd install Guacamole 1.5.4 but where i connect to my database = doesn't > work ! > with a user-mapping is OK, but not with a DB , why ?? > > my configuration > > Debian 12 > Tomcat 9.0.84 > > *Guacamole 1.5.4* > /etc/guacamole/lib > mysql-connector-j-8.2.0.jar > /etc/guacamole/extensions > guacamole-auth-jdbc-mysql-1.5.4.jar > > root@vps-123456:/opt/tomcat9/webapps# ls -l > total 13440 > drwxr-x--- 3 tomcat tomcat 4096 Jan 4 16:07 ROOT > drwxr-x--- 16 tomcat tomcat 4096 Jan 4 16:07 docs > drwxr-x--- 7 tomcat tomcat 4096 Jan 4 16:07 examples > drwxr-x--- 10 tomcat tomcat 4096 Jan 5 10:26 guacamole > -rw-r--r-- 1 tomcat tomcat 13734589 Dec 4 21:33 guacamole.war > drwxr-x--- 6 tomcat tomcat 4096 Jan 4 16:07 host-manager > drwxr-x--- 6 tomcat tomcat 4096 Jan 4 16:07 manager > > content of */etc/guacamole/guacamole.properties* > # MySQL > mysql-hostname: 127.0.0.1 > mysql-port: 3306 > mysql-database: guacadb > mysql-username: xxxx > mysql-password: yyyy > mysql-ssl-mode: disabled > #user-mapping: /etc/guacamole/user-mapping.xml > #auth-provider: > net.sourceforge.guacamole.net.basic.BasicFileAuthenticationProvider > > i ran all sql scripts, my user guacadmin is created > all service are restarted : tomcat9 guacd mariadb > > How i can test/check otherwise ? > Check your Tomcat log files - in your case, likely /opt/tomcat9/logs/catalina.out - and see what messages are being displayed. This should tell you why it cannot connect to the MySQL DB. -Nick
