Hello, I have installed guacamole successfully before on Casa OS with the Big Bear app store, but I removed the VM Casa OS was on. So now I’m trying to install guacamole back but for some reason when I go to the app terminal to put the last command “mysql -u guacamole_user -p guacamole_db < initdb.sql” there is no MySQL folder in the var/lib/mysql it doesn’t exist. Before, I did find it, but now I haven’t been able to find it. I have installed and re-installed guacamole, restarted the VM, and made an entirely new VM (fresh install of casa os), but nothing has worked. If anyone could plz help me out, I would really appreciate it.
Specs:
OS: Ubuntu 20.04
Ram:8gb
Storage:125gb
CPU: 6 cores
2 Likes
Hey, I was having the same issue. I realize that when I opened the terminal from guacamole settings (click the three dots, click settings, click terminal and logs), that I was not accessing the terminal as the root user. This is evident because the current line starts with a $, when as root it starts with a #. So, we need to elevate privileges. I tried using the command:
$ su -
But could not elevate privileges, because I did not have the password for it. Maybe it hasn’t been set up, the root and user passwords in the docker-compose.yaml file did not work.
So instead, I used a bash client to ssh into my casaos host. To do this, run the following on the host machine:
$ sudo docker exec -it -u root big-bear-guacamole-mysql-1 /bin/bash
If you did not change the docker name for the container, than this works. If you did, replace big-bear-guacamole-mysql-1 with the docker container name. You can find running containers on the host machine with docker ps.
Then, enter your password and once you have root access run the following:
$ mysql -u guacamole_user -p guacamole_db < initdb.sql
Just like in the guide.
Hope this helps.