November 2015 - discuss - lists.mariadb.org

[Maria-discuss] GRANT error - undocumented?
by Felipe Gasper 12 Nov '15

12 Nov '15

Hello, I’ve found an apparent discrepancy between MySQL 5.6 and MariaDB 10.1. When you GRANT ALL PRIVILEGES on a DB to a user/host that is not in the mysql.users table, MariaDB 10.1 throws ER_PASSWORD_NO_MATCH, whereas MySQL 5.6 creates the user/host entry. Is this by design? I don’t see the behavior discussed at https://mariadb.com/kb/en/mariadb/grant/. Thank you for your time! Below I am including the client outputs for both servers. -Felipe Gasper Houston, TX -------------------------- Server version: 10.1.8-MariaDB-log MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database fgtemp; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use fgtemp; Database changed MariaDB [fgtemp]> grant all on fgtemp.* to 'root'@'nowhere'; ERROR 1133 (28000): Can't find any matching row in the user table MariaDB [fgtemp]> -------------------------- Server version: 5.6.27-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database fgtemp; Query OK, 1 row affected (0.00 sec) mysql> use fgtemp; Database changed mysql> grant all on fgtemp.* to 'root'@'nowhere'; Query OK, 0 rows affected (0.05 sec) --------------------------

4 5

Re: [Maria-discuss] Donating during the downloads
by Federico Razzoli 12 Nov '15

12 Nov '15

If you are talking about donations to the foundation (not the company) I agree that it's a great idea. If small donations are welcome, many people will probably donate (and I'm one of them). Just a hint: maybe you could even advertise merchandising in the download page. Regards Federico -------------------------------------------- Gio 12/11/15, Stephane VAROQUI <stephane(a)mariadb.com> ha scritto: Oggetto: Re: [Maria-discuss] Donating during the downloads A: "Colin Charles" <colin(a)mariadb.org> Cc: "Maria Discuss (maria-discuss(a)lists.launchpad.net)" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 12 novembre 2015, 09:06 Hi Colin! Indeed that's an excellent idea for the foundation.Would enjoy an online shop for market place (maxscale commercial modules), rdba credits, foundation donations . /stephane Stéphane Varoqui, Senior ConsultantPhone: +33 695-926-401, skype: svaroquihttp://www.mariadb.com Le Nov 12, 2015 à 7:28 AM, Colin Charles a écrit : Hi, Today I downloaded Ubuntu and saw this awesome page for donations. Do you think we should do this for the MariaDB Server / Connectors / etc. so that the MariaDB Foundation gets funded as well? I know that even LibreOffice has done this (http://donate.libreoffice.org/) We should consider this. Otto, what do you think? -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot <Contribute_to_Ubuntu___Ubuntu___Ubuntu.png>_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

1 0

[Maria-discuss] doubt with thread pool
by Roberto Spadim 11 Nov '15

11 Nov '15

i'm with a doubt if i have a thread pool with 1000 threads and a max_connections with 100 connections can i have more than 100 clients connected (1000 threads for example)? dos thread pool size limit the max connections, or max connections limite the thread pol size? -- Roberto Spadim

4 7

[Maria-discuss] TokuDB + virtual column
by Roberto Spadim 09 Nov '15

09 Nov '15

Hi guys, there's a plan to include virtual column to tokudb storage? /* Erro SQL (1910): TokuDB storage engine does not support computed columns */ thanks -- Roberto Spadim

3 4

[Maria-discuss] New Question: Install problem on Mac OSX 10.10.2
by AskMonty KB 09 Nov '15

09 Nov '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by 7stud. Please answer it at http://mariadb.com/kb/en/install-problem-on-mac-osx-10102/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I would love to switch to MariaDB, but over the last year I've tried installing it twice on different versions of Mac OSX and failed. I don't use Homebrew because generally it causes more problems than installing from source. So, I followed the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install: **MariaDB 10.1.8**\\ on **Mac OSX 10.10.2 **\\ with **Xcode 6.3.2**\\ {{{ $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake). $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:191:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:222:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:423:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:452:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:465:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:552:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:576:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:592:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:617:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:616:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:652:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:651:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:703:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:811:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:864:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:921:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:969:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1007:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1101:3: error: cannot use 'try' with exceptions disabled try { ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. make[2]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/dat.cpp.o] Error 1 make[1]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/all] Error 2 make: *** [all] Error 2 }}} -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/install-problem-on-mac-osx-10102/

