- discuss - lists.mariadb.org

[Maria-discuss] New Question: Mariadb refuses to stay confined to install directory
by AskMonty KB 29 Nov '13

29 Nov '13

Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: -------------------------------- I've been struggling with this off and on for weeks. I need a contained MariaDB install running in the home directory. My most recent attempt (and what would be my preferred method) is compiling from source. No matter what I do though MariaDB insists on trying to create /var/run/mysqld/mysqld.sock on every run and fails. I compiled it from source with --prefix pointing to my home directory. I ran mysql with --basedir and --defaults-file. The defaults-file I used contains the location of my mysql.sock file in the home directory but MariaDB will not use it. I even tried recompiling with --exec-prefix as per the MySQL 5.5 documentation but this screws the entire installation up, causing MariaDB to recreate the entire prefix path from root underneath src/efix=/ where I'm storing the source while I install. Here is my configure options: ##./configure --prefix=/home/user/web/servers/mariadb --enable-assembler \ --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \ --with-plugin-maria --with-aria-tmp-tables --without-plugin-innodb_plugin --without-plugin=tokudb \ --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-readline \ --with-ssl --with-plugins=max-no-ndb --with-embedded-server --with-libevent \ --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static \ --with-zlib-dir=bundled --enable-local-infile## And here is what happens when I try to launch MariaDB: ##$ bin/mysqld_safe --basedir=/home/user/web/servers/mariadb --defaults-file=/home/user/web/servers/mariadb/my.cnf 131128 16:20:20 mysqld_safe Logging to '/home/user/web/servers/mariadb/log/error.log'. mkdir: cannot create directory ‘/var/run/mysqld’: Permission denied Fatal error Can't create database directory '/var/run/mysqld/mysqld.sock'## My socket file is specific in the given my.cnf file as /home/user/web/servers/mariadb/run/mysql.sock No matter what I do I can't get MariaDB to behave and run in user land. What am I doing wrong? I've tried the Linux binaries with slightly more success but I still felt like I was fighting the server to get it to read files from the correct location. I'd like to have it compiled from source though and it *should* be easier this way since I can specify a prefix. How can I get MariaDB to follow the set prefix for all files? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-refuses-to-stay-confined-to-install-direct…

1 0

[Maria-discuss] plans for MDL
by MARK CALLAGHAN 28 Nov '13

28 Nov '13

