Hi Goncalo You might find you can accomplish what you want with posh ssh module for ssh in powershell
https://github.com/darkoperator/Posh-SSH -----Original Message----- From: Goncalo Rosa [mailto:[email protected]] Sent: Tuesday, 20 June 2017 5:15 PM To: [email protected] Subject: RE: groups for user . Hi, I am using Guacamole on a lab environment, where Guacamole servers are staying in a DMZ. So I don't want to integrate with our lab domain, since don't want to expose 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 environments 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 on Guacamole servers. The way I did it and works great, was using powershell scripts, that uses ssh to remotely run bash scripts on each guacamole server, that on their hand 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 connector, however didn't work, since most of the sql statements requires multiple 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çalo Rosa W: www.v2s.us Skype: goncalo_rosa -----Original Message----- From: s1324 [mailto:[email protected]] Sent: Tuesday, June 20, 2017 01:25 To: [email protected] 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.2363388.n4.nabble.com/groups-for-user-tp407p1177.html Sent from the Apache Guacamole (incubating) - Users mailing list archive at Nabble.com.
