- discuss - lists.mariadb.org

[Maria-discuss] per session query rewrite?
by James Leu 21 Nov '15

21 Nov '15

Hello, I've recently discovered the QueryRewrite plugin. I was wondering if there was any thought, or active work on making the rewrite rules associated with a connection/session. If there is not any active work on this, would the community find this useful? If so I would be willing to start development towards it. Any guidance would be greatly appreciated. -- James R. Leu jleu(a)mindspring.com

2 1

[Maria-discuss] New Question: Plugin DLL not working in Windows Server 2012 R2
by AskMonty KB 21 Nov '15

21 Nov '15

Hello, A new question has been asked in "MariaDB Community" by plcfischer. Please answer it at http://mariadb.com/kb/en/plugin-dll-not-working-in-windows-server-2012-r2/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a modified version of lib_mysqludf_sys (limits the programs that can be run). On Windows 7 Ultimate SP 1 64 bit) it works just fine. On Windows Server 2012 R2 I get: ERROR 1126 (HY000): Can't open shared library 'mysql_UDF.dll' (errno: 2, The specified module could not be found. Following is more information: /-------------------------------------------------------------------------------------------------------------------------------------------------------------------- C:\Program Files\MariaDB 10.1\lib\plugin>dir /q *.dll Volume in drive C has no label. Volume Serial Number is 1EBA-5D2D Directory of C:\Program Files\MariaDB 10.1\lib\plugin . . . 10/15/2015 04:42 PM 48,456 NT AUTHORITY\SYSTEM metadata_lock_info.dll 11/19/2015 06:46 PM 44,032 NT AUTHORITY\SYSTEM mysql_UDF.dll 10/15/2015 04:42 PM 48,456 NT AUTHORITY\SYSTEM query_cache_info.dll . . . 19 File(s) 5,186,832 bytes 0 Dir(s) 338,428,325,888 bytes free C:\Program Files\MariaDB 10.1\lib\plugin>mysql -h 127.0.0.1 -u root -p Enter password: ********* Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 10.1.8-MariaDB mariadb.org binary distribution 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 EMR; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> CREATE FUNCTION sys_exec RETURNS int SONAME 'mysql_UDF.dll'; ERROR 1126 (HY000): Can't open shared library 'mysql_UDF.dll' (errno: 2, The specified module could not be found. ) MariaDB [(none)]> show variables like '%plug%'; +-----------------+-------------------------------------------+ | Variable_name | Value | +-----------------+-------------------------------------------+ | plugin_dir | C:\Program Files\MariaDB 10.1\lib\plugin\ | | plugin_maturity | unknown | +-----------------+-------------------------------------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> --------------------------------------------------------------------------------------------------------------------------------------------------------------------/ I tried mysql version 5.7.9 and have the same error. Any ideas? Thanks, Charles Fischer -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/plugin-dll-not-working-in-windows-server-2012-r2/

1 0

[Maria-discuss] Connect Engine with ODBC
by Bruce Carlson 20 Nov '15

20 Nov '15

Hi, I've been experimenting with the new Connect engine and the ODBC table type. I've installed MariaDB 10.1.17 on a test machine. I have an ODBC diver connected to a C-ISAM database. I am able to use this ODBC to connect from a MS Access 2013 database and despite some restrictions related to the C-ISAM DB it works well I have also been able to connect successfully from MariaDB and create connect tables. The only issue I'm having with the ODBC table type is the lack of indexes. However, I have noticed that in the MariaDB documentation accessible from https://mariadb.com/kb/en/mariadb/connect-table-types-odbc-table-type-acces… there is a note :- "Version 1.04 (from MariaDB 10.1.6<https://mariadb.com/kb/en/mariadb-1016-release-notes/>) adds remote indexing facility to the ODBC table type." As I've now installed 10.1.17 on my test machine, would someone be able to provide more information on the status of remote indexing, how it works and on how I may be able to make use of this? I am using HeidiSQL (Vers. 9.1.0.4867) as a front end tool and when I try to create indexes for the connect tables I get a message "SQL Error (1105): Table type ODBC is not indexable". Kind Regards, Bruce Carlson

