March 2014 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Reentrant mariadbclient on the horizon?
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by markcianfaglione: -------------------------------- I've written an test application that can be multi-threaded and I've done a bit of testing only to find that mariadbclient is not reentrant! (Oh the humanity!) I have got it to run using the reentrant library (libmysqlclient_r) for MySQL but there doesn't seem to be a similar library for mariadbclient. Is this even on the horizon? Mark -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/reentrant-mariadbclient-on-the-horizon/

2 1

[Maria-discuss] New Question: Question about testing
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by openiduser40: -------------------------------- I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mariadb.com/kb/en/mysql-test-overview gives some information + fails to give enough. Suggest docs add a full example. Something like this... 1) create a database net1# mysql_create_database --dbname=mariadb_test --dbuser=mariadb --dbpass=mariadb /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'CREATE DATABASE mariadb_test CHARACTER SET utf8 COLLATE utf8_general_ci' /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'GRANT ALL PRIVILEGES ON mariadb_test.* to 'mariadb@localhost' IDENTIFIED BY "mariadb"; FLUSH PRIVILEGES;' 2) run a test The reason I ask about this is every test I run fails. lsof shows my socket is /var/run/mysqld/mysqld.sock + here are the failures. mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES' | grep mariadb_test shows my database exists. These tests fail to connect to database... net1# mysqltest --verbose --protocol=socket --socket=/var/run/mysqld/mysqld.sock --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server (null):3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# mysqltest --verbose --host=localhost --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SELECT db,user,host FROM mysql.db WHERE db="mariadb_test"' +--------------+---------+-----------+ | db | user | host | +--------------+---------+-----------+ | mariadb_test | mariadb | localhost | +--------------+---------+-----------+ Obviously I'm missing something simple + having a complete example would help. Please update this question with all steps required to run mysqltest. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/question-about-testing/

1 0

[Maria-discuss] New Question: JSON error
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by miroigov: -------------------------------- Hello, I installed MariaDB Manager on CentOS 6.5 and when i open in browser http://domain.com:8080/MariaDBManager/ it starts loading and then displays error : API did not return JSON for: GET http://localhost/consoleAPI/api/user HTTP 500 - Errors: HTTP/1.1 500 Internal Server Error - The API is unable to function because PHP JSON functions are not available I do not have experience with Tomcat and have no idea how to set json for php. I have php 5 install and json is working fine with default config /etc/php.ini -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/json-error/

1 0

[Maria-discuss] New Question: Permanent link to download last version of MariaDB
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by francocorbelli: -------------------------------- I suggest to create permanent link to last version of a given series. Something like this https://downloads.mariadb.org/mariadb-5.5/mariadb-current-winx64.msi With best regards for a great project. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/permanent-link-to-download-last-version-of-mariadb/

1 0

[Maria-discuss] New Question: creating pivot table fails
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "CONNECT Table Types" by nobswolf: -------------------------------- I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints? MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1; ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO) MariaDB [nav]> -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/

1 0

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'
by Tanstaafl 12 Mar '14

12 Mar '14

Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of setting up SOGo groupware, amd have run into a stumbling block. Not a show stopper, but it definitely put a heavy burden on me, as the SysAdmin. SOGo can Active Directory just fine for testing Group Memberships for purposes of applying ACLs (for shared calendars, contacts, etc)... We intentionally do not use SSO - we enforce very strong email passwords, but allow much weaker AD computer passwords - so email AUTH happens with our SQL DB. The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. So, my first questions is, has anyone every come up with a decent schema that provides for managing user groups in the same way as AD groups that scales reasonably well? I'm very dangerous when it comes to this stuff, so can't even attempt this myself, but I have some options available to help get this done, especially if I can get some help/advice with getting started. One thing I do know is the SOGo guy had to create a 'View' to use, so whatever we end up using will have to work inside a View (probably displaying my ignorance to the world with that comment - is pretty much everything in an SQL DB compatible with 'Views'?)... I'd dearly appreciate any help anyone is willing to give... Thanks, Charles

3 5

[Maria-discuss] InnoDB selected projects (corrected links)
by Jan Lindström 12 Mar '14

12 Mar '14

Hi all, After careful weighting and selection process, I have selected following two projects as a starting point to improve InnoDB (1) InnoDB file space defragmentation Description: External tool to physically delete delete marked rows from InnoDB file space and freeing unused file space. https://mariadb.atlassian.net/browse/MDEV-5834 (2) InnoDB fast bulk load Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1). https://mariadb.atlassian.net/browse/MDEV-5835 Now, I hope these projects mostly represent the most frequently requested features and are most usable to current customers and/or potential new customers. Next, I would hope some indication which one of the selected project you would like to see first. Votes can be added above links. R: -- -- Jan Lindström, Principal Engineer SkySQL - The MariaDB Company MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>

1 0

[Maria-discuss] MariaDB 10.0.9 now available
by Daniel Bartholomew 10 Mar '14

10 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate (RC) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.9 - Release Notes: https://mariadb.com/kb/en/mariadb-1009-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1009-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.9 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/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are 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

1 0

[Maria-discuss] New Question: unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work
by AskMonty KB 09 Mar '14

09 Mar '14

Hello, A new question has been asked in "MariaDB community" by asifcyberdome: -------------------------------- unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work I am running FEDORA 20 and I have MySQL installed or the replacement MariaDB. same difference. I am able to do everything correcty. Everything works, except when I run the command: "systemctl enable mysqld.service", It gives me error "failed to issue method call: no such file or directory." Is this a known issue? Is this a known BUG? Is there a way to fix this? I am running Fedora 20 MySQL/MariaDB 5.5 version. Any help is greatly appreciated -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-start-mysql-server-at-boot-systemctl-ena…

1 0

[Maria-discuss] New Question: V5.5.36 will only use default data directory
by AskMonty KB 08 Mar '14

08 Mar '14

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- I installed v5.5.36 on a new Mint16 installation and it started ok. I then modified my.cnf to point to an existing data directory. I made sure that all folders and files were owned by mysql user and the mysql group had permissions to read/write. I also deleted existing files ib_logfile0/1, ibdata1 and aria_log_control as I know these must be recreated. When restarting MariaDb I get: Can't create/write to file '/home/michael/mysql/aria_log_control' (Errcode: 13). Files ib_logfile0 & 1 and ibdata1 were created ok so it is not a permissions problems. Why does only aria_log_control fail to create. If I copy all this data to default /var/lib/mysql and reset my.cnf then they work fine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/v5536-will-only-use-default-data-directory/

1 0