Install Guacamole MySQL

cd /tmp
wget http://mirrors.ircam.fr/pub/apache/guacamole/1.0.0/source/guacamole-server-1.0.0.tar.gz
tar -xzf guacamole-server-1.0.0.tar.gz

cd guacamole-server-1.0.0/
./configure --with-init-dir=/etc/init.d

Protocol support:

RDP ....... yes
SSH ....... yes
Telnet .... yes
VNC ....... yes

Services / tools:

guacd ...... yes
guacenc .... yes

make
make install

ldconfig

systemctl enable guacd

mkdir -p /etc/guacamole/lib
mkdir -p /etc/guacamole/extensions

cd /tmp
wget http://apache.crihan.fr/dist/guacamole/1.0.0/binary/guacamole-1.0.0.war

mv guacamole-1.0.0.war /etc/guacamole/guacamole.war
ln -s /etc/guacamole/guacamole.war /var/lib/tomcat8/webapps/
mkdir /usr/lib/x86_64-linux-gnu/freerdp/
ln -s /usr/local/lib/freerdp/guac*.so /usr/lib/x86_64-linux-gnu/freerdp/
ln -s /usr/share/java/mysql-connector-java.jar /etc/guacamole/lib/
ln -s /etc/guacamole /var/lib/tomcat8/webapps/.guacamole

cd /tmp
wget http://mirror.ibcp.fr/pub/apache/guacamole/1.0.0/binary/guacamole-auth-jdbc-1.0.0.tar.gz

tar -xvf guacamole-auth-jdbc-1.0.0.tar.gz
cp guacamole-auth-jdbc-1.0.0/mysql/guacamole-auth-jdbc-mysql-1.0.0.jar /etc/guacamole/extensions/

nano /etc/guacamole/guacamole.properties

# Auth provider class
auth-provider: net.sourceforge.guacamole.net.auth.mysql.MySQLAuthenticationProvider

mysql-hostname: localhost
mysql-port: 3306
mysql-database: guacamole_db
mysql-username: guacamole_user
mysql-password: guacamole_user

PS: Les informations sont dans le cadre du labo, vous aurez différentes valeurs.

sudo apt-get install mariadb-server

mysql_secure_installation

Enter current password for root (enter for none): (appuyer sur enter car pas de password par défaut)
Set root password? [Y/n] Y
New password:
Re-enter new password:
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y

mysql -u root -p

create database guacamole_db;
create user 'guacamole_user'@'localhost' identified by 'P@$$w0rd';
GRANT SELECT,INSERT,UPDATE,DELETE ON guacamole_db.* TO 'guacamole_user'@'localhost';
flush privileges;
quit

PS: Là encore les informations dépendent de chacun.

cat guacamole-auth-jdbc-1.0.0/mysql/schema/*.sql | mysql -P 3306 -h localhost -u root -pP@$$w0rd guacamole_db

service tomcat8 restart

service guacd start

sudo ufw allow 22
sudo ufw allow 80/tcp
sudo ufw allow 3389
sudo ufw allow 443/tcp
sudo ufw enable

<bootnote web>http://FQDN_or_IP_GUACAMOLE_SERVER:8080/guacamole/