Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

Thanks for the quick replies. Some points...
Disconnecting/Reconnecting the MySQL server from LO-DB is not really a
work-around. Essentially confirming the displayed message mentioned (i.e.
"The last package sent to the server...") with just one click is in my
opinion more efficient, although not really good enough for somebody not
quite as "benevolent" as myself wrt doing "serious" day to day work with LO-BASE.
Regarding SSH to the server: I use the MySQL client all the time without problems
from my LOCAL machine anyway without having to use SSH, which - by the way -
I am not allowed to use either by the sysadmin at the server. However, while the
MySQL client is o.k. for DB-Admins to do maintenance work (like backups), it is
not fit for everyday production type transaction-type work. By the way - the same
applies also to tools like phpMyAdmin or MySQL workbench.
I will look into this as a feature request...
Regards from Salzburg (hardly any snow here - in January! Where is the world
getting to, I wonder!

On Wed, 27 Jan 2016 11:53:18 +0100, Tom Davies <> wrote:

Hi :)
If you haven't already done so then posting this idea as a "featurerequest" would be a really good 
way forwards.  Unfortunately not many devs
dare take on the challenge of working with Base.  So the next step might be
to promote it somewhere, preferably in a few different places.  This
mailing list is a good one.  Perhaps a MySql forum too.  Perhaps some sort
of crowd-funding or crowd sourcing place.  So, i think you are already
doing the right sorts of things.

Wrt trying to access a remote server, perhaps using ssh from a linux
command-line might be a way in?  Dealing with the server's sys.admin might
be a blocker, or rather finding a way of contacting them might be.
Regards from
Tom :)

On Wednesday, 27 January 2016, Heinrich Stoellinger <>

I have been an avid user of LO/OO-Base for years, using it to connect to a
MySQL database for everyday work --- couldn't do without it. I am convinced
that a good connection to a DB-backend like MySQL/MariaDB is essential for
LO to be successful in a "real" business environment.
As I have mentioned in earlier messages to the list, I use JDBC to connect
to my remote DB-server as well as the native MySQL-connector for my local
test server.
Unfortunately I don't have access to the remote server and therefore cannot
change its idle-timeout, which is set at 60 seconds.
On my Linux-Mint system I also connect to the server via the command line
MySQL client. If - after going away for more than 60 seconds - I come back
to do more work, the client reports the timeout, but reconnects
This is kind of acceptable, even in a business production environment.
Unfortunately the native connector does not support "autoreconnect". This
means that one would have to restart LO in case of a timeout (unacceptable
for "serious" work!) On the other hand, JDBC does allow the specification
"autoreconnect=true" as part of a connect string. However, unlike in the
of the MySQL command-line client, LO-Base doesn't simply reconnect
but displays a message such as "The last package sent to the server was x
seconds ago, the lase received packed was y seconds ago".
This means that whenever a timeout occurs, one has to confirm the wish to
reconnect - even though one has specified that one wants to do this in the
connect string when defining the DB-connection properties in the first
I wonder how difficult it would be to implement such a REALLY automatic
Regards (and I appologise for the lengthy description...)
H. Stoellinger

Erstellt mit Operas revolutionärem E-Mail-Modul:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

Erstellt mit Operas revolutionärem E-Mail-Modul:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.