Make pgl_reporters group independent from root user

[alcazoid]

Is it possible to use user id == 0 for the owner id of pgl_reporters? This will ensure that even if you delete root user, group will still function.

When you delete user - all groups owned by him are removed as well. I use LDAP authentication and don't need local root user, so I delete it(after making one of LDAP users an administrator, of course), which causes deletion of the pgl_reporters group and further errors.

[ArthurHoaro]

I understand your problem, but I don't think it's a good idea to rely on the user id or sequence number in the DB. If for some reason, my sequence number starts at 5 instead of 1, it won't work either. I think that the 'root' user is the most common thing between every GitLab installation.

I would suggest that you block Administrator instead of removing him. But if you really want to delete root, you should edit the file pgl/pgl_script_postgres.sql (or MySQL) line 5 and replacing 'root' by your administrator username (before running the script, of course).
EDIT: It can be a little tricky, because your user need to be already created.

I didn't know that removing root removed the team though, I'll add a notice in the README.

[alcazoid]

Hm, the numbering starts from 1, ids are incrementing, and user with id == 1 is root, that's why I suggested using 0 as identifier, that's the other common thing with GitLab installations - 0 user id is usually not occupied, unless you mess with your DB manually.

I've already patched my triggers, thank you.

[ArthurHoaro]

Oh ok. I didn't tried, but I'm not sure that giving no owner to a team is a good idea.