Do you have any plans for MDL in MariaDB 10+ that might do something better for workloads that need to do some DDL concurrent with some long-running SELECT statements? https://www.facebook.com/MySQLatFacebook/posts/10151939557456696 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[Maria-discuss] New Question: Build fails at "Linking CXX executable tdb-recover"
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: -------------------------------- I'm trying to compile MariaDB on Ubuntu 13.10. I've followed all the directions here on the KB in regards to compiling. I meet all the package requirements listed. This is the output where make fails: Linking CXX executable tdb-recover cd /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft && /usr/bin/cmake -E cmake_link_script CMakeFiles/tdb-recover.dir/link.txt --verbose=1 /usr/bin/c++ -std=c++11 -Wall -Werror -Wcast-align -Wshadow -Wmissing-format-attribute -Wpointer-arith -Wmissing-declarations -Wno-missing-noreturn -Wextra -Wno-error=strict-overflow -Wpacked -fno-exceptions -fno-rtti -Wno-error=missing-format-attribute -Wmissing-format-attribute -Wlogical-op -Wtrampolines -Wswitch -Winit-self -Wstrict-null-sentinel -Wno-missing-field-initializers -Wall -Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -fimplicit-templates -flto -fuse-linker-plugin -O2 -g -DNDEBUG -DDBUG_OFF -g -O3 -UNDEBUG -g -fuse-linker-plugin -Wno-error=strict-overflow CMakeFiles/tdb-recover.dir/tdb-recover.cc.o -o tdb-recover -lpthread libft_static.a ../util/libutil_static.a ../../../../zlib/libzlib.a .././xz/lib/liblzma.a ../portability/libtokuportability_static.a -lpthread -ldl -lrt /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc: In function ‘ft_leaf_run_gc’: /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc:2261:26: error: ‘leaf_entry’ may be used uninitialized in this function [-Werror=maybe-uninitialized] if (leaf_entry->type != LE_MVCC) { ^ lto1: all warnings being treated as errors lto-wrapper: /usr/bin/g++-4.8.real returned 1 exit status /usr/bin/ld.bfd.real: lto-wrapper failed collect2: error: ld returned 1 exit status Pastebin for easier reading: http://pastebin.com/wGzHpD2p I'm using the default compile option list posted here: https://mariadb.com/kb/en/generic-build-instructions/ The only thing I've changed is the prefix. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/build-fails-at-linking-cxx-executable-tdb-recover/

1 0

[Maria-discuss] New Question: Link MariaDB Client Library for C with specific external zlib and openssl
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "MariaDB Client Library for C" by trsystran: -------------------------------- Hi, I am trying to link the mariadb client library with zlib and openssl which are neither embedded in mariadb (for zlib), nor the one available on the system: I want to force cmake to use zlib and openssl from a given path. How can I do that? Is there another way than creating my own FindZLIB.cmake and force it via CMAKE_MODULE_PATH ? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/link-mariadb-client-library-for-c-with-specific-ex…

1 0

[Maria-discuss] New Question: SphinxSE gone from MariaDB 10.0.6?
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "Development" by robertmedeksza: -------------------------------- I recently ran apt-get upgrade and this updated my MariaDB 10.0.4 to 10.0.6. After the update the SphinxSE engine is gone and my Sphinx tables no longer function. How can I get SphinxSE back and can this be fixed in 10.0.7? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sphinxse-gone-from-mariadb-1006/

1 0

[Maria-discuss] mariadb galera msvc
by Yann Nayn 25 Nov '13

25 Nov '13

Hi this is my first post to this list I just setup a github repository with version 5.5.33.a compiling version using msvc 1600 at: https://github.com/YannNayn/mariadb-galera-msvc any tests and suggestions are welcome

2 4

[Maria-discuss] Table Change notification to all Clients?
by SARTrack Admin 21 Nov '13

21 Nov '13

I develop a Windows application for Search and Rescue (using Delphi and MyDAC components), which gets a stream of "APRS" data packets, up to 10 per second. These are saved in the SQL database, but all Clients which are connected to the database MUST be notified when a Table change has occured, so that they then can update their internal tables. Which in turn update their Maps (GPS location of moving items) and other data, which MUST be up-to-date. Currently I am having all Clients polling the database every 5 seconds, which really sucks, and causes all kinds of other problems. Is there any chance that MariaDB will have some kind of Client Notification system when a Table has changed, as some other SQL databases seem to have? Thanks Bart Kindt SARTrack Limited http://www.sartrack.co.nz/ -- SARTrack Developer and CEO

6 5

[Maria-discuss] MariaDB 5.5.34 now available
by Daniel Bartholomew 21 Nov '13

21 Nov '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.34. This is a Stable (GA) maintenance (bug fix) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.34 - Release Notes: https://mariadb.com/kb/en/mariadb-5534-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5534-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.34 About MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has had several MariaDB focused Webinars recently, including one about MariaDB 10.0 that was held earlier today. It and the other MariaDB webinars are (or will be, in the case of the one held today) available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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 or my.ini file! See http://mariadb.com/kb/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 the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/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 Knowledge Base - http://mariadb.com/kb

4 5

[Maria-discuss] MariaDB 10.0.6 Beta now available
by Daniel Bartholomew 18 Nov '13

18 Nov '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.6. This is a Beta release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0 Beta Blog Posts - https://blog.mariadb.org/mariadb-10-0-6-now-available/ - https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/ MariaDB 10.0.6 Beta - Release Notes: https://mariadb.com/kb/en/mariadb-1006-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1006-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.6 About MariaDB 10.0: https://mariadb.com/kb/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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://mariadb.com/kb/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://mariadb.com/kb/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 Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Maria DB 10.0 Roles Usage
by Adam Scott 13 Nov '13

13 Nov '13

Roles are supported according to ( https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/) So the following commands worked: create role read_only;grant select on example.* to read_only;grant usage on example.* to read_only; grant select on example.* to app_report@'localhost';When i logged in as app_report, show databases did not show the example database. And selects against tables in the example database did not work. What am I missing? Thanks, Adam C. Scott

4 4