Docker Compose File for Apache Guacamole

---
version: "2.1"
services:
  guacd:
    image: linuxserver/guacd
    container_name: guacd
    ports:
      - 4822:4822
    restart: unless-stopped

# Guacamole - Remote desktop, SSH, on Telnet on any HTML5 Browser 
# Create all databases and tables first
  guacamole:
    image: guacamole/guacamole:latest
    container_name: guacamole
    restart: unless-stopped
    ports:
      - 8070:8080
    environment:
      GUACD_HOSTNAME: guacd
      MYSQL_HOSTNAME: 192.168.1.3
      MYSQL_PORT: 3306
      MYSQL_DATABASE: guacamole
      MYSQL_USER: <dbuser>
      MYSQL_PASSWORD: <dbpassword>

Create Guacamole Initialization Script

Guacamole requires that the database be initialized first. This involves several steps. However, Guacamole provides a script that can simplify this process. From your host system’s commandline, run this command to create the initialization script.

docker run --rm guacamole/guacamole /opt/guacamole/bin/initdb.sh --mysql > guac_initdb.sql

Now please create the database, create the database user, grant the user access to the database.

mysql -u root -p
create database guacamole;
CREATE USER 'guacdb_user' IDENTIFIED BY 'my_strong_password';
GRANT ALL ON `guacamole%`.* TO 'guacdb_user';
flush privileges;
quit

Finally initialize the database like this:

cat guac_initdb.sql | /usr/local/mariadb10/bin/mysql -u guacdb_user -p guacamole;

You should now be able to access guacamole http://IPofHost:8070/guacamole/