bug report with mysql and nss_ldap

Hello.

I'd like to report a bug I've found with MySQL. MySQL, as shipped with Mandrake
9, gets hanged when starting it with safe_mysqld or service mysql start
or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS_LDAP IS ENABLED! I'd like to report
this so that you can try if it's a bug from mysql or mandrake9 by trying it on
other systems...

I guess it's a mysql bug as nss_ldap is very standard and used worldwide...

Thank you

How-To-Repeat: Try MySQL with a machine which has nss_ldap, the
name-service-switch module from padl.com included in most distros (rh,
mandrake). It has to be completely enabled, not just ldap in nsswitch.conf, but
fully ldap.conf and ldap.secret configured and working. Then, with nss_ldap
enabled as described, try to start mysql with safe_mysqld, or with the init.d
init scripts. I've found that with su mysql; mysqld -h /var/lib/mysql, mysql
runs flawlessly, so I guess it's simply a safe_mysqld bug or related when trying
to locate the correct user for executing mysqld.

---

--
Francisco A. Lozano
Factory Web - I+D
Tlf: 902 365 055
http://www.factoryw.com
Error 152. Windows no encontrado. ¿(A)legrarse, (B)ailar, (F)iesta?


--
Francisco A. Lozano
Factory Web - I+D
Tlf: 902 365 055
http://www.factoryw.com
Error 152. Windows no encontrado. ¿(A)legrarse, (B)ailar, (F)iesta?

-------------------------------------------------
Servicios de Correo de Factory Web
http://www.factoryw.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13355@lists.mysql.com
To unsubscribe, e-mail

Re: bug report with mysql and nss_ldap

Francisco Lozano writes:
> Hello.
>=20
> I'd like to report a bug I've found with MySQL. MySQL, as shipped wit=
h Mandrake
> 9, gets hanged when starting it with safe_mysqld or service mysql sta=
rt
> or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS_LDAP IS ENABLED! I'd like t=
o report
> this so that you can try if it's a bug from mysql or mandrake9 by try=
ing it on
> other systems...
>=20
> I guess it's a mysql bug as nss_ldap is very standard and used worldw=
ide...
>=20
> Thank you
>=20
> How-To-Repeat:=20


[skip]
>=20
> --=20
> Francisco A. Lozano
> Factory Web - I+D
> Tlf: 902 365 055
> http://www.factoryw.com
> Error 152. Windows no encontrado. =BF(A)legrarse, (B)ailar, (F)iesta?=



Hi!

This list is dedicated to the fully repeatable bug reports.

We do not use Mandrake ourselves, and I doubt that we use nss_ldap
anywhere, so we can not repeat it.

It is, however, possible that it is our bug, and we are eager to fix
bugs ASAP.

So, in order to help us please find out what is written in MySQL error
log, under which uid is mysqld running, what are permissions /
ownerships within the datadir etc ...

It is possible that it is nss_ldap bug, as mysql is very standard and
used worldwide.

Thank you
=20

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13357@lists.mysql.com
To unsubscribe, e-mail

Re: bug report with mysql and nss_ldap

Francisco Lozano writes:
> Hello.
>
> I'd like to report a bug I've found with MySQL. MySQL, as shipped with
> Mandrake 9, gets hanged when starting it with safe mysqld or service
> mysql start or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS LDAP IS ENABLED!
> I'd like to report this so that you can try if it's a bug from mysql
> or mandrake9 by trying it on other systems...

I noticed the bug too, using SuSE 7.3 and mysqld Ver 3.23.41
mysqld is running as user mysql and mysql has rwx-permission
on database-dir (/var/liv/mysql).

How-To-Repeat:

Enabling ldap lookup in /etc/nsswitch.conf (passwd: files ldap),
mysqld hangs on signal 11 (no logfile is beeing created):

mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary or one of the libraries it was linked agaist is corrupt,
improperly built,or misconfigured. This error can also be caused by
malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, something is
definitely wrong and this may fail

key_buffer_size=16773120
record_buffer=131072
sort_buffer=524280
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size+(record_buffer + sort_buffer)*max_connections = 80379K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Bogus stack limit or frame pointer, fp=0xbfffdb68,
stack_bottom=0x7445f910, thread_stack=65536, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x73311e10 is invalid pointer
thd->thread_id=-353769241


Successfully dumped variables, if you ran with --log, take a look at the
details of what thread -353769241 did to cause the crash. In some cases
of really bad corruption, the values shown above may be invalid



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13374@lists.mysql.com
To unsubscribe, e-mail