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/
>

Reply via email to