Installed Guacamole; All good and have login page.
But "guacadmin" user/pass is not a valid credential as it doesn't connect to
MySQL.
General config is as below on a Debian based OS:
sudo mkdir -p /usr/share/tomcat8/.guacamole/{extension.lib}
wget
https://downloads.mysql.com/archives/get/p/3/file/mysql-connector-java-8.0.18.tar.gz
tar xzf mysql-connector-java-8.0.18.tar.gz
sudo cp mysql-connector-java-8.0.18/mysql-connector-java-8.0.18.jar
/usr/share/tomcat8/.guacamole/lib
wget
http://mirror.intergrid.com.au/apache/guacamole/1.0.0/binary/guacamole-auth-jdbc-1.0.0.tar.gz
tar xzf guacamole-auth-jdbc-1.0.0.tar.gz
sudo cp
guacamole-auth-jdbc-1.0.0.tar.gz/mysql/guacamole-auth-jdbc-mysql-1.0.0.jar
/usr/share/tomcat8/.guacamole/lib
tried *mysql-connector-java-5.1.46-bin.jar* above as well, no difference.
MySQL:
CREATE DATABASE guacdb;
CREATE USER 'guacamole_user'@'localhost' IDENTIFIED BY 'some_password';
GRANT SELECT,INSERT,UPDATE,DELETE ON guacdb.* TO
'guacamole_user'@'localhost';
FLUSH PRIVILEGES;
Schema:
sudo mysql guacdb < 001-create-schema.sql
sudo mysql guacdb < 002-create-admin-user.sql
guacamole.properties:
~ sudo vim /etc/guacamole/guacamole.properties
# MySQL properties
mysql-hostname: localhost
mysql-port: 3306
mysql-database: guacdb
mysql-username: guacamole_user
mysql-password: some_password
Tomcat8 has it logged in /catalina.out/ as:
/[2020-04-04 21:01:49] [info] 21:01:49.054 [http-nio-8080-exec-2] WARN
o.a.g.r.auth.AuthenticationService - Authentication attempt from
0:0:0:0:0:0:0:1 for user "guacadmin" failed./
Any advice? something's missed?
P.S. /user-mapping.xml/ works fine for login and connections.
--
Sent from:
http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
For additional commands, e-mail: user-h...@guacamole.apache.org
