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> 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, > > > > > > [image: > 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 <+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 <v2s.us>* e: *goncalo.r...@v2s.us <goncalo.r...@v2s.us>* > > > > > > *From:* fou fe [mailto:fouh...@live.fr] > *Sent:* Tuesday, 13 February, 2018 14:02 > *To:* 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> > *Envoyé :* mardi 13 février 2018 14:01 > *À :* 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/ >