- discuss - lists.mariadb.org

[Maria-discuss] mysql_install_db.exe failing on Dutch Windows Machine(s) on some Folders
by Derek R Magee 23 Oct '15

23 Oct '15

Hi, I'm trying to debug a mariadb failure on a machine in Holland. It seems mysql_install_db doesn't work for some folders, but does for others (e.g. c:\temp\db). We've typed exactly the same thing into the Dutch machine as my UK machine. On the UK machine it works fine, on the dutch machine it claims to work, but the mysql folder is empty on completion (and sunsequently the database doesn't start for obvious reasons). I've asked the guy in Holland to check folder write permissions on the parent folders created, and obviously the logged in user must be the owner as they are created with mkdir (see below): =========================================================== Dutch machine: =========================================================== Microsoft Windows [versie 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Alle rechten voorbehouden. C:\Users\g10031702>cd c:\ c:\>mkdir MIM c:\>cd MIM c:\MIM>mkdir MIMDB c:\MIM>cd "c:\program files\mariadb 10.1\BIN" c:\Program Files\MariaDB 10.1\bin>mysql_install_db.exe --datadir=c:/MIM/MIMDB/db --password=password Running bootstrap Creation of the database was successfull c:\Program Files\MariaDB 10.1\bin> [On exit the db sub-folder is created, as is the mysql sub-folder, but the latter is empty. N.B. We tried both 5.5 and 10.1 versions, same issue, same output.] =========================================================== UK Machine =========================================================== C:\Users\cscdrm>cd c:\ c:\>mkdir MIM c:\>cd MIM c:\MIM>mkdir MIMDB c:\MIM>cd "c:\Program Files\MariaDB 5.5\bin" c:\Program Files\MariaDB 5.5\bin>mysql_install_db.exe --datadir=c:/MIM/MIMDB/db --password=password Running bootstrap Removing default user <------- Extra Setting root password <------- Extra Creating my.ini file <------- Extra Creation of the database was successfull c:\Program Files\MariaDB 5.5\bin> [On exit the db sub-folder is created, as is the mysql sub-folder, and the lattercontains ~80 files] Has anyone got an idea how to fix this? We've seen similar things on a range of Dutch machines in the same institution where it always works if you use a sub folder of c:\temp, but other locations fail (e.g. under c:\Users, c:\). I've never seen it fail on a UK machine. Thanks a lot Derek

1 0

[Maria-discuss] CentOS Docker Container Image not only for OpenShift
by Honza Horak 23 Oct '15

23 Oct '15

For those who are interested in containers, I'd like to share a Docker image that we've produced in Red Hat in cooperation with OpenShift guys. And will be really glad for any feedback you have. The image can be used in OpenShift or run directly. But what I find really interesting is a PoC implementation of master/slave, that is not documented as official feature yet, but it can be used as simple as that: docker pull centos/mariadb-100-centos7 docker run -e MYSQL_MASTER_USER=master \ -e MYSQL_MASTER_PASSWORD=master \ -e MYSQL_DATABASE=db \ -e MYSQL_USER=user \ -e MYSQL_PASSWORD=foo \ -e MYSQL_ROOT_PASSWORD=rootpasswd \ -d centos/mariadb-100-centos7 mysqld-master docker run -e MYSQL_MASTER_USER=master \ -e MYSQL_MASTER_PASSWORD=master \ -e MYSQL_DATABASE=db \ -e MYSQL_MASTER_SERVICE_NAME=<master_ip> \ -d centos/mariadb-100-centos7 mysqld-slave More info about the image available here: https://hub.docker.com/r/centos/mariadb-100-centos7/ As said above, any feedback welcome :) Honza

1 0

[Maria-discuss] mysqldump mishandling DB name?
by Felipe Gasper 22 Oct '15

22 Oct '15

In client/mysqldump.c, there is a command: mysql_real_escape_string(mysql, db_name_buff, db, strlen(db)); … which appears to be doubling up and backslashes in the database name when the “--routines” argument is passed to mysqldump. This bug affects MySQL 5.7.9 (and back at least to 5.1); I’ve filed a MySQL bug here: https://bugs.mysql.com/bug.php?id=78932 -FG

1 0

