You can leverage the backend SQL table schema and insert server-connection details directly, providing an alternative to the web admin interface. In this scenario, database tables guacamole_collection and guacamole_connection_parameter are key as they persist connect name, server target, and associated metadata. To insert parent entry, begin with this SQL statement that specifies name and protocol:
INSERT INTO guacamole_connection (connection_name, protocol) VALUES (‘cld-linux-server’, ‘vnc’);
Insert the connection parameters, including hostname and port.
INSERT INTO guacamole_connection_parameter VALUES (1, ‘hostname’, ‘localhost’); INSERT INTO guacamole_connection_parameter VALUES (1, ‘port’, ‘5901’);
Inserting into these tables and leveraging the Connect storage engine that is available for MariaDB, you can bulk-import a server list from an external CSV file containing key server data. The Connect storage engine is available by installing mariadb-plugin-connect. After installation, map a CVS file…