Hi,

I get to use my UDF now. I had to compile my project.dpr (UDF created
with Kylix) in the RedHat. My .so had to compiled with Conectiva 8.

Thanks for your answer!

Ivan

> At 07:51 PM 4/06/2003 +0000, you wrote:
> >Hi,
> >
> >I am with a problem after install the Firebird (1.0.2) in the Red

Hat

> >8.0 (Kernel 2.4.18-14). I'm not get to use my UDFs.
> >I put the DZZUDF.so (my udf) in the directory /opt/interbase/UDF
> >
> >But when i execute a SQL with any function (select LTRIM('test')

from

> >dual) always show this message:
> >
> >-invalid request BLR at offset 28 function NAME_MY_FUNCTION is not
> >defined
> >-module name or entrypoint could not be found
> >
> >I had this problems in other case when i installed Slackware in the
> >server. I had to install the Conectiva 8.0 and function perfectly,
> >and now with Red Hat occurs the same problem. I have the conectiva
> >8.0 in 5 enterprises, and all cases function perfectly my UDFs. But
> >always i try to install other version of linux (Slackware and

RedHat)

> >i have this problem.
> >
> >Exists any diference of configuration from Conectiva to other
> >distribution of linux (Slackware, RedHat, ...)??
> >
> >The declaration of my UDFs are correct, because it functions
> >perfectly in others servers with Conectiva 8.0.
> >
> >See any declaration of my UDFs:
> >
> >DECLARE EXTERNAL FUNCTION RTRIM
> > CSTRING(32765) BY DESCRIPTOR
> > RETURNS CSTRING(32765)
> > ENTRY_POINT 'RTRIM' MODULE_NAME 'DZZUDF';
> >
> >DECLARE EXTERNAL FUNCTION STRLENGTH
> > CSTRING(32765) BY DESCRIPTOR
> > RETURNS INTEGER BY VALUE
> > ENTRY_POINT 'LENGTH' MODULE_NAME 'DZZUDF';
> >
> >if anybody can help me i'd thank a lot!
> >
> >Else i will have to install conectiva 8.0 again in this server...
>
> Ivan,
> Two things you could try:
>
> 1) check the permissions on the UDF library file. I seem to

recall that,

> if the rpm was installed by root, then you have to give permissions

to the

> firebird user to any directories that were created during the

install.

>
> 2) explicitly configure the external_file_directory parameter in
> isc_config (works only on Superserver):
>
> external_function_directory "opt/interbase/UDF" // note double-

quotes

>
> and restart the server afterwards.
>
> heLen