User and Role UUID ignition 8.3

Hello,

I have installed Ignition 8.3.1 and observed that in the "User Sources" of type Database, the "users" and "roles" tables automatically add a "user_uuid" and "role_uuid" column, respectively. It seems irrelevant whether you configure the User Source to use UUIDs or not; the columns are created and populated with the UUIDs regardless.

If the installation is 100% new, there is no issue because the entire user creation process is new and works correctly. However, if you upgrade from version 8.1 to 8.3, these columns are not created in the existing DB tables. Consequently, the User Source throws errors when attempting to create users or roles from the Gateway web interface. Once the columns are manually created in the table, even if they contain no data initially, you can successfully access and use the interface.

This could be a problem for migrations, as it renders the User Source inoperative until these columns are created.

I also believe it is an error that these columns are created and populated with UUIDs even when the "Use UUIDs" option in the User Source configuration is **not active**, as this behavior can lead to these migration issues.

Regards,

Sounds like a bug. You should open a support ticket.

Yeah definitely a bug. Just for clarity:

  • What type of DB?
  • Is this on upgrade from 8.1 → 8.3.0 or 8.1 → 8.3.1?