Hi,

I've a UDF file 'gdi_udf' working on a firebird 1.5 Linux Debian etch
(32bit) perfect.
Now I had to switch the server:
firebird 1.5 Linux Debian lenny (64 bit).

I installed firebird2-classic-server from etch repositories (but amd64)
Version: 1.5.3.4870-12
Archive: oldstable, now
Depends: libc6 (>= 2.3.5-1), libfbembed1, libgcc1 (>= 1:4.1.1-12),
libncurses5 (>= 5.4-5), libstdc++6 (>= 4.1.1-12),
firebird2-server-common (>= 1.5.3.4870-6), firebird2-common, netbase


I copied the 'gdi_udf' file in /usr/lib/firebird2/UDF directory and
restart inetd.

When I use isql-fb I got the following UDF error:
------
SQL> select strtoint(kundennr) from kunden where kundennr = '19777';
Statement failed, SQLCODE = -902

Access to UDF library "/usr/lib/firebird2/UDF/libgdi_udf.so" is denied
by server administrator
------

------
SQL> show function strtoint;

Function STRTOINT:
Function library is gdi_udf
Entry point is fn_ValToInt
Returns BY VALUE INTEGER
Argument 1: CSTRING(50) CHARACTER SET WIN1252
------

------
This is isql version:
ISQL Version: LI-V1.5.3.4870 Firebird 1.5
Firebird/linux AMD64 (access method), version "LI-V1.5.3.4870 Firebird 1.5"
on disk structure version 10.1
------

The file libgdi_udf.so is missing, but the file is named 'gdi_udf'.
Permissions are correct to directory and file.
I gbak -B the db on the 32bit system and gbak -R on the 64bit system.
The 'gdi_udf' file was in the UDF directory as I started gbak -R on the
64 bit system.
UdfAccess in firebird.conf is Restricted UDF (default).

I also installed the FirebirdCS-1.5.5.4926-0.i686.tar.gz for testing,
but here I couldn't execute anything.
/opt/firebird/bin/isql -> no such file or directory... but isql is in
there ::confused

I read a lot about possible problems, but I did not found a solution.

What exactly is the problem here (64bit?) and how to solve?

Thanks for help.
Regards
Andi