Hi *,

I have installed the firebird Mac OS X package from sourceforge. I have a good
understanding from firebird on Linux - but not on Mac OS X.

When accessing a UDF, I get the following error:

Statement failed, SQLCODE = -902

Access to UDF library "Library/Frameworks/Firebird.framework/Resources/English.lproj/
var/UDF/ib_udf.so" is denied by server adm

I enabled access of UDFs in firebird.conf:

UdfAccess = Restrict UDF

and I declared the UDF with the following file:

-- snip --
create database '127.0.0.1:/Volumes/common/database/test.fdb';
commit;
connect '127.0.0.1:/Volumes/common/database/test.fdb';
declare external function abs
double precision
returns double precision by value
entry_point 'IB_UDF_abs' module_name 'ib_udf';
commit;
--

The file in the UDF directory is named ib_udf.dylib - I don't know why it says, that it can't
access ib_udf.so. I have copied the ib_udf.dylib to ib_udf.so ib_udf.so.dylib - but without
changing anythin.

The permissons on this file are defaulted to firebird:firebird - as it should be.

On my Linux PPC box the same things works quite fine ...

Has anyone a hint for me?

Thx,

Chris