Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MySQL Client / pthread Problem

1 view
Skip to first unread message

Nick Vargish

unread,
Feb 25, 2000, 3:00:00 AM2/25/00
to

Greetings,

Sorry if this is the wrong list, or if the answer is available in some
other (less intrusive) forum[1].

I am trying to use MySQL and a couple of tools on my OpenBSD 2.6 system. I
successfully built and installed MySQL using the ports facility. It runs
fine, and I can create databases and tables, run SELECTs and so on.

The problem crops up when I try to build tools that use the libmysqlclient
shared library. I get this error with php (by looking in the logs) and
with xmysql (built from within ports facility, by the way):

imrryr$ xmysql

/usr/libexec/ld.so: Undefined symbol "_pthread_key_create" called from
xmysql:/usr/local/lib/libmysqlclient.so.6.0 at 0x40039538

According to the system man pages, pthread_key_create does indeed exsit.
It doesn't seem to matter what I set my LD_LIBRARY_PATH to, but I'm open
to any suggestions.

Thanks for any advice or help you can pass my way,

Nick

[1] I spent a good portion of last night wading through FAQs, AltaVista,
and Deja PowerSearches... Nothing applicable jumped out at me.

--
#include<stdio.h> /* SigMask 0.3 (sig.c) 19990429 PUBLIC DOMAIN "Compile Me" */
int main(c,v)char *v;{return !c?putchar(*v-1)&&main(0,v+ /* Tweaks welcomed. */
1):main(0,"Ojdl!Wbshjti!=obwAqbusjpu/ofu?\v\1");} /* build: cc -o sig sig.c */


Martin Portmann

unread,
Feb 25, 2000, 3:00:00 AM2/25/00
to

> /usr/libexec/ld.so: Undefined symbol "_pthread_key_create"
> called from xmysql:/usr/local/lib/libmysqlclient.so.6.0 at
> 0x40039538

Not 100% sure: but one must compile and link all threaded
programs with flag -pthread also if they itself are not
using threads (see 'man pthreads') ... hope this helps ...

------------------------------------------------------------
Martin Portmann Phone +41-41-7832720
infinitum AG, Switzerland Fax +41-41-7832721
Software Solutions www.infinitum.ch

"Time is the best teacher, unfortunately it kills all its
students"

Chris Cappuccio

unread,
Feb 25, 2000, 3:00:00 AM2/25/00
to
I noticed, as of mysql 3.22.32, any code that you link to -lmysqlclient needs
to be linked to -lc_r also

This may be a bug in the current linker, not giving you an error when you
don't do this. Libmysqlclient calls some stuff in the libc_r

On Fri, 25 Feb 2000, Nick Vargish wrote:

|
| Greetings,
|
| Sorry if this is the wrong list, or if the answer is available in some
| other (less intrusive) forum[1].
|
| I am trying to use MySQL and a couple of tools on my OpenBSD 2.6 system. I
| successfully built and installed MySQL using the ports facility. It runs
| fine, and I can create databases and tables, run SELECTs and so on.
|
| The problem crops up when I try to build tools that use the libmysqlclient
| shared library. I get this error with php (by looking in the logs) and
| with xmysql (built from within ports facility, by the way):
|
| imrryr$ xmysql
|

| /usr/libexec/ld.so: Undefined symbol "_pthread_key_create" called from
| xmysql:/usr/local/lib/libmysqlclient.so.6.0 at 0x40039538
|

| According to the system man pages, pthread_key_create does indeed exsit.
| It doesn't seem to matter what I set my LD_LIBRARY_PATH to, but I'm open
| to any suggestions.
|
| Thanks for any advice or help you can pass my way,
|
| Nick
|
| [1] I spent a good portion of last night wading through FAQs, AltaVista,
| and Deja PowerSearches... Nothing applicable jumped out at me.
|
| --
| #include<stdio.h> /* SigMask 0.3 (sig.c) 19990429 PUBLIC DOMAIN "Compile Me" */
| int main(c,v)char *v;{return !c?putchar(*v-1)&&main(0,v+ /* Tweaks welcomed. */
| 1):main(0,"Ojdl!Wbshjti!=obwAqbusjpu/ofu?\v\1");} /* build: cc -o sig sig.c */
|
|

---
Reverend Chris Cappuccio
http://www.dqc.org/~chris/


0 new messages