Instalar guacamole-Apache en Debian Buster con autenticación por base de datos.

#	Me guio de esta gente 
https://www.mogilowski.net/2020/03/23/install-guacamole-1-1-0-on-debian-10-with-db-authentication/

#	Antes de arrancar descargamos desde la web 
https://guacamole.apache.org/releases/
#	Los tres archivos que necesitamos. 
guacamole-server-1.3.0.tar.gz
guacamole-1.3.0.war
guacamole-auth-jdbc-1.3.0.tar.gz

sudo apt install tomcat9 tomcat9-admin tomcat9-common tomcat9-user build-essential libcairo2-dev libjpeg62-turbo-dev libtool-bin libossp-uuid-dev libavcodec-dev libavutil-dev libswscale-dev freerdp2-dev libpango1.0-dev libssh2-1-dev libtelnet-dev libvncserver-dev libwebsockets-dev libpulse-dev libssl-dev libvorbis-dev libwebp-dev wget mariadb-server mariadb-client -y

tar vfx guacamole-server-1.3.0.tar.gz
cd guacamole-server-1.3.0/
sudo autoreconf -fi
sudo ./configure --with-init-dir=/etc/init.d --enable-allow-freerdp-snapshots
sudo make
sudo make install
sudo ldconfig
sudo systemctl enable guacd
sudo systemctl start guacd
mkdir /etc/guacamole
sudo cp guacamole-1.3.0.war /etc/guacamole/guacamole.war
sudo ln -s /etc/guacamole/guacamole.war /var/lib/tomcat9/webapps/
sudo mkdir /etc/guacamole/{extensions,lib}
sudo echo "GUACAMOLE_HOME=/etc/guacamole" |sudo tee -a /etc/default/tomcat9

sudo mysql -p
CREATE DATABASE guacamole_db;
CREATE USER 'guacamole_user'@'localhost' IDENTIFIED BY 'passw0rd';
GRANT SELECT,INSERT,UPDATE,DELETE ON guacamole_db.* TO 'guacamole_user'@'localhost';
FLUSH PRIVILEGES;
quit;

tar vfx guacamole-auth-jdbc-1.3.0.tar.gz
cat guacamole-auth-jdbc-1.3.0/mysql/schema/*.sql | sudo mysql -u root -p guacamole_db 
sudo cp guacamole-auth-jdbc-1.3.0/mysql/guacamole-auth-jdbc-mysql-1.3.0.jar /etc/guacamole/extensions/ 
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.13.tar.gz
tar xvzf mysql-connector-java-8.0.13.tar.gz
sudo cp mysql-connector-java-8.0.13/mysql-connector-java-8.0.13.jar /etc/guacamole/lib/
mysql_tzinfo_to_sql /usr/share/zoneinfo |sudo mysql -u root -p mysql

sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf

default_time_zone='America/Argentina/Buenos_Aires'

sudo systemctl restart mariadb.service

sudo vi /etc/guacamole/guacamole.properties

# Hostname and Guacamole server port
guacd-hostname: localhost
guacd-port: 4822

# MySQL properties
mysql-hostname: localhost
mysql-port: 3306
mysql-database: guacamole_db
mysql-username: guacamole_user
mysql-password: passw0rd

sudo systemctl restart tomcat9

http://<YOUR_SERVER>:8080/guacamole

Usuario guacadmin
Clave guacadmin