Project

General

Profile

Bug #40856

Fix display of GIDs in new UI

Added by Tom Fjader over 1 year ago. Updated over 1 year ago.

Status:
Done
Priority:
No priority
Assignee:
Vaibhav Chauhan
Category:
GUI (new)
Target version:
Seen in:
Severity:
New
Reason for Closing:
Reason for Blocked:
Needs QA:
No
Needs Doc:
No
Needs Merging:
No
Needs Automation:
No
Support Suite Ticket:
n/a
Hardware Configuration:
ChangeLog Required:
No

Description

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.

users-legacy-ui.png (32.8 KB) users-legacy-ui.png Correct GID in Legacy UI Tom Fjader, 08/07/2018 08:35 AM
incorrect-GID-new-UI.png (112 KB) incorrect-GID-new-UI.png Incorrect GID in New UI Tom Fjader, 08/07/2018 08:35 AM
23864
23868

History

#1 Updated by Tom Fjader over 1 year ago

  • Subject changed from Account / Users shows wrong GID to Account / Users shows wrong GID in new UI
  • Description updated (diff)
  • Seen in changed from Unspecified to 11.2-U3

#2 Updated by Tom Fjader over 1 year ago

  • Seen in changed from 11.2-U3 to 11.2-BETA2

#3 Updated by Dru Lavigne over 1 year ago

  • Reason for Blocked set to Need additional information from Author

Tom: can you attach a screenshot of what you are seeing in the UI as an example?

#4 Updated by Tom Fjader over 1 year ago

23864
23868

I added two images showing the correct GID's in Legacy UI versus wrong GID's in the new UI

#5 Updated by Dru Lavigne over 1 year ago

  • Assignee changed from Release Council to Erin Clark
  • Target version changed from Backlog to 11.2-BETA3

#6 Updated by Erin Clark over 1 year ago

  • Assignee changed from Erin Clark to Dennis Mullen

#8 Updated by Erin Clark over 1 year ago

  • Assignee changed from Dennis Mullen to Vaibhav Chauhan

#10 Updated by Vaibhav Chauhan over 1 year ago

  • Status changed from Unscreened to In Progress

#11 Updated by Erin Clark over 1 year ago

  • Status changed from In Progress to Ready for Testing

#12 Updated by Dru Lavigne over 1 year ago

  • Subject changed from Account / Users shows wrong GID in new UI to Fix display of GIDs in new UI
  • Reason for Blocked deleted (Need additional information from Author)
  • Needs Doc changed from Yes to No
  • Needs Merging changed from Yes to No

#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.

#14 Updated by Dru Lavigne over 1 year ago

  • Status changed from Passed Testing to Done

Also available in: Atom PDF