On Thu, Jan 2, 2020 at 11:30 AM Kelvin Middleton <[email protected]> wrote:
> Hi, I'm new to gaucamole so trying to setup my first working conf to test > and am having new user *issues*. > > I'm using docker with linux containers on a Windows host and have guacd, > mysql and guacamole all up and running. However when I attempt to load the > web interface at http://localhost/guacamole/ I get a blank webpage and > the docker logs on the guacamole server show... > > 13:55:54.844 [http-nio-8080-exec-9] ERROR o.a.g.rest.RESTExceptionMapper - > Unexpected internal error: > ### Error querying database. Cause: java.sql.SQLException: Access denied > for user 'guacamole_user'@'xxx.xx.x.x' (using password: YES) > ### The error may exist in > org/apache/guacamole/auth/jdbc/user/UserMapper.xml > ### The error may involve > org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne > ### The error occurred while executing a query > ### Cause: java.sql.SQLException: Access denied for user > 'guacamole_user'@'xxx.xx.x.x' > (using password: YES) > > I've validated the guacamole_user account is working and accepting both > local and remote connections and the grants on the database match all > documentation I've seen. > This indicates the following items: 1) The MySQL extension is correctly installed within the Docker image. 2) The MySQL server is up and running and responding. 3) The username or password is incorrectly configured. Since it looks like the account name is correct, I suspect that the password is misconfigured somewhere - either mis-matched between the server and the Guacamole configuration, or not being correctly passed through to the Docker container. I'd suggest that you get a shell going in the Guacamole Client Docker container and look at the guacamole.properties file and make sure that the password for the MySQL extension is present in the file, and the value is what you expect. It's also possible, depending on how you've configured that user account in MySQL, that the IP address being used to access it is not the same as the one you configured when you issued the GRANT statement for the guacamole_user account. Make sure that matches up. -Nick >