3 6

[Maria-discuss] New Question: Error exporting from MySQL to MariaDB
by AskMonty KB 19 Nov '15

19 Nov '15

Hello, A new question has been asked in "MariaDB Documentation" by jayres. Please answer it at http://mariadb.com/kb/en/error-exporting-from-mysql-to-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am attempting to move a wordpress db from a server running MySQL to one running MariaDb. It stops and throws this error: 2 errors were found during analysis. Ending quote ' was expected. (near "" at position 16695) 4 values were expected, but found 3. (near "(" at position 16587) SQL query: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''<a href="/locations/about/" class="right-side-footer-link">About Us</a>&nbsp' at line 116 Apparently that is within this line in the db: (405, 'woo_footer_right_text', '<a href="/locations/about/" class="right-side-footer-link">About Us</a>   <a href="/contact/" class="right-side-footer-link">Contact Us</a>   <a href="/appointments-bill-pay/medical-forms/" class="right-side-footer-link">Medical Forms</a><br /><a href="/legal/" class="right-side-footer-link">Legal</a>   <a href="/sitemap/" class="right-side-footer-link">Sitemap</a>   <a href="/professionals/partner-links/" class="right-side-footer-link">Partner Links</a>   <a href="https://access.domain.com/+CSCOE+/logon.html" class="right-side-footer-link" target="_blank">PACS Login</a>', 'yes'), Is it the multiple non-breaking space codes? Do I need to escape them (and how to escape them for MariaDb) or replace them (if so, with what?) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-exporting-from-mysql-to-mariadb/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.22 and updated connectors now available
by Daniel Bartholomew 19 Nov '15

19 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.22, MariaDB Connector/C 2.2.1, and MariaDB Connector/J 1.3.1. All of these are Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.22-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10022-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10022-changelog/ - Downloads: http://downloads.mariadb.org/mariadb-galera/10.0.22 - About MariaDB Galera Cluster: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ MariaDB Connector/Java 1.3.1-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-connector-j-131-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-connector-j-131-changelog/ - Downloads: https://downloads.mariadb.org/connector-java/1.3.1/ - About MariaDB Connector/J: https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.2.1-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-connector-c-221-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-connector-c-221-changelog/ - Downloads: http://downloads.mariadb.org/connector-c/2.2.1/ - About MariaDB Connector/ODBC: https://mariadb.com/kb/en/about-mariadb-connector-c/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/ We hope you enjoy MariaDB! -- MariaDB 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: Install Maria DB Audit plugin to mysql
by AskMonty KB 19 Nov '15

19 Nov '15

Hello, A new question has been asked in "MariaDB Community" by udara_ranawakaarachchi_g. Please answer it at http://mariadb.com/kb/en/install-maria-db-audit-plugin-to-mysql/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi I tired to installed maria db audit plugin to mysql community server 5.7.I used below command to install plugin to database. Command INSTALL PLUGIN server_audit SONAME 'server_audit.so' However I received below error message. Error 1126(HY000):Can't open shared library sr/lib64/mysq;/plugin/server_audit.so' (errorno:2 /usr/lib64/nysql/plugin/server_audit.so: undefined symbol:safe_mutex_lock) Pls let me know how to overcome above issue. Thank -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/install-maria-db-audit-plugin-to-mysql/

1 0

[Maria-discuss] New Question: Using MariaDB on Linux from C++ ODBC
by AskMonty KB 18 Nov '15

18 Nov '15

Hello, A new question has been asked in "MariaDB Connector/C" by jimbrownsmart. Please answer it at http://mariadb.com/kb/en/using-mariadb-on-linux-from-c-odbc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is the connector what I need to use ODBC from C++ on opensuse 13? It would be great if you could point me to a document that says how to get mariadb set up so I can contact it with ODBC from C++ I extacted mariadb-connector-c-2.2.1-linux-x86_64 but I don't know what to do next. mariadb_config has a bunch of options.but I can't find any documentation. I have installed already these: MyODBC-unixODBC; unixODBC; mariadb; mariadb-client; mariadb-errormessages. odbc.ini is empty odbsinst.ini only has postgreseql which is my backup if I can't get mariadb to work. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/using-mariadb-on-linux-from-c-odbc/

