System Variables
GUACAMOLE - mySQL
--- GUCAMOLE
mysql -uguacamole -p guacamole
-- Generate salt
SET @salt = UNHEX(SHA2(UUID(), 256));
-- Create user and hash password with salt
INSERT INTO guacamole_user (username, password_salt, password_hash) VALUES ('windtdb', @salt, UNHEX(SHA2(CONCAT('l@Hvv1f3', HEX(@salt)), 256)));
--- Create a Connection
INSERT INTO guacamole_connection (connection_name, protocol) VALUES ('windtdb', 'rdp'); SET @id = LAST_INSERT_ID();
-- Add parameters
INSERT INTO guacamole_connection_parameter VALUES (@id, 'hostname', '128.226.31.95');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'port', '3389');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'disable-audio', 'true');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'ignore-cert', 'true');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'security', 'any');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'domain', 'bgm');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'username', 'chouck');
INSERT INTO guacamole_connection_parameter VALUES (@id, 'password', 'l@Hvv1f3');
show tables;
select * from guacamole_connection;
select * from guacamole_connection_group;
select * from guacamole_connection_group_permission;
select * from guacamole_connection_history;
select * from guacamole_connection_parameter;
select * from guacamole_connection_permission;
select * from guacamole_system_permission;
select * from guacamole_user;
select * from guacamole_user_permission;