Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | PostgreSQL SDBC native driver not available for 64bit | ||
---|---|---|---|
Product: | Base | Reporter: | pcav <cavallini> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | caolanm, frank.schoenheit, issues, kendy, oooforum, p.kerry, pavel, rene |
Version: | OOo 2.0.4 | ||
Target Milestone: | --- | ||
Hardware: | PC (x86_64) | ||
OS: | Linux, all | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
pcav
2007-04-04 17:10:29 UTC
.uno.so are binary files - supposedly 32bit when they work on 32bit OOo. No surprise that they don't work with 64bit OOo; you would need their 64bit versions. Where comes the postgresql-sdbc-0.7.4.zip from? To ping the originators to provide even the 64bit version... The 64bit version does not appear to be available from the web site. In any case, this would not solve the problem in our setting, as users share 64 and 32 bit machines with the same home; given that the drive has to be installed in the home for each user, they will not be able to use the driver smoothly across machines. Extensions can also be installed in the shared installation of OOo, and since you need to have a 32 and a 64 bit version of OOo, you could install both versions of the extension once. I am not sure how to do this shared installation, try to invoke "unopkg" on the command line, it is said to have some respective switch (I never tried, though). Otherwise, I suggest asking in users@openoffice.org. closing issue Sorry, I do not understand the rationale behind closing this issue: 1. the driver provided on the http://dba.openoffice.org/drivers/postgresql/ site does not work on 64bit machines 2. the proposed solution (recompiling OOo+PG) is just unfeasible for the average OOo user 3. the unpkg approach does not work for me 4. I do not see the reason why sending the request to users instead of the ad hoc database list. I am therefore reopening the issue. pc In my opinion, what you have is a request for enhancement to the extension author: to provide a 64 bit version as well. Note that this would require the author to have a 64 bit build environment, which I somehow doubt ... Note that this does not depend on the unopkg thing at all. I was just saying that once you have two extension versions (32 and 64 bit), you could install them in the respective OOo installation (since you have two OOo versions, it seems). This would still allow your users to work with either of those versions, always having the same home. Hi, I think, some things are getting mixed up here. @pcav (as issue writer): 1) Please state, if you have installed the 32bit or the 64 bit version of openoffice (check with the unix command file /path/to/ooo/program/soffice.bin ) on your 64 bit system. You should not use the 64 bit version atm, as it is broken ( see http://wiki.services.openoffice.org/wiki/Porting_to_x86-64_%28AMD64%2C_EM64T%29 , the first sentence tells "It is of no use for non-developers"). 2) I think, you use the 32 bit version of openoffice, that comes with your distribution. If you do so, please download the openoffice.org version from openoffice.org, install it separately and test the driver with it. This runs on my 64bit suse system. If it does not run, you'll have my support in hunting down why it does not run. 3) Assuming that the above test is successful for you, the problem remains, that the driver does not run with the openoffice coming with your distribution. This is the fault of the gcc project, which does not hold up binary compatibilty between different versions of gcc, address your issue there. You can also try to approach your distributor to make him add the postgresql driver to its distribution. 4) The problem will vanish on the long run, when the driver gets integrated into OOo code base. This will happen someday, but there is no due date. Bye, Joerg Thanks for following this up. # file /usr/lib/openoffice/program/soffice.bin /usr/lib/openoffice/program/soffice.bin: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.0, dynamically linked (uses shared libs), for GNU/Linux 2.6.0, stripped I'm investigatin this with the Debian devs. I still do not understand why the driver is not included in OOo code base: it is pretty stable for us, very useful, and I cannot immagine it causing harms to non-pg users. Alternatively, the driver may be packaged in my distro, which could solve part of the problem (see http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=346475). Using the same home with 32 and 64 bits, however, may still be an issue. So OOo does build on 64bit (at least for Debian); does the pg driver compile? Has someone tried yet? The older version (0.6.x) did not, according to Debian developers. pcav: 0.7.4 seems to build fine in a OOo2 env (barring some needed patches for newer gccs) on my ppc box (didn't yet try x86_64). I'll probably add the extension to the 2.3 Debian packages of OOo. (maybe as a extra package, maybe in -base, didn't decide yet finally) This bug looks like INVALID. It says that the "PostgreSQL SDBC native driver on 64-bit does not work", but it does work - it just is not available in binary form for anything else than i386. (While that would work, see http://packages.debian.org/experimental/openoffice.org-sdbc-postgresql. Now, of course there could be a wish to jbu to also provide a 64bit package as OpenOffice.org now als has 64bit packages, but... I'll change the title to reflect that. This bug looks like INVALID. It says that the "PostgreSQL SDBC native driver on 64-bit does not work", but it does work - it just is not available in binary form for anything else than i386. (While that would work, see http://packages.debian.org/experimental/openoffice.org-sdbc-postgresql. Now, of course there could be a wish to jbu to also provide a 64bit package as OpenOffice.org now als has 64bit packages, but... I'll change the title to reflect that. oops Fast forward a few years: given that lots of people must be using 64bit nowadays instead of 32bit, will there be a release of a SDBC native driver for 64bit linux? postgresql-sdbc-0.7.6b.zip downloaded from http://www.openoffice.org/dba/drivers/postgresql/index.html works for me under 32bit linux but not 64bit. Many thanks Paul. Fast forward a few years to 2012: given that lots of people must be using 64bit nowadays instead of 32bit, will there be a release of a SDBC native driver for 64bit linux? postgresql-sdbc-0.7.6b.zip downloaded from http://www.openoffice.org/dba/drivers/postgresql/index.html works for me under apache openoffice 3.4.1 32bit linux but not 64bit linux. Many thanks Paul. Reset assignee on issues not touched by assignee in more than 1000 days. Very annoying for those running with AOO x64 under Linux. And the next buid under MacOS will be full x64. Maybe that will be better to warn users who access to this webpage: http://www.openoffice.org/dba/drivers/postgresql/ But that will be better too to build this driver on 64-bits ;-) |