All, I'm trying to use the UDF functionality, but I keep getting the same error when I issue the CREATE FUNCTION command. This is the error:
mysql> CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "udf_example.so"; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 0 ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: relocation erro) I've recompiled with debug support and this is what I get in the log: mysql_create_function: error: dlopen of udf_example.so failed, error: 0 (ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: relocation error: file /usr/lib/udf_example.so: symbol default_charset_info: referenced symbol not found) Environment: - Solaris 7 (on Sparc Ultra 250) - MySQL version 3.23.46, compiled locally (not from a package) - gcc 2.95.3 - configure options: CC=gcc CXX=gcc ./configure --with-mysqld-ldflags=-rdynamic --prefix=/usr/local/mysql --loca lstatedir=/disk3/mysql - command for compiling udf_example.cc: gcc -shared -lgcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\ "" -DDATADIR="\"/disk3/mysql\"" -DSHAREDIR="\"/usr/local/mysql/share/mysql \"" -DHAVE_CONFIG_H -I/usr/local/src/mysql-3.23.46/include -fno-implicit-te mplates -fno-exceptions -fno-rtti -o udf_example0.so udf_example.cc udf_example.so exists in /usr/lib I've seen a few posts on the net with a similar description of the problem, but never a solution :-( does anyone have a clue how to resolve this issue? Thanks, Tim Tim Wuyts Software Engineer EUnet Systems KPN Belgium --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php