sorry for late answer . like Mike say every tables is described in Manual http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema
guacamole_connection describe each connection and protocol used. guacamole_connection_group is organisational guacamole-connection_group_permission describe users permission for each connection group guacamole_connection_permission describe users permissions with connection_id finaly guacamole_connection_parameter is collections of parameter name and parameter_value for each connection_id parameter_name can be hostname,port, security,drive-path,... you can add connection with GUI and see what happen in your tables with tools like phpmyadmin. I'm also interesting in REST API ... more informations about that will be gracefull? Thanks ________________________________ De : Mike Jumper <mike.jum...@guac-dev.org> Envoyé : mercredi 14 février 2018 22:12 À : user@guacamole.apache.org Objet : Re: Easiest way to get 300 servers into guacamole! Worth noting also that the schema used by the database auth is documented in the manual: http://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema If unsure what tables/columns are applicable to the data you're trying to insert, the above is a good resource. - Mike On Wed, Feb 14, 2018 at 4:24 AM, Goncalo Rosa <goncalo.r...@v2s.us<mailto:goncalo.r...@v2s.us>> wrote: You can do a mysql insert into guacamole_connection table for the connections. And you need to do an insert into guacamole_connection_parameter to set the hostname ipaddress, port and any other required parameter. I did that to bulk 200 connections at once when I started. Kind regards, [http://www.v2s.us/wp-content/uploads/2017/11/logo-V2S-V-c%C3%B3pia.png] GONÇALO COELHO ROSA CTO V2S Colombia p: +57 (1) 7610087<tel:+57%201%207610087> m: +57 310 229 51 90 a: Calle 118, No. 14B-56, Ofc 303, Bogotá, Colombia<https://maps.google.com/?q=Calle+118,+No.+14B-56,+Ofc+303,+Bogot%C3%A1,+Colombia&entry=gmail&source=g> w: www.v2s.us<mailto:v2s.us> e: goncalo.r...@v2s.us<mailto:goncalo.r...@v2s.us> From: fou fe [mailto:fouh...@live.fr<mailto:fouh...@live.fr>] Sent: Tuesday, 13 February, 2018 14:02 To: user@guacamole.apache.org<mailto:user@guacamole.apache.org> Subject: RE: Easiest way to get 300 servers into guacamole! Hi Olivier, There is an example to create connection SET @nom_group_connexion='TC'; SET @type_group= 'ORGANIZATIONNAL' SET @max_connexions='29'; SET @max_connexions_paruser= '1'; #--------------------------------------------- INSERT INTO guacamole_connection_group (connection_group_name,type,max_connections,max_connections_per_user) VALUES (@nom_group_connexion,@type_group, @max_connexions,@max_connexions_paruser); #----------------------------creation serveur dans le groupe SET @nom_connection = 'serveur_tc'; SET @proto='rdp'; INSERT INTO guacamole_connection (connection_name,protocol) VALUES (@nom_connection,@proto) ; You can adapt it with file .csv for 300 servers You have also to add your users and give them permission for each connection. hope that help ________________________________ De : thestraychow <oliver.whitting...@gmail.com<mailto:oliver.whitting...@gmail.com>> Envoyé : mardi 13 février 2018 14:01 À : user@guacamole.apache.org<mailto:user@guacamole.apache.org> Objet : Easiest way to get 300 servers into guacamole! Hi guys, I'm looking at getting a list of servers into guacamole... I use LDAP for auth. Is there an easy way to take the burdon out of making each one individually! -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