1 0

[Maria-discuss] Replication to galera cluster
by Igor Mazur 18 Nov '15

18 Nov '15

Hi, I've tried to setup replication from production MariaDB (lets name proddb) to a data warehouse on Galera cluster (dw1, dw2 and dwarbitrator - last is a node with garb). Made master-slave link between proddb and dw1. And on dw1 I have actual data, but they are not updated on dw2. Other schemas successfully transfer their updates between dw1 and dw2 as required. Looks like only difference that other schemas are updated with direct requests to dw1 and dw2, and replicated schema is updated only through replication. Does anyone have experience with a similar configuration? Igor

2 2

[Maria-discuss] New Question: Buffer size issue?
by AskMonty KB 18 Nov '15

18 Nov '15

Hello, A new question has been asked in "General FAQ" by Bytesmiths. Please answer it at http://mariadb.com/kb/en/buffer-size-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a query that returns a string considerably longer than 1024 characters. It was working properly in MariaDB 5.1. I have upgraded to 10.1.8, and it appears that the query return is being truncated at 1024 characters. I see this behaviour in three separate tools, including php mysql calls, phpMyAdmin, and the mysql command line tool. (It was the mysql CLI, piped to wc, that told me that exactly 1024 characters were being sent, but no more.) Assuming this is not a bug, but rather some variable to be tweaked, can someone point me in the right direction? Thanks in advance! BTW: Here is the query, which has not changed since it was written in 5.1: <pre>SELECT GROUP_CONCAT(DISTINCT '<a href="/wiki/', p.family, '" title="', f.explanation, '">', p.family, '</a>' ORDER BY p.family SEPARATOR ', ') FROM s_plants p LEFT JOIN s_plant_families f ON p.family = f.family</pre> This query basically returns a string containing a long list of plant family names, wrapped in HTML links. This is what I get back: <pre><a href="/wiki/Agavaceae" title="Agave family">Agavaceae</a>, <a href="/wiki/Aizoaceae" title="Fig-Marigold or Ice Plant family">Aizoaceae</a>, <a href="/wiki/Alliaceae" title="Onion and Garlic family">Alliaceae</a>, <a href="/wiki/Amaranthaceae" title="Amaranth family">Amaranthaceae</a>, <a href="/wiki/Anacardiaceae" title="Cashew or Sumac family">Anacardiaceae</a>, <a href="/wiki/Apiaceae" title="Celery or Carrot family, formerly Umbelliferae">Apiaceae</a>, <a href="/wiki/Apocynaceae" title="Periwinkle family">Apocynaceae</a>, <a href="/wiki/Araliaceae" title="Ginseng family">Araliaceae</a>, <a href="/wiki/Asteraceae" title="Daisy family, formerly Compositae">Asteraceae</a>, <a href="/wiki/Boraginaceae" title="Forget-me-Not family">Boraginaceae</a>, <a href="/wiki/Brassicaceae" title="Cabbage family, formerly Cruciferae">Brassicaceae</a>, <a href="/wiki/Campanulaceae" title="Bellflower Family">Campanulaceae</a>, <a href="/wiki/Caprifoliaceae" title="Honeysuckle family" >Caprifoliaceae</a>, <a href="/wiki/Car</pre> That last link with the open quote in the open anchor tag sure plays havoc with the rest of the page... :-) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/buffer-size-issue/

1 0

[Maria-discuss] (no subject)
by 林澤宇 17 Nov '15

17 Nov '15

Hi guy, I have two database server used the Replication + MHA + MaxScale . When the master(mdb1) went down ,I had select "show slave status" on slave(mdb2) , the slave database show "No query specified". So I can sure the slave database was be a master database. I had used maxscale commad "list servers" to show servers status : that show the mdb1 was down and mdb2 was runnung . But I can't connect to mysql via Maxscale, I got an error message : failed to create new session . How to use the Maxscale in two server replication ? The minimum database server node of MaxScale are 3 servers ?

1 0