Subject UdfAccess Question
Author Alan McDonald
FB 1.5.2 intalled on Fedora via the install script (not rpm) - Using
IBExpert
Declared a test UDF as follows (from the distro sql
DECLARE EXTERNAL FUNCTION ltrim
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_ltrim' MODULE_NAME 'ib_udf';
UdfAccess = None
causes IBExpert to hang permanently - service restart is the only way out -
i.e. no exception raised just a lock up - restarting FB produces a service
crash on the server but it restarts.
UdfAccess = Full
causes a BLR entry point missing error on the standard udf libraries

UdfAccess = /opt/firebird/UDF
causes this message
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Access to UDF library "libib_udf.so.so" is denied by server administrator.

Please note the "lib" on the front and the extra ".so" on the end...

I find the config file lacking in specific examples - the Release Notes
shows an example
UdfAccess = UDF; /bad_dir
What does
UdfAccess = UDF mean? is this a directory with no slash? or somthing else?
The notes say it needs to be None, Restrict or Full but there are no clear
examples.
Can someone clarify these issues, and also confirm the permissions required
for the libraries? Maybe the install script does not set these correctly?

Simply I cannot get any UDFs to respond.
thanks
Alan