[Maria-discuss] New Question: Where is the "Restrictions and Limitations" documentation of MariaDB?
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by openiduser59. Please answer it at http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! MySQL has the "Restrictions and Limitations" documentation section: http://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/subquery-restrictio… Where is the same section of MariaDB docs? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document…

1 0

[Maria-discuss] New Question: Unable to create after insert trigger on mariadb
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "SQL Structure and Commands" by girish2477. Please answer it at http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I followed trigger instructions from documentation. When i run the script from command line, cursor does not come back. i have to kill the execution Server version: 5.5.46-MariaDB MariaDB Server Tried various formats CREATE TRIGGER company_insert AFTER INSERT ON companyMain FOR EACH ROW INSERT INTO companytest (ID, Value) VALUES (20, CONCAT(NEW.`Code`,' - ',NEW.`Name`)); ------------ DELIMITER // DROP TRIGGER IF EXISTS company_insert ; CREATE TRIGGER company_insert AFTER INSERT ON companyMainFOR EACH ROW BEGIN DECLARE vFormatID int; SET vFormatID=20; INSERT INTO companytest (ID,Value) VALUES ( vFormatID,NEW.`Name`); END; // DELIMITER; Tried running from command directly or pass as .sql file. both ways its stuck no response back on command. Have to kill. ^CCtrl-C -- query killed. Continuing normally. ERROR 1317 (70100) at line 3: Query execution was interrupted Your help will be appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/

1 0

[Maria-discuss] CONJ SSL connection with client cert and key
by Beeton, Carolyn (Carolyn) 20 Oct '15

20 Oct '15

From: Beeton, Carolyn (Carolyn) Sent: Monday, October 19, 2015 3:39 PM To: 'maria-discuss(a)lists.launchpad.net' Subject: CONJ SSL connection with client cert and key I am using the MariaDb Connector/J to connect to a remote database which requires a client cert and key in addition to the server cert. Is there any way to configure this (similar to MySql clientCertificateKeyStoreUrl)? Thanks, Carolyn

1 0

[Maria-discuss] New Question: Please update procedures to upgrade Galera cluster from MariaDB 10.0.21/22 to MariaDB 10.1.8
by AskMonty KB 19 Oct '15

19 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by robin_anil_g. Please answer it at http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It seems like wserp replication is now part of MariaDB. I would appreciate insights into correct rolling upgrade procedure for the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster…

1 0

[Maria-discuss] Moving from Launchpad lists to something else... ?
by Colin Charles 19 Oct '15

19 Oct '15

Hi, I was speaking to Otto (CEO, MariaDB Foundation) and discussing that we should move the lists from Launchpad to something else. We obviously want to preserve the archives, and this isn’t going to happen overnight (something like an aim by the end of the year). Would you be ok with running on Google Groups? Would you prefer being on Mailman? Do you have another self-hosted or (preferably free) hosted solution as your preference? Today, we have several lists (maria-discuss, maria-developers, maria-docs) that are hosted on Launchpad. We also have a few lists (ambassadors, announce, commits, mirroring, maria-buildbot-reports) hosted on Mailman at lists.askmonty.org. Let us know what you think about this Kind Regards, Colin Charles -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

6 6

[Maria-discuss] New Question: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
by AskMonty KB 17 Oct '15

17 Oct '15

Hello, A new question has been asked in "MariaDB Community" by wraith. Please answer it at http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! Being new to MariaDB, I'm unsure if this is the correct forum to pose my question. Please forgive and forward me in the right direction if it is not :) I've recently upgraded from MySQL to MariaDB on my QNAP TS-410 server and commenced using. I've recently attempted to backup my tables and have been faced with a "Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)". I've browsed the web and the "mysql_upgrade" command is regularly touted; however, this doesn't appear to be on my TS-410. I've also attempted restarting the server via the TS-410 web interface. I approached QNAP who responded they were unable to assist. Which leads me here. Has anyone encountered a similar or same scenario? And able to provide assistance in resolving? Thanks in advance -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because…

1 0

[Maria-discuss] MariaDB version string in initial handshake
by Felipe Gasper 17 Oct '15

17 Oct '15

Hi all, I’m seeing a version string like this from the server in the initial handshake: 5.5.5-10.1.16-MariaDB Why does MariaDB negotiate with a different-format version string than MySQL? Is this documented somewhere? -FG

3 2