Mailing-List: contact user-help@guacamole.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@guacamole.incubator.apache.org
From: James Fraser <James.Fraser@veritec.com.au>
To: "user@guacamole.incubator.apache.org"
	<user@guacamole.incubator.apache.org>
Subject: RE: groups for user .
Thread-Topic: groups for user .
Thread-Index: AQHS6V4WHcP17TI4F0Ct7Czlx4CZDaItVy0AgAEu3IA=
Date: Wed, 21 Jun 2017 01:19:57 +0000
Message-ID: <SYXPR01MB17903C06EB297553FC6A141EBADA0@SYXPR01MB1790.ausprd01.prod.outlook.com>
References: <CAAU4Jc8TLcsQ1L72WokaoO8TyMpc55JbsZqzQMTgmSeuj6aotw@mail.gmail.com>
 <CAAU4Jc_ib=i9bLoHrwCPM_hah9wVCzMaGJnMoKC0OHh1psk=dA@mail.gmail.com>
 <410b0f08b6134e0ba641d8c1bfacbed1@VM-EXCH13-PCA.mulhouse.fr>
 <1497918329204-1177.post@n4.nabble.com>
 <1ead8bbda8da44e3beeb36806ab64e8f@SRVV2SHQPEXG01.v2s.loc>
In-Reply-To: <1ead8bbda8da44e3beeb36806ab64e8f@SRVV2SHQPEXG01.v2s.loc>
Accept-Language: en-US
Content-Language: en-US
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Jun 2017 01:19:57.9039
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b7ee413d-ea27-457d-9c0d-589dadc4baaa
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SYXPR01MB1790
archived-at: Wed, 21 Jun 2017 01:20:21 -0000

Hi Goncalo

You might find you can accomplish what you want with posh ssh module for ss=
h in powershell

https://github.com/darkoperator/Posh-SSH


-----Original Message-----
From: Goncalo Rosa [mailto:goncalo.rosa@v2s.us]=20
Sent: Tuesday, 20 June 2017 5:15 PM
To: user@guacamole.incubator.apache.org
Subject: RE: groups for user .

Hi,

I am using Guacamole on a lab environment, where Guacamole servers are stay=
ing in a DMZ.

So I don't want to integrate with our lab domain, since don't want to expos=
e it to the DMZ. Instead I decided to implement local mariadb database for =
each guacamole server.

On the other hand I have around 200 users being weekly assigned to lab envi=
ronments dynamically. And I have a centralized windows 2008 R2 server that =
provides management to all lab environment components. So I constantly need=
 to add and remove connections to users from this Windows 2008 R2 servers o=
n Guacamole servers.

The way I did it and works great, was using powershell scripts, that uses s=
sh to remotely run bash scripts on each guacamole server, that on their han=
d execute SQL statements against MariaDB database.

And actually just work great with no errors and quite clean.

I also tried to run powershell commands straight to MariaDB with mysql conn=
ector, however didn't work, since most of the sql statements requires multi=
ple instructions per connection and I couldn't find a way to make it happen=
 through mysql-connector invoked from powershell.

So I would suggest you to think in a solution as such, that would allow you=
 to manage your connections around easily and smoothly.

Cheers

Gon=E7alo Rosa


W: www.v2s.us                   Skype: goncalo_rosa

-----Original Message-----
From: s1324 [mailto:steve_alder@csx.com]=20
Sent: Tuesday, June 20, 2017 01:25
To: user@guacamole.incubator.apache.org
Subject: RE: groups for user .

Did you get this issue resolved?

I am having the same challenge.


--
View this message in context: http://apache-guacamole-incubating-users.2363=
388.n4.nabble.com/groups-for-user-tp407p1177.html
Sent from the Apache Guacamole (incubating) - Users mailing list archive at=
 Nabble.com.