1 0

[Maria-discuss] New Question: I would love to switch to MariaDB, but over the last year I've tried installing it twice on different versions of Mac OSX and failed.
by AskMonty KB 08 Nov '15

08 Nov '15

Hello, A new question has been asked in "Downloads" by 7stud. Please answer it at http://mariadb.com/kb/en/i-would-love-to-switch-to-mariadb-but-over-the-las… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I don't use Homebrew because it causes more problems than installing from source. So I followed the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install on Mac OSX 10.10.2 with Xcode 6.3.2: $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake). $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:191:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:222:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:423:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:452:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:465:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:552:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:576:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:592:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:617:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:616:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:652:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:651:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:703:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:811:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:864:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:921:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:969:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1007:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1101:3: error: cannot use 'try' with exceptions disabled try { ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. make[2]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/dat.cpp.o] Error 1 make[1]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/all] Error 2 make: *** [all] Error 2 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-would-love-to-switch-to-mariadb-but-over-the-las…

1 0

[Maria-discuss] Compiling maxscale
by Justin Swanhart 08 Nov '15

08 Nov '15

Hi, When I try to compile maxscale, the classifier won't compile because it needs server headers. How do I tell it where to find the source. It uses multiple headers in multiple directories so adding the server source via a simple -I to CXXFLAGS doesn't work. Am I missing something? Sent from my iPhone

2 2

[Maria-discuss] Bad file descriptor mariadb 10.1.
by joao＠7lan.net 07 Nov '15

07 Nov '15

Hi List, Sometimes, my mysqld daemon begin to consumes 100% the connection to the server gets unstable and I get flooded in the mysql error log with these messages: Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor it only stops when I restart the daemon, no query is shown in "show full processlist". Maybe some kernel adjustment? Any ideia? Running centos 7 at the lastest version. [root@db1 scripts]# yum -y update Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: ftpmirror.your.org * epel: mirror.nexcess.net * extras: ftpmirror.your.org * updates: mirrors.lga7.us.voxel.net No packages marked for update [root@db1 scripts]# rpm -qa|grep -i MariaDB MariaDB-shared-10.1.8-1.el7.centos.x86_64 MariaDB-client-10.1.8-1.el7.centos.x86_64 MariaDB-common-10.1.8-1.el7.centos.x86_64 MariaDB-server-10.1.8-1.el7.centos.x86_64 Thanks! João Reis.

4 5

[Maria-discuss] New Question: Downgrade MariaDB
by AskMonty KB 04 Nov '15

04 Nov '15

Hello, A new question has been asked in "Upgrading MariaDB" by areno. Please answer it at http://mariadb.com/kb/en/downgrade-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I recently upgraded MariaDB 10.0.21 to 10.1.8. Our program that interacts with it is tossing errors and we found out it's not supported by the program. We were directed from the application dev team to install 10.0.21 back. I cannot find any documentation on how to properly downgrade the DB and move the data to an older version. Any specific process to follow? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/downgrade-mariadb/

1 0

[Maria-discuss] LOAD FILE and BIT datatype
by Roberto Spadim 03 Nov '15

03 Nov '15

hi guys, how could i send bit data to mysql with LOAD FILE? a table example: create table t (i bit not null default 0); LOAD DATA LOCAL INFILE "file.csv" IGNORE INTO TABLE `t` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' (i) the data file is simple: 0 1 0 1 0 1 but i got Warning 1024: Out of range value for column 'i' at row 1 ... to last row any idea? i tried b'0' b'1' '0' '1' 0 1 but no one work, i don't know what happen but it's cast always to 1 (maybe convert from string to binary?)

2 12