Hi, If you’re more familiar with MySQL, stick with that, it’ll be easier for you in the long run. Unless you’re running some super duper distributed active-active DB cluster, you shouldn’t find any issues (performance wise) with MySQL as a db provider.
Bogdan > On 10 Sep 2020, at 21:10, Lander, Howard Michael <[email protected]> wrote: > > Hi Nick > > I've just about got this working, but there is one sticking point: I > realized that I need to create the user myself rather than depending on the > mechanism enabled by postgresql-auto-create-accounts, The documentation is > pretty clear on how to do this in mysql, but much less forthcoming on how to > do this in postgresql. A few minutes of Google searching didn't seem to find > a simple recipe. Can you offer any advice on this? I have considered > switching to mysql, since I really don't care much which database is running. > > Thanks > Howard > > From: Nick Couchman <[email protected]> > Sent: Wednesday, September 9, 2020 4:36 PM > To: [email protected] <[email protected]> > Subject: Re: Running guacamole inside of a secured environment > > On Wed, Sep 9, 2020 at 4:33 PM Lander, Howard Michael <[email protected] > <mailto:[email protected]>> wrote: > Thanks for such a quick response. > > I am updating to 1.2.0 now. > > Is it not possible to do the mapping between users and connections using > psql? Sort of looks like it is in the docs... I am doing an automated > deployment and can't really use the GUI. > > > Oh, it is definitely possible - that's all the WebUI does. Basically what > you'll need to do is: > - Grab the entity_id of the user or group you want to associate > - Grab the connection_id of the connection you want to associate > - Add an entry to the <guacamole_connection_permission> table with the entity > id, the connection id, and "READ" permission. > > You can do this with SQL on the database itself, or you can automate via > Guacamole's REST API. Unfortunately right now documentation for the REST API > is lacking, so if you go that route you'll have to figure out the calls to > make by looking at the network traffic on the web interface and duplicating > that. > > -Nick
