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

前提

已完成guacamole 0.9.8的基本安装
已安装好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.解压这两个文件

1 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下创建这两个文件夹）

1
2

# 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 -p
Enter password: password
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)
mysql> quit
Bye

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

1
2
3

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

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

# MySQL properties
mysql-hostname: localhost
mysql-port: 3306
mysql-database: guacamole_db
mysql-username: guacamole_user
mysql-password: some_password