I'm trying to install nss_postgresql in the Conectiva Linux 6.0 distribution. The system recognizes the users in the db, but seems to not lookup the passwords in the a_shadow table... the shadow.c seems to be without use, how you can see in the logs:
nss_pgsql[632]: starting connection
nss_pgsql[632]: find 0 servers definition.
nss_pgsql[632]: connect string :[0] host=localhost port=5432 dbname=pg_auth user=pwlookup password=passwd
nss_pgsql[632]: connected
nss_pgsql[632]: getpwnam(test)
nss_pgsql[632]: select username,passwd,uid,gid,gecos,homedir,shell from a_passwd where username = 'test'
nss_pgsql[632]: one entry found
nss_pgsql[632]: closing connection
nss_pgsql[632]: connection closed
nss_pgsql[632]: getpwname(test) return [1]
PAM_pwdb[632]: check pass; user unknown
login[632]: FAILED LOGIN 1 FROM (null) FOR test, User not known to the underlying authentication module
can anyone help me ???
thanks,
mentex
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
CREATE UNIQUE INDEX "users_uid_key" on "a_passwd" using btree ( "uid" "int4_ops" );
CREATE UNIQUE INDEX "group_gid_key" on "a_group" using btree ( "gid" "int4_ops" );
this is the cause of my problem ???
thanks,
mentex
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm trying to install nss_postgresql in the Conectiva Linux 6.0 distribution. The system recognizes the users in the db, but seems to not lookup the passwords in the a_shadow table... the shadow.c seems to be without use, how you can see in the logs:
nss_pgsql[632]: starting connection
nss_pgsql[632]: find 0 servers definition.
nss_pgsql[632]: connect string :[0] host=localhost port=5432 dbname=pg_auth user=pwlookup password=passwd
nss_pgsql[632]: connected
nss_pgsql[632]: getpwnam(test)
nss_pgsql[632]: select username,passwd,uid,gid,gecos,homedir,shell from a_passwd where username = 'test'
nss_pgsql[632]: one entry found
nss_pgsql[632]: closing connection
nss_pgsql[632]: connection closed
nss_pgsql[632]: getpwname(test) return [1]
PAM_pwdb[632]: check pass; user unknown
login[632]: FAILED LOGIN 1 FROM (null) FOR test, User not known to the underlying authentication module
can anyone help me ???
thanks,
mentex
I have change the sampleschema to:
CREATE UNIQUE INDEX "users_uid_key" on "a_passwd" using btree ( "uid" "int4_ops" );
CREATE UNIQUE INDEX "group_gid_key" on "a_group" using btree ( "gid" "int4_ops" );
this is the cause of my problem ???
thanks,
mentex