[libreoffice-users] Re: Mysql Native Connector for LO 5.4
Le 08/09/2017 à 18:10, H. Stoellinger a écrit : Hi Heinrich, > environment together with LO 5.4.1. Is there a native connector (64-bit, > Linux-Mint 18.2)? The distro provided version of the native connector for Linux Mint 18.2 only works with 5.1.6.x I believe ? Of course, there is no native connector for any of the snap/PPA versions of LibreOffice nor I suppose for the 5.4.x version of LibreOffice from the TDF download site. The only place to find such a native connector would be the extensions website... Alex -- 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
[libreoffice-users] Re: MySQL Native Connector for Linux 4.2 and 4.3
Le 04/01/2015 14:01, Heinrich Stöllinger a écrit : Hi Heinrich, the possibility to specify such a parameter. Under the given situation LO 4.3.5.2 crashes when the server goes away and one acknowledges the respective error message. Is there a chance to get an autoconnect-feature included in a future version of the connector? File a new bug request for enhancement, if one hasn't been filed already. Your description of the crash when the connection is dropped at least confirms a bug I reported here : https://bugs.freedesktop.org/show_bug.cgi?id=83995 Alex -- 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
[libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Le 04/10/2014 00:09, Heinrich Stöllinger a écrit : Heinrich, Dan, It is a known limitation of the native mysql connector, although I don't remember right now whether an enhancement request has been filed. I couldn't find one after a quick search on bugzilla. Alex -- 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
[libreoffice-users] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex -- 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] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Alex Thurgood schrieb: Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex Hi Alex, I do have a long-time connection with ALL 3 kinds of MySQL connectors. Only the native one REALLY works o.k... There is one problem in MY case, however: My DB-Hosting facility specifies a connection time-out value of 1 minute. With the Java connector one can specify reconnect-true (or yes?) when defining the DB under LO. This means that LO at least re-connects after a termination of the connection by the server. This is NOT a good situation, but it is kind of acceptable. The native connector does NOT allow such a specification. This makes it unusable to me unfortunately. I hope that it might be possible to change this limitation of the native connector. Regards Heinrich -- 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] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
On 10/03/2014 06:07 AM, Heinrich Stöllinger wrote: Alex Thurgood schrieb: Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex Hi Alex, I do have a long-time connection with ALL 3 kinds of MySQL connectors. Only the native one REALLY works o.k... There is one problem in MY case, however: My DB-Hosting facility specifies a connection time-out value of 1 minute. With the Java connector one can specify reconnect-true (or yes?) when defining the DB under LO. This means that LO at least re-connects after a termination of the connection by the server. This is NOT a good situation, but it is kind of acceptable. The native connector does NOT allow such a specification. This makes it unusable to me unfortunately. I hope that it might be possible to change this limitation of the native connector. Regards Heinrich This may not be much of a work a round. I have a database using MySQL 5.5 server that I leave open for long periods of time. So when I come back the database, I get the message: MySQL has gone away. Since the database is the only thing that I am using LibreOffice for at the time, I close the database rather than LibreOffice. This opens the Start window which contains a list of previously used files. I double click the name of the database, and I am reconnected. It even remembers the user name and password, so the database is opened and ready to use. Have you filed a bug report about this? Dan -- 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] Re: MySQL native connector for LibreOffice 4.2 and 4.3 (Linux versions)
Dan Lewis schrieb: On 10/03/2014 06:07 AM, Heinrich Stöllinger wrote: Alex Thurgood schrieb: Le 03/10/2014 07:27, Alan B a écrit : Hi Alan, I have a database from the US gov't, npidata freely available, with about 3.5 million rows and around 350 columns. Actually the gov't provides a csv. Imported it into a MySQL db using the MySQL command line. Never been able to read the primary table using the Java connector. With the native MySQL Yeah, the whole Java connector thing within LibreOffice and large record sets is a very bad combination, even with a mysql backend ! I'm not surprised you couldn't read it with an array of data that big, even if each field only contained 1 byte :-) Glad that the native connector at least allows you to load the records :-)) Alex Hi Alex, I do have a long-time connection with ALL 3 kinds of MySQL connectors. Only the native one REALLY works o.k... There is one problem in MY case, however: My DB-Hosting facility specifies a connection time-out value of 1 minute. With the Java connector one can specify reconnect-true (or yes?) when defining the DB under LO. This means that LO at least re-connects after a termination of the connection by the server. This is NOT a good situation, but it is kind of acceptable. The native connector does NOT allow such a specification. This makes it unusable to me unfortunately. I hope that it might be possible to change this limitation of the native connector. Regards Heinrich This may not be much of a work a round. I have a database using MySQL 5.5 server that I leave open for long periods of time. So when I come back the database, I get the message: MySQL has gone away. Since the database is the only thing that I am using LibreOffice for at the time, I close the database rather than LibreOffice. This opens the Start window which contains a list of previously used files. I double click the name of the database, and I am reconnected. It even remembers the user name and password, so the database is opened and ready to use. Have you filed a bug report about this? Dan Hello Dan, I understand what you are telling me! However, a one-minute-timeout value (which I unfortunately cannot change since I don't have sysadmin access to the server) is simply too short. It means that it interrupts normal work far too often. Certainly one cannot go away for a coffee and excpect the server to still be connected!!! No, I haven't yet filed a bug report. Solving this issue (auto-reconnect) is probably more of an enhancement than a bug. However, I think I will follow your suggestion in any case. Regards Heinrich -- 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
[libreoffice-users] Re: MySQL native connector for OS X
Le 22/09/2014 16:53, Dan Lewis a écrit : Hi Dan, Can MySQL be accessed on an Apple computer using a native connector? If so, what is the URL for where it is located? If not, how can it be accessed and the URL for the connector's location? Answer to your first question : yes Answer to your second question : it depends on the version of LO For LO 4.2 64bit : http://sourceforge.net/projects/lomysqlconnectorextension/files/4.2/OSX64/mysql-connector-ooo.oxt/download For 4.3 64bit, there is no connector available, to my knowledege, as I was unable to compile it for a very long time due changes made by the devs in the build system. I now have a connector OXT that works with current 4.4 alpha, that I could make available, but I haven't tested it with 4.3. Additionally, one of the buildbots doing daily builds includes the connector as standard, but I don't know which one. Alex -- 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
[libreoffice-users] Re: MySQL Native Connector for 32 bit LibreOffice on Ubuntu 12.04
Le 22/02/13 11:49, Fernand Vanrie a écrit : Hi Fernand, BUT: we need to find a solution for this problem, for aOO there is also a connector, it works fine with LO 3.6 , for using it in LO 4.0 we need to re-compile the extension using the SDK and not the whole code base who looks a less complex task This approach does not work at the moment, judging from my discussions on the dev list. Something to do with automatically included extra function code that the mysql connector extension code doesn't know how to deal with following changes in OUString code introduced into LO's code tree. 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 Native Connector for 32 bit LibreOffice on Ubuntu 12.04
Le 21/02/2013 04:21, Dan Lewis a écrit : Hi Dan, These were the ones that autogen.sh had to have before it stopped with an error message at line 201: libgnomevfs2-common, libgnomevfs2-bin, libgnomevfs2-0, libgnomevfs2-dev, libgnomevfs2-extra, libgnomevfs2-0-dbg. These unfortunately are a pain in the backside when building LO on Ubuntu based distros, especially if you are not using Gnome as the desktop UI, but they have nothing to do with the connector itself. This gnomevfs lark is a problem with the build-deps not pulling in the required libraries, for whatever reason, I haven't managed to fathom that out. Prior to downloading the master build, I installed two files that Alex Thurgood suggested: libmysqlclient18 and libmysqlcppconn5 using synaptic. I also noticed these files were available: libmysqlclient-dev and libmysqlcppconn-dev. So I installed these also. I had run autogen.sh a couple of times with an error stopping it at line 201. The error led me to the first group of files which I also installed using synaptic. Then I ran (at Alex' suggestion): autogen.sh --with-ext-mysql-connector --with-system-mysql. (It should have also had an option containing the path to the external mysql connector.) So, it ignored the first option I gave it. You shouldn't neeed to point to the mysql dev libraries if you have the client and source installed on your system. I only use the --with-libmysql-path option when building on Mac OSX, as the headers for MySQL are not included in a default OSX installation. 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 Native Connector for 32 bit LibreOffice on Ubuntu 12.04
Le 21/02/2013 04:21, Dan Lewis a écrit : So the reason for this email including the QA people is that I would like a simple test done by someone with a 32 bit Debian system and MySQL server. Please install the AOO MySQL native connector. Also install these two files: libmysqlclient18 and libmysqlcppconn5. With these installed, can you connect to MySQL? If so, part of our problem is solved. This is what I suggested to Heinrich when I pointed him to my 32bit connector download on Dropbox. 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 Native Connector for 32 bit LibreOffice on Ubuntu 12.04
On 02/20/2013 10:21 PM, Dan Lewis wrote: I have a 32 bit laptop running Ubuntu 12.04. On it I have installed LO 3.6.5.2 and 4.0.0.3. This evening I was going to built LO 4.0.0 with the native connector for MySQL. In the process I had to download some files needed for autogen.sh to work properly. Among these are two groups. These were the ones that autogen.sh had to have before it stopped with an error message at line 201: libgnomevfs2-common, libgnomevfs2-bin, libgnomevfs2-0, libgnomevfs2-dev, libgnomevfs2-extra, libgnomevfs2-0-dbg. Prior to downloading the master build, I installed two files that Alex Thurgood suggested: libmysqlclient18 and libmysqlcppconn5 using synaptic. I also noticed these files were available: libmysqlclient-dev and libmysqlcppconn-dev. So I installed these also. I had run autogen.sh a couple of times with an error stopping it at line 201. The error led me to the first group of files which I also installed using synaptic. Then I ran (at Alex' suggestion): autogen.sh --with-ext-mysql-connector --with-system-mysql. (It should have also had an option containing the path to the external mysql connector.) So, it ignored the first option I gave it. Since then, I have installed the MySQL Native Connector that I had downloaded from AOO a couple of months ago. I did this to both LO 3.6.5.2 and 4.0.0.3. I have a Base file which I use to connect to my MySQL server using the native connector. Now I can access MySQL using this file with both 3.6.5.2 and 4.0.0.3. So the reason for this email including the QA people is that I would like a simple test done by someone with a 32 bit Debian system and MySQL server. Please install the AOO MySQL native connector. Also install these two files: libmysqlclient18 and libmysqlcppconn5. With these installed, can you connect to MySQL? If so, part of our problem is solved. Tomorrow, I am going to run autogen.sh with the three needed options. Hopefully, I will build a native connector for LibreOffice. --Dan Thursday night: Having installed the MySQL Native Connector in LO 4.0.0.3 and noticed it worked now, I ran autogen.sh --with-ext-mysql-connector --with-system-mysql. This time it ran without an error message, and this time it did not ignore the first option. So, I ran make. Friday morning: Make has completed during the night with this comment in the terminal: = (1/1) Building module instsetoo_native = Entering /home/dan/Downloads/LO-Build/libo/instsetoo_native/inc_openoffice/unix Entering /home/dan/Downloads/LO-Build/libo/instsetoo_native/inc_openoffice/windows/msi_languages Entering /home/dan/Downloads/LO-Build/libo/instsetoo_native/util dmake: makefile.mk: line 231: Warning: -- Prior to dmake 4.5 only one %-target per target-definition worked reliably. Check your makefiles. dmake: makefile.mk: line 280: Warning: -- Prior to dmake 4.5 only one %-target per target-definition worked reliably. Check your makefiles. cp -f /home/dan/Downloads/LO-Build/libo/solver/unxlngi6.pro/lib/pyuno/uno.py ../unxlngi6.pro/bin/uno.py cp -f /home/dan/Downloads/LO-Build/libo/solver/unxlngi6.pro/lib/pyuno/unohelper.py ../unxlngi6.pro/bin/unohelper.py cp -f /home/dan/Downloads/LO-Build/libo/solver/unxlngi6.pro/lib/pyuno/pythonloader.py ../unxlngi6.pro/bin/pythonloader.py No EPM: do no packaging at this stage Multiprocessing build is finished Maximal number of processes run: 2 What I am going to do is run make again. This time I will use the following so I have a log of the process: | make 21 | tee build.log --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] Re: MySQL Native Connector for 32 bit LibreOffice on Ubuntu 12.04
Le 21/02/2013 13:41, Dan Lewis a écrit : Hi Dan, What I am going to do is run make again. This time I will use the following so I have a log of the process: | make 21 | tee build.log You have a successful LO build, congratulations. You can now setup the build as a developer install with : make dev-install Upon successful completion, you will get a line that says something about being able to set up the working environment to run the dev version, using /.../.../ooenv. The ooenv script file is created non-executable so you have to chmod +x it. Then you can launch ooenv script, it doesn't do anything visible, just sets up your environment to point to the LO-dev install tree (and probably some other magic I haven't understood yet, like a separate configuration folder). Then you can start LO-dev with the equivalent soffice script from the same folder as ooenv. 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 Native Connector for 32 bit LibreOffice on Ubuntu 12.04
On 02/21/2013 01:10 PM, Alex Thurgood wrote: Le 21/02/2013 13:41, Dan Lewis a écrit : Hi Dan, What I am going to do is run make again. This time I will use the following so I have a log of the process: | make 21 | tee build.log You have a successful LO build, congratulations. You can now setup the build as a developer install with : make dev-install Upon successful completion, you will get a line that says something about being able to set up the working environment to run the dev version, using /.../.../ooenv. The ooenv script file is created non-executable so you have to chmod +x it. Then you can launch ooenv script, it doesn't do anything visible, just sets up your environment to point to the LO-dev install tree (and probably some other magic I haven't understood yet, like a separate configuration folder). Then you can start LO-dev with the equivalent soffice script from the same folder as ooenv. Alex I ran into a problem: it would not install the build. Here are the error messages that I found at the end of the make dev-install: ERROR: ERROR: Missing files at /home/dan/Downloads/LO-Build/libo/solenv/bin/modules/installer/scriptitems.pm line 1280 The other area with two errors at the end of a long line of SUCCESS ... beginning with the last two SUCCESS lines: SUCCESS: Source for services.rdb: /home/dan/Downloads/LO-Build/libo/solver/unxlngi6.pro/xml/services.rdb : SUCCESS: Source for libsvgiolo.so: /home/dan/Downloads/LO-Build/libo/solver/unxlngi6.pro/lib/libsvgiolo.so : : ERROR: Removing file pythonscript.py from file list. : ERROR: Removing file scriptproviderforpython.rdb from file list. : : : Removing directory /tmp/ooopackaging/i_21631361472263 : : Thu Feb 21 13:44:23 2013 (00:00 min.) : ## : Command line arguments: : ## So, what do I do now? --Dan PS: I was able to run the queries for Bug # 61166 by clicking the SQL icon (Run SQL command directly) when using LO 4.0.0.3. -- 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-Native Connector for 4.0
Le 15/01/13 09:44, Heinrich Stoellinger a écrit : Hi Heinrich, Hello, Has somebody compiled/tested the native connector under 4.0? For me it does work using it with 4.0.0.1, build ID:527, running under Debian-Wheezy. It does NOT work under Linux-Mint-Maya or Windows/Vista Yes, it still works for me (self-compiled from the master git repo) on : - Linux Mint Maya 32bit (based on Precise Pangolin) - Bodhi Linux 2.2.0 64bit - Linux Pear 5 32bit (based on Precise Pangolin) - Mac OSX 10.8.2 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-Native Connector for 4.0
Le 15/01/13 14:59, Tom Davies a écrit : Hi :) Is it worth learning how to compile from source in order to get one tailored to your system? IMHO, yes, it is an interesting, if sometimes rather frustrating, experience for a non-developer/casual software builder. On the other hand i gather it ties-up a desktop machine for quite a while so if you don't have access to several machines then it might be a pain. Building does indeed take a while, on my 4gig RAM Linux box, about 10 - 12 hours, sometimes more if there are lots of changes in the git repo. I keep being told that compiling is really not difficult but it still scares me. Nothing to be scared about. It won't trash your machine (but might make the GUI unusable if you don't have much RAM). Patience is definitely a virtue when it comes to building LO. It is just that when the build fails, there's not always an obvious explanation for why, especially if it built fine previously for several days, or even months. 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-Native Connector for 4.0
Hi :) Hmm, one of my colleagues has just left for the day leaving an Xp machine that i could try to use for this. Unfortunately both my bosses are still here and might be a bit 'funny' about me spending time on it. Is it fairly quickeasy to set it up to compile? Is Xp the right OS? I could reboot it into Ubuntu 12.04 (might be 10.04 i can never remember which is on which machine at the moment). Heinrich was looking for an Xp build or Win7? Note that even if i do start this it's a first time for me so i'm not expecting success. Regards from Tom :) From: Alexander Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, 15 January 2013, 14:50 Subject: [libreoffice-users] Re: MySQL-Native Connector for 4.0 Le 15/01/13 14:59, Tom Davies a écrit : Hi :) Is it worth learning how to compile from source in order to get one tailored to your system? IMHO, yes, it is an interesting, if sometimes rather frustrating, experience for a non-developer/casual software builder. On the other hand i gather it ties-up a desktop machine for quite a while so if you don't have access to several machines then it might be a pain. Building does indeed take a while, on my 4gig RAM Linux box, about 10 - 12 hours, sometimes more if there are lots of changes in the git repo. I keep being told that compiling is really not difficult but it still scares me. Nothing to be scared about. It won't trash your machine (but might make the GUI unusable if you don't have much RAM). Patience is definitely a virtue when it comes to building LO. It is just that when the build fails, there's not always an obvious explanation for why, especially if it built fine previously for several days, or even months. 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-Native Connector for 4.0
Hi Tom, I would not advise attempting to build it on XP or anything Windows unless you really know what you are doing. Building on Linux is far easier on the whole, as everything is more or less either pre-installed, or easy to add in the right place via the package management system. Virtually anything based on Ubuntu 12.04 works, not sure about 10.04 though, as that is getting on a bit now and some of the library versions will probably be too old. 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-Native Connector for 4.0
Alexander , Connector works fine for LOdev4.0 and windows XP Hi Tom, I would not advise attempting to build it on XP or anything Windows unless you really know what you are doing. Building on Linux is far easier on the whole, as everything is more or less either pre-installed, or easy to add in the right place via the package management system. Virtually anything based on Ubuntu 12.04 works, not sure about 10.04 though, as that is getting on a bit now and some of the library versions will probably be too old. 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-Native Connector for 4.0
Le 15/01/13 16:39, Fernand Vanrie a écrit : Hi Fernand, Connector works fine for LOdev4.0 and windows XP Thanks for the info. Do you build it yourself, or did you get it from the AOO project ? 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-Native Connector for 4.0
On 15/01/2013 17:36, Alexander Thurgood wrote: Le 15/01/13 16:39, Fernand Vanrie a écrit : Hi Fernand, Connector works fine for LOdev4.0 and windows XP Thanks for the info. Do you build it yourself, or did you get it from the AOO project ? i still use a extension MySQL Connector 1.0.1 made by oracle :-) 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-Native Connector for 4.0
Le 15/01/13 18:12, Fernand Vanrie a écrit : i still use a extension MySQL Connector 1.0.1 made by oracle :-) Well it is good to know that it is still working :-)) 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 native connector - several databases retrieved?
Le 19/01/2012 15:05, fmayo a écrit : Hi again, Good point. I confirm that having user access privilege restricted to one single database only this one is displayed in the tables area. This seems to be a good workaround. Format: V Database name Table 1 Table 2 If you want to be able to see all of the dbs again irrespective of the driver privileges, you could, instead of resetting them at mysql server level, try activating/deactiving the Ignore Driver Privileges option in the Connection Advanced details of your ODB file (although I haven't tried this to see if it actually 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 native connector - several databases retrieved?
Le 20/01/2012 09:30, Alexander Thurgood [via Document Foundation Mail Archive] a écrit : If you want to be able to see all of the dbs again irrespective of the driver privileges, you could, instead of resetting them at mysql server level, try activating/deactiving the Ignore Driver Privileges option in the Connection Advanced details of your ODB file (although I haven't tried this to see if it actually works). Alex Thanks for the hint, Alex. I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each action on this option). Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access rights restricted to the targeted db. BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ? Thanks again for your support in Base area. -- Francois M Dual boot: Ubuntu 11.10 amd64 - W7 LibreOffice 3.4.4 - Francois Dualboot Ubuntu 11.10 amd64 - W7 LibreOffice 3.4.4 OOO340m1 (Build:402) -- View this message in context: http://nabble.documentfoundation.org/MySQL-native-connector-several-databases-retrieved-tp3663736p3675458.html Sent from the Users mailing list archive at Nabble.com. -- 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 native connector - several databases retrieved?
Hi :) Perhaps this link? I haven't read any of these tho :( http://wiki.services.openoffice.org/wiki/Connect_MySQL_and_Base I'm not sure if the 'need' for java is still there. http://user.services.openoffice.org/en/forum/viewforum.php?f=13sid=6943ad59fc048d9c54a76bd69f7229cc http://user.services.openoffice.org/en/forum/viewtopic.php?f=40t=41292 http://www.webhosting.uk.com/forums/mysql-hosting/5591-connecting-mysql-openoffice-base-using-jdbc.html Regards from Tom :) --- On Fri, 20/1/12, fmayo francoismalias-fo...@yahoo.fr wrote: From: fmayo francoismalias-fo...@yahoo.fr Subject: [libreoffice-users] Re: MySQL native connector - several databases retrieved? To: users@global.libreoffice.org Date: Friday, 20 January, 2012, 13:35 Le 20/01/2012 09:30, Alexander Thurgood [via Document Foundation Mail Archive] a écrit : If you want to be able to see all of the dbs again irrespective of the driver privileges, you could, instead of resetting them at mysql server level, try activating/deactiving the Ignore Driver Privileges option in the Connection Advanced details of your ODB file (although I haven't tried this to see if it actually works). Alex Thanks for the hint, Alex. I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each action on this option). Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access rights restricted to the targeted db. BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ? Thanks again for your support in Base area. -- Francois M Dual boot: Ubuntu 11.10 amd64 - W7 LibreOffice 3.4.4 - Francois Dualboot Ubuntu 11.10 amd64 - W7 LibreOffice 3.4.4 OOO340m1 (Build:402) -- View this message in context: http://nabble.documentfoundation.org/MySQL-native-connector-several-databases-retrieved-tp3663736p3675458.html Sent from the Users mailing list archive at Nabble.com. -- 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 native connector - several databases retrieved?
On Fri, 2012-01-20 at 05:35 -0800, fmayo wrote: Le 20/01/2012 09:30, Alexander Thurgood [via Document Foundation Mail Archive] a écrit : If you want to be able to see all of the dbs again irrespective of the driver privileges, you could, instead of resetting them at mysql server level, try activating/deactiving the Ignore Driver Privileges option in the Connection Advanced details of your ODB file (although I haven't tried this to see if it actually works). Alex Thanks for the hint, Alex. I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each action on this option). Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access rights restricted to the targeted db. BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ? Thanks again for your support in Base area. Hello Francois, I believe that for the time being the absolute best location for information is the one you have already found. There is a Base user guide nearing completion, but it will not be specific to MySQL connections. There are some historical web sites that can be mined, but many of the people that donated the most usable information there are now here. Best wishes, //drew -- 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 native connector - several databases retrieved?
Le 20/01/12 14:35, fmayo a écrit : Hi François, Thanks for the hint, Alex. I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each action on this option). Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access rights restricted to the targeted db. BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ? Thanks again for your support in Base area. Ah ok, wasn't sure anyway whether that option actually did anything, or maybe I just misunderstood what it was supposed to do ;-) If you speak/understand French, which I suspect you might from your name, there are a few out there : http://www.google.fr/url?sa=trct=jq=openoffice.org%20base%20et%20mysqlsource=webcd=2ved=0CCkQFjABurl=http%3A%2F%2Fwww.openoffice.org%2Ffr%2FDocumentation%2FHow-to%2FBdd%2F05jdbc_mysqlfr-v2.pdfei=GIQZT9W5JILrOfGYiZcLusg=AFQjCNHYrxzDz3noMW0VRrUbEFpbHgDITAcad=rja http://www.solix.info/spip/spip.php?article59 http://www.openoffice.org/fr/Documentation/How-to/indexht-base.html http://forge.mysql.com/wiki/Connector_OpenOffice http://valaurea.free.fr/documents/sig11_ooomysql_1.html This link below points to the French OOo Base forum, but they will also field questions about LibreOffice : http://user.services.openoffice.org/fr/forum/viewforum.php?f=9sid=c96475dd0faebf7e8ff1926dcfcabae4 The corresponding English OOo Base forums : http://www.oooforum.org/forum/viewforum.phtml?f=10 http://user.services.openoffice.org/en/forum/viewforum.php?f=13sid=4d3f693555f7ca2c615460430117d722 There is also more general stuff on the net about Base in English, not least the User Guides produced by ODFAuthors and the LibreOffice Documentation project : http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft http://wiki.documentfoundation.org/images/6/68/0108GS3-GettingStartedWithBase.odt So,yeah, you have to trawl around a bit, but there is stuff out there. 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 native connector - several databases retrieved?
Le 20/01/12 14:35, fmayo a écrit : Hi Frnaçois, BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ? Thanks again for your support in Base area. One more thing comes to mind : to get the best out of your connection to a mysql server, you will find yourself writing and executing queries in DirectSQL mode rather than with the graphical query designer as it is, errm, how should I put it, a bit stuck in time (by that I mean, leagues away in the past from where Access is today, or Lotus Approach, FMPro, etc) when it comes to accessing the underlying server engine query functionality. The same goes for casual user friendly Form design ;-) just so you're forewarned :-)) 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 native connector - several databases retrieved?
Hi :) Ahh yes i forgot there are some LibreOffice chapters but mostly only in draft http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Probably not much different from the OOo guide as i suspect the same person/people is/are doing both. Regards from Tom :) --- On Fri, 20/1/12, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL native connector - several databases retrieved? To: users@global.libreoffice.org Date: Friday, 20 January, 2012, 15:31 Le 20/01/12 14:35, fmayo a écrit : Hi François, Thanks for the hint, Alex. I gave it a try, but this action did not produce any visible effect on displayed dbs' (even with closing Base between each action on this option). Then, the ongoing solution for me is to have two distinct user profiles: one accessing to all db and an other one with access rights restricted to the targeted db. BTW, do you know of some guide, tuto,site or forum related to combined use of MySQL + Base ? Thanks again for your support in Base area. Ah ok, wasn't sure anyway whether that option actually did anything, or maybe I just misunderstood what it was supposed to do ;-) If you speak/understand French, which I suspect you might from your name, there are a few out there : http://www.google.fr/url?sa=trct=jq=openoffice.org%20base%20et%20mysqlsource=webcd=2ved=0CCkQFjABurl=http%3A%2F%2Fwww.openoffice.org%2Ffr%2FDocumentation%2FHow-to%2FBdd%2F05jdbc_mysqlfr-v2.pdfei=GIQZT9W5JILrOfGYiZcLusg=AFQjCNHYrxzDz3noMW0VRrUbEFpbHgDITAcad=rja http://www.solix.info/spip/spip.php?article59 http://www.openoffice.org/fr/Documentation/How-to/indexht-base.html http://forge.mysql.com/wiki/Connector_OpenOffice http://valaurea.free.fr/documents/sig11_ooomysql_1.html This link below points to the French OOo Base forum, but they will also field questions about LibreOffice : http://user.services.openoffice.org/fr/forum/viewforum.php?f=9sid=c96475dd0faebf7e8ff1926dcfcabae4 The corresponding English OOo Base forums : http://www.oooforum.org/forum/viewforum.phtml?f=10 http://user.services.openoffice.org/en/forum/viewforum.php?f=13sid=4d3f693555f7ca2c615460430117d722 There is also more general stuff on the net about Base in English, not least the User Guides produced by ODFAuthors and the LibreOffice Documentation project : http://www.odfauthors.org/openoffice.org/english/userguide3/db3/dbg3_draft http://wiki.documentfoundation.org/images/6/68/0108GS3-GettingStartedWithBase.odt So,yeah, you have to trawl around a bit, but there is stuff out there. 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 native connector - several databases retrieved?
Le 17/01/12 17:01, fmayo a écrit : Hi, Thanks for the advice, Fernand. Good to know that it works fine with MySQL. I tested it that way, even closing both the server and the Ubuntu session: no change. So, as a general info to the community, when connecting Base to MariaDB thru MySQL native connector (1.0.1), it seems that all db's within the targeted environment are reported in Base 'Tables' zone. If you restrict your users' rights through the Tables/Columns privilege in mysql, are these tables still visible when you re-start LO and re-open the ODB ? 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 Native Connector
Hi Tom, Today I tried to download and then activate the MySQL Native Connector you put on LO-Extensions. However, I still get the error message loading component library failed. file:///home.../.../..32bit.oxt/mysqlc.uno.so. Any idea what could be the reason? The only thing I can think of is that I use LO 3.4.2 (in addition to using a bleeding-edge Debian-Wheezy!). Thanks for any ideas. Regards Heinrich On Wed, 21 Sep 2011 06:00:28 +0200, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Thanks :) So Building neatly avoids the packagiong issues of .rpm versus .deb? We just need 1 for 32bit GnuLinux and 1 for 64bit, not 1 for each of the main families (Arch? Slackware, Debian, RedHat, errr)? So, Heinrich's build might be good to upload to your page? Doing a build sounds quite technical to me. I need to look at the guide as i have never done it before (well twice doing copypaste from guides and not having a clue what i was doing). Anyway, thanks for the link to the guide :) Heinrich, has it helped? Regards from Tom :) --- On Tue, 20/9/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Tuesday, 20 September, 2011, 16:25 Le 20/09/11 12:25, Tom Davies a écrit : Hi Tom, After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensionstemplates site? This is precisely what I have done for Mac OSX. How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine? I really don't know, but I'm hasarding a guess that they are fairly generic - however, each distrib currently packages its own version of the connector extension to accompany any given release of their own version of LibO. What is certain is that if you want a 32bit connector, you have to build with the 32bit mysql connector C library, and if you want 64bit, well...the corresponding bit library for that. If you look at the OOo extension site, the MySQL native connector extension was provided in the following flavours : http://extensions.services.openoffice.org/en/project/mysql_connector Linux (32bit) Linux x86_64 Mac OS X (32bit only) Solaris Sparc Solaris x86 Windows (I assume only 32bit, but who knows ?) So, one would need to build for these arch/OSes and also Win64. 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
[libreoffice-users] Re: MySQL Native Connector
Le 26/09/11 16:07, Heinrich Stoellinger a écrit : Hi Heinrich, Today I tried to download and then activate the MySQL Native Connector you put on LO-Extensions. However, I still get the error message loading component library failed. file:///home.../.../..32bit.oxt/mysqlc.uno.so. Any idea what could be the reason? The only thing I can think of is that I use LO 3.4.2 (in addition to using a bleeding-edge Debian-Wheezy!). No, I think it is either a build issue with a library version problem, or possibly a naming issue, I'm looking into it at the moment and will update the list if I find a solution. 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 Native Connector
Le 18/09/11 20:09, Heinrich Stoellinger a écrit : Hi Heinrich, Do you have pyuno (python-uno component loader) installed by any chance? 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 Native Connector
Hi :) Thanks for the flowers but it's Alex that has been doing all the work on this. It's an interesting topic and it would be great to have the connector available for download or perhaps even better might be to have simple instructions available so that non-programmers (like me) can build it easily on their own system. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/MySQL-Native-Connector-tp3344766p3370220.html Sent from the Users mailing list archive at Nabble.com. -- 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 Native Connector
Le 21/09/11 12:11, Tom Davies a écrit : Hi Tom, So, it's a race between you and Heinrich then :) I like the idea of different people contributing builds as the need arises. More a community effort and it spreads the knowledge a bit. Regards from Tom :) I have now built a 32bit version of the connector extension for Linux, I shall be putting it on the extensions site today. It was built on my XBuntu Natty box. I can safely say that compared to building on Mac, building on Linux was a doddle. 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 Native Connector
Thanks, Alex, you have certainly beaten me to it. I will try to download/install the connector on my Debian system this evening and then report on my findings. Regards Heinrich P.S.: I am actually president (=worker) of a wind band. This weekend we will be giving 5 concerts - organising these feats keeps me FAR MORE than busy. The reason I am actually bothering with all that software is that I have been wanting to write a software package (based on PHP) for the administration of such a band. I should maybe also state that I used to work for Mother Blue for a long time as a systems engineer. AD in most of its ramifications was my subject then. Can't let got of it (even though I definitely prefer to play music!) :) On Thu, 22 Sep 2011 10:22:07 +0200, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 21/09/11 12:11, Tom Davies a écrit : Hi Tom, So, it's a race between you and Heinrich then :) I like the idea of different people contributing builds as the need arises. More a community effort and it spreads the knowledge a bit. Regards from Tom :) I have now built a 32bit version of the connector extension for Linux, I shall be putting it on the extensions site today. It was built on my XBuntu Natty box. I can safely say that compared to building on Mac, building on Linux was a doddle. 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
[libreoffice-users] Re: MySQL Native Connector
On 09/22/2011 01:22 AM, Alexander Thurgood wrote: Le 21/09/11 12:11, Tom Davies a écrit : Hi Tom, So, it's a race between you and Heinrich then :) I like the idea of different people contributing builds as the need arises. More a community effort and it spreads the knowledge a bit. Regards from Tom :) I have now built a 32bit version of the connector extension for Linux, I shall be putting it on the extensions site today. It was built on my XBuntu Natty box. I can safely say that compared to building on Mac, building on Linux was a doddle. Alex Unfortunately... loading component library failed: file://home/username/.libreoffice/3/user/uno_packages/cache/uno_packages/Ap2E1u_/msql-native-connector-1.0.1-linux-32bit.oxt/mysqlc.uno.so 32bit Ubuntu Maverick (10.10). LO 3.4.3. Same results with LO 3.3.4. Note that my profile path for LO 3.4.3 is: ~/.libreoffice.3.4/3 However the connector is attmepting to install into: ~/.libreoffice/3/user/uno_packages rather than using the modified data in bootstraprc. Just to ensure that my path settings for LO 3.4.3 (I do this on purpose so that I can run multiple instances of LO) wasn't the issue, I then attempted to install on 3.3.4, where my profile path is the standard: ~/.libreoffice/3/user Same results. So it's not a profile path issue. Added note: the OOo mysql native connector is 4.1MB and yours is 375.6KB. That's quite a difference: $ ls -l mysql* . 4285738 2011-09-20 09:19 mysql-connector-ooo-1.0.1-linux-intel.oxt . 384635 2011-09-22 10:02 mysql-native-connector-1.0.1-linux-32bit.oxt Interestingly, the Ubuntu OOo version (OOo 3.2.1 - go-oo build) is 207.5KB: $ ls -l /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt . 212436 2011-01-28 23:56 /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt -- 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 Native Connector
Le 22/09/11 19:21, NoOp a écrit : Hi NoOp,, Unfortunately... loading component library failed: file://home/username/.libreoffice/3/user/uno_packages/cache/uno_packages/Ap2E1u_/msql-native-connector-1.0.1-linux-32bit.oxt/mysqlc.uno.so 32bit Ubuntu Maverick (10.10). LO 3.4.3. Same results with LO 3.3.4. Well thanks for testing anyway. Note that my profile path for LO 3.4.3 is: ~/.libreoffice.3.4/3 However the connector is attmepting to install into: ~/.libreoffice/3/user/uno_packages rather than using the modified data in bootstraprc. Just to ensure that my path settings for LO 3.4.3 (I do this on purpose so that I can run multiple instances of LO) wasn't the issue, I then attempted to install on 3.3.4, where my profile path is the standard: ~/.libreoffice/3/user Same results. So it's not a profile path issue. Hmmm, interesting. Added note: the OOo mysql native connector is 4.1MB and yours is 375.6KB. That's quite a difference: $ ls -l mysql* . 4285738 2011-09-20 09:19 mysql-connector-ooo-1.0.1-linux-intel.oxt . 384635 2011-09-22 10:02 mysql-native-connector-1.0.1-linux-32bit.oxt Yes, the Mac one I built is over 1Mb too, I noticed how small the Linux one was when I copied it over. I didn't seem to get any errors though when building. Interestingly, the Ubuntu OOo version (OOo 3.2.1 - go-oo build) is 207.5KB: $ ls -l /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt . 212436 2011-01-28 23:56 /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt So the answer may well lie in the specificity of the build environment because this connector appears to work on the machine I built it on in the master build, i.e. the future 3.5 code. Perhaps, it is necessary to build with the 3.4 build source in order to adapt it to that particular set of code ?? Or then again, perhaps your Maverick and my Natty have other differences that mean that it doesn't work. I really don't know enough about it to say, unfortunately and I won't be able to setup a new build with 3.4 source soon, at least probably not until next week. 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 Native Connector
On 09/22/2011 10:46 AM, Alexander Thurgood wrote: Le 22/09/11 19:21, NoOp a écrit : ... Interestingly, the Ubuntu OOo version (OOo 3.2.1 - go-oo build) is 207.5KB: $ ls -l /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt . 212436 2011-01-28 23:56 /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt So the answer may well lie in the specificity of the build environment because this connector appears to work on the machine I built it on in the master build, i.e. the future 3.5 code. Perhaps, it is necessary to build with the 3.4 build source in order to adapt it to that particular set of code ?? Or then again, perhaps your Maverick and my Natty have other differences that mean that it doesn't work. I really don't know enough about it to say, unfortunately and I won't be able to setup a new build with 3.4 source soon, at least probably not until next week. Alex Just took a look at the libreoffice-mysql-connector that comes from the Natty 11.04 repo it's install size is 496KB, but it also depends (and installs) libmysqlcppcon4 which is 782KB. $ apt-cache depends libreoffice-mysql-connector libreoffice-mysql-connector Depends: libc6 Depends: libgcc1 Depends: libmysqlclient16 Depends: libmysqlcppconn4 Depends: libstdc++6 Depends: libstlport4.6ldbl Depends: ure Depends: libreoffice-core Suggests: mysql-server Conflicts: ure I also have Oneiric (11.10) installed in a VM. 11.10 has Ubuntu's LO 3.4.3. In 11.10: libreoffice-mysql-connector = 492KB libmysqlcppcon4 = 676KB I'll poke around later today to see what the differences might be. Gary -- 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 Native Connector
Le 21/09/11 06:00, Tom Davies a écrit : Hi Tom, Hi :) Thanks :) So Building neatly avoids the packagiong issues of .rpm versus .deb? We just need 1 for 32bit GnuLinux and 1 for 64bit, not 1 for each of the main families (Arch? Slackware, Debian, RedHat, errr)? So, Heinrich's build might be good to upload to your page? Yes, the build produces an OXT file, that is all one needs. You have to hunt around for it a bit, what with the convoluted build and deliver process that the build goes through, but it can be found when all is said and done. One thing I do not know yet is whether or not the absolute path to the library has to be give at configure time (using autogen.sh). Certainly this was the case for Mac, but I am assuming/hoping that this is not required for Linux (however, I could be wrong). Be aware that building the connector requires extra switches to be activated at configure time when you use ./autogen/sh. These switches are the following : --enable-ext-mysql-connector --with-libmysql-path=/Users/alex/DevHack/mysql-connector-c-6.0.2osx10.5-x86-32bit Like I said, the second switch may well be optional on Linux, but I had to specify it when building the connector on Mac. I am currently trying to just build a working LibreOffice installation set on a *buntu box I happen to have laying around, so I will rebuild with the corresponding connector switch option once/if that completes. If I then manage to get something out of it, I'll put it up on the Extensions site next to the Mac connector. 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 Native Connector
Hi :) So, it's a race between you and Heinrich then :) I like the idea of different people contributing builds as the need arises. More a community effort and it spreads the knowledge a bit. Regards from Tom :) --- On Wed, 21/9/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Wednesday, 21 September, 2011, 10:18 Le 21/09/11 06:00, Tom Davies a écrit : Hi Tom, Hi :) Thanks :) So Building neatly avoids the packagiong issues of .rpm versus .deb? We just need 1 for 32bit GnuLinux and 1 for 64bit, not 1 for each of the main families (Arch? Slackware, Debian, RedHat, errr)? So, Heinrich's build might be good to upload to your page? Yes, the build produces an OXT file, that is all one needs. You have to hunt around for it a bit, what with the convoluted build and deliver process that the build goes through, but it can be found when all is said and done. One thing I do not know yet is whether or not the absolute path to the library has to be give at configure time (using autogen.sh). Certainly this was the case for Mac, but I am assuming/hoping that this is not required for Linux (however, I could be wrong). Be aware that building the connector requires extra switches to be activated at configure time when you use ./autogen/sh. These switches are the following : --enable-ext-mysql-connector --with-libmysql-path=/Users/alex/DevHack/mysql-connector-c-6.0.2osx10.5-x86-32bit Like I said, the second switch may well be optional on Linux, but I had to specify it when building the connector on Mac. I am currently trying to just build a working LibreOffice installation set on a *buntu box I happen to have laying around, so I will rebuild with the corresponding connector switch option once/if that completes. If I then manage to get something out of it, I'll put it up on the Extensions site next to the Mac connector. 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
Re: [libreoffice-users] Re: MySQL Native Connector
Hello Alex, Thanks for the advice! To start with, I am VERY busy (outside IT!) for the coming week, so I simply won't have the time to do anything in this respect at the moment. The funny thing is that on my W/Vista-LO 3.3.4 System that connects to a MySQL database server running on my GNU-Linux-Debian-Wheezy system - the native connector works like a dream. Therefore I do most serious work with the database on the Windows system at present. Being a Linux fan I think that this is somewhat shameful... ;) Regards Heinrich On Wed, 21 Sep 2011 11:08:25 +0200, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 20/09/11 18:25, NoOp a écrit : Hi NoOp, ... According to: http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0 the source is here: http://dev.mysql.com/doc/refman/5.1/en/connector-cpp.html [MySQL Connector/C++ Download] http://dev.mysql.com/downloads/connector/cpp/ If you are building LibO on Linux, just follow the build instructions on the LibreOffice Native build page that I indicated. The build environment that it is advised to install prior to downloading the source code for LibO will download and install the mysql C and CPP connector libraries. If you are on Windows, the build environment is currently much harder to setup and get running from what I understand. 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: MySQL Native Connector
Hi Snip, I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a 32-bit system might be the reason. Seeing as I don't really have the time to do more research I suppose I will just have to live with ODBC (or even JDBC :() till somebody comes up with a solution. Regards Heinrich On Mon, 19 Sep 2011 23:05:22 +0200, planas jsloz...@gmail.com wrote: Hi Heinrich On Mon, 2011-09-19 at 17:59 +0200, Heinrich Stoellinger wrote: Hi Drew, As I mentioned before -- the problem is that activating the native MySQL connector after making the correct selection for the odb-file doesn't work, at least not on my Debian Wheezy system. I keep getting the error message ... no SDBC driver found for the URL. Maybe the connector has to be re-built for LO 3.4? I have no idea :( Regards Heinrich I am able to connect with the native MySQL connector using 3.4.3 using Ubuntu. I am using mysql-connector-ooo-1.0.1-linux-x86_64.oxt ( I have a 64 bit system). I download the connector from the OOo extension site. Snip On Mon, 19 Sep 2011 17:36:24 +0200, drew d...@baseanswers.com wrote: On Sun, 2011-09-18 at 16:54 +0200, Andreas Säger wrote: Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Howdy Andreas, If you do not have the native connector extension installed then only the odbc and jdbc options are available. With the extension added into the user configuration then a third option is available - 'Connect directly'. //drew -- 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/ -- 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 Native Connector
Le 20/09/11 08:10, Heinrich Stoellinger a écrit : Hi all, Hi Snip, I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a 32-bit system might be the reason. Seeing as I don't really have the time to do more research I suppose I will just have to live with ODBC (or even JDBC :() till somebody comes up with a solution. Regards The solution is to rebuild the connector for all combinations of OS/arch from source. That is how I got my Mac OSX version of the connector running. None of the devs at LO are building the connector, it is an option in the configure switch that must be activated specifically. Possibly, and I say just possibly, the Linux distribs will rebuild it with their next updates to LO, but I have no idea who deals with that on each distrib. Same goes for Windows (32/64). If no one complains about that to the Linux port distrib maintainers, then nothing will get done, that's for sure. Additionally, if no one complains about it on the developer list here, or opens a bug report for it, then nothing will happen either. Even if someone complains about it, you might well get an answer back of the ilk the source is available, build it yourself, which granted, is not particularly useful/helpful when one is a mere consumer of the product. 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 Native Connector
Hi :) After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensionstemplates site? How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine? Regards from Tom :) --- On Tue, 20/9/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Tuesday, 20 September, 2011, 10:42 Le 20/09/11 08:10, Heinrich Stoellinger a écrit : Hi all, Hi Snip, I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a 32-bit system might be the reason. Seeing as I don't really have the time to do more research I suppose I will just have to live with ODBC (or even JDBC :() till somebody comes up with a solution. Regards The solution is to rebuild the connector for all combinations of OS/arch from source. That is how I got my Mac OSX version of the connector running. None of the devs at LO are building the connector, it is an option in the configure switch that must be activated specifically. Possibly, and I say just possibly, the Linux distribs will rebuild it with their next updates to LO, but I have no idea who deals with that on each distrib. Same goes for Windows (32/64). If no one complains about that to the Linux port distrib maintainers, then nothing will get done, that's for sure. Additionally, if no one complains about it on the developer list here, or opens a bug report for it, then nothing will happen either. Even if someone complains about it, you might well get an answer back of the ilk the source is available, build it yourself, which granted, is not particularly useful/helpful when one is a mere consumer of the product. 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
Re: [libreoffice-users] Re: MySQL Native Connector
Hi, Could somebody please give me info about where to get the appropriate source-code and a bit of how-to regarding building the connector for 3.4.3? I will give it a try. Regards Heinrich On Tue, 20 Sep 2011 12:25:40 +0200, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensionstemplates site? How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine? Regards from Tom :) --- On Tue, 20/9/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Tuesday, 20 September, 2011, 10:42 Le 20/09/11 08:10, Heinrich Stoellinger a écrit : Hi all, Hi Snip, I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a 32-bit system might be the reason. Seeing as I don't really have the time to do more research I suppose I will just have to live with ODBC (or even JDBC :() till somebody comes up with a solution. Regards The solution is to rebuild the connector for all combinations of OS/arch from source. That is how I got my Mac OSX version of the connector running. None of the devs at LO are building the connector, it is an option in the configure switch that must be activated specifically. Possibly, and I say just possibly, the Linux distribs will rebuild it with their next updates to LO, but I have no idea who deals with that on each distrib. Same goes for Windows (32/64). If no one complains about that to the Linux port distrib maintainers, then nothing will get done, that's for sure. Additionally, if no one complains about it on the developer list here, or opens a bug report for it, then nothing will happen either. Even if someone complains about it, you might well get an answer back of the ilk the source is available, build it yourself, which granted, is not particularly useful/helpful when one is a mere consumer of the product. 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
[libreoffice-users] Re: MySQL Native Connector
Le 20/09/11 12:25, Tom Davies a écrit : Hi Tom, After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensionstemplates site? This is precisely what I have done for Mac OSX. How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine? I really don't know, but I'm hasarding a guess that they are fairly generic - however, each distrib currently packages its own version of the connector extension to accompany any given release of their own version of LibO. What is certain is that if you want a 32bit connector, you have to build with the 32bit mysql connector C library, and if you want 64bit, well...the corresponding bit library for that. If you look at the OOo extension site, the MySQL native connector extension was provided in the following flavours : http://extensions.services.openoffice.org/en/project/mysql_connector Linux (32bit) Linux x86_64 Mac OS X (32bit only) Solaris Sparc Solaris x86 Windows (I assume only 32bit, but who knows ?) So, one would need to build for these arch/OSes and also Win64. 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 Native Connector
Le 20/09/11 17:20, Heinrich Stoellinger a écrit : Hi Heinrich, Hi, Could somebody please give me info about where to get the appropriate source-code and a bit of how-to regarding building the connector for 3.4.3? I will give it a try. The general build instructions for building LibO are here : http://wiki.documentfoundation.org/Development/Native_Build if you get stuck, ask on the freenode irc libreoffice developer's channel. You have to start with a complete build environment, and most of the suite will probably need to be built anyway before the build can proceed to compile the connector code. 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 Native Connector
On 09/20/2011 08:20 AM, Heinrich Stoellinger wrote: Hi, Could somebody please give me info about where to get the appropriate source-code and a bit of how-to regarding building the connector for 3.4.3? I will give it a try. Regards Heinrich ... According to: http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0 the source is here: http://dev.mysql.com/doc/refman/5.1/en/connector-cpp.html [MySQL Connector/C++ Download] http://dev.mysql.com/downloads/connector/cpp/ -- 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 Native Connector
On Tue, 2011-09-20 at 11:25 +0100, Tom Davies wrote: Hi :) After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensionstemplates site? How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine? Regards from Tom :) In theory, the builds should be very generic. The problem is when a downtsream distro tweaks the package to make it better or more suitable for some reason. It is possible, then, for the build to have new dependencies that are not in the upstream version. For example Ubuntu is derived from Debian but it has some tweaks that do not allow for total compatibility with Debian upstream repositories. --- On Tue, 20/9/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Tuesday, 20 September, 2011, 10:42 Le 20/09/11 08:10, Heinrich Stoellinger a écrit : Hi all, Hi Snip, I suppose the fact that I use Debian-Wheezy (next after Squeeze) on a 32-bit system might be the reason. Seeing as I don't really have the time to do more research I suppose I will just have to live with ODBC (or even JDBC :() till somebody comes up with a solution. Regards Try the OOo extension, it seems to work will with 3.3.x and 3.4.x in Ubuntu without any modifications. I have both versions downloaded for Linux. I can email them to you off list. The solution is to rebuild the connector for all combinations of OS/arch from source. That is how I got my Mac OSX version of the connector running. None of the devs at LO are building the connector, it is an option in the configure switch that must be activated specifically. Possibly, and I say just possibly, the Linux distribs will rebuild it with their next updates to LO, but I have no idea who deals with that on each distrib. Same goes for Windows (32/64). If no one complains about that to the Linux port distrib maintainers, then nothing will get done, that's for sure. Additionally, if no one complains about it on the developer list here, or opens a bug report for it, then nothing will happen either. Even if someone complains about it, you might well get an answer back of the ilk the source is available, build it yourself, which granted, is not particularly useful/helpful when one is a mere consumer of the product. 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 -- Jay Lozier jsloz...@gmail.com -- 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 Native Connector
Hi :) Thanks :) So Building neatly avoids the packagiong issues of .rpm versus .deb? We just need 1 for 32bit GnuLinux and 1 for 64bit, not 1 for each of the main families (Arch? Slackware, Debian, RedHat, errr)? So, Heinrich's build might be good to upload to your page? Doing a build sounds quite technical to me. I need to look at the guide as i have never done it before (well twice doing copypaste from guides and not having a clue what i was doing). Anyway, thanks for the link to the guide :) Heinrich, has it helped? Regards from Tom :) --- On Tue, 20/9/11, Alexander Thurgood alex.thurg...@gmail.com wrote: From: Alexander Thurgood alex.thurg...@gmail.com Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Tuesday, 20 September, 2011, 16:25 Le 20/09/11 12:25, Tom Davies a écrit : Hi Tom, After 1 person has built it for their system can the built package be uploaded somewhere for other people to use? If so could it be uploaded to the new LO Extensionstemplates site? This is precisely what I have done for Mac OSX. How generic are builds? Would it cover the entire family (Ubuntu, Mint, Trisquel etc), just Debian, one particular release of Debian, or just the specific machine? I really don't know, but I'm hasarding a guess that they are fairly generic - however, each distrib currently packages its own version of the connector extension to accompany any given release of their own version of LibO. What is certain is that if you want a 32bit connector, you have to build with the 32bit mysql connector C library, and if you want 64bit, well...the corresponding bit library for that. If you look at the OOo extension site, the MySQL native connector extension was provided in the following flavours : http://extensions.services.openoffice.org/en/project/mysql_connector Linux (32bit) Linux x86_64 Mac OS X (32bit only) Solaris Sparc Solaris x86 Windows (I assume only 32bit, but who knows ?) So, one would need to build for these arch/OSes and also Win64. 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
Re: [libreoffice-users] Re: MySQL Native Connector
On Sun, 2011-09-18 at 16:54 +0200, Andreas Säger wrote: Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Howdy Andreas, If you do not have the native connector extension installed then only the odbc and jdbc options are available. With the extension added into the user configuration then a third option is available - 'Connect directly'. //drew -- 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 Native Connector
Hi Drew, As I mentioned before -- the problem is that activating the native MySQL connector after making the correct selection for the odb-file doesn't work, at least not on my Debian Wheezy system. I keep getting the error message ... no SDBC driver found for the URL. Maybe the connector has to be re-built for LO 3.4? I have no idea :( Regards Heinrich On Mon, 19 Sep 2011 17:36:24 +0200, drew d...@baseanswers.com wrote: On Sun, 2011-09-18 at 16:54 +0200, Andreas Säger wrote: Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Howdy Andreas, If you do not have the native connector extension installed then only the odbc and jdbc options are available. With the extension added into the user configuration then a third option is available - 'Connect directly'. //drew -- 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 Native Connector
Hi Heinrich On Mon, 2011-09-19 at 17:59 +0200, Heinrich Stoellinger wrote: Hi Drew, As I mentioned before -- the problem is that activating the native MySQL connector after making the correct selection for the odb-file doesn't work, at least not on my Debian Wheezy system. I keep getting the error message ... no SDBC driver found for the URL. Maybe the connector has to be re-built for LO 3.4? I have no idea :( Regards Heinrich I am able to connect with the native MySQL connector using 3.4.3 using Ubuntu. I am using mysql-connector-ooo-1.0.1-linux-x86_64.oxt ( I have a 64 bit system). I download the connector from the OOo extension site. Snip On Mon, 19 Sep 2011 17:36:24 +0200, drew d...@baseanswers.com wrote: On Sun, 2011-09-18 at 16:54 +0200, Andreas Säger wrote: Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Howdy Andreas, If you do not have the native connector extension installed then only the odbc and jdbc options are available. With the extension added into the user configuration then a third option is available - 'Connect directly'. //drew -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Jay Lozier jsloz...@gmail.com -- 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 Native Connector
Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Why, well firstly because no one gives a damn, and second, to build the connector you have to rely on the mysql C connector library (even if you use mysql C++ library) and that library is GPL2, which means that the connector that links to it has to be released under the GPL (this is in fact what Sun did with the native connector extension). The LibO project releases under the LGPL/MPL and not the GPL. At the moment, the OOo mysql native connector is available for download from here : http://extensions.services.openoffice.org/en/project/mysql_connector My advice, get it while you can and keep a copy near to hand. How long that will remain the case now that this site is to integrated into the ApacheOOo project remains to be seen, because Apache can not accept GPLed code into its projects. I have built the native connector for MacOSX and put it on the LibreOffice extensions site, but as far as I know, no one has built it for Windows or Linux (on Linux the question is mostly irrelevant because the distribs provide it in most cases, however, that does mean you are tied to the distrib version of LibreOffice). 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 Native Connector
Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. -- 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 Native Connector
Hi Alex, As I have already mentioned in an earlier posting - I downloaded the connector from the site you mention. However, trying to then install/activate it in my LO 3.4.3 system fails. Heinrich On Sun, 18 Sep 2011 16:28:03 +0200, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Why, well firstly because no one gives a damn, and second, to build the connector you have to rely on the mysql C connector library (even if you use mysql C++ library) and that library is GPL2, which means that the connector that links to it has to be released under the GPL (this is in fact what Sun did with the native connector extension). The LibO project releases under the LGPL/MPL and not the GPL. At the moment, the OOo mysql native connector is available for download from here : http://extensions.services.openoffice.org/en/project/mysql_connector My advice, get it while you can and keep a copy near to hand. How long that will remain the case now that this site is to integrated into the ApacheOOo project remains to be seen, because Apache can not accept GPLed code into its projects. I have built the native connector for MacOSX and put it on the LibreOffice extensions site, but as far as I know, no one has built it for Windows or Linux (on Linux the question is mostly irrelevant because the distribs provide it in most cases, however, that does mean you are tied to the distrib version of LibreOffice). 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: MySQL Native Connector
Hi :) It might be a good idea to plan a move from MySql to MariaDb. MariaDb is a drop-in replacement for MySql. MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on. It's almost all the MySql people except the ones paid by Oracle. Regards from Tom :) --- On Sun, 18/9/11, Andreas Säger saege...@t-online.de wrote: From: Andreas Säger saege...@t-online.de Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 15:54 Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. -- 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 Native Connector
On Sunday, September 18, 2011 07:48:09 PM Tom Davies wrote: Hi :) It might be a good idea to plan a move from MySql to MariaDb. MariaDb is a drop-in replacement for MySql. MariaDb is much faster at developing and bug-fixing so a bug-report to them might get a faster response and they might well be happy to work on a project such as the extension/add-on. It's almost all the MySql people except the ones paid by Oracle. Regards from Tom :) --- On Sun, 18/9/11, Andreas Säger saegerei@t- online.de wrote: From: Andreas Säger saege...@t-online.de Subject: [libreoffice-users] Re: MySQL Native Connector To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 15:54 Am 18.09.2011 16:28, Alexander Thurgood wrote: Le 17/09/11 21:43, Andreas Säger a écrit : Hi Andreas, As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. It is neither built nor shipped by the LibreOffice project. It is shipped with various Linux distributions, who include it in their extensions build setup. Thank you, Now I see that we first choose MySQL and then we are prompted for ODBC or JDBC. I was under the impression that MySQL refers to the built-in driver. Do you know if this will work in parallel with MySQl until things can be migrated? Also so phpMyAdmin or something simular work with it? Thats -- 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 Native Connector
Am 17.09.2011 21:23, Heinrich Stoellinger wrote: Hello, Some time ago somebody gave me a link to downloading the native connector to LO/OO from MySQL. I can't find that e-mail anymore! :'( Could you please resend the info? Thanks a lot in advance Heinrich As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. -- 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 Native Connector
Hello Andreas, Thanks for your hint, but... Weird! One can in fact select MySQL as the (native) type of connection for an odb-file. However when one then tries to open the odb-file, LO displays a list-box for the specification of a programme with which to open the odb-file. Downloading the connector and then trying to activate the connector through the extension manager doesn't work either. On Sat, 17 Sep 2011 21:43:46 +0200, Andreas Säger ville...@t-online.de wrote: Am 17.09.2011 21:23, Heinrich Stoellinger wrote: Hello, Some time ago somebody gave me a link to downloading the native connector to LO/OO from MySQL. I can't find that e-mail anymore! :'( Could you please resend the info? Thanks a lot in advance Heinrich As far as I know, it is shipped with LibreOffice. Choose database type MySQL instead of JDBC or ODBC. -- 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