RE: Easiest way to get 300 servers into guacamole!

2018-02-15 Thread 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 
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 
> 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  m: +57 310 229 51 90


a:


Calle 118, No. 14B-56, Ofc 303, Bogotá, 
Colombia


w:


www.v2s.us  e: 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 
>
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: Device redirection not working in LINUX RDP

2018-02-15 Thread Nick Couchman
On Thu, Feb 15, 2018 at 6:02 AM, Amarjeet Singh 
wrote:

> Hi Team,
>
>
> I am trying to redirect Shared drive  [ from Guacamole Server ] to remote
> desktop [ Ubuntu with XfreeRdp installed ] .
>
>
I gather you mean xrdp, not XfreeRdp.  XfreeRdp is the Linux RDP client,
xrdp is the RDP service for Linux.


> It's not working.
>
>
Do you know for sure that xrdp supports drive/filesystem redirection?  Have
you tried it with other RDP clients to see if it works as it does with a
Windows RDP server?

-Nick


Re: Unable to get Duo 2FA to work with Guacamole

2018-02-15 Thread amlamarra
Well, I do have the GUACAMOLE_HOME variable set in /etc/environment. There's
a single line in that file: "GUACAMOLE_HOME=/etc/guacamole" that ensures
that environment variable is set at boot and I can verify with the "env"
command. And I can assure you that both the mysql & Duo extension .jar files
are in the same directory "/etc/guacamole/extensions"...

ND I'm an idiot...

I forgot to extract the downloaded extension file for Duo, leaving it as a
.tar.gz
Once I extracted the .jar file, restarted Jetty, everything worked!

Thank you, Mike, for getting me to do some simple troubleshooting that I
should have done myself  :D



--
Sent from: 
http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/


Device redirection not working in LINUX RDP

2018-02-15 Thread Amarjeet Singh
Hi Team,


I am trying to redirect Shared drive  [ from Guacamole Server ] to remote
desktop [ Ubuntu with XfreeRdp installed ] .

It's not working.

There are no errors in the logs. It is showing thet Guacamole Filesystem
redirected successfully.

Am I missing something ?


Thanks and Regards,
Amarjeet Singh