From: Michael Widenius
Date: March 31 1999 1:33pm
Subject: UDF: can't resolve symbol
List-Archive: http://lists.mysql.com/mysql/1231
Message-Id: <14082.9155.635947.781236@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Jochen" == Jochen Dolze <dolze@stripped> writes:

Jochen> i'm using mysql-3.22.16a-gamma on linux-2.1.111
Jochen> (libc.so.5.4.17,libstdc++.so.27.2.1) with linuxthreads-0.6.

Jochen> i compiled udf_example.cc with

Jochen> c++ -Wall -shared -DMYSQL_SERVER
Jochen> -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
Jochen> -DDATADIR="\"/usr/local/mysql/var\""
Jochen> -DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DHAVE_CONFIG_H
Jochen> -I./../include -I./../regex -I. -I../include -I.. -I.  -O
Jochen> -DDBUG_OFF -o libudf_example.so

Jochen> after that i moved libudf_example.so to /usr/local/mysql/lib
Jochen> and ldconfig -v shows:

Jochen> ldconfig: version 1.8.5 /usr/local/mysql/lib:
Jochen> libmysqlclient.so.6 => libmysqlclient.so.6.0.0
Jochen> libudf_example.so => libudf_example.so

Jochen> and, ldd libudf_example.so shows:

Jochen> ./libudf_example.so => ./libudf_example.so libc.so.5 =>
Jochen> /lib/libc.so.5.4.17 libstdc++.so.27 =>
Jochen> /usr/lib/libstdc++.so.27.2.1 libm.so.5 => /lib/libm.so.5.0.6

Jochen> but, after CREATE FUNCTION lookup RETURNS STRING SONAME
Jochen> "udf_example.so" i get

Jochen> ERROR 1126: Can't open shared library 'udf_example.so' (errno:
Jochen> 22 Unable to resolve symbol)

Jochen> And the log says:

Jochen> /usr/local/mysql/libexec/mysqld: can't resolve symbol
Jochen> 'ctype_latin1' /usr/local/mysql/libexec/mysqld: can't resolve
Jochen> symbol 'to_upper_latin1'

Jochen> Where are ctype_latin1 and to_upper_latin1 defined??? What's
Jochen> wrong?

The above is defined in libmystring.a;  On the other hand I, the above 
symbols should also exits in the mysqld deamon, so I can't understand
why you get the above.  You can always try linking with libmystring.a

Regards,
Monty