Re: [libreoffice-users] Native Connector

Thanks a lot, Girvin...
My situation is exactly as you describe it. I used to run my own server,
installing everything from Linux to Apache2, PHP, mail, MySQL, etc.
Therefore I had the possibility to set my OWN parameters for MySQL.
For cost and other reasons I changed to a "stripped-down" web-hosting
structure and therefore have stopped being my own admin....
I also think that 60 seconds is an inappropriate value for the wait_timeout
because it doesn't even allow you to go have a quick coffee (or other, more
pressing things...).
Yes, in MY situation it would be great if the native connector supported
a kind of automatic reconnect after the SERVER (nothing to do with LO-Base!)
shuts down an idle connection (in my case in 60 seconds, even though 28800
would be allowed!!!
Regards from Austria
H. S.


On Mon, 12 May 2014 00:35:48 +0200, anne-ology <laginnis@gmail.com> wrote:

>        Well, that autoReconnect=true must have something to do with JAVA
> ...
>
>             I 'searched' and uncovered nearly 100,000 articles  [whew  ;-)
> ]
>
> https://www.google.com/search?q=autoReconnect%3Dtrue&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a&channel=sb
>
>        BTW - when opening up the first few, I noticed others are asking the
> same question re. this timing out  ???!!!???!!!???
>
>        Oops - Something tells me I should quit calling this machine a
> glorified-typewriter; maybe it will want revenge and blow up ... ... ...
>             my mouse already died this year; had to replace the li'l
> fella'  ;-)
>
>
>
> From: Girvin Herr <girvin.herr@sbcglobal.net>
> Date: Sun, May 11, 2014 at 2:53 PM
> Subject: Re: [libreoffice-users] Native Connector
> To: users@global.libreoffice.org
>
>
> Yes, if I understand Mr. Stoellinger's problem correctly, it is the MySQL
> server (aka "back-end") which is dropping his connection. According to my
> MySQL documentation, by default, the MySQL server drops any connection
> after 8 hours of continuous connection. However, Mr. Stoellinger's admin
> has reduced that time to 60 seconds!  IMHO, that is ridiculous, but it must
> be the policy at his institution, so he must live with it.  The MySQL
> connector driver that he has been using has a workaround by triggering a
> reconnect operation every so often, effectively restarting the 60-second
> timer.  That is the purpose of the "autoReconnect=true" connector driver
> parameter he talks about.  Now, it appears that the new LO Base has a MySQL
> native driver that replaces the Oracle MySQL-connector-java driver that he
> most likely has been using and he needs to know if the new LO native driver
> supports the reconnect schema and if so, how to implement it.  As far as I
> know, no one on this list so far has given him the answer to that question.
>  I have no experience with the new native driver (yet), so I do not have
> the answer.  If the native driver does not support it, or he does not get
> an answer, I would suggest keeping the Oracle JDBC driver until he gets his
> answer, if the new LO still allows replacement of the native built-in
> driver.
>
> BTW: I am my own admin, so my MySQL server is still set to the default
> timeout, if any.  Therefore, I do not experience this disconnect problem.
>  However, every so often, I see a posting about it on this forum, so he is
> not alone.
> HTH.
> Girvin Herr
>
>
>
> On 05/10/2014 03:37 PM, Tom Davies wrote:
>
>  Hi :)
> > It's the 2nd one Anne-ology.
> >
> > The connector is some sort of bridge between Base and MySql.  It's the
> > bridge that is timing out rather than the computer afaik.
> > Regards from
> > Tom :)
> >
> >
> >
> >
> > On 10 May 2014 22:13, anne-ology <laginnis@gmail.com> wrote:
> >
> >          If you're referring to the computer-machine shutting down and/or
> > > entering sleep-mode, then there's a simple solution;
> > >              if you're referring to something else - well, I haven't a
> > > clue.
> > >
> > >         If the 1st - go to properties/options/ and re-set the timing
> > > mechanism to never shut down;
> > >             you can also do similarly in various programs - as LO -
> > >           which otherwise decide they want to save every so often, causing
> > > me to lose my train of thought while writing  ;-)
> > >
> > >         If the 2nd - I'll be awaiting someone else's response on this
> > > list;
> > >             and will attempt to figure out what's what  ;-)
> > >
> > >
> > >
> > > From: Heinrich Stoellinger <hc.stoellinger@aon.at>
> > > Date: Sat, May 10, 2014 at 8:08 AM
> > > Subject: [libreoffice-users] Native Connector
> > > To: "users@global.libreoffice.org" <users@global.libreoffice.org>
> > >
> > >
> > > Hello,
> > > It's good to see a native connector for MySQL under 4.2.
> > > One question: In the server my.cnf the value for wait_timeout
> > > is set to 60 seconds and will not be increased. This is a nuisance
> > > if one needs to be connected over longer periods but sometimes
> > > has to go away from there client for more than a minute.
> > > Under the JDBC-connector there is a possibility to specify
> > > "?auto-reconnect=true" after the database name.
> > > Is there some facility like that under the native connector?
> > > Regards
> > > H. Stoellinger
> > >
> > > --
> > > Erstellt mit Operas revolutionärem E-Mail-Modul:
> > > http://www.opera.com/mail/


--
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