my guacamole server deploy in the vm the ip is 10.66.204.10, I cloned a vm from 10.66.204.10 and set the ip is 10.66.204.13 for the new cloned vm i stop the mysql in the new cloned vm, and modify mysql-hostname: to 10.66.204.10 in the guacamole.properties, the start the guacamole guacd and tomcat why it still access to mysql 10.66.204.13 and not the 10.66.204.10?
发件人: Nick Couchman [mailto:[email protected]] 发送时间: 2019年4月1日 20:58 收件人: [email protected] 主题: Re: POST /guacamole/api/tokens HTTP/1.1" 500 On Mon, Apr 1, 2019 at 8:47 AM Oliver.Zhang <[email protected]<mailto:[email protected]>> 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 ________________________________ CONFIDENTIALITY NOTICE: This electronic message is intended to be viewed only by the individual or entity to whom it is addressed. It may contain information that is privileged, confidential and exempt from disclosure under applicable law. Any dissemination, distribution or copying of this communication is strictly prohibited without our prior permission. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, or if you have received this communication in error, please notify us immediately by return e-mail and delete the original message and any copies of it from your computer system. For further information about Hikvision company. please see our website at www.hikvision.com<http://www.hikvision.com>
