On Fri, Jul 30, 2021 at 8:53 AM Daniel Harris
<[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
>
