[Nsspampgsql-devel] error with " DECLARE nss_pgsql_internal_allusers_curs SCROLL CURSOR FOR FOR READ ONLY"

[Coiby Xu]

Hi Stephen,

The problem is caused by nscd. I reload the service and it works normally
now:) Thanks!

P.S: I edit entry on the wiki of fusionforge to show the whole process,
hope it may useful to other people. Here's the link:
https://fusionforge.org/plugins/mediawiki/wiki/fusionforge/index.php/Configuration/NSS
.

2012/4/14 Stephen Gran <sgran at debian.org>

> Hi,
>
> This one time, at band camp, Coiby Xu said:
> > Hi Stephen,
> >
> > Thanks for you reply! Another thing is that if running "getent passwd
> > {shell_user}", it will not search for {shell_user} in database according
> to
> > log of pgsql but only in /etc/passwd.
>
> Can you make sure you have these three entries (each one is one line, so
> if it wraps in your mail client make sure it doesn't wrap in the config
> file).
>
> allusers        = SELECT login AS username, passwd, gecos,
> ('/var/lib/gforge/chroot/home/users/' || login) AS homedir, shell, uid, gid
> FROM nss_passwd
> getpwuid        = SELECT login AS username, passwd, gecos,
> ('/var/lib/gforge/chroot/home/users/' || login) AS homedir, shell, uid, gid
> FROM nss_passwd WHERE uid = $1
> getpwnam        = SELECT login AS username, passwd, gecos,
> ('/var/lib/gforge/chroot/home/users/' || login) AS homedir, shell, uid, gid
> FROM nss_passwd WHERE login = $1
>
> This should allow you to run 'getent passwd' and 'getent passwd $user'.
>
> If a query doesn't hit postgres, it is getting an answer from somewhere.
> Are you running nscd?  If so, please disable it for the duration of
> testing - it (obviously, I suppose) caches answers and can skew testing.
>
> Cheers,
> --
>  -----------------------------------------------------------------
> |   ,''`.                                            Stephen Gran |
> |  : :' :                                        sgran at debian.org |
> |  `. `'                        Debian user, admin, and developer |
> |    `-                                     http://www.debian.org |
>  -----------------------------------------------------------------
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
>
> iQIcBAEBCAAGBQJPiVF4AAoJELMRjO+K6o/u0OIQAOYHNPcTZo30auSplocX1Zcj
> MVa/m5kA7BTspPtgTVTdGM1hsY/VWQKXRdSouMKlXJ50Ad87q3LJDAOjoNIOXvVk
> 2PBX5IzEtv8EraEKVhb29xnwNWWPJ+Puhi2f6fXPA4j2chT6jFkA1BSEKksWC6Ap
> ZWLL7L5kJCk5aiXThtHNOQEdft+sbiBw7qZ4Ik4t37Ag/jw6DOEYYkgzzbcsqKsx
> wgfIFVH6npOHd0RkOEwYniy2wtxxJfErbYU1+vtwF+Gj2KMd+qLjUpkb0OeGC4JV
> W9k6rNNF0ouceNfC0Ms4jphkvwVHqbTiUpzDg1hb8oIxShN07Eb5II4wOH2213F8
> w0Ls5VhpUwEu4d3aLPULjd81Tk4TcKUjk1T5Q8BWF57rXkYzb6b7jBgo9Rf5CebR
> I+0NWus4OSlZuOtN0ZvgyqxWyW9+SmkefCAf3M9DCOzWWDp+nVKbeKoQPW7gyVMa
> 3DIgk85kX5uvwt0B+3j/3zaVdpn6KSqjm1C0a9DR2muUqfDb0eB9ELUM90TwxvrL
> OBVhwbotoz2EVa9CtmVJpvwXGo/nSmAhC4XD+/B67wHyFoL59/KaFL/pRUy+6BRJ
> 7levLNDf0jDhwjFrInwxFc1g3jrX214pLEjlhCZhoDx248IBKUTC0+rJSuiiipA5
> 0XPn1z6b3+/pSglD6bO8
> =Z2qP
> -----END PGP SIGNATURE-----
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/nsspampgsql-devel/attachments/20120414/aef0ccaf/attachment.html>