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 lagin...@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%3Dtrueie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-achannel=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.h...@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 lagin...@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.stoellin...@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
Re: [libreoffice-users] Native Connector
Hello Girvin, Yes, I will keep on using the JDBC-Driver, hoping that the native connector will support autoreconnect some time in the future. If LO drops JDBC, I have to look for a different Office system. To suggest restarting LO every time after having to go away for a short break really is NOT feasible in reality. Regards Heinrich P.S.: What do you guys think of Conchita winning the Eurovision song contest -- but THAT certainly should NOT start a new thread...(smiley!) On Sun, 11 May 2014 21:53:25 +0200, Girvin Herr girvin.h...@sbcglobal.net wrote: 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 lagin...@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.stoellin...@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/ -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Native Connector
Heinrich, Although I do not have the problem you are experiencing, I am keeping an eye on this thread is case I do have a similar problem in the future. I hope you can get an answer soon to solve your immediate problem. Aside from your cup of coffee example, from my experience, the Base Report Generator can take much more than 60 seconds to render a large report. I am not sure how Base collects the data for a report, but if it does so a record at a time, then your server would time out way before the report is finished! I would think that the best case would be that the constant reconnects would slow the Report Generator even more. Since it sounds like your system worked before LO 4.2.x and I suspect you where using the Oracle MySQL-connector-java, as I am, there may be a way to replace the new native connector with the tried-and-true Oracle connector. That would get you up and running again until more information on the native connector is released. I have no experience with this, but it may be an option for you, if it can be done. Good luck. Girvin On 05/11/2014 11:52 PM, Heinrich Stoellinger wrote: 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 lagin...@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%3Dtrueie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-achannel=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.h...@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 lagin...@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
Re: [libreoffice-users] Native Connector
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 lagin...@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.stoellin...@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/ -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Native Connector
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 lagin...@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.stoellin...@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/ -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Native Connector
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%3Dtrueie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-achannel=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.h...@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 lagin...@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.stoellin...@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/ -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Native Connector
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.stoellin...@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/ -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Native Connector
Hello, I am NOT referring to the server-side machine shutting down but - as I mentioned already earlier - to the MySQL-Server-parameter wait_timeout which is specified in my.cnf. It simply defines the interval of no request from a particular client to the server it is connected to. The server shuts down the connection if that period has expired without further hearing from the client. My problem is that I am NOT the system administrator of the server and the sysadmin of the server won't increase that wait_timeout value. JDBC has a way around this by auto-reconnecting the client if this is specified when establishing the connection. This is NOT an ideal situation (re-establishing the connection takes time...) but it is certainly better than having to shutdown/restart LO... Regards H. S. On Sat, 10 May 2014 23:13:38 +0200, anne-ology lagin...@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.stoellin...@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 on 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/ -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Native Connector
Sounds like the reason these programs are pre-programmed to save every so often ... yikes ... ... ... ;-0 Well, I think I'll return to referring to these machines as 'glorified typewriters' ;-) the KISs method doesn't allow for comprehending all the inner workings of these thing-a-ma-jigs ;-) Reminds me of ... ... ... ;-) ;-) ;-) `Twas brillig, and the slithy toves Did gyre and gimble in the wabe: All mimsy were the borogoves, And the mome raths outgrabe. ... ... ... by Rev. Charles Lutwidge Dodgson a.k.a. Lewis Carroll From: Heinrich Stoellinger hc.stoellin...@aon.at Date: Sat, May 10, 2014 at 5:46 PM Subject: Re: [libreoffice-users] Native Connector To: users@global.libreoffice.org Hello, I am NOT referring to the server-side machine shutting down but - as I mentioned already earlier - to the MySQL-Server-parameter wait_timeout which is specified in my.cnf. It simply defines the interval of no request from a particular client to the server it is connected to. The server shuts down the connection if that period has expired without further hearing from the client. My problem is that I am NOT the system administrator of the server and the sysadmin of the server won't increase that wait_timeout value. JDBC has a way around this by auto-reconnecting the client if this is specified when establishing the connection. This is NOT an ideal situation (re-establishing the connection takes time...) but it is certainly better than having to shutdown/restart LO... Regards H. S. On Sat, 10 May 2014 23:13:38 +0200, anne-ology lagin...@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.stoellin...@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 on 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 -- To unsubscribe e-mail to: users+unsubscr...@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