- discuss - lists.mariadb.org

[Maria-discuss] Creating MySQL .MYD, .MYI and .frm tables in Maria
by Carl Whalley 25 Nov '15

25 Nov '15

This is the final stage from my thread regarding a botched F22->23 upgrade which hosed bacula. I have been on to bacula support and they claim not to support Maria. Well, "not support" isn't right, just "not explicitly tested" - I know everything was ok under F22/Maria as I have another server to upgrade which runs fine now with this setup. It seems the MySQL tables were created when bacula was installed several iterations of Fedora ago, and at that time they were of the .MYD, .MYI style. Each time fedora was updated, these were carried forwards - possibly through the swap from when MySQL was native to it becoming Maria, as we see now. That's why all the existing ones are in the form with the extensions I mentioned. So, I'm now in a situation where it seems I have to create one last table ("Snapshot") and am having trouble because it somehow has been created but not in the .MYD, MYI style. The create table command is supplied already for me to enter - how can I remove the phantom one and create it again in the format the rest of the tables are in please?

2 1

[Maria-discuss] After Fedora 22->23 update maria db doesn't start
by Carl Whalley 24 Nov '15

24 Nov '15

>From the log after systemctl restart mariadb.service: InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 583845802 151124 9:51:40 [Note] Plugin 'FEEDBACK' is disabled. InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 151124 9:51:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 151124 9:51:40 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist in engine 151124 9:51:40 [Note] Server socket created on IP: '::'. 151124 9:51:40 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 151124 09:51:40 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended Trying other things [root@tiger ~]# mysqld_safe -uroot 151124 10:24:03 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. 151124 10:24:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 151124 10:24:03 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended [root@tiger ~]# mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed [root@tiger ~]#

3 11

[Maria-discuss] New Question: Verifying Mariadb 10.1 encryption
by AskMonty KB 23 Nov '15

23 Nov '15

Hello, A new question has been asked in "MariaDB Community" by markroland_g. Please answer it at http://mariadb.com/kb/en/verifying-mariadb-101-encryption/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have set up table-level InnoDB database encryption on Maria DB 10.1.8 (https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/) I'd like to know if there is any way to confirm that the data is truly encrypted. I've tried searching /var/lib/mysql/ibdata1 for sample data in the tables, but I don't know if that's a reliable test or not. * This is a re-post of a question I asked on Stack Overflow (http://stackoverflow.com/questions/33817877/verifying-mariadb-10-1-encrypti…) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/verifying-mariadb-101-encryption/

1 0

[Maria-discuss] MariaDB 10.1.9 now available
by Daniel Bartholomew 23 Nov '15

23 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.9. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.9 - Release Notes: https://mariadb.com/kb/en/mariadb-1019-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1019-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.9 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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] Problems installing MariaDB 10.1 on LEAP.
by Peter Laursen 23 Nov '15

23 Nov '15

I am facing problems installing MariaDB 10.1 on OpenSuSE LEAP (42.1) from the MariaDB repository for OpenSUSE 13. Even though built on/for SuSE 13.1 it worked fine on SuSE 13.2 as well. But not on LEAP: Please see attached screenshot from YaST (GUI) installer environment. I think that tells everything. 10.1 packages displayed here are from MariaDB repo (that registers with no problem with YaST/zypper, BTW). 10.0 and other packages displayed are from official SuSE repo. The 10.0 server from SuSE repo works fine, but I prefer 10.1 on this new VM. I am not interested in a 'hack-solution'. I can wait for a proper solution. But something (the memory allocation manager, seemingly) seems changed in OpenSuSE between-from 13.2 and LEAP creating a dependency problem with **MariaDB_from_MariaDB**. Is a new repo required to support OpenSUSE LEAP? @Daniel? -- Peter -- Webyog

2 3

[Maria-discuss] New Question: changing thelangauge of error messages in MySQL
by AskMonty KB 22 Nov '15

22 Nov '15

Hello, A new question has been asked in "SQL Language Structure" by mallika shaik. Please answer it at http://mariadb.com/kb/en/changing-thelangauge-of-error-messages-in-mysql/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi every one. I want to change MySQL error message language into Hindi. is it possible? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/changing-thelangauge-of-error-messages-in-mysql/

1 0

[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 19 Nov '15

19 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