User and Role UUID ignition 8.3

Ignition
1

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,

1 Like
2

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

3

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?
4

Hello,

Upgraded from 8.1.42 to 8.3.0
Database Postgresql 16

5

@strinidad -

I tried to reproduce the issue using PostgreSQL 16.1, and I had no problems with the migration. the *_uuid columns were added and populated as soon as I accessed the user source. They don’t get populated as part of migration, and instead get populated when the user source starts up on first access.

The user source will populate the uuid columns whether you are using them or not.

Did you see any errors in the logs either during migration (first startup after moving to 8.3) or on first access of the user source after the migration (when we attempt to create and fill the columns)?

Jesse

6

Hello,

I cannot see the logs because i reinstall OS and Ignition, and cannot tell you when columns where populated.

The only thing that I can say, is that this ignition installation, initially was an 8.0 version, after several updates on the 8.0 series we upgraded to 8.1. Maybe the 8.0 to 8.1 and then to 8.3 left some trash in the path.

Regards