i'm using mysql-3.22.16a-gamma on linux-2.1.111
(libc.so.5.4.17,libstdc++.so.27.2.1) with
linuxthreads-0.6.
i compiled udf_example.cc with
c++ -Wall -shared -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DHAVE_CONFIG_H
-I./../include -I./../regex -I. -I../include -I.. -I. -O -DDBUG_OFF -o
libudf_example.so
after that i moved libudf_example.so to /usr/local/mysql/lib and ldconfig
-v shows:
ldconfig: version 1.8.5
/usr/local/mysql/lib:
libmysqlclient.so.6 => libmysqlclient.so.6.0.0
libudf_example.so => libudf_example.so
and, ldd libudf_example.so shows:
./libudf_example.so => ./libudf_example.so
libc.so.5 => /lib/libc.so.5.4.17
libstdc++.so.27 => /usr/lib/libstdc++.so.27.2.1
libm.so.5 => /lib/libm.so.5.0.6
but, after CREATE FUNCTION lookup RETURNS STRING SONAME "udf_example.so" i
get
ERROR 1126: Can't open shared library 'udf_example.so' (errno: 22 Unable
to resolve symbol)
And the log says:
/usr/local/mysql/libexec/mysqld: can't resolve symbol 'ctype_latin1'
/usr/local/mysql/libexec/mysqld: can't resolve symbol 'to_upper_latin1'
Where are ctype_latin1 and to_upper_latin1 defined??? What's wrong?
Ciao
Joe_D