Thanks!
From: Nick Couchman <[email protected]> Sent: Friday, July 30, 2021 8:45 AM To: [email protected] Subject: Re: OIDC and PostgreSQL Authentication On Fri, Jul 30, 2021 at 8:53 AM Daniel Harris <[email protected]<mailto:[email protected]>> wrote: Hi Nick! Thanks for the information; To confirm, auto-create-users is working perfectly. I've just tried to run the DB query to set a user as an admin however, I keep getting the following error; guacamole_db=# INSERT INTO guacamole_system_permission(permission,entity_id) VALUES(ADMINISTER,2); ERROR: column "administer" does not exist LINE 1: ...le_system_permission(permission,entity_id) VALUES(ADMINISTER... Possible I typo'd the query: INSERT INTO guacamole_system_permission(permission,entity_id) VALUES ('ADMINISTER',2); Might be that the ADMINISTER enum needs the single-quotes around it, like a string value. I rarely do any work directly in the DB, so I was just taking a guess at it. I confirmed using TABLE guacamole_system_permission; that ADMINISTER does exist, so I'm not sure what is missing. The reason for doing it this way is if I remove the OIDC authentication mechanism I get no login prompt so I'm trying to set the administrator role directly in the DB so I can do the rest. Yep, makes sense. -Nick
