Problem occurs when creating a new database file that connects to a postgresql database via the postgresql-sdbc driver built in to LibreOffice. After setting all connection parameters correctly and then testing the connection, an error message occurs stating that the connection cannot be established. When opening an existing database file for LibreOffice with the same connection parameters and working in 3.5, the same error (connection cannot be established) occurs with 3.6. Haven't been able to get the debug output from either my postgresql back end or from LibreOffice to see what is happening. This has been tested and verified on three different machines (one x86_64 and the other two x86) with the same results. 3.6 doesn't work and 3.5 does. I noticed that the ArchLinux folks re-build some packages so that they work. I am running Slackware, as close to current as possible and have not had any issues for the last 3 years or so. Regards, Operating System: Linux (Other) Last worked in: 3.5.7.2 release
I have tried bot a recent master (2012-12-07, debug build) and 3.6.4.3 Linux 32-bit. In each I opened an existing .odb and created a new one, connecting to a PostgreSQL with a few small tables. In each case I was able to see the contents of a couple of tables by double-clicking on the table name. No errors were evident. @sk8tesgre8 ... Can you please give us details about your system and about your database and--particularly--a blow-by-blow description of what you did in LibreOffice? Terry.
Terrance, My system is Slackware-13.37 32 bit and 64 bit and I am using the re-packaged SlackBuilds LibreOffice package which works and has worked for the last 2-3 years without problems both in testing and production (our secretary and book-keeper). Using the steps that you listed below, and trying to connect to a PostgreSQL server throws an exception when connecting to a database on the PostgreSQL server whether one is trying to create a new .odb file or opening an existing .odb file using exactly the steps that you outlined. I am running PostgreSQL 9.2.1 but the postgresql-sdbc connector works in 3.5.7 with this version of PostgreSQL but not in 3.6. My databases have many large tables and as I stated before, everything works in LibreOffice 3.5.7 but not 3.6. My JRE is Oracle 1.7R9 (actually jdk 1.7R9). Steps to create the error: 1) Start LibreOffice and create a new database 2) Select "connect to an existing database" and select PostgreSQL as the type 3) Fill in connection information host=localhost dbname=database_name 4) Enter username on the database server and click "Test Connection" Alternately, 1) Open an existing *.odb file that works when connecting to a PostgreSQL server in LO 3.5 2) Try to test the connection (double click on tables or try to test the connection through "Edit Connection Properties" and "Test Connection" This is where everything fails with an error message that states that "Connection to database cannot be established" I have tried single and double quotes around the hostname and database name with the same results. Everything works with JDBC and postgresql-9.2 jdbc driver. I don't have PostgreSQL 9.1 running on any of my servers any more and really don't have a spare server to switch back to 9.1 right now. Hope this helps
Hello, Just as a sanity check, I installed the postgresql-sdbc extension on OpenOffice 3.4 and tried accessing several postgresql databases in the same manner as with LibreOffice 3.5 and 3.6. It works flawlessly just like the connector in LO 3.5.7 I then opened some *.odb files that were created with LO (3.5 and 3.6) and tried connecting through OOo and it still worked. Prior to this, I upgraded my servers with PostgreSQL 9.2.2 and upgraded my java jdk to 7u10. Things are still not working in 3.6.4.3 or any other version of LO 3.6 with the postgresql-sdbc connector. I had a similar issue with JDBC PostgreSQL 9.2 and jabref but was able to debug and fix the issue and submit a patch in spite of being quite inept at understanding java code. Maybe just fortunate this time around. Anyway, I haven't had the chance to look at the source code or download a debug version of LO yet. Not sure if I will these next weeks but I may try. Cheers, Fred
This might well be a DUP of https://bugs.freedesktop.org/show_bug.cgi?id=52388 Alex
No, I checked this bug before. I think around the 3.6.1 release as I didn't want to post anything that may have been an issue already. As I stated before, everything works in 3.5 with a fresh install, remove ~/.config/LibreOffice completely before starting LO. Test with creating a database connection using postgresql-sdbc and opening an existing *.odb file (using localhost an IP and a valid hostname) Everything works fine. Remove all ~/config/LibreOffice files and then remove 3.5 and install 3.6 Start LO and try to create a new database or open an existing *.odb file and try to test the connection (localhost, hostname or IP doesn't matter. They all work in 3.5, no extensions installed and certainly not postgresql-sdbc if it is already built in by default but not 3.6). Does LO look for a ~/OpenOffice directory on startup? Anyway, no matter as I didn't have the OOo postgresql-sdbc connector installed on OOo until last night. Cheers, Fred
I have just tried it with LO 3.6.5.2. Connected to Postgres directly (not JDBC or ODBC). It works with OpenSuSE 11.4 32bit rpm. IF I had a look at the URL I saw this: dbname=pgsqltest hostaddr=127.0.0.1 port=5432 Works the same way in LO 4.0.0.3 and LO 3.5.7.1. Could it be a problem with your libreoffice-profile?
I've tried removing any user data or directories for LibreOffice in my home directory but the problem persists. I have also tried the connection on several other systems running Slackware (fresh install, different computer, etc.) with the same results. 3.5.7 connects but later versions do not. How do I obtain debug information for the connection? It is not giving me any information in the PostgreSQL server logs so the actual connection is not happening. If I had some debug info, I could tell you more. It seems to be a Slackware issue though from your present results. Cheers, Fred
@comment7: When I have a look at the libreoffice-download there are only *.deb and *.rpm-packages for Linux. Could be this is a bug of SlackBuilds. Is there any bugtracker for these builds?
Check out slackbuilds.org and search for libreoffice. The maintainers of slackbuilds use a re-packaging script that uses the rpm version. Generally they do a very good job of keeping things correct. I have checked the script but may have missed something. Cheers, Fred
What version of PostgreSQL are you using? I am running 9.2 on my back end. Cheers, Fred
(In reply to comment #10) > What version of PostgreSQL are you using? I am running 9.2 on my back end. > I have PostgreSQL only installed for testing databases. Version 9.0.10-17.1 is the version running with OpenSuSE 11.4. I don't think that it is a problem of the version. I will see, if there is 9.2 available for OpenSuSE 11.4 Regards Robert
WFM on Linux 32bit (Mint Maya) with psql 9.1 and my build from master of 08/02/2013 Alex
I need to be able to test again on Mac OSX, but my pg server was being blocked at startup by some safety mechanism that Apple deemed fit to not tell people about...so until I can sort that out, testing against my OSX server is difficult in my work environment. Alex
I am looking at postgresql-sdbc.ini in /opt/libreoffice4.0/program. The contents of the file are: [Bootstrap] PQ_LOGLEVEL=NONE What is the proper switch to turn on debugging information? That would at least give me a starting point. Also, should the postgresql driver show up in the connection pooling list? It does not, which makes me think that somehow it isn't being loaded when LibreOffice starts. Just a hunch. Could be wrong. Cheers, Fred
Have tested LO 4.0.0 public release for OSX against a postgresql 9.2.3 instance hosted on a OSX 10.8 Server - the connection works, I can create, modify tables, etc, see bug 52388. Alex
(In reply to comment #14) > Also, should the postgresql driver show up > in the connection pooling list? It does not, which makes me think that > somehow it isn't being loaded when LibreOffice starts. Just a hunch. Could > be wrong. > I have had a look at the connections on my system: Driver of postgresql isnt shown in the list, too. But postgresql works with the direct connection. Regards Robert
Just tested LO365 on OSX, works there too. Alex
(In reply to comment #15) > Have tested LO 4.0.0 public release for OSX against a postgresql 9.2.3 > instance hosted on a OSX 10.8 Server - the connection works, I can create, > modify tables, etc, see bug 52388. > > > Alex I should have said that I can modify the table data, there is another bug that currently prevents modifying the table definitions via the LO GUI. Alex
Is there a way to turn on debugging for the postgresql driver? I've tried a number of things in the postgresql-sdbc.ini file with no results. Also, my postgresql libs (libpq, etc.) are for 9.2 This would only make a difference if the libo driver was looking for a dynamic library. Cheers, Fred
Anything new for this bug-report? Trying just other PostgreSQL-bugs. Have changed my system since the last comment here. Now PostgreSQL 9.2 is working together with many different LO-versions. Logelevel is the same as described in comment14. Regards Robert
On 09/15/2013 09:30 AM, bugzilla-daemon@freedesktop.org wrote: > > *Comment # 20 <https://bugs.freedesktop.org/show_bug.cgi?id=58207#c20> > on bug 58207 <https://bugs.freedesktop.org/show_bug.cgi?id=58207> from > robert@familiegrosskopf.de <mailto:robert@familiegrosskopf.de> * > Anything new for this bug-report? > Trying just other PostgreSQL-bugs. Have changed my system since the last > comment here. Now PostgreSQL 9.2 is working together with many different > LO-versions. > Logelevel is the same as described incomment14 <show_bug.cgi?id=58207#c14>. > > Regards > > Robert > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. > I've been using the slackbuilds from alien's website which work with postgresql-SDBC in both 3.x and 4.0.x. I tried these before trying to rebuild libreoffice on my own system as I needed to get things going without too much fuss. They work very well with the latest postgresql 9.2 versions. My guess is that with Slackware, there are some shared libraries missing that are required for the mainstream LibreOffice builds. The bug can probably be closed at this point. Thank you very much for your followup and development of LibreOffice. Cheers, Fred
(In reply to comment #21) > I've been using the slackbuilds from alien's website which work with > postgresql-SDBC in both 3.x and 4.0.x. I tried these before trying to > rebuild libreoffice on my own system as I needed to get things going > without too much fuss. They work very well with the latest postgresql > 9.2 versions. My guess is that with Slackware, there are some shared > libraries missing that are required for the mainstream LibreOffice builds. > > The bug can probably be closed at this point. Thank you very much for > your followup and development of LibreOffice. So let us close this bug as "resolved - worksforme". Regards Robert