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
