Re: [Nss-mysql-users] Re: Nss-mysql-users digest, Vol 1 #3 - 2 msgs

[Doug Currey]

Ok things seem to be worse.

I tried to use 33.1 and now get the following  if I do "id ddcurrey" Note:
ddcurrey is only in the mysql database.
error while loading shared libraries: /usr/lib/libnss_mysql.so.2: undefined
symbol: my_thread_end

Go back to .30 this doesn't happen

Here is my log output. with .33.1  as far as the userid and groupid below
they are correct.  This much looks good.

Oct 30 22:16:19 itsi1 nss-mysql[6082]: getpwnam called for ddcurrey
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_read_conf_file: called for
section users
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_read_conf_file ended for
section users
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_db_connect: connection
with host=localhost,user=radius,passwd=radsql,database=radius,port=3306
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_passwd_fill_struct called
for user ddcurrey
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_sqlprintf():
buffersize=1024, len=133
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_passwd_fill_struct: SQL
statement: select
USERNAME,UID,(null),FULL_NAME,"/bin/false","/home/nohome",GID from USERS
where USERNAME='ddcurrey' and UID is not null and 1=1
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_passwd_fill_struct:
username == ddcurrey
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_passwd_fill_struct: uid ==
1053
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_passwd_fill_struct: gid ==
100
Oct 30 22:16:19 itsi1 nss-mysql[6082]: _nss_mysql_passwd_fill_struct
finished sucessfully

Here is output when I did the compile.

./configure --enable-debug
creating cache ./config.cache
checking for gcc... gcc
checking whether the C compiler (gcc  ) works... yes
checking whether the C compiler (gcc  ) is a cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking for mysql_real_connect in -lmysqlclient_r... yes
checking for pthread_mutex_lock in -lpthread... yes
checking for zlibVersion in -lz... yes
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for syslog.h... yes
checking for unistd.h... yes
checking for mysql/mysql.h... yes
checking for pthread.h... yes
checking for working const... yes
checking for uid_t in sys/types.h... yes
checking for inline... inline
checking for size_t... yes
checking for strdup... yes
checking for strtol... yes
checking for mysql_real_escape_string... yes
updating cache ./config.cache
creating ./config.status
creating Makefile
creating tests/Makefile
creating config.h
address@hidden nss-mysql-0.33.1]# make
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -DHAVE_CONFIG -c 
-o parser.o parser.c
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -DHAVE_CONFIG -c 
-o lib.o lib.c
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -DHAVE_CONFIG -c 
-o shadow.o shadow.c
shadow.c: In function `check_connection':
shadow.c:246: warning: implicit declaration of function `my_thread_init'
shadow.c:258: warning: implicit declaration of function `my_thread_end'
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -DHAVE_CONFIG -c 
-o passwd.o passwd.c
passwd.c: In function `check_connection':
passwd.c:328: warning: implicit declaration of function `my_thread_init'
passwd.c:340: warning: implicit declaration of function `my_thread_end'
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -DHAVE_CONFIG -c 
-o group.o group.c
group.c:327:13: warning: junk on line after #undef
group.c:328:15: warning: junk on line after #undef
group.c: In function `_nss_mysql_initgroups':
group.c:379: warning: implicit declaration of function `my_thread_end'
group.c: In function `check_connection':
group.c:561: warning: implicit declaration of function `my_thread_init'
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -DHAVE_CONFIG -De
nt_t=gid_t -c -o ent.o ent.c
ent.c: In function `_nss_mysql_setent':
ent.c:157: warning: implicit declaration of function `my_thread_init'
ent.c:159: warning: implicit declaration of function `my_thread_end'
gcc -g -O2 -Wall -Wstrict-prototypes -Wpointer-arith -fPIC -shared -o
libnss_mysql.so.2 -Wl,-soname,libnss_mysql.so.2 parser.o lib.o shadow.o
passwd.o group.o ent.o -lmysqlclient_r -lz -lpthread
address@hidden nss-mysql-0.33.1]# make install
if [ ! -e /usr/lib ]; then mkdir -p /usr/lib; fi
cp libnss_mysql.so.2 /usr/lib
if ! [ -e /etc/nss-mysql.conf ] ; then install -m 644 -o root -g root
nss-mysql.conf /etc/ ; fi
if ! [ -e /etc/nss-mysql-root.conf ] ; then install -m 600 -o root -g root
nss-mysql-root.conf /etc/ ; fi

Last but not least I still get that same error message if I try to start
mysql with the "groups:  files mysql" line in place.

----- Original Message -----
From: "Guillaume Morin" <address@hidden>
To: "Doug Currey" <address@hidden>
Cc: <address@hidden>
Sent: Friday, October 26, 2001 3:30 AM
Subject: Re: [Nss-mysql-users] Re: Nss-mysql-users digest, Vol 1 #3 - 2 msgs


> Dans un message du 24 oct à 18:56, Doug Currey écrivait :
> > I think it is mysql itself crashing on the nss-mysql stuff but can't
figure
> > out why only the group entry blows its mind.
>
> There is maybe a bug in the MySQL handling of NSS functions ...
>
> > I went to version 3.23.43 latest stable and do get the same results.
> (snip)
> > thd->query at (nil)  is invalid pointer
>
> Hmm, that is really weird.
>
> Could you try to get the latest CVS and compile it in debugmode ?
>
> The log will be very useful if the crash occured really in NSS-MySQL.
>
> Thanks for your help.
>
> Regards
>
> --
> Guillaume Morin <address@hidden>
>
>                     Sometimes I find I need to scream (RHCP)