The following reply was made to PR pkg/30473; it has been noted by GNATS.

From: Michael Rauch <mrauch@NetBSD.org>
To: David Chmelik <dchmelik@hipplanet.com>
Cc: gnats-bugs@netbsd.org
Subject: Re: pkg/30473: openoffice text/mysql database
Date: Fri, 24 Jun 2005 10:17:24 +0200

 --UlVJffcvxoiEqYs2
 Content-Type: text/plain; charset=us-ascii
 Content-Disposition: inline
 
 Hi, 
 
 On Mon, Jun 13, 2005 at 03:17:30PM -0700, David Chmelik wrote:
 > Michael,
 > I did not get the reply earlier.  I searched for libodbc.so and read
 > it was in unixodbc, which I had.  I reinstalled v2.0.11nb4 and tried
 > again without success.  OO is kind of a big program for me to try to
 > debug, but I wonder if I am doing something wrong.
 
 I had some time to look into this problem.
 Can you please try the attached patch for files/soffice?
 (Or alternatively, so you don't have to recompile OOo, you can also
 patch /usr/pkg/bin/soffice, after replacing @@PREFIX@@ with /usr/pkg.)
 
 After that, libodbc.so.1 was found.
 I've played around with database settings, and then got an error
 about libodbcinst.so. This might come from the fact that I haven't fully
 setup odbc, as some mails I found with google seem to suggest.
 If you get the same problem, please tell me, then I'll try to debug this
 further.
 
 
 Michael
 
 
 --UlVJffcvxoiEqYs2
 Content-Type: text/plain; charset=us-ascii
 Content-Disposition: attachment; filename="OOo.patch"
 
 Index: soffice
 ===================================================================
 RCS file: /cvsroot/pkgsrc/misc/openoffice/files/soffice,v
 retrieving revision 1.5
 diff -u -r1.5 files/soffice
 --- soffice	6 Jan 2005 15:52:20 -0000	1.5
 +++ soffice	23 Jun 2005 21:02:42 -0000
 @@ -50,4 +50,8 @@
  export PTHREAD_DIAGASSERT
  fi
  
 +# Let the standard pkgsrc libraries be found by dlopen()
 +LD_LIBRARY_PATH=$LD_LIBRARY_PATH:@@PREFIX@@/lib
 +export LD_LIBRARY_PATH
 +
  exec ${SOFFICE}/soffice "$@"
 
 --UlVJffcvxoiEqYs2--