On 12/06/2019 20:56, DmitriyL wrote:
I have successfully deployed Guacamole 1.0.0, and now looking into automating some of the tasks for adding users & connections. For config storage I have gone with Postgres, so the idea is to run sql commands against the DB. I have reviewed the documentation (https://guacamole.apache.org/doc/gug/jdbc-auth.html#jdbc-auth-schema) and while I've had some success with writing scripts I'm very new to sql so it's been a struggle. Is there a repo with SQL scripts for managing common tasks in Guacamole DB? Thank you.
Here's a quick description of my php-based solution. I don't think it works verbatim on Guacamole 1.0.0 due to some minor schema updates since I wrote it, but it might give you some useful pointers in conjunction with the schema documentation you linked to (e.g. there might be some new fields you need to set to sensible 'default' values)
http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/Guacamole-SQL-queries-td4411.html#a4423 Adam --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
