From owner-freebsd-openoffice@FreeBSD.ORG Mon Aug 11 11:02:27 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D43ED37B404 for ; Mon, 11 Aug 2003 11:02:27 -0700 (PDT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0CE1443FE3 for ; Mon, 11 Aug 2003 11:02:26 -0700 (PDT) (envelope-from owner-bugmaster@freebsd.org) Received: from freefall.freebsd.org (peter@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.9/8.12.9) with ESMTP id h7BI2PUp082249 for ; Mon, 11 Aug 2003 11:02:25 -0700 (PDT) (envelope-from owner-bugmaster@freebsd.org) Received: (from peter@localhost) by freefall.freebsd.org (8.12.9/8.12.9/Submit) id h7BI2Pf6082243 for openoffice@freebsd.org; Mon, 11 Aug 2003 11:02:25 -0700 (PDT) Date: Mon, 11 Aug 2003 11:02:25 -0700 (PDT) Message-Id: <200308111802.h7BI2Pf6082243@freefall.freebsd.org> X-Authentication-Warning: freefall.freebsd.org: peter set sender to owner-bugmaster@freebsd.org using -f From: FreeBSD bugmaster To: openoffice@FreeBSD.org Subject: Current problem reports assigned to you X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 11 Aug 2003 18:02:28 -0000 Current FreeBSD problem reports Critical problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2003/08/01] ports/55147 openoffice Openoffice build failure 1 problem total. Serious problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2002/09/07] ports/42516 openoffice OpenOffice.org generate wrong WM_LOCALE_N a [2002/09/14] ports/42777 openoffice OpenOffice install fails a [2003/05/11] ports/52068 openoffice portupgrade of openoffice.org-1.0.3 stall a [2003/05/11] ports/52087 openoffice error while building japanese/openoffice o [2003/07/16] ports/54546 openoffice OpenOffice-1.0.3_2 build fails: autoconf. f [2003/08/01] ports/55164 openoffice openoffice fails to compile 6 problems total. Non-critical problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2003/04/15] ports/50996 openoffice editors/ooodict-hu_HU port can moved to h 1 problem total. From owner-freebsd-openoffice@FreeBSD.ORG Tue Aug 12 07:59:18 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DEFEC37B401 for ; Tue, 12 Aug 2003 07:59:18 -0700 (PDT) Received: from smtp.tstar.net (smtp.tstar.net [207.13.78.13]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2423B43F3F for ; Tue, 12 Aug 2003 07:59:18 -0700 (PDT) (envelope-from ro-twy2@tstar.net) Received: from rotwy (dial6-10.tstar.net [198.68.205.25]) by smtp.tstar.net (8.12.9/8.12.9) with SMTP id h7CEx6kx003187 for ; Tue, 12 Aug 2003 09:59:12 -0500 Message-ID: <000801c360e2$49a48520$19cd44c6@rotwy> From: "ro tolar" To: Date: Tue, 12 Aug 2003 09:58:45 -0500 MIME-Version: 1.0 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: register me X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 12 Aug 2003 14:59:19 -0000 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/03 From owner-freebsd-openoffice@FreeBSD.ORG Wed Aug 13 10:59:19 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0B7BF37B401 for ; Wed, 13 Aug 2003 10:59:19 -0700 (PDT) Received: from pan.gwi.net (pan.gwi.net [207.5.128.165]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4A26043F93 for ; Wed, 13 Aug 2003 10:59:18 -0700 (PDT) (envelope-from fkittred@gwi.net) Received: from nexus.gwi.net (blake.gwi.net [207.5.142.8]) by pan.gwi.net (8.12.6p2/8.12.6) with ESMTP id h7DHxHEL084875 for ; Wed, 13 Aug 2003 13:59:17 -0400 (EDT) (envelope-from fkittred@gwi.net) Message-Id: <200308131759.h7DHxHEL084875@pan.gwi.net> To: openoffice@freebsd.org From: fkittred@gwi.net In-Reply-To: Your message of "Fri, 04 Apr 2003 17:06:45 +0200." <20030404170601.V37965@cvs.imp.ch> Date: Wed, 13 Aug 2003 13:57:27 -0400 Subject: problems with ODBC(Postgres) with StarOffice 6.0 X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 Aug 2003 17:59:19 -0000 FreeBSD OS 4.8-stable StarOffice 6.0 Postgres-odbc 7.2.5 iodbc 3.0.5 Hello; I am back to using StarOffice 6.0 due to an inability to build any recent versions of OpenOffice. But that is not what this message is about. It is about trying to access a remote postgres database from StarOffice via ODBC. I installed /usr/ports/databases/postgres-odbc which in turn installed iodbc. After a half day of futzing around, I got a ~/.odbc.ini that worked at least with the libiodbc-3.0.5/samples/odbctest program. I can connect via odbc to the remote database. However, when I start soffice, go to Tools->Data Sources, select database type of "ODBC" and then try to browse, I get "Could not load the program library libodbc.so or it is corrupted". I have created symlinks to "/usr/local/lib/psqlodbc.so" called /usr/lib/libodbc.so and /usr/local/lib/libodbc.so. Neither seemed to work. Any suggestions? regards, fletcher From owner-freebsd-openoffice@FreeBSD.ORG Wed Aug 13 12:14:46 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 48A1037B401 for ; Wed, 13 Aug 2003 12:14:46 -0700 (PDT) Received: from aphrodite.gwi.net (aphrodite.gwi.net [207.5.128.164]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9445D43FA3 for ; Wed, 13 Aug 2003 12:14:45 -0700 (PDT) (envelope-from fkittred@gwi.net) Received: from nexus.gwi.net (blake.gwi.net [207.5.142.8]) by aphrodite.gwi.net (8.12.6p2/8.12.6) with ESMTP id h7DJEiPh047486; Wed, 13 Aug 2003 15:14:44 -0400 (EDT) (envelope-from fkittred@gwi.net) Message-Id: <200308131914.h7DJEiPh047486@aphrodite.gwi.net> To: fkittred@gwi.net From: fkittred@gwi.net In-Reply-To: Your message of "Wed, 13 Aug 2003 13:57:27 EDT." <200308131759.h7DHxHEL084875@pan.gwi.net> Date: Wed, 13 Aug 2003 15:12:54 -0400 cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 Aug 2003 19:14:46 -0000 On Wed, 13 Aug 2003 13:57:27 -0400 fkittred@gwi.net wrote: > FreeBSD OS 4.8-stable > StarOffice 6.0 > Postgres-odbc 7.2.5 > iodbc 3.0.5 > > Hello; > > I am back to using StarOffice 6.0 due to an inability to > build any recent versions of OpenOffice. But that is not what this > message is about. It is about trying to access a remote postgres > database from StarOffice via ODBC. > > I installed /usr/ports/databases/postgres-odbc which in turn installed > iodbc. After a half day of futzing around, I got a ~/.odbc.ini that > worked at least with the libiodbc-3.0.5/samples/odbctest program. I > can connect via odbc to the remote database. However, when I start > soffice, go to Tools->Data Sources, select database type of "ODBC" and > then try to browse, I get "Could not load the program library > libodbc.so or it is corrupted". I have created symlinks to > "/usr/local/lib/psqlodbc.so" called /usr/lib/libodbc.so and > /usr/local/lib/libodbc.so. Neither seemed to work. > > Any suggestions? > > regards, > fletcher Sorry, here is my ~/.odbc.ini file: [ODBC Data Sources] Lines = Lines and Circuits Database [Lines] DSN=Lines Driver = /usr/local/lib/psqlodbc.so Servername = devtest Database = lines Servertype = postgres Username = fkittred Port = 5432 Trace = ON TraceFile = stdout Password = Protocol = 7.2 FetchBufferSize = 99 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = CommLog = 1 [Default] Driver = /usr/local/lib/psqlodbc.so [ODBC] InstallDir = /usr/local/lib/libiodbc.so From owner-freebsd-openoffice@FreeBSD.ORG Fri Aug 15 02:54:19 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BC23C37B401 for ; Fri, 15 Aug 2003 02:54:19 -0700 (PDT) Received: from mail.imp.ch (mail.imp.ch [157.161.1.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 88B2C43F75 for ; Fri, 15 Aug 2003 02:54:18 -0700 (PDT) (envelope-from mb@imp.ch) Received: from nbs.imp.ch (nbs.imp.ch [157.161.4.7]) by mail.imp.ch (8.12.6p2/8.12.3) with ESMTP id h7F9sFbV026867; Fri, 15 Aug 2003 11:54:16 +0200 (CEST) (envelope-from Martin.Blapp@imp.ch) Received: from cvs.imp.ch (cvs.imp.ch [157.161.4.9]) by nbs.imp.ch (8.12.8/8.12.3) with ESMTP id h7F9sElH7761533; Fri, 15 Aug 2003 11:54:14 +0200 (MES) Date: Fri, 15 Aug 2003 11:54:14 +0200 (CEST) From: Martin Blapp To: fkittred@gwi.net Message-ID: <20030815115242.U38762@cvs.imp.ch> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 15 Aug 2003 09:54:20 -0000 Hi. > I am back to using StarOffice 6.0 due to an inability to > build any recent versions of OpenOffice. But that is not what this > message is about. It is about trying to access a remote postgres > database from StarOffice via ODBC. http://projects.imp.ch/openoffice ... > I installed /usr/ports/databases/postgres-odbc which in turn installed > iodbc. After a half day of futzing around, I got a ~/.odbc.ini that > worked at least with the libiodbc-3.0.5/samples/odbctest program. I > can connect via odbc to the remote database. However, when I start > soffice, go to Tools->Data Sources, select database type of "ODBC" and > then try to browse, I get "Could not load the program library > libodbc.so or it is corrupted". I have created symlinks to > "/usr/local/lib/psqlodbc.so" called /usr/lib/libodbc.so and > /usr/local/lib/libodbc.so. Neither seemed to work. You cannot use a linux version of office (staroffice is linux only) and try to use freebsd odbc libs. Install the linux odbc libs, then it will work. Martin Martin Blapp, ------------------------------------------------------------------ ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E ------------------------------------------------------------------ From owner-freebsd-openoffice@FreeBSD.ORG Fri Aug 15 07:33:18 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 976C637B401 for ; Fri, 15 Aug 2003 07:33:18 -0700 (PDT) Received: from aphrodite.gwi.net (aphrodite.gwi.net [207.5.128.164]) by mx1.FreeBSD.org (Postfix) with ESMTP id D827D43FBD for ; Fri, 15 Aug 2003 07:33:17 -0700 (PDT) (envelope-from fkittred@gwi.net) Received: from nexus.gwi.net (blake.gwi.net [207.5.142.8]) by aphrodite.gwi.net (8.12.6p2/8.12.6) with ESMTP id h7FEXGPh015392; Fri, 15 Aug 2003 10:33:17 -0400 (EDT) (envelope-from fkittred@gwi.net) Message-Id: <200308151433.h7FEXGPh015392@aphrodite.gwi.net> To: Martin Blapp From: fkittred@gwi.net In-Reply-To: Your message of "Fri, 15 Aug 2003 11:54:14 +0200." <20030815115242.U38762@cvs.imp.ch> Date: Fri, 15 Aug 2003 10:31:22 -0400 cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 15 Aug 2003 14:33:18 -0000 On Fri, 15 Aug 2003 11:54:14 +0200 (CEST) Martin Blapp wrote: > http://projects.imp.ch/openoffice ... OK, I downloaded and installed openoffice-1.0.3_2. I have the same problems. Any debugging suggestions would be gratefully accepted. regards, fletcher On Wed, 13 Aug 2003 13:57:27 -0400 fkittred@gwi.net wrote: > FreeBSD OS 4.8-stable > StarOffice 6.0 > Postgres-odbc 7.2.5 > iodbc 3.0.5 > > Hello; > > I am back to using StarOffice 6.0 due to an inability to > build any recent versions of OpenOffice. But that is not what this > message is about. It is about trying to access a remote postgres > database from StarOffice via ODBC. > > I installed /usr/ports/databases/postgres-odbc which in turn installed > iodbc. After a half day of futzing around, I got a ~/.odbc.ini that > worked at least with the libiodbc-3.0.5/samples/odbctest program. I > can connect via odbc to the remote database. However, when I start > soffice, go to Tools->Data Sources, select database type of "ODBC" and > then try to browse, I get "Could not load the program library > libodbc.so or it is corrupted". I have created symlinks to > "/usr/local/lib/psqlodbc.so" called /usr/lib/libodbc.so and > /usr/local/lib/libodbc.so. Neither seemed to work. > > Any suggestions? > > regards, > fletcher Sorry, here is my ~/.odbc.ini file: [ODBC Data Sources] Lines = Lines and Circuits Database [Lines] DSN=Lines Driver = /usr/local/lib/psqlodbc.so Servername = devtest Database = lines Servertype = postgres Username = fkittred Port = 5432 Trace = ON TraceFile = stdout Password = Protocol = 7.2 FetchBufferSize = 99 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = CommLog = 1 [Default] Driver = /usr/local/lib/psqlodbc.so [ODBC] InstallDir = /usr/local/lib/libiodbc.so From owner-freebsd-openoffice@FreeBSD.ORG Fri Aug 15 07:45:41 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id ECF0737B401 for ; Fri, 15 Aug 2003 07:45:41 -0700 (PDT) Received: from mail.imp.ch (mail.imp.ch [157.161.1.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8594943FA3 for ; Fri, 15 Aug 2003 07:45:40 -0700 (PDT) (envelope-from mb@imp.ch) Received: from nbs.imp.ch (nbs.imp.ch [157.161.4.7]) by mail.imp.ch (8.12.6p2/8.12.3) with ESMTP id h7FEjbbV007850; Fri, 15 Aug 2003 16:45:37 +0200 (CEST) (envelope-from Martin.Blapp@imp.ch) Received: from cvs.imp.ch (cvs.imp.ch [157.161.4.9]) by nbs.imp.ch (8.12.8/8.12.3) with ESMTP id h7FEjblH9248623; Fri, 15 Aug 2003 16:45:37 +0200 (MES) Date: Fri, 15 Aug 2003 16:45:37 +0200 (CEST) From: Martin Blapp To: fkittred@gwi.net In-Reply-To: <200308151433.h7FEXGPh015392@aphrodite.gwi.net> Message-ID: <20030815164504.C38762@cvs.imp.ch> References: <200308151433.h7FEXGPh015392@aphrodite.gwi.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: openoffice@freebsd.org Subject: Re: problems with ODBC(Postgres) with StarOffice 6.0 X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 15 Aug 2003 14:45:42 -0000 Hi, > OK, I downloaded and installed openoffice-1.0.3_2. I have the same > problems. Any debugging suggestions would be gratefully accepted. > Sorry I really don't know. Maybe you should wait for openoffice1.1 ? Martin From owner-freebsd-openoffice@FreeBSD.ORG Fri Aug 15 09:34:11 2003 Return-Path: Delivered-To: freebsd-openoffice@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 87CB337B401; Fri, 15 Aug 2003 09:34:11 -0700 (PDT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1C0BF43F93; Fri, 15 Aug 2003 09:34:11 -0700 (PDT) (envelope-from ceri@FreeBSD.org) Received: from freefall.freebsd.org (ceri@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.9/8.12.9) with ESMTP id h7FGYAUp002895; Fri, 15 Aug 2003 09:34:11 -0700 (PDT) (envelope-from ceri@freefall.freebsd.org) Received: (from ceri@localhost) by freefall.freebsd.org (8.12.9/8.12.9/Submit) id h7FGYA5o002891; Fri, 15 Aug 2003 09:34:10 -0700 (PDT) Date: Fri, 15 Aug 2003 09:34:10 -0700 (PDT) From: Ceri Davies Message-Id: <200308151634.h7FGYA5o002891@freefall.freebsd.org> To: yxw@bianca.lcs.mit.edu, ceri@FreeBSD.org, gnats-admin@FreeBSD.org, openoffice@FreeBSD.org Subject: Re: ports/55563: openoffice doesnot build on both stable and current release X-BeenThere: freebsd-openoffice@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting OpenOffice to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 15 Aug 2003 16:34:11 -0000 Synopsis: openoffice doesnot build on both stable and current release State-Changed-From-To: open->feedback State-Changed-By: ceri State-Changed-When: Fri Aug 15 09:32:28 PDT 2003 State-Changed-Why: Could you please submit a followup to this PR with some indication of the actual build error, and at which point it fails? Responsible-Changed-From-To: gnats-admin->openoffice Responsible-Changed-By: ceri Responsible-Changed-When: Fri Aug 15 09:32:28 PDT 2003 Responsible-Changed-Why: Assign to maintainers. http://www.freebsd.org/cgi/query-pr.cgi?pr=55563