| Subject | Re: [firebird-support] UDF access in FB 1.5 - part II |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-02-21T21:56:37Z |
At 07:34 PM 21/02/2005 +0100, you wrote:
First, you did the wrong thing by installing Fb 1.5 over the top of Fb
1.0. You should have uninstalled Fb 1.0 and done a clean install. You
probably still need to do this, since there will be artifacts hanging
around that are interfering with how the server finds its "home".
Next, the error message is telling something more interesting than the fact
that the server can't get access to the UDF directory. It is saying that
you have included the ".so" suffix in your UDF declaration. If it is
there, it should not be; and it must be removed for RESTRICT. (Or some
name-scrambling is going on, due to your having leftover pieces from Fb 1.0
in the path...)
Don't forget about case-sensitivity.
Next, the keyword in firebird.conf is RESTRICT, not RESTRICTED. The
parameter UdfAccess = RESTRICT UDF
is telling the server to look for UDF libraries only in the directory UDF
that is beneath its "home" directory, that is, the directory immediately
above /bin. If the server doesn't know where its home directory is, then
it can't find the library.
You could try changing it so that the path is not relative, i.e.
UdfAccess = Restrict /opt/firebird/UDF
However, if the home directory is not known to the engine, there will be
other things that will go wrong. Why don't you study the Fb 1.5 release
notes? You can get a French version from the Firebird 1.5 download page at
www.ibphoenix.com.
./heLen
>Hello Alan and othersYes.
>
>Finally I got the server in my hand again and starting the battle with UDF
>from
>the beginning. Current situation is as follow:
>
>- I have installed FB 1.5 over 1.03 from FB1.5 rpm (latest available)
>- the install is default (/opt/firebird)
>- FB 1.5 is running as root user
>- UDF directory permission is set to firebird/firebird (as Alan sugested)
>- firebird.conf has line UdfAccess = Restricted UDF
>- read access of udflib.so - the library - is set to public
>
>And still getting "Access to UDF library "libudflib.so.so" is denied by server
>administrator" error message.
>
>Anyone has a clue?
First, you did the wrong thing by installing Fb 1.5 over the top of Fb
1.0. You should have uninstalled Fb 1.0 and done a clean install. You
probably still need to do this, since there will be artifacts hanging
around that are interfering with how the server finds its "home".
Next, the error message is telling something more interesting than the fact
that the server can't get access to the UDF directory. It is saying that
you have included the ".so" suffix in your UDF declaration. If it is
there, it should not be; and it must be removed for RESTRICT. (Or some
name-scrambling is going on, due to your having leftover pieces from Fb 1.0
in the path...)
Don't forget about case-sensitivity.
Next, the keyword in firebird.conf is RESTRICT, not RESTRICTED. The
parameter UdfAccess = RESTRICT UDF
is telling the server to look for UDF libraries only in the directory UDF
that is beneath its "home" directory, that is, the directory immediately
above /bin. If the server doesn't know where its home directory is, then
it can't find the library.
You could try changing it so that the path is not relative, i.e.
UdfAccess = Restrict /opt/firebird/UDF
However, if the home directory is not known to the engine, there will be
other things that will go wrong. Why don't you study the Fb 1.5 release
notes? You can get a French version from the Firebird 1.5 download page at
www.ibphoenix.com.
./heLen