Thanks for the advice. I'm not yet fluent with using APIs, so discovering the APIs for Guacamole is a tall task I'm not ready to take on. So, back to the white board it is.
Sent: Tuesday, February 15, 2022 at 2:57 PM
From: "Craig Sawyer" <[email protected]>
To: [email protected]
Subject: Re: Manual database update
From: "Craig Sawyer" <[email protected]>
To: [email protected]
Subject: Re: Manual database update
in the PG database, `
nextval('guacamole_entity_entity_id_seq'::regclass)`, i.e. the entity
ID is created for you, and you probably shouldn't mess with that.
You appear to be using MySQL and it's apparently due to MySQL Strict
Mode, whatever that is(not a MySQL user). You probably don't want to
turn it off, MySQL isn't known for being the best data safety steward
by default, so turning off the default on safety stuff seems like a
bad idea.
Instead I'd just add/delete users based on their username, which
should be unique across your organization anyway. You can always
figure out the entity ID if needed. i.e. use a null value for the ID,
and let the DB create the entity_id #'s for you.
For us, we use the somehwat undocumented API instead to do these
things from python code(any language possible), but it's exactly the
same use-case. We programatically setup guac users and connections
before the user ever connects to Guac as part of our sync users to HR
system.
-Craig
On Tue, Feb 15, 2022 at 12:34 PM Jim Rx <[email protected]> wrote:
>
> Hello - I am attempting to manually control the contents of the guacmole_entity, guacamole_user, and guacamole_connection_permission tables.
>
> My overall goal is the script the provisioning of connections. I would like to be in a position where our users can log in to guacamole and already have their connections defined and assigned to their profile.
>
> My planned approach to this is to create a txt/csv file with the proper entries for each of the tables, and then use those to manually load into the tables.
>
> I'm running into my first issue with the guacamole_entity table. As it stands, there is one entry in the table, entity_id 1, which is guacadmin.
>
> The reason I want to manually control the entity_id is so that I can reliably delete those entries when the group of users depart and their connections are no longer needed.
>
> I have a txt file with a few users in it, and I am attempting to manually define the entity_id. The text file for my tests looks like this:
> 101,2299Bbob,USER
> 102,2299JWill,USER
> 103,2299SDogg,USER
> 104,2299AUser,USER
>
> When I try to import this into the entity table, I receive an error that says I have an incorrect integer value. Specifically:
>
> ERROR 1366 (22007) at line 1: Incorrect integer value: '101' for colum `guacamole_db`.`guacamole_entity`.`entity_id` at row 1
>
> Any suggestions?
>
> Thanks
>
> Jim
> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
nextval('guacamole_entity_entity_id_seq'::regclass)`, i.e. the entity
ID is created for you, and you probably shouldn't mess with that.
You appear to be using MySQL and it's apparently due to MySQL Strict
Mode, whatever that is(not a MySQL user). You probably don't want to
turn it off, MySQL isn't known for being the best data safety steward
by default, so turning off the default on safety stuff seems like a
bad idea.
Instead I'd just add/delete users based on their username, which
should be unique across your organization anyway. You can always
figure out the entity ID if needed. i.e. use a null value for the ID,
and let the DB create the entity_id #'s for you.
For us, we use the somehwat undocumented API instead to do these
things from python code(any language possible), but it's exactly the
same use-case. We programatically setup guac users and connections
before the user ever connects to Guac as part of our sync users to HR
system.
-Craig
On Tue, Feb 15, 2022 at 12:34 PM Jim Rx <[email protected]> wrote:
>
> Hello - I am attempting to manually control the contents of the guacmole_entity, guacamole_user, and guacamole_connection_permission tables.
>
> My overall goal is the script the provisioning of connections. I would like to be in a position where our users can log in to guacamole and already have their connections defined and assigned to their profile.
>
> My planned approach to this is to create a txt/csv file with the proper entries for each of the tables, and then use those to manually load into the tables.
>
> I'm running into my first issue with the guacamole_entity table. As it stands, there is one entry in the table, entity_id 1, which is guacadmin.
>
> The reason I want to manually control the entity_id is so that I can reliably delete those entries when the group of users depart and their connections are no longer needed.
>
> I have a txt file with a few users in it, and I am attempting to manually define the entity_id. The text file for my tests looks like this:
> 101,2299Bbob,USER
> 102,2299JWill,USER
> 103,2299SDogg,USER
> 104,2299AUser,USER
>
> When I try to import this into the entity table, I receive an error that says I have an incorrect integer value. Specifically:
>
> ERROR 1366 (22007) at line 1: Incorrect integer value: '101' for colum `guacamole_db`.`guacamole_entity`.`entity_id` at row 1
>
> Any suggestions?
>
> Thanks
>
> Jim
> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
