Upgrading Firebird from 1.5.x to 2.0.x on Linux

I recently upgraded Firebird from 1.5.x to 2.0.5 on my Linux server.  Suddenly my UDF library stopped working.  Every time I tried to execute one of the UDFs I got the following error:

invalid request BLR at offset 90
function GRCIRCLE is not defined
module name or entrypoint could not be found

I had the shared library in the UDF directory, the UDFAccess parameter was set to Restrict UDF, the file permissions were correct.  It was driving me crazy.  I finally found out that my shared library has references to libfbembed.so.1 in it.  In Firebird 2.0.x that file is renamed to libfbembed.so.2.  Simply symbollically linking libfbembed.so.2 to libfbembed.so.1 solved the problem.

Leave a Reply