You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by "Oliver.Zhang" <zh...@hikvision.com> on 2019/04/01 12:46:39 UTC
答复: POST /guacamole/api/tokens HTTP/1.1" 500
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?
发件人: Mike Jumper [mailto:mjumper@apache.org]
发送时间: 2019年4月1日 20:33
收件人: user@guacamole.apache.org
主题: Re: POST /guacamole/api/tokens HTTP/1.1" 500
On Mon, Apr 1, 2019, 05:24 Oliver.Zhang <zh...@hikvision.com>> wrote:
The error occurred : POST /guacamole/api/tokens HTTP/1.1" 500, hwo to resolve it?
You will need to determine what error is occurring.
Check the Tomcat logs for error messages from Guacamole, some of which may have occurred much earlier during webapp startup. If you have a reverse proxy in front of Guacamole, check that, too.
- Mike
________________________________
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>
答复: POST /guacamole/api/tokens HTTP/1.1" 500
Posted by "Oliver.Zhang" <zh...@hikvision.com>.
I got it.because the guacamole_user privilegees is not enough.
mysql> CREATE DATABASE guacamole_db;
Query OK, 1 row affected (0.00 sec)
mysql> CREATE USER 'guacamole_user'@'localhost' IDENTIFIED BY 'some_password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON guacamole_db.* TO 'guacamole_user'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)
发件人: Mike Jumper [mailto:mjumper@apache.org]
发送时间: 2019年4月1日 21:25
收件人: user@guacamole.apache.org
主题: Re: POST /guacamole/api/tokens HTTP/1.1" 500
On Mon, Apr 1, 2019, 06:13 Oliver.Zhang <zh...@hikvision.com>> wrote:
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?
If the logs show that access is being denied to the MySQL user at 10.66.204.13, it is because that is the IP address of the Guacamole server relative to the MySQL server.
If you are expecting otherwise, I suggest rechecking the configuration of your VM and network settings. According to your logs, reality doesn't agree with that expectation.
- Mike
________________________________
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>
Re: POST /guacamole/api/tokens HTTP/1.1" 500
Posted by Mike Jumper <mj...@apache.org>.
On Mon, Apr 1, 2019, 06:13 Oliver.Zhang <zh...@hikvision.com> wrote:
> 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?
>
If the logs show that access is being denied to the MySQL user at
10.66.204.13, it is because that is the IP address of the Guacamole server
relative to the MySQL server.
If you are expecting otherwise, I suggest rechecking the configuration of
your VM and network settings. According to your logs, reality doesn't agree
with that expectation.
- Mike
答复: POST /guacamole/api/tokens HTTP/1.1" 500
Posted by "Oliver.Zhang" <zh...@hikvision.com>.
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:vnick@apache.org]
发送时间: 2019年4月1日 20:58
收件人: user@guacamole.apache.org
主题: Re: POST /guacamole/api/tokens HTTP/1.1" 500
On Mon, Apr 1, 2019 at 8:47 AM Oliver.Zhang <zh...@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
________________________________
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>
Re: POST /guacamole/api/tokens HTTP/1.1" 500
Posted by Nick Couchman <vn...@apache.org>.
On Mon, Apr 1, 2019 at 8:47 AM Oliver.Zhang <zh...@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