Did you extract the schema's and write it to the guacamole.db ?
*Thank You*
Sean Hulbert
*Founder / CEO*
*Work Ph:* 925.663.5565
*Security Centric Inc.*
A Cybersecurity Virtualization Enablement Company
/StormCloud Gov, Protected CUI Environment!/
Industry's most secure virtual desktops!
*/FedRAMP MIL4 in process (SAR)/*
System Award Management
*CAGE: 8AUV4*
*SAM ID: UMJLJ8A7BMT3*
AFCEA San Francisco Chapter President
If you have heard of a hacker by name, he/she has failed, fear the
hacker you haven’t heard of!
CONFIDENTIALITY NOTICE: This communication with its contents may contain
confidential and/or legally privileged information. It is solely for the
use of the intended recipient(s). Unauthorized interception, review, use
or disclosure is prohibited and may violate applicable laws including
the Electronic Communications Privacy Act. If you are not the intended
recipient, please contact the sender and destroy all copies of the
communication. Content within this email communication is not legally
binding as a contract and no promises are guaranteed unless in a formal
contract outside this email communication.
igitur qui desiderat pacem, praeparet bellum!!!
Epitoma Rei Militaris
On 1/8/2024 11:29 AM, Nick Couchman wrote:
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
