column number 3 is out of range 0..2

[frateralexander]

Dears,
When I try use the command "getent group MyUser" I have an error:
column number 3 is out of range 0..2
Could you help me about this
My query is
getgrnam = SELECT groupname, passwd, gid FROM group_table WHERE groupname = $1

[frateralexander]

I'm using libnss-pgsql2 with cockroachDB

@frateralexander did you ever get this to work? When I enable query logging for Cockroach, I don't even see libnss-pgsql even attempt queries after login.

[mariusmarais]

I ran into the same problem, you can work around it by adding a fourth column using a query like

SELECT groupname, passwd, gid, '' FROM group_table WHERE groupname = $1

After that all getents work, although I'm still getting a hang when trying to login as a user.

[hjr3]

After that all getents work, although I'm still getting a hang when trying to login as a user.

After applying #2 then it stops hanging for me. However, it was still failing to login. Once I found https://serverfault.com/a/988551/132409 and got nscd running then I can log in as normal.

I am having problems with chroot still though.