UDF Error:-module name or entrypoint could not be found

Hi, I am using firebird 1.5 on RedHat 7.3. I have compiled and installed rfunc UDF library (the latest CVS snapshot rfunc2 module). All the functions are there. I have Have changed the UdfAccess to event Full. Still it is giving me the following error:

-module name or entrypoint could not be found

rfunc is in the /opt/firebird/UDF directory. Complete output is given below.

Is there any other good UDF library?

Regards:

Joga Singh


SQL> show function substr;

Function SUBSTR:
Function library is rfunc
Entry point is fn_substr
Returns CSTRING(255) CHARACTER SET NONE

Argument 1: CSTRING(255) CHARACTER SET NONE
Argument 2: INTEGER
Argument 3: INTEGER
SQL> select substr(usrid,1,1) from users;
Statement failed, SQLCODE = -104

invalid request BLR at offset 63
-function SUBSTR is not defined
-module name or entrypoint could not be found

Now when I changed the UdfAccess to Restrict UDF it gives me the following error:


SQL> select trim(urltext) from appmenu;
Statement failed, SQLCODE = -902

Access to UDF library "librfunc.so" is denied by server administrator