[libreoffice-users] Re: MySQL-Connector
On 02/15/2013 07:59 PM, Heinrich Stoellinger wrote: Hi Heinrich, - it neither works on Mint-Nadia or Windows-Vista (I know, I know -- I should upgrade THAT system!). The connector DID however work under Vista and LO 3.6.5. Unfortunately I really don't have the time to compile it myself... What are the plans in any case? There are no plans by any of the mainstream devs, or the LO project, to support this connector. For Linux distribs, you will have to wait until they produce an updated connector, but of course, if they are not shipping LO4, the you are well and truly up the creek without a paddle. Which bit architecture are you using on Linux Nadia ? I can send you a 32bit version that I built for Linux Maya and which works, but it might not on Nadia if the Ubuntu/Mint people have changed the mysql library versions in the meantime. Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: MySQL-Connector
On 02/15/2013 08:15 PM, Dan Lewis wrote: Hi Dan, One of the problems depends upon whether the OS is 32 bit or 64 bit. I have a tower that is 64 bit and a MacBook which uses 32 bit with both using Ubuntu 12.04 LTS. The native connector works fine for 64 bit but does not work for the 32 bit. MySQL also has a JDBC driver on their On my 32bit Linux Mint Maya and Pear Linux distribs (both based on Ubuntu Precise Pangolin), I can build a functional mysql connector. If you want a copy to test, please let me know by private mail On Mac OSX, the build of the connector is hosed thanks to recent changes introduced by a Linux dev to switch building of the connector to the gbuild process. I have no idea what is happening on Windows, as no-one that I know of is building it for that OS. Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: MySQL-Connector
On 02/15/2013 07:59 PM, Heinrich Stoellinger wrote: Hi Heinrich, Unfortunately I really don't have the time to compile it myself... What are the plans in any case? If your Nadia OS is 32bit, try this : https://dl.dropbox.com/u/107086405/32bit/U1204/mysql-connector-ooo.oxt and let me know whether it works. Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: MySQL-Connector
On 02/16/2013 10:09 AM, Alex Thurgood wrote: If your Nadia OS is 32bit, try this : https://dl.dropbox.com/u/107086405/32bit/U1204/mysql-connector-ooo.oxt and let me know whether it works. 64bit version here (Ubuntu1204 baseline) : https://dl.dropbox.com/u/107086405/64bit/U1204/mysql-connector-ooo.oxt Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Look for step-by-step guide
Am 15.02.2013 03:26, schrieb C. H. D.: I am new to debugging and programming. Referring to: https://bugs.freedesktop.org/show_bug.cgi?id=60710#c5 ... do you have a debug symbols build you could run valgrind in to see if there is some memory corruption there ? What documents should I consult to help me to understand what to do? Where is the step-by-step guide, especially for LibreOffice 4? (I need detailed steps.) Did you read https://wiki.documentfoundation.org/BugReport ? Especially, the section on extra info looks helpful: https://wiki.documentfoundation.org/BugReport#Providing_extra_information_for_the_developers_-_ADVANCED HTH, Nino -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Using_LibreOffice_in_a_Web_Browser
Where can i get more info on 'Using_LibreOffice_in_a_Web_Browser' i found this link: https://wiki.documentfoundation.org/Using_LibreOffice_in_a_Web_Browser What is the planning with this web-enabled stuff? -- Luuk -- For unsubscribe instructions e-mail to: users+h...@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] page down in word processors - find next
I was asking about the keyboard PgDn button. On-screen buttons are a different topic. On Sat, 2013-02-16 at 04:01 +, Tom Davies wrote: Hi :) ???!?!!?!?? Ahh. You were talking about on-screen buttons? The ones under the vertical scroll bar? Middle one is called Navigation. I was talking about keyboard buttons. Now i'm not sure what anyone else was talking about. It's 4am though so i might still be dreaming or having a nightmare or something. I thought i understood but now i'm flummoxed. Regards form Tom :) From: Jean-Francois Nifenecker jean-francois.nifenec...@laposte.net To: users@global.libreoffice.org Sent: Friday, 15 February 2013, 22:24 Subject: Re: [libreoffice-users] page down in word processors - find next Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes continue search forward and the page up becomes continue search backwards. That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: page down in word processors - find next
On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes continue search forward and the page up becomes continue search backwards. That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, It would seem that as LO has evolved, changing the meaning of the page down/up screen buttons to search down/up is no longer needed as the find box (at the bottom of the screen) has search up/down arrows right next to it. If folk agree, I will file an enhancement request (If someone will give me the buglist address again) bill -- For unsubscribe instructions e-mail to: users+h...@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] Re: page down in word processors - find next
On 02/16/2013 07:41 AM, william drescher wrote: On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes continue search forward and the page up becomes continue search backwards. That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, It would seem that as LO has evolved, changing the meaning of the page down/up screen buttons to search down/up is no longer needed as the find box (at the bottom of the screen) has search up/down arrows right next to it. If folk agree, I will file an enhancement request (If someone will give me the buglist address again) bill For some time, this has been used for navigation. PageUp/PageDown and SearchUp/SearchDown are only 2 of 20 functions. What about the other 18 functions? I think we can even give this a name: Navigation tool. --Dan -- For unsubscribe instructions e-mail to: users+h...@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] page down in word processors - find next
Tom, Eric, Le 16/02/2013 13:18, Eric Beversluis a écrit : I was asking about the keyboard PgDn button. On-screen buttons are a different topic. to my French understanding, a button is some screen widget. On a keyboard there are only keys. Sorry if I misunderstood. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@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] page down in word processors - find next
You're right, of course. We started talking about keys, but then somewhere the word 'button' started getting used to refer to keys. However Tom's reference to the 'Edit File' button to toggle between 'read only' and 'edit' was correct usage--though it may have put 'button' rather than 'key' into our heads. On Sat, 2013-02-16 at 14:31 +0100, Jean-Francois Nifenecker wrote: Tom, Eric, Le 16/02/2013 13:18, Eric Beversluis a écrit : I was asking about the keyboard PgDn button. On-screen buttons are a different topic. to my French understanding, a button is some screen widget. On a keyboard there are only keys. Sorry if I misunderstood. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@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] Re: MySQL-Connector
On Sat, 16 Feb 2013 08:55:02 +0100, Alex Thurgood alex.thurg...@gmail.com wrote: On 02/15/2013 07:59 PM, Heinrich Stoellinger wrote: Hi Heinrich, - it neither works on Mint-Nadia or Windows-Vista (I know, I know -- I should upgrade THAT system!). The connector DID however work under Vista and LO 3.6.5. Unfortunately I really don't have the time to compile it myself... What are the plans in any case? There are no plans by any of the mainstream devs, or the LO project, to support this connector. For Linux distribs, you will have to wait until they produce an updated connector, but of course, if they are not shipping LO4, the you are well and truly up the creek without a paddle. Which bit architecture are you using on Linux Nadia ? I can send you a 32bit version that I built for Linux Maya and which works, but it might not on Nadia if the Ubuntu/Mint people have changed the mysql library versions in the meantime. Alex Hi Alex, Thanks for your offer! I use a 32bit architecture on Mint-Nadia. Yes, I will gladly try out the connector you built for Maya. Please send it to hc.stoellin...@aon.at. I have of course used both JDBC- and ODBC-based connectors in the past. But if I can, I avoid both of them, partly for the reason that installation (of the ODBC-version in particular) is more work, but also because I have found them to be buggier. I also assume that they use more resources. Altogether I feel that a well-performing, stable connector to the widely used relational DB-systems is a MUST for any serious application where data structure is non-trivial and where a sizeable amount of data has to be dealt with. So - if AOOffice can produce something which works cross-OS then we should try to get something working also in LO. Regards from a snowed in Salzburg Heinrich -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] Re: MySQL-Connector
Hello Alex, Thanks for the offer - unfortunately it does NOT work.. What a pity! Regards H On Sat, 16 Feb 2013 10:09:09 +0100, Alex Thurgood alex.thurg...@gmail.com wrote: On 02/15/2013 07:59 PM, Heinrich Stoellinger wrote: Hi Heinrich, Unfortunately I really don't have the time to compile it myself... What are the plans in any case? If your Nadia OS is 32bit, try this : https://dl.dropbox.com/u/107086405/32bit/U1204/mysql-connector-ooo.oxt and let me know whether it works. Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] Re: page down in word processors - find next
Hi :) I am not quite sure what the proposal is but here is the link https://wiki.documentfoundation.org/BugReport I like the way OpenSource tends to have many different ways of doing the same thing. To some extent it seems most programs do but OpenSource sometimes goes a bit further in offering some really odd methods. So, just because 1 thing works doesn't mean we need to depreciate another way. People each get used to their own preferred ways and seldom appreciate being forced to learn new ones Regards from Tom :) From: william drescher will...@techservsys.com To: users@global.libreoffice.org Sent: Saturday, 16 February 2013, 12:41 Subject: [libreoffice-users] Re: page down in word processors - find next On 2/15/2013 5:24 PM, Jean-Francois Nifenecker wrote: Le 15/02/2013 22:59, bill a écrit : I am keeping the same thread as it is closely related. The one thing that I really don't like is that as soon as you do a search the page down button becomes continue search forward and the page up becomes continue search backwards. That is fine while you are searching, but how does one return it to page up and page down ? You'll notice that then the page buttons are changing colours: by default, they turn blue in search mode while they are black in scroll mode. To get back from the search mode to the scroll mode, just click the center button (whatitsname?) and select the page icon. HTH, It would seem that as LO has evolved, changing the meaning of the page down/up screen buttons to search down/up is no longer needed as the find box (at the bottom of the screen) has search up/down arrows right next to it. If folk agree, I will file an enhancement request (If someone will give me the buglist address again) bill -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Re: MySQL-Connector
Hi :) Oops, i meant the files NOT the connector. Can the same file be read on different platforms if each platform is using the appropriate connector for it? So if those different platforms are using different versions of LIbreOffice but the right connectors then opening and using the files shouldn't be a problem should it? Regards from Tom :) From: Alex Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Saturday, 16 February 2013, 7:51 Subject: [libreoffice-users] Re: MySQL-Connector On 02/15/2013 10:24 PM, Tom Davies wrote: Tom, Is there a problem with running different versions on different OSes? It should be fine t do that shouldn't it? Regards from Tom :) Please, please, pretty please, sometimes I really do get the impression you have not read anything we have exchanged in the past on this topic. On Unix/Linux, and for LibreOffice, the native connector is dependent on : - the OS version ; - the bit architecture ; - the version of libmysqlclient ; - the version of libmysqlcppconn ; - the version of LO. This means that if I build a mysql connector on say PCBSD 9.1, it will not work on Ubuntu, Suse, Redhat or Debian. Even if I build a 32bit version of the connector on a Suse 32bit OS, the functionality on another version of that same OS is not guaranteed if the versions of libmysqlclient or libmysqlcppconn are different between the two versions, notwithstanding the fact that it will not work at all on a 64bit Suse OS (different architectures). So, the situation today is that for each Linux/Unix OS, and each major version of that OS, the connector has to be built separately. In addition to these niceties, the build of the connector regularly gets screwed by devs changing things for one OS (mostly Linux), without giving a *expletive* about the other OSes. This is currently the case at least for Mac OSX, thanks to recent changes in the gbuild process for mysqlc and mysqlcppconn. As I don't build on Windows (and do not intend to), I really don't know what the situation is there currently. The situation over at ApacheOO is different. There, the connector is built by another volunteer, using the SDK, i.e. in theory, it produces an OS version agnostic mysql connector. However, the differences in code trees between LO and AOO now mean that the connector for AOO no longer works in LO4, or at least, that is what Heinrich has reported (and Robert too, I believe). Alex -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: MySQL-Connector
On 02/16/2013 06:55 PM, Heinrich Stoellinger wrote: Hello Alex, Thanks for the offer - unfortunately it does NOT work.. What a pity! Regards H Ok, so that confirms that it is Linux OS bit and version dependent, probably because the versions of the mysql libraries have changed too. Alex -- For unsubscribe instructions e-mail to: users+h...@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] Re: MySQL-Connector
UNSUBSCRIBE ME! I HAVE USED YOUR UNSUBSCRIBE SYSTEM 3 TIMES, NOW, AND I AM SICK OF IT! UNSUBSCRIBE ME!! -- j...@fastmail.us On Sat, Feb 16, 2013, at 03:40 PM, Tom Davies wrote: Hi :) Oops, i meant the files NOT the connector. Can the same file be read on different platforms if each platform is using the appropriate connector for it? So if those different platforms are using different versions of LIbreOffice but the right connectors then opening and using the files shouldn't be a problem should it? Regards from Tom :) From: Alex Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Saturday, 16 February 2013, 7:51 Subject: [libreoffice-users] Re: MySQL-Connector On 02/15/2013 10:24 PM, Tom Davies wrote: Tom, Is there a problem with running different versions on different OSes? It should be fine t do that shouldn't it? Regards from Tom :) Please, please, pretty please, sometimes I really do get the impression you have not read anything we have exchanged in the past on this topic. On Unix/Linux, and for LibreOffice, the native connector is dependent on : - the OS version ; - the bit architecture ; - the version of libmysqlclient ; - the version of libmysqlcppconn ; - the version of LO. This means that if I build a mysql connector on say PCBSD 9.1, it will not work on Ubuntu, Suse, Redhat or Debian. Even if I build a 32bit version of the connector on a Suse 32bit OS, the functionality on another version of that same OS is not guaranteed if the versions of libmysqlclient or libmysqlcppconn are different between the two versions, notwithstanding the fact that it will not work at all on a 64bit Suse OS (different architectures). So, the situation today is that for each Linux/Unix OS, and each major version of that OS, the connector has to be built separately. In addition to these niceties, the build of the connector regularly gets screwed by devs changing things for one OS (mostly Linux), without giving a *expletive* about the other OSes. This is currently the case at least for Mac OSX, thanks to recent changes in the gbuild process for mysqlc and mysqlcppconn. As I don't build on Windows (and do not intend to), I really don't know what the situation is there currently. The situation over at ApacheOO is different. There, the connector is built by another volunteer, using the SDK, i.e. in theory, it produces an OS version agnostic mysql connector. However, the differences in code trees between LO and AOO now mean that the connector for AOO no longer works in LO4, or at least, that is what Heinrich has reported (and Robert too, I believe). Alex -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Re: MySQL-Connector
Looks like it, Alex! As I said before, I don't really want to use the Java version, it never worked well for me either on Linux OR on Windows. Also, isn't there a kind of strategy to diminish the dependence on Java in LO? If so, this would be yet another reason to avoid JDBC. ODBC on the other hand requires more effort to set it up, especially on a variation of system platforms... So, it seems to me that the way to go MUST be a native connector. Do you know whether MariaDB is doing anything in this direction? Regards H On Sat, 16 Feb 2013 22:22:11 +0100, Alex Thurgood alex.thurg...@gmail.com wrote: On 02/16/2013 06:55 PM, Heinrich Stoellinger wrote: Hello Alex, Thanks for the offer - unfortunately it does NOT work.. What a pity! Regards H Ok, so that confirms that it is Linux OS bit and version dependent, probably because the versions of the mysql libraries have changed too. Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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
Problems unsubscribing from list was: [libreoffice-users] MySQL-Connector
Have you taken a look at the Problems? link underneath the link to the help email? On Saturday, 16 February 2013, JIM7 wrote: UNSUBSCRIBE ME! I HAVE USED YOUR UNSUBSCRIBE SYSTEM 3 TIMES, NOW, AND I AM SICK OF IT! UNSUBSCRIBE ME!! -- j...@fastmail.us javascript:; On Sat, Feb 16, 2013, at 03:40 PM, Tom Davies wrote: Hi :) Oops, i meant the files NOT the connector. Can the same file be read on different platforms if each platform is using the appropriate connector for it? So if those different platforms are using different versions of LIbreOffice but the right connectors then opening and using the files shouldn't be a problem should it? Regards from Tom :) From: Alex Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Saturday, 16 February 2013, 7:51 Subject: [libreoffice-users] Re: MySQL-Connector On 02/15/2013 10:24 PM, Tom Davies wrote: Tom, Is there a problem with running different versions on different OSes? It should be fine t do that shouldn't it? Regards from Tom :) Please, please, pretty please, sometimes I really do get the impression you have not read anything we have exchanged in the past on this topic. On Unix/Linux, and for LibreOffice, the native connector is dependent on : - the OS version ; - the bit architecture ; - the version of libmysqlclient ; - the version of libmysqlcppconn ; - the version of LO. This means that if I build a mysql connector on say PCBSD 9.1, it will not work on Ubuntu, Suse, Redhat or Debian. Even if I build a 32bit version of the connector on a Suse 32bit OS, the functionality on another version of that same OS is not guaranteed if the versions of libmysqlclient or libmysqlcppconn are different between the two versions, notwithstanding the fact that it will not work at all on a 64bit Suse OS (different architectures). So, the situation today is that for each Linux/Unix OS, and each major version of that OS, the connector has to be built separately. In addition to these niceties, the build of the connector regularly gets screwed by devs changing things for one OS (mostly Linux), without giving a *expletive* about the other OSes. This is currently the case at least for Mac OSX, thanks to recent changes in the gbuild process for mysqlc and mysqlcppconn. As I don't build on Windows (and do not intend to), I really don't know what the situation is there currently. The situation over at ApacheOO is different. There, the connector is built by another volunteer, using the SDK, i.e. in theory, it produces an OS version agnostic mysql connector. However, the differences in code trees between LO and AOO now mean that the connector for AOO no longer works in LO4, or at least, that is what Heinrich has reported (and Robert too, I believe). Alex -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ -- For unsubscribe instructions e-mail to: users+h...@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: Problems unsubscribing from list was: [libreoffice-users] MySQL-Connector
Hi :) This link http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ The instructions say to send an email to users+h...@global.libreoffice.org but often the users+ bit looks like it's not part of the address. That users+ bit is crucial! So it's the entire line there that needs to be used as the address. Do you get the confirmation email or do you never receive that? Regards from Tom :) From: Kieran Peckett crazyske...@gmail.com To: JIM7 j...@fastmail.us Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Saturday, 16 February 2013, 21:43 Subject: Problems unsubscribing from list was: [libreoffice-users] MySQL-Connector Have you taken a look at the Problems? link underneath the link to the help email? On Saturday, 16 February 2013, JIM7 wrote: UNSUBSCRIBE ME! I HAVE USED YOUR UNSUBSCRIBE SYSTEM 3 TIMES, NOW, AND I AM SICK OF IT! UNSUBSCRIBE ME!! -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] MySQL on a network
On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@gmail.com wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Hi Dan, When you define your MySQL-database under LO-Base, specify the hostname (or the IP-address) of the server as well as the port (usually 3306) instead of localhost. I am actually using a MySQL-server over the internet. It works o.k Regards H -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] Link Base to External Spreadsheet
On 02/16/2013 07:04 PM, Mark LaPierre wrote: Hey All, I need to link a database to several external spreadsheets. A. If I use the DB wizard to create a DB linked to a spreadsheet I get the table named by the name of the tab inside the spreadsheet. That's great but I can not add any more tables, linked or otherwise. B. If I add a new table by opening a spreadsheet in Calc, and then selecting the data in the spreadsheet, copying, and then pasting it into Base, with the table icon selected, I get a table with fixed data. I need to do A. to link to multiple external tables. I also need to be able to create additional tables that are not links to external spreadsheets. A few weeks of perusing the manual, google, and the help files has not provided an answer. Maybe I need to use MS Access. Any suggestions? You are using Base to connect to a spreadsheet. Because of that, you can only add, modify, nor remove data within the spreadsheet. So, if you want to add more tables, add more sheets that each has the data for a new table. Then save the spreadsheet, close and then reopen Base. The new tables should show up in the database. And as you have discovered, you will want to name each new sheet with the name you want for the table. I've done this several times. --Dan -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Ubuntu PPAs for 4.0.x Stable?
Anybody know when the PPA for 4.0.x will be populated? I'm in no rush and can obviously download the .deb files. However, would make deploying to 30 computers a tad easier. The following PPA is empty. https://launchpad.net/~libreoffice/+archive/libreoffice-4-0 Thanks. -- Sajan Parikh /Owner, Noppix LLC/ e: sa...@noppix.com p: (563) 447-0822 Noppix LLC Logo -- For unsubscribe instructions e-mail to: users+h...@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] Link Base to External Spreadsheet
On 02/16/2013 07:32 PM, Dan Lewis wrote: On 02/16/2013 07:04 PM, Mark LaPierre wrote: Hey All, I need to link a database to several external spreadsheets. A. If I use the DB wizard to create a DB linked to a spreadsheet I get the table named by the name of the tab inside the spreadsheet. That's great but I can not add any more tables, linked or otherwise. B. If I add a new table by opening a spreadsheet in Calc, and then selecting the data in the spreadsheet, copying, and then pasting it into Base, with the table icon selected, I get a table with fixed data. I need to do A. to link to multiple external tables. I also need to be able to create additional tables that are not links to external spreadsheets. A few weeks of perusing the manual, google, and the help files has not provided an answer. Maybe I need to use MS Access. Any suggestions? You are using Base to connect to a spreadsheet. Because of that, you can only add, modify, nor remove data within the spreadsheet. So, if you want to add more tables, add more sheets that each has the data for a new table. Then save the spreadsheet, close and then reopen Base. The new tables should show up in the database. And as you have discovered, you will want to name each new sheet with the name you want for the table. I've done this several times. --Dan Thanks Dan, Now how do I create non-linked tables inside the same DB? How do I link to another external spreadsheet using the same DB? Can I link to only one spreadsheet at a time? I have data in four different spreadsheets that I need to consolidate into one large report. The data in those spreadsheets changes every week. I don't want to have to copy and paste the data from those four spreadsheets onto the appropriate tab of linked spreadsheet every week. From your email I gather that all tables must be tabs on the one spreadsheet that is linked. Is that a true statement? Seems pretty inconvenient. -- _ °v° /(_)\ ^ ^ Mark LaPierre Registered Linux user No #267004 https://linuxcounter.net/ -- For unsubscribe instructions e-mail to: users+h...@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] MySQL on a network
Dan Lewis wrote: On 02/16/2013 06:44 PM, Heinrich Stoellinger wrote: On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@gmail.com wrote: I can connect to the MySQL server (5.5) on the same computer using localhost. But how do I connect to a MySQL server on another computer on the same network? I can not find it in the MySQL manual, or I don't know where to look in it. I use MySQL Workbench for administrative purposes. --Dan Hi Dan, When you define your MySQL-database under LO-Base, specify the hostname (or the IP-address) of the server as well as the port (usually 3306) instead of localhost. I am actually using a MySQL-server over the internet. It works o.k Regards H More information: My laptop is 192.168.2.101 and the MySQL server is on 192.168.2.100. The database I want to access is Budget. I entered Budget as the database name, Server as 192.168.2.100, port is 3306. I then test the connection, enter the user name and password. The error message I get is Host '192.168.2.101' is not allowed to connect to this MySQL server. I am using the MySQL JDBC driver, and when I click the Test Class button, I get the message The JDBC Driver was loaded successfully. Any suggestions as to what I might be doing wrong? --Dan Sounds like the server is not configured to allow you access. Since the IP addresses for the server and your computer are on the same LAN, I can assume the MySQL server is on another computer on the same LAN. You don't say if you did this in mysql: GRANT ALL PRIVILEGES ON *.* TO username@hostname IDENTIFIED BY `password` WITH GRANT OPTION; Note that the hostname should be the IP address of your laptop, or 192.168.2.101 . Note that the IP address may need around it due to the periods and numbers. If not, the server will not allow you access. The laptop is not registered as a trusted computer. You must have done this for your other computer, but you need to do it for all computers you need access for. Or, if you are brave, you can use % for any host: username@%. Or, better yet, you can limit access to your LAN: username@192.168.2.% For further information, this can be found in the MySQL reference manual under Access Control, Stage 1: Connection Verification. Hope this helps. Girvin Herr -- For unsubscribe instructions e-mail to: users+h...@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