On Mon, Apr 1, 2019 at 8:47 AM Oliver.Zhang <zhangjianp...@hikvision.com> wrote:
> The tomcat error log is : > > ### Error querying database. Cause: java.sql.SQLException: Access denied > for user 'guacamole_user'@'10.66.204.13' (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'@'10.66.204.13' > (using password: YES) > > > > > > My guacamole.properties is: > > # MySQL properties > > mysql-hostname: 10.66.204.10 > > mysql-port: 3306 > > mysql-database: ********* > > mysql-username: ********* > > mysql-password: ********* > > mysql-default-max-connections: 1000 > > mysql-default-max-group-connections: 1000 > > > > > > why it still access to mysql 10.66.204.13 and not the 10.66.204.10? > > > > > This message is telling you that the user is logging in *from* 10.66.204.13, presumably the host where Guacamole is running. This just means that the MySQL user either doesn't have an entry for logging in from that host, or the credentials are incorrect. Try logging in using the mysql-username and mysql-password values from a MySQL command line client on the same system where Guacamole is running. -Nick