- discuss - lists.mariadb.org

[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

Re: [Maria-discuss] [DBD-mysql] mysql_server_prepare causes segmentation fault on execute (#44)
by Patrick Galbraith 28 May '13

28 May '13

Hi Jan, I suspect it's a server issue vs. client, since as you say mysql crashes. No client should be able to do that :) The real test, is to write a program in C against libmysql that uses the server-side prepared statement API and see if you can reproduce it there. Monty and his team definitely would want to know about the crash. Any chance you could run that with mysql running debug and capture a trace? I would want to get that to Monty and team ASAP. Regards, Patrick On May 25, 2013, at 6:02 AM, Jan Pingel <notifications(a)github.com> wrote: > I've been debugging an issue with prepared queries crashing on the 2nd execute() on my FreeBSD box with the following: > > perl-5.16.2_1 > p5-DBD-mysql-4.021 > p5-DBI-1.625 > mariadb-server-5.5.30 > After connect if I set $DB->{'mysql_server_prepare'} = 1 the first execute() works but on the 2nd one the connection is lost as mariadb/mysql crashes. If I set $DB->{'mysql_server_prepare'} = 0 after connect it works as expected. > > The prepared query is: > > our $shop::test_query = $DB->prepare("SELECT id, merchant_id, name, price, image FROM lbn_shop_products WHERE category_id = ? ORDER BY purchase_count DESC, ctime DESC LIMIT ?, ?"); > Executing the queries: > > #>print $shop::test_query->execute(11, 0, 15) > 3 > $VAR1 = 1; > > #>print $shop::test_query->execute(11, 0, 15) > Database Error: > Lost connection to MySQL server during query > File Line Subroutine > ...k/shared/lib/exceptions.pm 93 (eval) oyster::console::__ANON__ > ...ork/shared/lib/database.pm 17 exceptions::throw > ...ared/lib/oyster/console.pm 73 (eval) database::handle_error > ...ared/lib/oyster/console.pm 31 oyster::_console_execute > ...k/shared/lib/exceptions.pm 178 (eval) oyster::console::__ANON__ > ...ared/lib/oyster/console.pm 64 exceptions::try > script/console.pl 38 oyster::console::start > > ! HASH(0x7fdcf8abd5b8) > The mysql/mariadb log isn't very useful: > > 130525 08:45:41 mysqld_safe mysqld restarted > I believe this is the same issue mentioned on both of these: > http://bugs.mysql.com/bug.php?id=27421 > https://rt.cpan.org/Public/Bug/Display.html?id=83497 > > Is there any additional information that would be useful such as setting the trace level and reporting the output? > > — > Reply to this email directly or view it on GitHub. >

1 0

[Maria-discuss] Aria table with auto increment PK - no concurrent inserts?
by Dmitry Insta 27 May '13

27 May '13

Hello, Aria FAQ says: "Multiple concurrent inserters into the same table." However, if I create a table with autoincrement PK, ENGINE=Aria ROW_FORMAT=PAGE (tried also TRANSACTIONAL=1) then there is no concurrency - only 1 thread is working, others are stuck in "Waiting for table level lock". I couldn't find the exact description of Aria engine behaviour in docs/faq/discussions - is it the way it's supposed to be? Thank you!

1 0

[Maria-discuss] New Question: database password?
by AskMonty KB 27 May '13

27 May '13

Hello, A new question has been asked in "Getting Started" by TommiG: -------------------------------- Dear colleagues, is there a way to have user restrictions embedded into the database? I learned user accounts and passwords are stored as part of the DBMS, but not as part of the DB. Therefore someone could copy the physical DB-files to an memorystick, move it to another machine and with a fresh installation of MariaDB he can read and modify all data. We create a desktop application and would like to distribute a database with private information to the end users. Is there a way we can hide this information and restrict its access only by using our client application but not by any other client? Sure we could encrypt our secret data, but than the DBMS could not create inizes, constrains, etc. Thank you in advance. Best regards, Thomas Env: WinXP, Win7, Win8 -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/database-password/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mycnf/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/getting-started-mycnf/

1 0