How to install Guacamole with MySQL on Debian Buster (10.1)

[ivanmarcus <iv...@yahoo.com.INVALID>]

With regard to the recent enquiry about installing Guacamole on Debian 
Buster 
(https://lists.apache.org/thread.html/ff5b707b06d31458eb4716b56560d50112efd7e68e0beccc8063100f@%3Cdev.guacamole.apache.org%3E), 
and for anyone wanting to give this a try...

... I've found the following works from a fresh install of the netinst 
version of Debian in a VM:


su

apt-get install gnupg
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
wget http://repo.mysql.com/mysql-apt-config_0.8.13-1_all.deb
dpkg -i mysql-apt-config_0.8.13-1_all.deb (select the requisite version 
of MySQL & then 'ok' - I used 5.7)
apt-get update

apt-get install mysql-server
apt-get install build-essential autoconf libtool m4 libpng-dev 
libjpeg-dev libcairo-dev libossp-uuid-dev libtelnet-dev libpango1.0-dev 
libssh2-1-dev libwebp-dev libvncserver-dev libpulse-dev libvorbis-dev

nano /etc/apt/sources to incl stretch repo (deb 
http://deb.debian.org/debian/ stretch main)
apt update

apt-get install libmysql-java libfreerdp-dev
apt-get install tomcat8 tomcat8-admin tomcat8-common tomcat8-user

apt-get install git
git clone git://github.com/apache/guacamole-server.git
cd guacamole-server
autoreconf -fi
./configure --with-init-dir=/etc/init.d
make
make install
ldconfig

mysql -u root -p
create database guacamole_db;
create user 'guacamole_user'@'localhost' identified by '';
grant select,insert,update,delete on guacamole_db.* to 
'guacamole_user'@'localhost';
flush privileges;
quit

wget 
https://www.apache.org/dist/guacamole/1.0.0/binary/guacamole-auth-jdbc-1.0.0.tar.gz
tar -zxvf guacamole-auth-jdbc-1.0.0.tar.gz
mkdir /etc/guacamole
mkdir /etc/guacamole/extensions
mkdir /etc/guacamole/lib

wget https://www.apache.org/dist/guacamole/1.0.0/binary/guacamole-1.0.0.war
cp guacamole-1.0.0.war /etc/guacamole/guacamole.war
cp guacamole-auth-jdbc-1.0.0/mysql/guacamole-auth-jdbc-mysql-1.0.0.jar 
/etc/guacamole/extensions/
ln -s /etc/guacamole/guacamole.war /var/lib/tomcat8/webapps/
systemctl enable guacd

nano /etc/guacamole/guacamole.properties
  mysql-hostname: localhost
  mysql-port: 3306
  mysql-database: guacamole_db
  mysql-username: guacamole_user
  mysql-password:
(ctrl-x then y)

cat guacamole-auth-jdbc-1.0.0/mysql/schema/*.sql | mysql -u root -p 
guacamole_db
ln -s /usr/share/java/mysql-connector-java.jar /etc/guacamole/lib/
mkdir -p /usr/lib/$(dpkg-architecture -qDEB_BUILD_GNU_TYPE)/freerdp
ln -s /usr/local/lib/freerdp/guac*.so /usr/lib/$(dpkg-architecture 
-qDEB_BUILD_GNU_TYPE)/freerdp/
ldconfig
systemctl restart guacd
systemctl restart tomcat8.service


YMMV - I did try various things before I could get it to work (incl 
MariaDB, but that got a bit hard) so this is a bit messy and I expect 
this could be tidied up and improved on.