Web lists-archives.com

udf shared library import




I was not able to load a function in udf_example.so.  The response to
CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so';

is

Error Code: 1126. Can't open shared library 'udf_example.so' (errno: 0
/usr/lib64/mysql/plugin/udf_example.so: cannot open shared object file: No
such file or directory)

I did follow instructions
1. compile udf_example.so with
gcc -fPIC -I/usr/include/mysql/ -shared -o udf_example.so udf_example.c
2. verify my plugin directory:
show variables like 'plugin%' : /usr/lib64/mysql/plugin/
3. place udf_example.so in /usr/lib64/mysql/plugin/
4. verify I have a table mysql.func and a column 'type': SELECT * FROM
mysql.func;

Any hints?  Thank you.