ports/129308: editors/openoffice.org-3-devel (3.1.20081024) unopkg can't resolve "db_create"

[RandomUser]

>Number:         129308
>Category:       ports
>Synopsis:       editors/openoffice.org-3-devel (3.1.20081024) unopkg can't resolve "db_create"
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Nov 30 18:20:03 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     RandomUser
>Release:        6.4
>Organization:
N/A
>Environment:
FreeBSD 6.4-PRERELEASE #11: Wed Nov  5 00:24:07 CST 2008

openoffice.org-3.1.20081024

ldd /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libdeploymentmiscfi.so
/usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libdeploymentmiscfi.so:
        libdb-4.2.so => /usr/local/lib/libdb-4.2.so (0x2819b000)
        libuno_cppuhelpergcc3.so.3 => /usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib/libuno_cppuhelpergcc3.so.3 (0x2826a000)
        libuno_cppu.so.3 => /usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib/libuno_cppu.so.3 (0x28320000)
        libuno_sal.so.3 => /usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib/libuno_sal.so.3 (0x2835b000)
        libtlfi.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libtlfi.so (0x28511000)
        libucbhelper4gcc3.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libucbhelper4gcc3.so (0x285a5000)
        libutlfi.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libutlfi.so (0x28620000)
	libxcrfi.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libxcrfi.so (0x286c5000)
	libstlport_gcc.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib/libstlport_gcc.so (0x28753000)
	libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x287cc000)
	libm.so.4 => /lib/libm.so.4 (0x2889a000)
	libuno_salhelpergcc3.so.3 => /usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib/libuno_salhelpergcc3.so.3 (0x288b0000)
	libz.so.3 => /lib/libz.so.3 (0x288b4000)
	libvos3gcc3.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libvos3gcc3.so (0x288c5000)
	libbasegfxfi.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libbasegfxfi.so (0x288e5000)
	libi18nisolang1gcc3.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libi18nisolang1gcc3.so (0x28984000)
	libcomphelp4gcc3.so => /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libcomphelp4gcc3.so (0x2898a000)


db42-4.2.52_5

ldconfig -r|grep db-4
        89:-ldb-4.2.2 => /usr/X11R6/lib/libdb-4.2.so.2
        626:-ldb-4.2.2 => /usr/local/lib/libdb-4.2.so.2

nm -s /usr/local/lib/libdb-4.2.so.2|grep db_create
0001f354 T __bam_db_create_4002
00064390 T __db_db_create_4002
0006af21 T __dbcl_db_create_4002
0006e015 T __dbcl_db_create_ret_4002
0003a778 T __ham_db_create_4002
0004be88 T __qam_db_create_4002
000844a3 T db_create_4002
00066c2c T xdr___db_create_msg_4002
00066c92 T xdr___db_create_reply_4002

javavmwrapper-2.3.2
diablo-jre-1.5.0.07.01_12
diablo-jdk-1.5.0.07.01_8
jdk-1.5.0p4_1
linux-sun-jdk-1.4.2.13
>Description:
Attempts to add an OpenOffice extension fail, regardless of LD_LIBRARY_PATH and LD_RUN_PATH with:

./unopkg add --shared /var/tmp/OpenOfficeExtensions/OOoDesignedLabels/OOoDesignedLabels.oxt
/libexec/ld-elf.so.1: /usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program/libdeploymentmiscfi.so: Undefined symbol "db_create"

Without LD...PATH variables set, unopkg fails with,
./unopkg add --shared /var/tmp/OpenOfficeExtensions/OOoDesignedLabels/OOoDesignedLabels.oxt
javaldx failed. User must select a JRE from options dialog!You need to close the already opened Extension Manager to continue.

even though runtime OpenOffice Tools/Options/OpenOffice.org/Java shows "/usr/local/diablo-jdk1.5.0/jre" and Vendor: "Sun Microsystes, Inc, Version 1.5.0".

LD..PATH variables were set to:
LD_LIBRARY_PATH=/usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.0/program:/usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib:/usr/local/lib
LD_RUN_PATH=/usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.0/program:/usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib:/usr/local/lib:/usr/lib:/lib


These were initially NOT defined, but PR#127946 indicated using at least LD_LIBRARY_PATH to mitigate another OO extension install problem.


ld loader hints file is set to:
/var/run/ld-elf.so.hints:
        search directories: /lib:/usr/lib:/usr/lib/compat:/usr/X11R6/lib:/usr/local/lib:/usr/local/lib/compat/pkg:/usr/local/lib/compat:/usr/local/lib/evolution/2.12:/usr/local/lib/gcc-4.2.4:/usr/local/lib/mysql:/usr/local/lib/nss:/usr/local/lib/pth:/usr/local/lib/qt4:/usr/local/libexec/openldap:/usr/local/openoffice.org-DEV300_m34/openoffice.org/ure/lib:/usr/local/openoffice.org-DEV300_m34/openoffice.org/basis3.1/program

which was defined BEFORE defining the LD..PATH variables.
>How-To-Repeat:
Use any "unopkg" subcommand.
>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted: