[GUACAMOLE-1401] Docker/guacamole-client: MySQL auth fails when MYSQL_PORT not set

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Component/s: guacamole-auth-jdbc-mysql
• Labels: Docker
• Assignee: Unassigned
• Reporter: Edwin Mackenzie-Owen
• Created: 17/Aug/21 21:41
• Updated: 14/Oct/24 21:45
• Resolved: 14/Oct/24 21:45

Description

Hi,

I was trying to set up Guacamole in Kubernetes using both LDAP and MySQL. LDAP users could log in, but guacadmin could not. Manually assigning admin permissions to a LDAP  user via MySQL commands also wouldn't work. I suspected the MySQL connection was not working.

So I looked at the guacamole.properties inside the guacamole container. It contained the line: mysql-port: tcp://<resolved-address-of-mysql-hostname>:3306. 

I had not set the environment variable MYSQL_PORT, because the manual says it defaults to 3306. After I set MYSQL_PORT to 3306, the line in guacamole.properties changed to mysql-port: 3306, and I could log in as guacadmin.

Additional information:

I used guacamole/guacamole:1.3.0. as it was not clear whether the latest tag would provide a recent build of 1.3.0 or a development version.

Issue Links

• is fixed by: GUACAMOLE-374 Installing Guacamole with Docker improvements