Fix display of GIDs in new UI
The GID field in Account / Users is clearly wrong. I guess you output wrong field from the database. There is no GID field in the account_bsdusers table in the freenas-v1.db. You apparently output field account_bsdusers.bsdusr_group_id, but this field is NOT the GID, it is the FOREIGN KEY to table account_bsdgroups.
You need e.g. a JOIN query with those two tables joined 'ON account_bsdgroups.id = account_bsdusers.bsdusr_group_id' the get the true GID i.e. 'account_bsdgroups.bsdgrp_gid'. This should be trivial for anyone who knows SQL.
#13 Updated by Timothy Moore II over 1 year ago
- Status changed from Ready for Testing to Passed Testing
- Needs QA changed from Yes to No
Testing with FreeNAS system updated to FreeNAS-11.2-MASTER-201808310859:
Go to Account > Users. Create new users Chester and Maximilian. View UID and GID for these users and compare to the display in Legacy UI. Values match and appear correct.