Re: [libreoffice-users] LO-Base - Autoreconnect

Hello,
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 <tomcecf@gmail.com> 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 <hc.stoellinger@aon.at>
> wrote:
>
> > Hello,
> > 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
> > automatically.
> > 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
> > of
> > "autoreconnect=true" as part of a connect string. However, unlike in the
> > case
> > of the MySQL command-line client, LO-Base doesn't simply reconnect
> > AUTOMATICALLY,
> > 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
> > place!
> > I wonder how difficult it would be to implement such a REALLY automatic
> > reconnection...
> > Regards (and I appologise for the lengthy description...)
> > H. Stoellinger
> >
> >
> > --
> > Erstellt mit Operas revolutionärem E-Mail-Modul:
> > http://www.opera.com/mail/
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted