guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carter Sema <CS...@acschools.org>
Subject SQL User/Connection Scripting
Date Thu, 02 Nov 2017 15:31:43 GMT
My guacamole is setup to authenticate from LDAP, but since connections cannot get managed unless
Schema is updated. I wanted to try and manage connections through the SQL database Guacamole
uses. Currently my way to get a user into guacamole is such

SIS SQL Statement Pull into CSV -> PowerShell Adds User to AD Security Group -> User
Logs In->User has no connections
(This process is automated through SFTP and Windows Task Scheduler, every morning around 4AM,
it adds new users)

After the user logs in, usually I add the connection for myself or another Tech, but for students
it could become large scale and not able to be done by hand.

Which is great and works. So I started SQL scripting to add a connection but am just a little
confused and looking for an example, if anyone has done this. In order to add the connection,
First the user has to be added to SQL, (again just looking for example If possible) the My
CSV that I am pulling from our Student information System has all the information needed to
create the SQL user. I am just looking for the mappings that I need to set. I looked at "Chapter
6: Database Authentication" in the Guacamole Manual, but it wasn't all that helpful.  It gives
the column names for SQL, but sometimes a generic example helps me to understand better.

Thanks!

Carter Sema
Network Support Specialist
[CertBadge_Administrator_web]


Mime
View raw message