Ask Your Question
0

Connecting to PostgreSQL database with LibreOffice Base

asked 2016-09-05 16:56:05 +0200

Abrabacabra gravatar image

Hello,

I tried to resolve my problem with the information gathered on the internet, but I still don't get why it is not working.

I am using LibreOffice 5.1.5 and PostgreSQL 9.4.

So in the Datasource URL I type:

dbname=geomatic_db hostaddr=192.168.1.112

Then I enter my login/password to test the connection. (The connection could not be established)

I can connect to my DB using PGAdmin or phppgadmin using the same credentials.

What am I doing wrong?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-09-05 18:03:51 +0200

Ratslinger gravatar image

Haven't used PostgreSQL in some time but I believe you are missing port=5432.

edit flag offensive delete link more

Comments

Still have the same error

Abrabacabra gravatar imageAbrabacabra ( 2016-09-05 22:02:53 +0200 )edit

Just downloaded, installed and connected. Used host=localhost port=5432 dbname=myTest

I'm on xubuntu 16.04 LO v5.2 and PostgreSQL 9.5

Ratslinger gravatar imageRatslinger ( 2016-09-05 23:24:00 +0200 )edit

Still doesn't work...

Where can I view logs of connection attempts? That would be useful for debug...

Abrabacabra gravatar imageAbrabacabra ( 2016-09-06 02:52:18 +0200 )edit

On Xubuntu it's root/var/log/postgresql/postgresql-9.5-main.log

Ratslinger gravatar imageRatslinger ( 2016-09-06 03:15:16 +0200 )edit

By the way, what connection type are you using. I'm using the default PostgreSQL connection installed with LO.

Ratslinger gravatar imageRatslinger ( 2016-09-06 03:19:26 +0200 )edit

SDBC. I installed the Debian package libreoffice-sdbc-postgresql

Abrabacabra gravatar imageAbrabacabra ( 2016-09-06 04:19:27 +0200 )edit

But what about Base logs?

Abrabacabra gravatar imageAbrabacabra ( 2016-09-06 04:21:50 +0200 )edit

No Base logs. Why not use the native connector? Supposedly better than others. I don't get it. I've completely installed twice today just to cover the bases. Used native connector in Base - no problems. Used JDBC in SQL Workbench also no problems. It's pretty straightforward. I think MySQL was more difficult.

Ratslinger gravatar imageRatslinger ( 2016-09-06 05:07:58 +0200 )edit

I purged LibreOffice* and reinstalled and it worked. I think the issue came from the fact that I installed LibreOffice from Debians's backports but the SDBC driver from the Stable repo (i didn't pay attention...). I installed everything from the same repo, and now it works.

Thank you!

Abrabacabra gravatar imageAbrabacabra ( 2016-09-06 13:37:16 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-09-05 16:56:05 +0200

Seen: 7,930 times

Last updated: Sep 05 '16