Re: [EXT] MySQL SDBC Connector
Am 10/15/2012 09:13 PM, schrieb Andrea Pescetti: On 12/10/2012 Ariel Constenla-Haile wrote: On Sun, Sep 09, 2012 at 07:52:03PM +0200, Roberto Galoppini wrote: Hi Ariel, would you be interested in managing the AOO Extension page dedicated to the MySQL connector? At the present stage is unmaintained, I believe you'd be the 'natural' candidate for that. I finally ended up setting a new project page: http://extensions.openoffice.org/en/project/mysql-driver It wouldn't be fair to take the current page Actually, I feel it would be fair to take it! If the extension is unmaintained (meaning that the user who was maintaining it does no longer have an account on the Extensions site) then it is confusing to users to have the unmaintained version and your patched one available. Sorry that I haven't reported this earlier. I remember that I've maintained this webpage. Of course not as the developer but as (kind of) liaison officer between OOo community and Sun/Oracle. And yes, I don't have access to it anymore, so I cannot change it myself. I agree with Andrea that it's better to continue the already (and wrt the stats very popular!) webpage than to have two with the same purpose. It occurred already a couple times that I had to explicitly point users to your patched version and that they solved their problems with it. So it surely deserves better exposure. Week: 795 | Month: 3,850 | Year: 45,050 If you don't host your version on extensions.openoffice.org, it will always be shadowed by this (buggy) one, because downloads won't be tracked. So, seeing this as a user, the best solutions I can imagine are: 1) Take over http://extensions.openoffice.org/en/project/mysql_connector ; old releases are archived, available and credited appropriately; nothing new will happen there since no users can update the page. +1 2) Keep both projects, but state clearly on the older one that it is abandoned and that bugfixes and 3.4.x compatibility can be obtained in your version, and link to it. In this case, it would help if you hosted the packages on extensions.openoffice.org so that it can be shown in the most popular listing and gradually shadow the old one. But at the very least we should agree on a replacement text for the 3.4 compatibility notice at http://extensions.openoffice.org/en/project/mysql_connector and get it replaced. Marcus
Re: [EXT] MySQL SDBC Connector
Hi Roberto, On Sun, Sep 09, 2012 at 07:52:03PM +0200, Roberto Galoppini wrote: Hi Ariel, would you be interested in managing the AOO Extension page dedicated to the MySQL connector? At the present stage is unmaintained, I believe you'd be the 'natural' candidate for that. I finally ended up setting a new project page: http://extensions.openoffice.org/en/project/mysql-driver It wouldn't be fair to take the current page that has these downloads numbers: Week: 795 | Month: 3,850 | Year: 45,050 because, wearing my AOO-committer hat, the project http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ is not affiliated with, or endorsed by, the ASF or this project in any way: any one is free to take the sources from AOO repository, or even the one with the fixes I've made (as I'm releasing them under the ALv2.0) and seet up his/her own fork. Regards -- Ariel Constenla-Haile La Plata, Argentina pgpMyuukZROSW.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
On Thu, Sep 06, 2012 at 10:50:21PM -0300, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). I also managed to build the Report Builder: http://people.apache.org/~arielch/extensions/ReportBuilder.oxt and started fixing the PostgreSQL driver. @Andrew: is there any chance to get that code contributed under the Apache License? http://www.openoffice.org/dba/drivers/postgresql/index.html#source I couldn't find anywhere where the old cvs repor has gone; I've an old copy of the sources, they all have Sun license headers, so I guess they were transfered to Oracle. Regards -- Ariel Constenla-Haile La Plata, Argentina pgp2NmfbfYgB6.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
On 10/12/12 3:16 PM, Ariel Constenla-Haile wrote: Hi Roberto, On Sun, Sep 09, 2012 at 07:52:03PM +0200, Roberto Galoppini wrote: Hi Ariel, would you be interested in managing the AOO Extension page dedicated to the MySQL connector? At the present stage is unmaintained, I believe you'd be the 'natural' candidate for that. I finally ended up setting a new project page: http://extensions.openoffice.org/en/project/mysql-driver It wouldn't be fair to take the current page that has these downloads numbers: Week: 795 | Month: 3,850 | Year: 45,050 because, wearing my AOO-committer hat, the project http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ is not affiliated with, or endorsed by, the ASF or this project in any way: any one is free to take the sources from AOO repository, or even the one with the fixes I've made (as I'm releasing them under the ALv2.0) and seet up his/her own fork. do you plan to upload your builds in the repo under a new page? I think that would be ok and we can remove the old page and can start from scratch. On the new page you could make clear that it is a separate project not related directly to the Apache project. Juergen
Re: [EXT] MySQL SDBC Connector
On Fri, Oct 12, 2012 at 03:31:44PM +0200, Jürgen Schmidt wrote: On 10/12/12 3:16 PM, Ariel Constenla-Haile wrote: Hi Roberto, On Sun, Sep 09, 2012 at 07:52:03PM +0200, Roberto Galoppini wrote: Hi Ariel, would you be interested in managing the AOO Extension page dedicated to the MySQL connector? At the present stage is unmaintained, I believe you'd be the 'natural' candidate for that. I finally ended up setting a new project page: http://extensions.openoffice.org/en/project/mysql-driver It wouldn't be fair to take the current page that has these downloads numbers: Week: 795 | Month: 3,850 | Year: 45,050 because, wearing my AOO-committer hat, the project http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ is not affiliated with, or endorsed by, the ASF or this project in any way: any one is free to take the sources from AOO repository, or even the one with the fixes I've made (as I'm releasing them under the ALv2.0) and seet up his/her own fork. do you plan to upload your builds in the repo under a new page? No, I'll keep everything (source, binaries, wiki, issues) under Google Code, it has integration with Google Analytics, which is really nice. I think that would be ok and we can remove the old page and can start from scratch. On the new page you could make clear that it is a separate project not related directly to the Apache project. It already says: Disclaimers: Apache, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. MySQL is trademark of Oracle Corporation. Other names may be trademarks of their respective owners. but I will add some of the lines I wrote above. And now I notice I used MySQL in the page URL, I changed it to http://extensions.openoffice.org/en/project/aoo-my-sdbc Regards -- Ariel Constenla-Haile La Plata, Argentina pgpL23HKau2FG.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
On Fri, Oct 12, 2012 at 03:31:44PM +0200, Jürgen Schmidt wrote: On the new page you could make clear that it is a separate project not related directly to the Apache project. One this that should be also updated/removed is the WikiPublisher: http://extensions.openoffice.org/en/project/wikipublisher It even has Sun's name, and Date: 2009-Jun-09 Regards -- Ariel Constenla-Haile La Plata, Argentina pgpzRlobvJBsI.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
2012.10.12. 15:21 keltezéssel, Ariel Constenla-Haile írta: On Thu, Sep 06, 2012 at 10:50:21PM -0300, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). I also managed to build the Report Builder: http://people.apache.org/~arielch/extensions/ReportBuilder.oxt It is Good news :) You plan to work on bug fixes in report builder? Zoltan and started fixing the PostgreSQL driver. @Andrew: is there any chance to get that code contributed under the Apache License? http://www.openoffice.org/dba/drivers/postgresql/index.html#source I couldn't find anywhere where the old cvs repor has gone; I've an old copy of the sources, they all have Sun license headers, so I guess they were transfered to Oracle. Regards
Re: [EXT] MySQL SDBC Connector
Hi Zlotan, On Fri, Oct 12, 2012 at 04:17:46PM +0200, Reizinger Zoltán wrote: 2012.10.12. 15:21 keltezéssel, Ariel Constenla-Haile írta: On Thu, Sep 06, 2012 at 10:50:21PM -0300, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). I also managed to build the Report Builder: http://people.apache.org/~arielch/extensions/ReportBuilder.oxt It is Good news :) You plan to work on bug fixes in report builder? I'm not sure yet, because studying/debugging the Java stuff may not be that fun; on the other hand, working on the MySQL and the PostgreSQL drivers has been really nice :) (I had to study-by-debugging the MySQL/Connector C++, Connector C, and even parts of glibc to find out why localhost connections didn't work on Linux). The Report Builder, in its current state, seems to work fine on Windows, on Linux I see mixing results, depending on the distro. Regards -- Ariel Constenla-Haile La Plata, Argentina pgpIRdedmYZ58.pgp Description: PGP signature
Report builder (was:Re: [EXT] MySQL SDBC Connector)
2012.10.12. 16:29 keltezéssel, Ariel Constenla-Haile írta: Hi Zlotan, On Fri, Oct 12, 2012 at 04:17:46PM +0200, Reizinger Zoltán wrote: 2012.10.12. 15:21 keltezéssel, Ariel Constenla-Haile írta: On Thu, Sep 06, 2012 at 10:50:21PM -0300, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). I also managed to build the Report Builder: http://people.apache.org/~arielch/extensions/ReportBuilder.oxt It is Good news :) You plan to work on bug fixes in report builder? I'm not sure yet, because studying/debugging the Java stuff may not be that fun; on the other hand, working on the MySQL and the PostgreSQL drivers has been really nice :) (I had to study-by-debugging the MySQL/Connector C++, Connector C, and even parts of glibc to find out why localhost connections didn't work on Linux). The Report Builder, in its current state, seems to work fine on Windows, on Linux I see mixing results, depending on the distro. Unser windows I tested works in most cases. Only thing which not works, the charts, if you open report with chart included it is fails with error: Failed to parse the report - possibly caused by changes in Chart, which not followed in report buider. I could sen my test database with chart in reports, to see that. Best regards, Zoltan Regards
Re: Report builder (was:Re: [EXT] MySQL SDBC Connector)
On Fri, Oct 12, 2012 at 04:39:41PM +0200, Reizinger Zoltán wrote: The Report Builder, in its current state, seems to work fine on Windows, on Linux I see mixing results, depending on the distro. Unser windows I tested works in most cases. Only thing which not works, the charts, if you open report with chart included it is fails with error: Failed to parse the report - possibly caused by changes in Chart, which not followed in report buider. I could sen my test database with chart in reports, to see that. yes, please send me a copy. Regards -- Ariel Constenla-Haile La Plata, Argentina pgpLgKi3Rarms.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
Hi Ariel; - Original Message - ... Hi Mechtilde, On Sat, Sep 08, 2012 at 10:38:42AM +0200, Mechtilde wrote: thanks for the good job. So it is possible to use further the mysql-connector. Can you also publish the source code for the connector. Then other people are also able to distribute it. I'm working on it, I have to investigate if a can let the license header we use in AOO (I also added it to the files I added). I've just enabled the Source tab on the project, it can be cloned with: git clone https://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ I guess it will be a license soup but that is OK since ALv2 is GPL compatible. I wonder, is there code that we can remove from AOO now? A source tarball will have to wait until I solve this license thing, and write the readme, notice, license, etc., and the extension is ready to be release (it isn't still ready for a release). If anyone is willing to contribute with code, qa, bug report, please send me a note (you will need a google account). I would like to try building it on FreeBSD but I will have to wait until a src tarball is available. Cheers, Pedro.
Re: [EXT] MySQL SDBC Connector
On Sat, Sep 8, 2012 at 11:10 AM, Ariel Constenla-Haile arie...@apache.orgwrote: Hi Mechtilde, On Sat, Sep 08, 2012 at 10:38:42AM +0200, Mechtilde wrote: thanks for the good job. So it is possible to use further the mysql-connector. Can you also publish the source code for the connector. Then other people are also able to distribute it. I'm working on it, I have to investigate if a can let the license header we use in AOO (I also added it to the files I added). I've just enabled the Source tab on the project, it can be cloned with: git clone https://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ A source tarball will have to wait until I solve this license thing, and write the readme, notice, license, etc., and the extension is ready to be release (it isn't still ready for a release). If anyone is willing to contribute with code, qa, bug report, please send me a note (you will need a google account). Hi Ariel, would you be interested in managing the AOO Extension page dedicated to the MySQL connector? At the present stage is unmaintained, I believe you'd be the 'natural' candidate for that. Roberto Regards -- Ariel Constenla-Haile La Plata, Argentina -- This e- mail message is intended only for the named recipient(s) above. It may contain confidential and privileged information. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the message and any attachment(s) from your system. Thank you.
Re: [EXT] MySQL SDBC Connector
On 07/09/2012 Alex Thurgood wrote: On 07/09/2012 03:50, Ariel Constenla-Haile wrote: I managed to build the MySQL Connector extension and make it work on Thanks, great news! Indeed there were quite a few request for an updated version. A nice to have would be for Mac OSX too ;-) I see one (which I couldn't try) at http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/downloads/list ; so apparently all platforms supported by the old MySQL connector are now supported by Ariel's updated version too. Regards, Andrea.
Re: [EXT] MySQL SDBC Connector
On Thu, Sep 06, 2012 at 10:50:21PM -0300, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). The code will be hosted at http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ The Google group aoo-my-sdbc will work as a mailing list. Regards -- Ariel Constenla-Haile La Plata, Argentina pgpf8kYG7XTeO.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Ariel, thanks for the good job. So it is possible to use further the mysql-connector. Can you also publish the source code for the connector. Then other people are also able to distribute it. kind regars Am 08.09.2012 10:17, schrieb Ariel Constenla-Haile: On Thu, Sep 06, 2012 at 10:50:21PM -0300, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). The code will be hosted at http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ The Google group aoo-my-sdbc will work as a mailing list. Regards -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlBLBBIACgkQucZfh1OziSuGGQCeJk9ZhhHW+VirgqdYgm4fkZVb 1oYAoJSyEWEYyupOyHadWfwUgGKJita3 =CCW+ -END PGP SIGNATURE-
Re: [EXT] MySQL SDBC Connector
Hi Mechtilde, On Sat, Sep 08, 2012 at 10:38:42AM +0200, Mechtilde wrote: thanks for the good job. So it is possible to use further the mysql-connector. Can you also publish the source code for the connector. Then other people are also able to distribute it. I'm working on it, I have to investigate if a can let the license header we use in AOO (I also added it to the files I added). I've just enabled the Source tab on the project, it can be cloned with: git clone https://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/ A source tarball will have to wait until I solve this license thing, and write the readme, notice, license, etc., and the extension is ready to be release (it isn't still ready for a release). If anyone is willing to contribute with code, qa, bug report, please send me a note (you will need a google account). Regards -- Ariel Constenla-Haile La Plata, Argentina pgpwz2m4jQ8C2.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
Hi Ariael, Hi Li Feng Wang, I tested on win7 32bit with localhost no problems for me with this connector. Can connect create and use queries, forms, etc. I connected to Mysql 5.1 and 5.5 servers. 2012.09.07. 5:09 keltezéssel, Ariel Constenla-Haile írta: Hi Li Feng Wang, On Fri, Sep 07, 2012 at 10:26:57AM +0800, Li Feng Wang wrote: I test it on Windows XP 32bits, just connect to local MySQL directly. It have no crash. thanks for testing it :) But it list all databases, not only my specified database name. I don't know whether it is a existing issue. I couldn't find an issue number, but it's reproducible with Oracle's build from http://extensions.openoffice.org/en/project/mysql_connector I'm not find it, may be it is not there, but you can search for MySQL native driver development information and known bugs on wiki: http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Overview http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Known_Problems It's strange that the extension is not listed on bugzilla when you select Product: extensions. The extension is listed on MySQL site http://dev.mysql.com/downloads/connector/ so maybe bugs where reported there... I'll have to investigate. Bugzilla you can search for mysql connector issues in advanced search select database connection in product field, then you can select MySQL Connector/OOo in component field. Regards, Zoltan Regards
Re: [EXT] MySQL SDBC Connector
On 9/7/12 3:50 AM, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). it's cool and will help probably many people. How did you build it? Did you simply use the former code and build it within our normal build env? Or did you use a SDK env or a completely new one. Did you create a separate module or project?. Well we had reasons to exclude it from our normal builds and I think it would be good to learn more about the way you have chosen to build it. I remember that we talked about solutions for some removed features that somebody could take the code and could create a mini project somewhere else to ensure that it can be built and used with future AOO version. Juergen
Re: [EXT] MySQL SDBC Connector
Hi Reizinger, On Fri, Sep 07, 2012 at 08:20:43AM +0200, Reizinger Zoltán wrote: But it list all databases, not only my specified database name. I don't know whether it is a existing issue. I couldn't find an issue number, but it's reproducible with Oracle's build from http://extensions.openoffice.org/en/project/mysql_connector I'm not find it, may be it is not there, but you can search for MySQL native driver development information and known bugs on wiki: http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Overview http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Known_Problems I had found this only one issue, it seemed too little ;) http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0/Known_Issues It's strange that the extension is not listed on bugzilla when you select Product: extensions. The extension is listed on MySQL site http://dev.mysql.com/downloads/connector/ so maybe bugs where reported there... I'll have to investigate. Bugzilla you can search for mysql connector issues in advanced search select database connection database access was the field name. in product field, then you can select MySQL Connector/OOo in component field. There are 31: https://issues.apache.org/ooo/buglist.cgi?cmdtype=runnamednamedcmd=mysqlconn-ooo I will upload the source code in Apache Extras - or plain Google Code (the extension cannot be built here at AOO because it must build and ship the MySQL Connector/C and Connector/C++, both GPL); Google Code has a bug report feature, so I may add the reproducible bugs there. I'm not sure what to do with those bugs in AOO bugzilla, because, in the case that I'll fix some bugs (and I'm not sure about it, I do this in my spare time, so I invest time in coding as far as it's fun), in that case I don't plan to commit code in AOO source tree under trunk/main/mysqlc: after IP clearance with revision 1201714 the code only works with MySQL system libraries, so that it can be considered dead code, and archived. Regards -- Ariel Constenla-Haile La Plata, Argentina pgp1NkfGiW7Vt.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
On 07/09/2012 03:50, Ariel Constenla-Haile wrote: Hi Ariel, * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) Ooh, nice, thanks for that. My own attempts at building the connector in the past for Mac and Linux have been fraught with pain, frustration and disappointment, i.e. the build took ages, and then the connector didn't work or at least, wasn't portable. These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). A nice to have would be for Mac OSX too ;-) Alex
Re: [EXT] MySQL SDBC Connector
Hi Jürgen, On Fri, Sep 07, 2012 at 09:31:38AM +0200, Jürgen Schmidt wrote: On 9/7/12 3:50 AM, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). it's cool and will help probably many people. How did you build it? Did you simply use the former code and build it within our normal build env? Or did you use a SDK env or a completely new one. Did you create a separate module or project?. I built it with the SDK environment, just like the Complex Toolbar Controls example in /sdk/examples/cpp/complextoolbarcontrols Of course, with some little tweaking: the SDK only uses Make and Zip, and as the extensions builds also the MySQL Connector/C and Connector/C++, you need to add some extra tools, including cmake, but I managed to use all these stuff with plain Makefile's and includes, à la SDK. This has the advantage that anyone, with a minimal building knowledge can set up the SDK environment and build the extension - at least in theory, I set up the Makefile to build only on Linux and Windows, but adapting a few things it may be buildable in other systems too. Example of external tools needed on Windows: # Unx utilities for Windows: # http://sourceforge.net/projects/unxutils/files/latest/download # Extract external libraries # This tar does not understand -z, so we need zcat too TAR=C:\UnxUtils\usr\local\wbin\tar.exe ZCAT=C:\UnxUtils\usr\local\wbin\zcat.exe # patching the external libraries PATCH=C:\UnxUtils\usr\local\wbin\patch.exe # get rid of echoing XML files CAT=C:\UnxUtils\usr\local\wbin\cat.exe SED=C:\UnxUtils\usr\local\wbin\sed.exe # we could use xcopy to copy recursively, but it sucks COPY=C:\UnxUtils\usr\local\wbin\cp.exe COPYRECURSIVE=$(COPY) -rf # MySQL Connector/C is built with CMake # http://www.cmake.org/cmake/resources/software.html CMAKE=C:\cmake-2.8.9-win32-x86\bin\cmake.exe First I though about using configure and cygwin, but this approach makes building the extension more easy: add these tools to a win.mk and simply install and set up the AOO SDK, and build the extension with it. Of course, in Linux developing is easier and straight forward; but on Windows the SDK user already has to search for a GNU Make, and these tools can be found on the same package (except for CMake, that can be downloaded in a zip, no need to install it). Well we had reasons to exclude it from our normal builds and I think it would be good to learn more about the way you have chosen to build it. I remember that we talked about solutions for some removed features that somebody could take the code and could create a mini project somewhere else to ensure that it can be built and used with future AOO version. Some stuff needs to be linked against no URE libraries, like the removed WordPerfect filter. I didn't look at the PDF Import extension, in theory an extension should only link against URE libs, but this might be not the case. Anyway, it might be useful to take the Hybrid PDF stuff out of this extension and implement it in the main code, office-wide: it is a nice feature. Regards -- Ariel Constenla-Haile La Plata, Argentina pgp6zovFoh1Ei.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
Hi Alex, On Fri, Sep 07, 2012 at 09:45:24AM +0200, Alex Thurgood wrote: * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) Ooh, nice, thanks for that. My own attempts at building the connector in the past for Mac and Linux have been fraught with pain, frustration and disappointment, i.e. the build took ages, and then the connector didn't work or at least, wasn't portable. I have the feeling they really didn't use the normal environment to build the extension. In the build environment the MySQL Connector/C comes as Deus ex Machina, it's not built, but the extension must include the three libraries (the uno component, the Connector/C and Connector/C++ - although they are not linked against each other, they are loaded at runtime). These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). A nice to have would be for Mac OSX too ;-) As I explained to Jürgen, you will only need the SDK + CMake to build it, so you will be able to play with it :) I'll let you know when I upload the code to Apache Extras. Regards -- Ariel Constenla-Haile La Plata, Argentina pgpAsOlDa8Eqh.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
On 9/7/12 9:40 AM, Ariel Constenla-Haile wrote: Hi Reizinger, On Fri, Sep 07, 2012 at 08:20:43AM +0200, Reizinger Zoltán wrote: But it list all databases, not only my specified database name. I don't know whether it is a existing issue. I couldn't find an issue number, but it's reproducible with Oracle's build from http://extensions.openoffice.org/en/project/mysql_connector I'm not find it, may be it is not there, but you can search for MySQL native driver development information and known bugs on wiki: http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Overview http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Known_Problems I had found this only one issue, it seemed too little ;) http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0/Known_Issues It's strange that the extension is not listed on bugzilla when you select Product: extensions. The extension is listed on MySQL site http://dev.mysql.com/downloads/connector/ so maybe bugs where reported there... I'll have to investigate. Bugzilla you can search for mysql connector issues in advanced search select database connection database access was the field name. in product field, then you can select MySQL Connector/OOo in component field. There are 31: https://issues.apache.org/ooo/buglist.cgi?cmdtype=runnamednamedcmd=mysqlconn-ooo I will upload the source code in Apache Extras - or plain Google Code (the extension cannot be built here at AOO because it must build and ship the MySQL Connector/C and Connector/C++, both GPL); Google Code has a bug report feature, so I may add the reproducible bugs there. I agree that makes probably most sense I'm not sure what to do with those bugs in AOO bugzilla, because, in the case that I'll fix some bugs (and I'm not sure about it, I do this in my spare time, so I invest time in coding as far as it's fun), in that case I don't plan to commit code in AOO source tree under trunk/main/mysqlc: after IP clearance with revision 1201714 the code only works with MySQL system libraries, so that it can be considered dead code, and archived. we can keep the issues in bugzilla for reference at the moment but probably it make sense to mark them won't be fixed with an appropriate comment that the code is not maintained here at Apache and point to the new location. And of course close them. Juergen
Re: [EXT] MySQL SDBC Connector
On 9/7/12 10:15 AM, Ariel Constenla-Haile wrote: Hi Jürgen, On Fri, Sep 07, 2012 at 09:31:38AM +0200, Jürgen Schmidt wrote: On 9/7/12 3:50 AM, Ariel Constenla-Haile wrote: Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). it's cool and will help probably many people. How did you build it? Did you simply use the former code and build it within our normal build env? Or did you use a SDK env or a completely new one. Did you create a separate module or project?. I built it with the SDK environment, just like the Complex Toolbar Controls example in /sdk/examples/cpp/complextoolbarcontrols that's what I hoped. I hope we can find time to improve the development/build experience for this kind of stuff. For Java extensions we have the NetBeans plugin and I think with some manual tweaking Eclipse can be used as well. Or the Eclipse plugin of Cedric of course. For C++ the SDK env is one approach but not the best one. For Windows I can think of a MS studio project file with all the necessary custom targets and tweaks. a lot of room for improvements as always ;-) But again I am glad that you give it a try and closed one gap. I think the connector is very useful for many users. Juergen Of course, with some little tweaking: the SDK only uses Make and Zip, and as the extensions builds also the MySQL Connector/C and Connector/C++, you need to add some extra tools, including cmake, but I managed to use all these stuff with plain Makefile's and includes, à la SDK. This has the advantage that anyone, with a minimal building knowledge can set up the SDK environment and build the extension - at least in theory, I set up the Makefile to build only on Linux and Windows, but adapting a few things it may be buildable in other systems too. Example of external tools needed on Windows: # Unx utilities for Windows: # http://sourceforge.net/projects/unxutils/files/latest/download # Extract external libraries # This tar does not understand -z, so we need zcat too TAR=C:\UnxUtils\usr\local\wbin\tar.exe ZCAT=C:\UnxUtils\usr\local\wbin\zcat.exe # patching the external libraries PATCH=C:\UnxUtils\usr\local\wbin\patch.exe # get rid of echoing XML files CAT=C:\UnxUtils\usr\local\wbin\cat.exe SED=C:\UnxUtils\usr\local\wbin\sed.exe # we could use xcopy to copy recursively, but it sucks COPY=C:\UnxUtils\usr\local\wbin\cp.exe COPYRECURSIVE=$(COPY) -rf # MySQL Connector/C is built with CMake # http://www.cmake.org/cmake/resources/software.html CMAKE=C:\cmake-2.8.9-win32-x86\bin\cmake.exe First I though about using configure and cygwin, but this approach makes building the extension more easy: add these tools to a win.mk and simply install and set up the AOO SDK, and build the extension with it. Of course, in Linux developing is easier and straight forward; but on Windows the SDK user already has to search for a GNU Make, and these tools can be found on the same package (except for CMake, that can be downloaded in a zip, no need to install it). Well we had reasons to exclude it from our normal builds and I think it would be good to learn more about the way you have chosen to build it. I remember that we talked about solutions for some removed features that somebody could take the code and could create a mini project somewhere else to ensure that it can be built and used with future AOO version. Some stuff needs to be linked against no URE libraries, like the removed WordPerfect filter. I didn't look at the PDF Import extension, in theory an extension should only link against URE libs, but this might be not the case. Anyway, it might be useful to take the Hybrid PDF stuff out of this extension and implement it in the main code, office-wide: it is a nice feature. Regards
Re: [EXT] MySQL SDBC Connector
Hi Jürgen, Ariel, 2012.09.07. 10:51 keltezéssel, Jürgen Schmidt írta: On 9/7/12 9:40 AM, Ariel Constenla-Haile wrote: Hi Reizinger, On Fri, Sep 07, 2012 at 08:20:43AM +0200, Reizinger Zoltán wrote: But it list all databases, not only my specified database name. I don't know whether it is a existing issue. I couldn't find an issue number, but it's reproducible with Oracle's build from http://extensions.openoffice.org/en/project/mysql_connector I'm not find it, may be it is not there, but you can search for MySQL native driver development information and known bugs on wiki: http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Overview http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta/Known_Issues http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/Known_Problems I had found this only one issue, it seemed too little ;) http://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0/Known_Issues It's strange that the extension is not listed on bugzilla when you select Product: extensions. The extension is listed on MySQL site http://dev.mysql.com/downloads/connector/ so maybe bugs where reported there... I'll have to investigate. Bugzilla you can search for mysql connector issues in advanced search select database connection database access was the field name. in product field, then you can select MySQL Connector/OOo in component field. There are 31: https://issues.apache.org/ooo/buglist.cgi?cmdtype=runnamednamedcmd=mysqlconn-ooo I will upload the source code in Apache Extras - or plain Google Code (the extension cannot be built here at AOO because it must build and ship the MySQL Connector/C and Connector/C++, both GPL); Google Code has a bug report feature, so I may add the reproducible bugs there. I agree that makes probably most sense I'm not sure what to do with those bugs in AOO bugzilla, because, in the case that I'll fix some bugs (and I'm not sure about it, I do this in my spare time, so I invest time in coding as far as it's fun), in that case I don't plan to commit code in AOO source tree under trunk/main/mysqlc: after IP clearance with revision 1201714 the code only works with MySQL system libraries, so that it can be considered dead code, and archived. we can keep the issues in bugzilla for reference at the moment but probably it make sense to mark them won't be fixed with an appropriate comment that the code is not maintained here at Apache and point to the new location. And of course close them. I will do the bugs move to Google code work, when Ariel created the new place for it, and I will close bugs in bugzilla. Zoltan Juergen
Re: [EXT] MySQL SDBC Connector
On 07/09/2012 10:25, Ariel Constenla-Haile wrote: Hi Ariel, As I explained to Jürgen, you will only need the SDK + CMake to build it, so you will be able to play with it :) I seem to recall that the SDK was never bundled with OOo for Mac, or was that just the URE ? If the SDK is dependent on the URE and it is not built/delivered for Mac, then I think I'm back to square one ? I'll let you know when I upload the code to Apache Extras. I look forward to it, thanks for your efforts. Alex
Re: [EXT] MySQL SDBC Connector
Hi Alex, On Fri, Sep 07, 2012 at 12:10:19PM +0200, Alex Thurgood wrote: On 07/09/2012 10:25, Ariel Constenla-Haile wrote: As I explained to Jürgen, you will only need the SDK + CMake to build it, so you will be able to play with it :) I seem to recall that the SDK was never bundled with OOo for Mac, or was that just the URE ? If the SDK is dependent on the URE and it is not built/delivered for Mac, then I think I'm back to square one ? I don't recall what Sun/Oracle did, but now you can find the SDK for Mac on http://www.openoffice.org/download/other.html#tested-sdk or direct link to the SF mirrors: http://sourceforge.net/projects/openofficeorg.mirror/files/stable/3.4.1/Apache_OpenOffice_incubating-SDK_3.4.1_MacOS_x86_install_en-US.dmg/download Regards -- Ariel Constenla-Haile La Plata, Argentina pgpUS2Otz84Ey.pgp Description: PGP signature
[EXT] MySQL SDBC Connector
Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). Regards -- Ariel Constenla-Haile La Plata, Argentina pgpVGeLpQ50nG.pgp Description: PGP signature
Re: [EXT] MySQL SDBC Connector
I test it on Windows XP 32bits, just connect to local MySQL directly. It have no crash. But it list all databases, not only my specified database name. I don't know whether it is a existing issue. 2012/9/7 Ariel Constenla-Haile arie...@apache.org Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). Regards -- Ariel Constenla-Haile La Plata, Argentina -- Best Wishes, LiFeng Wang
Re: [EXT] MySQL SDBC Connector
Very, very cool!! Thanks Ariel! Pedro. From: Ariel Constenla-Haile arie...@apache.org To: ooo-dev@incubator.apache.org Sent: Thursday, September 6, 2012 8:50 PM Subject: [EXT] MySQL SDBC Connector Hi *, I managed to build the MySQL Connector extension and make it work on * CentOS 5.8 32 and 64 bits * Ubuntu 10.04 LTS 32 and 64 bits * Fedora 15 32 bits and 17 64 bits * Windows XP 32 bits * Windows 7 64 bits (arch. does not matter on Win, AOO is a 32 bits application) You can find the extension binaries on http://people.apache.org/~arielch/extensions/aoo-my-sdbc/ These are supposed to be universal builds, that is, run on every Windows version, and Linux distro (Linux base is CentOS 5 with glibc 2.5). Everyone is welcome to test if they work on their systems; by work I mean it does not crash, I didn't fix any of the existing issues, it was just a try-to-build-it (for now). Regards -- Ariel Constenla-Haile La Plata, Argentina
Re: [EXT] MySQL SDBC Connector
Hi Li Feng Wang, On Fri, Sep 07, 2012 at 10:26:57AM +0800, Li Feng Wang wrote: I test it on Windows XP 32bits, just connect to local MySQL directly. It have no crash. thanks for testing it :) But it list all databases, not only my specified database name. I don't know whether it is a existing issue. I couldn't find an issue number, but it's reproducible with Oracle's build from http://extensions.openoffice.org/en/project/mysql_connector It's strange that the extension is not listed on bugzilla when you select Product: extensions. The extension is listed on MySQL site http://dev.mysql.com/downloads/connector/ so maybe bugs where reported there... I'll have to investigate. Regards -- Ariel Constenla-Haile La Plata, Argentina pgpyf0UgMVu6M.pgp Description: PGP signature