- discuss - lists.mariadb.org

[Maria-discuss] openbsd switched libmysqlclient back to older mysql one
by Colin Charles 13 Jun '13

13 Jun '13

Hi! I noticed this: http://www.openbsd.org/cgi-bin/cvsweb/ports/databases/mariadb/Makefile?rev=… Revert back to using MySQL 5.1 for the time being. MariaDB 5.5 introduces a new libmysqlclient non-blocking API which utilizes co-routines. The X86 specific GCC ASM co-routine support hid the fact that there was an issue. The only fallback code so far is POSIX user contexts which OpenBSD does not support. Is this something we can fix to ensure that OpenBSD users can continue to use our libmysqlclient? cheers, -colin -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

2 1

[Maria-discuss] New Question: How to define a date in order to import an empty date from a CSV file?
by AskMonty KB 13 Jun '13

13 Jun '13

Hello, A new question has been asked in "Data Types" by JohnD: -------------------------------- I have a CSV file containing amongst other things a couple of date columns. Some of the date values are empty - that is just ",," - a comma followed by another comma. The date rows in the table are defined like this: `PTY_USR_PASSWORD_DATE` DATE NULL DEFAULT NULL, But when I import the data (using HeidiSQL), I get the following error: /* SQL Error (1292): Incorrect date value: '' for column 'PTY_USR_PASSWORD_DATE' at row 1 */ How should I set up the table to allow this? Or how can I modify the CSV? John D. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/how-to-define-a-date-in-order-to-import-an-empty-…

1 0

[Maria-discuss] MariaDB 10.0.3-alpha now available
by Daniel Bartholomew 11 Jun '13

11 Jun '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.3. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported and reimplemented features from MySQL 5.6 and entirely new features not found anywhere else. This is the fourth release in the 10.0 series. We are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. See the release notes and changelog for details on what is new in this release. Do not use alpha releases on production systems. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.3 Alpha - Release Notes: http://kb.askmonty.org/en/mariadb-1003-release-notes - Changelog: http://kb.askmonty.org/en/mariadb-1003-changelog - Downloads: http://downloads.mariadb.org/mariadb/10.0.3 Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] Clear-text plugin
by Peter Laursen 06 Jun '13

06 Jun '13

"no support for dlopen()" . How does this apply to Windows clients? We always build first on Windows and once we have no errors of any kind we build on Linux if the application exists for that platform (what MONyog does and SQLyog does not) and fix what issues may occur there. This issue has occurred with SQLyog (and as such for a Windows client). I am not coder/developer myself, but on Windows I think we have no other option than statically linking? We could of could compile the API as a .dll, but we don't (because we had a lot of problems with it earlier). -- Peter On Thu, Jun 6, 2013 at 3:25 PM, Sergei Golubchik <serg(a)mariadb.org> wrote: > Hi, Peter! > > On Jun 04, Peter Laursen wrote: > > We have the same problem. We cannot test either. But we have a few user > > reports. We will discuss what we can do. > > > > Is there any parameter or compile-time option we should be aware of? Any > > specific documentation somewhere? Anything? > > Not really. If the cleartext plugin is built and installed, it'll be > used when the server requests it. > > I've just checked that this plugin is present both in rpm and deb > packages. I didn't check binary tarballs, but it should be there too. > > So, there's nothing to configure at run-time or compile-time, everything > should work automatically and transparently. > > Hmm, unless you build a completely static client library with no support > for dlopen(). > > Regards, > Sergei >

2 1

[Maria-discuss] New Question: 100% RAM and Swapping
by AskMonty KB 05 Jun '13

05 Jun '13

Hello, A new question has been asked in "MariaDB community" by danezpz: -------------------------------- Hi, Having recently converted our cPanel servers from MySQL to MariaDB we're having issues with MariaDB using 100% of a servers RAM and swap when a customer optimises a table. This doesn't happen under normal circumstances and only when an optimize is run. Any ideas what's cause this? The servers have 16GB RAM and use the following my.cnf: http://paste2.org/P3cZzBHN Using MariaDB 5.5.30 Any help would be appreciated Thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/100-ram-and-swapping/

1 0

[Maria-discuss] New Question: Schema Missing after upgrading from MySQL 5.5.8 to MariaDB 5.5.31
by AskMonty KB 05 Jun '13

05 Jun '13

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by reustmd: -------------------------------- My OS is Windows 7 64-bit. I used the MariaDB msi installer. I uninstalled MySQL and installed MariaDB. I then launched sqlyog and it only found the standard mysql schemas (e.g., information_schema, mysql, performance_schema). My application schema appears to be missing. I also tried running "mysql_upgrade --verbose" and that didn't seem to help. Should I have to do something else? Thanks! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/schema-missing-after-upgrading-from-mysql-558-to-…

1 0

Re: [Maria-discuss] Clear-text plugin
by Peter Laursen 04 Jun '13

04 Jun '13

