You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by thestraychow <ol...@gmail.com> on 2018/02/13 13:01:56 UTC
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!
Posted by fou fe <fo...@live.fr>.
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 <mi...@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 <go...@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.rosa@v2s.us<ma...@v2s.us>
From: fou fe [mailto:fouhane@live.fr<ma...@live.fr>]
Sent: Tuesday, 13 February, 2018 14:02
To: user@guacamole.apache.org<ma...@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 <ol...@gmail.com>>
Envoyé : mardi 13 février 2018 14:01
À : user@guacamole.apache.org<ma...@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!
Posted by Mike Jumper <mi...@guac-dev.org>.
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 <go...@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.rosa@v2s.us <go...@v2s.us>*
>
>
>
>
>
> *From:* fou fe [mailto:fouhane@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 <ol...@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/
>
RE: Easiest way to get 300 servers into guacamole!
Posted by Goncalo Rosa <go...@v2s.us>.
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 m: +57 310 229 51 90
a:
Calle 118, No. 14B-56, Ofc 303, Bogotá, Colombia
w:
www.v2s.us<mailto:v2s.us> e: goncalo.rosa@v2s.us<ma...@v2s.us>
From: fou fe [mailto:fouhane@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 <ol...@gmail.com>>
Envoyé : mardi 13 février 2018 14:01
À : user@guacamole.apache.org<ma...@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!
Posted by thestraychow <ol...@gmail.com>.
Hi Fou,
Thanks for the info. What type of connection have you given in the example?
Where would i input that in the database itself?
--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
RE: Easiest way to get 300 servers into guacamole!
Posted by fou fe <fo...@live.fr>.
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 <ol...@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/
Re: Easiest way to get 300 servers into guacamole!
Posted by thestraychow <ol...@gmail.com>.
Thanks Nick - I dont see the REST calls in my developer console on chrome...
Do you have an example of what gets sent when a new connection is created...
I wish there was a CSV import or similar just to get the initial dump of
servers into the application :(
--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: Easiest way to get 300 servers into guacamole!
Posted by Nick Couchman <vn...@apache.org>.
On Tue, Feb 13, 2018 at 8:01 AM, thestraychow <ol...@gmail.com>
wrote:
> 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!
>
>
You can insert them into the database manually, as Fou suggests. This
works, but there is some risk that you'll enter something incorrectly that
won't be caught until you try to use it. The other option is to use the
REST API to create the entries. You can review the documentation, or look
at the Chrome Developer Console (or related development console in other
browsers) and watch the REST calls made when the web application inserts
the servers, and then copy that into a script.
-Nick