Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 10 Jan 2016 19:23:16 -0600
From:      Ryan Losh <ryanlosh@gmail.com>
To:        office@FreeBSD.org
Subject:   libreoffice FreeBSD port with PGSQL enabled--Base not working with a Postgres 9.3 server.
Message-ID:  <56930404.8040405@gmail.com>

next in thread | raw e-mail | index | archive | help
Hello:

I'm currently running PC-BSD, and I'm trying to get libreoffice Base to 
talk to my PostgreSQL 9.3 server.  The pre-built libreoffice binary in 
the PC-BSD "App Cafe" was built with the option for PGSQL=off.

On Saturday afternoon, 1/9/16 at approx 3:00 PM CST, I used the portsnap 
tool to update my ports tree.  I then proceeded to build my own 
editors/libreoffice package after using "make config" so that the 
options were the same as the PC-BSD build, only with PGSQL=on. Options 
listed below:

CUPS=on
GNOME=off
GTK2=on
GTK3=on
JAVA=on
KDE4=on
MMEDIA=off
PGSQL=on
SDK=off
SYSTRAY=on
TEST=off
VERBOSE=off
WEBDAV=off

The resulting libreoffice Base allows one to attempt to connect to 
postgres (I've verified that I can use the 'psql' command line tool on 
the system to connect to the desired database).  When one clicks the 
"test connection" button, a message pops up "Connection Test The 
connection was established successfully."  However, when one clicks the 
"Finish" button (with Yes, register the database for me, Open the 
database for editing), it says  "LibreOffice Document Recovery...Due to 
an unexpected error, LibreOffice crashed. All the files you were working 
on will now be saved. The next time LibreOffice is launched, your files 
will be recovered automatically. The following filews will be recovered:"

I've tried running libreoffice from the command line to see if any 
"clues" are given as to 'what' the unexpected error is.  I've looked 
everywhere I know to look for error messages, but cannot find any...

Is this a known problem?  If not, how can I help "debug" / troubleshoot 
it so it can be fixed?

libreoffice Base on my Windows, Mac and Linux PC's *ARE* able to connect 
to the postgres database, and (at least) read information from the 
tables therein...


Thank you
Ryan Losh
ryanlosh@gmail.com



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?56930404.8040405>