[Support] jasonbean - Apache Guacamole

[Hugh Jazz]

i'm trying to install this docker as i have a mariadb (linuxserver repo) that i use for other stuff. i'm a bit of a newbie with databases and whatnot and I can't get this to work.

 

should i use the regular sql option when installing or mysql server when i have the mariadb docker? i have filled out guacamole.properties with the db info i created in mariadb, but that doesn't seem to work. could anyone point me in the right direction?

Edited October 12, 2021 by Hugh Jazz
typo

[Taddeusz]

2 minutes ago, Hugh Jazz said:

i'm trying to install this docker as i have a mariadb (linuxserver repo) that i use for other stuff. i'm a bit of a newbie with databases and whatnot and I can't get this to work.

 

should i use the regular sql option when installing or mysql server when i have the mariadb docker? i have filled out guacamole.properties with the info db info i created in mariadb, but that doesn't seem to work. could anyone point me in the right direction?

MySQL is the correct choice. I’ll try and create some detailed instructions on how to create the database. But in short you need to create a database, user, attach the user to the database, and then run the schema sql scripts. If you’re not comfortable with this just use the container that already includes MariaDB.

[Hugh Jazz]

4 hours ago, Taddeusz said:

MySQL is the correct choice. I’ll try and create some detailed instructions on how to create the database. But in short you need to create a database, user, attach the user to the database, and then run the schema sql scripts. If you’re not comfortable with this just use the container that already includes MariaDB.

Thanks for the reply. I already tried all that. As you can see from screenshot, I created a database called guacamole and a user guac for it. I added this info to guacamole.properties. When I tried to run the script though, I get:

/mnt/user/appdata/ApacheGuacamoleNoMariaDB# cat mysql-schema/*.sql | mysql -u root -p guacamole
-bash: mysql: command not found
cat: write error: Broken pipe

I did this in unraids terminal. I also tried it with the user 'guac'. In the guacamole.properties I tried both localhost and the local ip for mariadb (192.168.0.10). any suggestions?

 

any help is much appreciated!

[Taddeusz]

@Hugh Jazz You’ll have to run from within the container since it has the mysql command line utilities.

[Hugh Jazz]

9 minutes ago, Taddeusz said:

@Hugh Jazz You’ll have to run from within the container since it has the mysql command line utilities.

that didn't help either i clicked the docker icon --> terminal

# cd config
# ls
guacamole  log  mysql-schema
# cat mysql-schema/*.sql | mysql -u root -p guacamole
sh: 3: mysql: not found
# 

is there something wrong with my docker install? should i reinstall, or could there be something in the guacamole.settings?

or anything else i've missed?

[alturismo]

57 minutes ago, Hugh Jazz said:

or anything else i've missed?

move the 2 files to the appdata folder from your mysql docker and run the commands from the sql docker shell you use, not from unraid and not from guacamole docker ...

[Hugh Jazz]

34 minutes ago, alturismo said:

move the 2 files to the appdata folder from your mysql docker and run the commands from the sql docker shell you use, not from unraid and not from guacamole docker ...

well that did the trick. got it up and running with rdp now! thanks a lot apprecaited

[Twitchstick]

I need a little help. I'm trying to setup a reverse proxy using NPM with cloudflare. I've done this numerous times for other dockers but I can't get it working. I used spaceinvaderone's YT video to get guacamole setup using a static ip and a custom port which I've never tried creating a reverse proxy after messing with those values.   Am i missing something?

[Taddeusz]

@Twitchstick NPM is a JavaScript package manager. Do you mean Nginx or Node.js?

[Twitchstick]

@Taddeusz Sorry I mean Nginx

[Taddeusz]

45 minutes ago, Twitchstick said:

@Taddeusz Sorry I mean Nginx

Here is the coming file I use for my Guacamole subdomain. I hope this at least gives you an idea. BTW, I have my Guacamole container network set to “bridge” so that it can have access to the host itself, which includes VM’s.

guacamole.subdomain.conf

[Taddeusz]

