Date: Wed, 29 Aug 2001 20:09:07 +1000 From: chris@aims.com.au To: <FreeBSD-gnats-submit@freebsd.org> Subject: ports/30185: [PATCH] databases/firebird: Fix UDF loading problem Message-ID: <200108290937.f7T9bGY56285@dbserver2.aims.private>
next in thread | raw e-mail | index | archive | help
>Number: 30185
>Category: ports
>Synopsis: [PATCH] databases/firebird: Fix UDF loading problem
>Confidential: no
>Severity: non-critical
>Priority: low
>Responsible: freebsd-ports
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Wed Aug 29 03:10:04 PDT 2001
>Closed-Date:
>Last-Modified:
>Originator: Chris Knight
>Release: FreeBSD 4.3-RELEASE i386
>Organization:
AIMS Independent Computer Professionals
>Environment:
System: FreeBSD dbserver2.aims.private 4.3-RELEASE FreeBSD 4.3-RELEASE #4: Fri Jun 8 20:34:41 EST 2001
root@dbserver2.aims.private:/usr/src/sys/compile/DBSERVER i386
>Description:
The UDF library that comes with the Firebird source doesn't load correctly
on FreeBSD due to the way in which the library is linked. When the database
goes to dynamically load the UDF library, it is unable to load all components
and fails with SQL error -104.
>How-To-Repeat:
Connect to a database with isql and issue the following commands:
DECLARE EXTERNAL FUNCTION strlen
CSTRING(32767)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf';
COMMIT;
SELECT strlen('string') FROM RDB$DATABASE;
>Fix:
Apply the following patch. It also fixes the ldconfig problem that has been
raised several times on the mailing list.
Index: post-install
===================================================================
RCS file: /home/ncvs/ports/databases/firebird/scripts/post-install,v
retrieving revision 1.1
diff -u -r1.1 post-install
--- post-install 2001/03/10 20:32:33 1.1
+++ post-install 2001/08/29 09:24:42
@@ -7,6 +7,9 @@
# Now fix up the mess.
+# fix perms for ldconfig
+chown root $PREFIX/firebird/lib
+
# fix up directories
for i in `find $PREFIX/firebird -print`
do
@@ -18,6 +21,9 @@
done
+# fix UDF load problem
+cd $PREFIX/firebird/lib
+ln -fs ib_util.so libib_util.so
cd $PREFIX/firebird/bin
>Release-Note:
>Audit-Trail:
>Unformatted:
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200108290937.f7T9bGY56285>