RE: Easiest way to get 300 servers into guacamole!

[fou fe]

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

RE: Easiest way to get 300 servers into guacamole!

[fou fe]

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