@Twitchstick Just ignore the commented lines.

[Twitchstick]

1 hour ago, Taddeusz said:

Here is the coming file I use for my Guacamole subdomain. I hope this at least gives you an idea. BTW, I have my Guacamole container network set to “bridge” so that it can have access to the host itself, which includes VM’s.

guacamole.subdomain.conf 1.05 kB · 1 download

So I set it back to "bridge" and I'm good to go. Thanks for the help. 

[darthjonathan12]

I just installed Guac on my pc and a VM. I have a few audio questions. On both machines, when the volume in the system tray is turned up I get an echo which sounds like two audio sources at the same time. When I mute there is no audio on either. The VM is not as bad but the quality of the audio seems lower. Is there a way to improve this? They look to be using a device called "Remote audio" 

[Taddeusz]

2 minutes ago, darthjonathan12 said:

I just installed Guac on my pc and a VM. I have a few audio questions. On both machines, when the volume in the system tray is turned up I get an echo which sounds like two audio sources at the same time. When I mute there is no audio on either. The VM is not as bad but the quality of the audio seems lower. Is there a way to improve this? They look to be using a device called "Remote audio" 

I’ve not experienced this myself. Is this through RDP? Are you using a headset on the device you’re connecting from?

[darthjonathan12]

25 minutes ago, Taddeusz said:

I’ve not experienced this myself. Is this through RDP? Are you using a headset on the device you’re connecting from?

Ok, so strangely this issue has disappeared. Remote Audio is sounding decent for a video stream. Perhaps I just needed to give RDP time to fully configure by connecting and disconnecting multiple times???

[vcolombo]

On 3/10/2021 at 3:17 PM, nug said:

...and I'm an idiot.  Thanks very much mate!

 

Next question, does anyone have ssh connections working with public key authentication working with this container?  No matter what I do I can only seem to connect successfully using a password.

 

When I use a private/public key pair it always just asks for the passphrase - even if there isn't one and if I set a passphrase it doesn't like that either.

Did you ever get key-based authentication to work? I'm running into the same issue currently. Thanks!

[vcolombo]

17 hours ago, vcolombo said:

Did you ever get key-based authentication to work? I'm running into the same issue currently. Thanks!

@nug I was finally able to get key-based SSH to work with Guacamole with help from this Reddit thread:

 

The key was the comment to use the old key format by running the following command:

ssh-keygen -t rsa -b 4096 -m PEM

After doing that and adding the public key to the remote host, I was able to connect successfully.

 

[timethrow]

Heya, Thanks for providing this container.

 

Are there any plans to update the Tomcat Version, as Nessus is reporting that the version Installed has a few Vulnerabilities (CVE-2021-25122, CVE-2021-25329).

 

Thanks

[Taddeusz]

3 hours ago, timethrow said:

Heya, Thanks for providing this container.

 

Are there any plans to update the Tomcat Version, as Nessus is reporting that the version Installed has a few Vulnerabilities (CVE-2021-25122, CVE-2021-25329).

 

Thanks

 

I just pushed an update that should include all the latest packages.

[Taddeusz]

16 minutes ago, Taddeusz said:

 

I just pushed an update that should include all the latest packages.

 

I'm backing this out. Apparently it downgraded tomcat. Not sure what's going on with the Debian packages.

[Taddeusz]

4 hours ago, timethrow said:

Heya, Thanks for providing this container.

 

Are there any plans to update the Tomcat Version, as Nessus is reporting that the version Installed has a few Vulnerabilities (CVE-2021-25122, CVE-2021-25329).

 

Thanks

I'll work on installing Tomcat separate from the Debian package manager.

[timethrow]

15 hours ago, Taddeusz said:

I'll work on installing Tomcat separate from the Debian package manager.

Heya, Thank you for looking at it and the update. Most appreciated

[nlz]

Thank you, appreciate you working to resolve vulnerabilities.

[CryoRig]

Can we get an update to 1.4?
Apparently fixes the RDP Audio Problems --> https://guacamole.apache.org/releases/1.4.0/