Centos6.5下guacamole 0.9.8配置数据库，实现管理多台电脑

前提

1. 已完成guacamole 0.9.8的基本安装
2. 已安装好mysql

一.下载数据库连接拓展

1.在GUACAMOLE_HOME下创建文件夹sqlauth，下载guacamole-auth-jdbc-mysql-0.9.8.tar.gz和mysql-connector-java-5.1.38.tar.gz

# mkdir sqlauth# cd sqlauth# wget http://dev.mysql.com/get/Downloads/Connector/j/mysql- connector-java-5.1.38.tar.gz # wget https://sourceforge.net/projects/guacamole/files/current/extensions/guacamole-auth-jdbc-0.9.8.tar.gz/

2.解压这两个文件

# tar -zxf guacamole-auth-jdbc-0.9.8.tar.gz# tar -zxf mysql-connector-java-5.1.38.tar.gz

3.将guacamole-auth-jdbc-mysql-0.9.8.jar复制到extensions文件夹下，mysql-connector-java-5.1.38-bin.jar复制到lib下（如果没有这两个文件夹，请先去GUACAMOLE_HOME下创建这两个文件夹）

# cp /etc/guacamole/sqlauth/guacamole-auth-jdbc-0.9.8/mysql/guacamole-auth-jdbc-mysql-0.9.8.jar  /etc/guacamole/extensions/# cp /etc/guacamole/sqlauth/mysql-connector-java-5.1.38/mysql-connector-java-5.1.38-bin.jar /etc/guacamole/lib/

二.创建Guacamole的数据库（这里用的是Mysql)

1.创建一个数据库

# mysql -u root -pEnter password: passwordmysql> 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)mysql> quitBye

2.执行与guacamole想关的sql语句

# cd guacamole/sqlauth/guacamole-auth-jdbc-0.9.8/mysql/schema/# cat ./*.sql | mysql -u root -p guacamole_dbEnter password: password

三.在guacamole.properties中配置数据库的信息，添加下面的内容

# MySQL propertiesmysql-hostname: localhostmysql-port: 3306mysql-database: guacamole_dbmysql-username: guacamole_usermysql-password: some_password

四.成功后guacamole的账号和密码默认都是guacadmin

成功后截图，可在SETTINGS里添加新的电脑

参考文档：

https://deviantengineer.com/2015/02/guacamole-centos7/
http://guacamole.incubator.apache.org/doc/gug/jdbc-auth.html