From owner-freebsd-ports  Wed Aug 29  3:10:14 2001
Delivered-To: freebsd-ports@hub.freebsd.org
Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21])
	by hub.freebsd.org (Postfix) with ESMTP id 6EB0F37B40C
	for <freebsd-ports@hub.freebsd.org>; Wed, 29 Aug 2001 03:10:05 -0700 (PDT)
	(envelope-from gnats@FreeBSD.org)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.11.4/8.11.4) id f7TAA5T73431;
	Wed, 29 Aug 2001 03:10:05 -0700 (PDT)
	(envelope-from gnats)
Received: from postoffice.aims.com.au (advanc2.lnk.telstra.net [139.130.119.73])
	by hub.freebsd.org (Postfix) with ESMTP id 0EA2137B406
	for <FreeBSD-gnats-submit@freebsd.org>; Wed, 29 Aug 2001 03:09:57 -0700 (PDT)
	(envelope-from chris@aims.com.au)
Received: from postoffice.aims.com.au (nts-ts1.aims.private [192.168.10.2])
	by postoffice.aims.com.au  with ESMTP id f7TA9rr09245
	for <FreeBSD-gnats-submit@freebsd.org>; Wed, 29 Aug 2001 20:09:53 +1000 (EST)
	(envelope-from chris@aims.com.au)
Received: from ntsts1 by aims.com.au
	with SMTP (MDaemon.v3.5.3.R)
	for <FreeBSD-gnats-submit@freebsd.org>; Wed, 29 Aug 2001 20:09:10 +1000
Message-Id: <200108290937.f7T9bGY56285@dbserver2.aims.private>
Date: Wed, 29 Aug 2001 20:09:07 +1000
From: chris@aims.com.au
Reply-To: <chris@aims.com.au>
To: <FreeBSD-gnats-submit@freebsd.org>
X-Send-Pr-Version: 3.113
Subject: ports/30185: [PATCH] databases/firebird: Fix UDF loading problem
Sender: owner-freebsd-ports@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-ports.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-ports>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-ports>
X-Loop: FreeBSD.org


>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