We have the same problem. We cannot test either. But we have a few user reports. We will discuss what we can do. Is there any parameter or compile-time option we should be aware of? Any specific documentation somewhere? Anything? -- Peter On Tue, Jun 4, 2013 at 2:19 PM, Sergei Golubchik <serg(a)mariadb.org> wrote: > Hi, Peter! > > On Jun 04, Peter Laursen wrote: > > For clarity: a 'dummy' parameter doing nothing does not solve our > > problem. We actually want to build clients that can (also) connect to > > Oracle MySQL Enterprise servers configured to make use of Oracle's PAM > > implementation. > > We build and distribute a cleartext plugin. And it can be used if the > server requests. In a sense, in MariaDB a cleartext plugin is always > enabled. So a dummy option is needed only to restore the binary protocol > compatibility. That's my understanding, at least, but I don't have > Oracle's PAM plugin, so I cannot test it. > > But if you have verified that your client with our C connector can not > connect to Oracle MySQL Enterprise server with the Oracle's PAM > implementation - please submit a bug report, and we will fix it. > > Regards, > Sergei > >

1 0

Re: [Maria-discuss] Clear-text plugin
by Peter Laursen 04 Jun '13

04 Jun '13

For clarity: a 'dummy' parameter doing nothing does not solve our problem. We actually want to build clients that can (also) connect to Oracle MySQL Enterprise servers configured to make use of Oracle's PAM implementation. -- Peter On Tue, Jun 4, 2013 at 11:05 AM, Peter Laursen <peter_laursen(a)webyog.com>wrote: > yes .. in the Connector/C. We use C/C++ for both SQLyog and MONyog. > > -- Peter > > > On Tue, Jun 4, 2013 at 10:17 AM, Sergei Golubchik <serg(a)mariadb.org>wrote: > >> Hi, Peter! >> >> On Jun 04, Peter Laursen wrote: >> > This is a continuation of >> > https://mariadb.atlassian.net/browse/CONC-25. We requested support for >> > the clear-text plugin (or a workaround of any kind) that would allow a >> > client compiled with the MariaDB connector to use PAM authentication >> > with MySQL Enterprise servers from Oracle. >> >> Another related issue is https://mariadb.atlassian.net/browse/MDEV-4574 >> which should be fixed in 5.5.32, next 5.5 release. >> >> But you, probably, want it in Connector/C, don't you? >> >> Regards, >> Sergei >> >> >

1 0

[Maria-discuss] Clear-text plugin
by Peter Laursen 04 Jun '13

04 Jun '13

This is a continuation of https://mariadb.atlassian.net/browse/CONC-25. We requested support for the clear-text plugin (or a workaround of any kind) that would allow a client compiled with the MariaDB connector to use PAM authentication with MySQL Enterprise servers from Oracle. I will not dispute Sergei's opinions about Oracle's implementation. But I believe it misses the point. The question is if the MariaDB connector should be a replacement for the C-IPA from Oracle. And the question is nothing else than that. Not the quality of solutions bundled with Enterprise servers from Oracle. I would like to hear opinions not only from 'core developers' like Sergei, but also from wider circles in MariaDB organization (management, marketing) as well as the user community. For us the problem is like this: We introduced support for the clear-text plugin in SQLyog 11.1. In 11.12 beta2 we replaced Oracles connector with MariaDB (and had to removed it again). We had a few crashes and memory leaks with mariaDB Connector but that is getting in control now (ther were bugs in both the API and in oru code). We probably could patch the MariaDB code without much problems to support the full-text plugin - but we don't have a MySQL Enterprise server to test with and we cannot release without proper testing. We have already started getting complaints from users/customers about that what we introduced in 11.1 has been removed in current development tree. It seems that we have quite a lot of customers using Oracle's Enterprise servers wiht Oracle's PAM authentication. A solution/workaround would very much be appreciated. Regards Peter Laursen Webyog

1 0

[Maria-discuss] New Question: Netbeans 7.3 + Hibernate + MariaDB Java Client + MySQL database
by AskMonty KB 30 May '13

30 May '13

Hello, A new question has been asked in "MariaDB Java Client" by mr_lou_d: -------------------------------- Although I can access the database through Netbeans using this driver and MySQL database, I am having difficulty getting Hibernate to work with the driver. Hibernate.cfg file has these entries: <property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306 /myspecial?zeroDateTimeBehavior=convertToNull [MariaDB - root on myspecial]</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> Note that the Hibernate plugin can't seem to find (doesn't have) any valid dialects for the mariadb driver. Therefore I edited the above xml to force MySQLDialect. This allowed me to get a little further, but when I try to create new "Hibernate mapping files and pojos from database", I fill in the dialog - but no files are generated. When I follow the same steps with the MySQL Java "Connector", including the same hibernate.reveng, it generates the pojos, and all works fine. Thanks for taking a look at this... Any ideas? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/netbeans-73-hibernate-mariadb-java-client-mysql-d…

1 0