Bug #40856

Updated by Tom Fjader about 2 years ago

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. freenas-vi.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_bsdusers.bsdusr_group_id' the get the true GID i.e. 'account_bsdgroups.bsdgrp_gid'. This should be trivial for anyone who knows SQL.