>>>>> "Curt" == Curt W Zirzow <curt@stripped> writes:
Curt> I've got a udf which I've got compiled as a share library. And then I
Curt> go into mysql and type:
mysql> create function relevant returns real soname
Curt> 'udf_relevant.so';
Curt> Query OK, 0 rows affected (0.00 sec)
mysql> select relevant('string 1', 'string 2');
Curt> +----------------------------------+
Curt> | relevant('string 1', 'string 2') |
Curt> +----------------------------------+
Curt> | 0.5000 |
Curt> +----------------------------------+
Curt> 1 row in set (0.00 sec)
Curt> So far everything is working ok, BUT...
Curt> If I start and stop mysqld I get in my error log:
Curt> 990328 18:32:10 Can't open shared library: 'udf_relevant.so',
Curt> errno:0 (/usr/local/lib/mysql/udf_relevant.so: Undefined symbol
Curt> "pthread_initial")
Curt> Whats going on? why wouldn't it load when mysqld is restarted?
Curt> I had this running ok on 3.22.16gamma but it isn't working for
Curt> 3.22.19b.
Curt> Here is some info about this computer.
>> Environment:
Curt> <machine, os, target, libraries (multiple lines)>
Curt> System: FreeBSD frigg.nordicdms.com 3.1-RELEASE FreeBSD
Curt> 3.1-RELEASE #0: Thu Mar
Curt> 25 21:08:13 PST 1999
Curt> walton@stripped:/usr/src/sys/compile/FRIGG
Curt> i386
Curt> Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake
Curt> /usr/bin/gcc /usr/
Curt> bin/cc
Curt> GCC: gcc version 2.7.2.1
Curt> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS=''
Curt> LDFLAGS=''
Curt> Configure command: ./configure --with-unix-socket-
Curt> path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes
Curt> Perl: This is perl, version 5.005_02 built for i386-freebsd
Hi!
Did you upgrade FreeBSD version between 3.22.16 gamma and 3.22.19b ?
The above is a error message from dlopen; I assume you can find some
solution to this if you do 'man dlopen'.
Regards,
Monty
