> At 03:59 PM 9/02/2005 +1100, you wrote:
>
> >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?
>
> read and execute on the UDF directory for the firebird group (should
> already have been done by the install script) and same for the file (copy
> the perms that ib_udf has).
>
>
> >Simply I cannot get any UDFs to respond.
>
> It seems you've tried everything but the right one. :-)
>
> configure it as
>
> UDFAccess = UDF # relative path location !!
>
> Remember to take the '#' off the beginning of the parameter.
>
> If you're using Superserver, remember to stop and restart the server to
> have the config change take effect. (With Classic, the next
> login will see
> it.)
>
> ,.hb
>
>
> FULL, btw, is platform-specific and not recommended.
>
> ./heLen

Well Helen - for whatever reason ... this does NOT work
UdfAccess = UDF
This does NOT work
UDFAccess = UDF
This DOES, however, finally work
UDFAccess = Restrict UDF
(this may work... not tried UdfAccess = Restrict UDF)

Something is wrong here don't you think? - It's certainly not as documented.
Alan