[Nss-mysql-devel] [support #102362] with nss-mysql "su" freezes

[nobody]

Support Request #102362, was updated on Tue 08/19/2003 at 16:17
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=102362&group_id=443

Category: None
Status: Open
Priority: 9
Summary: with nss-mysql "su" freezes

By: ian
Date: Tue 09/23/2003 at 08:00
Logged In: NO 
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030921

i jave kist found 'torture' in the 'tests' directory.  if I

compile wiht '--enable-debug' and run this, I do see output

in  my logs, however no output shows when running 'id <user>'

The output that shows is as below



Sep 23 12:50:52 twix torture[18975]: setent called for shadow(2)

Sep 23 12:50:52 twix torture[18975]:

_nss_mysql_set_fork_handler: called

Sep 23 12:50:52 twix torture[18975]:

_nss_mysql_set_fork_handler: finished

Sep 23 12:50:52 twix torture[18975]:

_nss_mysql_read_conf_file: called for section shadow

Sep 23 12:50:52 twix torture[18975]:

_nss_mysql_read_conf_file ended for section shadow

Sep 23 12:50:52 twix torture[18975]: _nss_mysql_db_connect:

called

Sep 23 12:50:52 twix torture[18975]: _nss_mysql_db_connect:

calling mysql_init(NULL)

Sep 23 12:50:52 twix torture[18975]: _nss_mysql_db_connect:

mysql_init() suceeded

Sep 23 12:50:52 twix torture[18975]: _nss_mysql_db_connect:

connection with

host=localhost,user=nss-shadow,passwd=96fc0b5b718aa720676171cd7b7ceda1073421db81bdd86ee582f8a3dfbfb7dc,database=nss_mysql,port=3306

Sep 23 12:50:52 twix torture[18975]:

_nss_mysql_send_query:called. MYSQL * 0x804ed08, mutex

(nil), SQL statement: select

user.password,user.user_name,user.lastchange,user.min,user.max,user.warn,user.inact,user.expire

from user where user.status = 'A' order by user.user_name

Sep 23 12:50:52 twix torture[18975]: setent(2): calling

db_close()

Sep 23 12:50:52 twix torture[18975]: setent(2): finished.

status: 1

Sep 23 12:50:52 twix torture[18975]: getent called for shadow(2)

Sep 23 12:50:52 twix torture[18975]: getent called

Sep 23 12:50:52 twix torture[18975]: user not found

Sep 23 12:50:52 twix torture[18975]: getent(2) exited with

status 0

Sep 23 12:50:52 twix torture[18975]: endent called for shadow(2)

Sep 23 12:50:52 twix torture[18975]: endent(2) finished





Where 'pookey' is in /etc/passwd, and 'test_user' is in

mysql.  debug enabled at compile time. nscd stopped.



twix nss-mysql-0.43 # getent passwd pookey

pookey:x:1000:100::/home/pookey:/bin/bash

twix nss-mysql-0.43 # getent passwd test_user

<hangs>



nothing in logs

starting nscd.



twix nss-mysql-0.43 # getent passwd test_user

test_user:x:1001:100:test user:/home/pookey:/bin/bash



==> auth.log <==

Sep 23 12:57:35 twix nss-mysql[19413]: passwd.c:

handle_query called for name test_user, uid 0, bulk 0

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_read_conf_file: called for section users

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_read_conf_file ended for section users

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_set_fork_handler: called

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_set_fork_handler: setting the fork handler

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_set_fork_handler: finished

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_check_connection called

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_check_connection: Initiating a new connection

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_db_connect: called

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_db_connect: calling mysql_init(NULL)

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_db_connect: mysql_init() suceeded

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_db_connect: connection with

host=localhost,user=nss,passwd=d821a395cb73858854ec1826ca1aa4dd77ef29b57860291631c4c948ea7e357a,database=nss_mysql,port=3306

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_check_connection: sucessfully exiting

Sep 23 12:57:35 twix nss-mysql[19413]: passwd.c: get_query

called for user test_user

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_escape_string: escaping "test_user" (*call_free == 0)

Sep 23 12:57:35 twix nss-mysql[19413]: passwd.c: get_query:

SQL statement is select

user.user_name,user.uid,NULL,user.realname,user.shell,user.homedir,user.gid

from user where user.user_name='test_user' and user.uid is

not null and user.status = 'A' order by user.uid

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_send_query:called. MYSQL * 0x8056b70, mutex

0x40bc594c, SQL statement: select

user.user_name,user.uid,NULL,user.realname,user.shell,user.homedir,user.gid

from user where user.user_name='test_user' and user.uid is

not null and user.status = 'A' order by user.uid

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_copy_to_buffer: called for test_user to

0xbfffa628(1024)

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_passwd_result_to_struct: username == test_user

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_copy_to_buffer: called for x to 0xbfffa632(1014)

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_passwd_result_to_struct: uid == 1001

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_passwd_result_to_struct: gid == 100

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_copy_to_buffer: called for test user to

0xbfffa634(1012)

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_copy_to_buffer: called for /home/pookey to

0xbfffa63e(1002)

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_copy_to_buffer: called for /bin/bash to

0xbfffa64b(989)

Sep 23 12:57:35 twix nss-mysql[19413]:

_nss_mysql_passwd_result_to_struct finished sucessfully

Sep 23 12:57:35 twix nss-mysql[19413]: passwd.c:

handle_query(): reached "out" label, result 0x8058068

Sep 23 12:57:35 twix nss-mysql[19413]: passwd.c: leaving

handle_query with status 1 (errno Success)



==> mysql/mysql.log <==

030923 12:57:35      82 Connect     address@hidden on nss_mysql

                     82 Query       select

user.user_name,user.uid,NULL,user.realname,user.shell,user.homedir,user.gid

from user where user.user_name='test_user' and user.uid is

not null and user.status = 'A' order by user.uid





still with nscd enabled

twix nss-mysql-0.43 # getent shadow test_user

<hangs>

nothing in logs.



twix tests # ls -la /etc/nss-mysql/

-rw-------    1 root     root         4739 Sep 23 10:12

nss-mysql-root.conf

-rw-r--r--    1 root     root         6895 Sep 23 12:39

nss-mysql.conf





Hope this helps!



----------------------------------------------------------------------

By: ian
Date: Tue 09/23/2003 at 06:45
Logged In: NO 
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030921

Right, I have just completly reinstall from scratch.

I'm still getting issues with this one.

Compiling with this...

./configure --enable-debug --sysconfdir=/etc/nss-mysql

results in not even 'id <user>' working, that will freeze

If I configure without '--enable-debug', 'id <user>' will

work, but su 'user' won't. 

I really am keen to help get this bug fixed, so will run any

tests, or allow the package maintainer access to my system.



glibc 2.3.2

gcc version 3.2.3

MySQL 4.0.13

Kernel 2.4.20-gentoo-r7 (a patched 2.4.20 - will try

alternate unpatched kernel on request)



Latest Nss-mysql downloaded from here.

no make options used.

tried both with and without nscd running (don't know if it

would make a difference anyway).

I'm using gentoo 1.4,  everything has been built and

optimised for AMP-XP (don't know if that would mattEr).



Open to suggestsion.  If package maintainer wants access to

try things, please email me (address@hidden) with a SSH key.  



Kind Regards,



Ian

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=102362&group_id=443

_______________________________________________
  Message sent via/by Savannah
  http://savannah.nongnu.org/