October 2015 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB Galera Cluster Wrsep not ready
by Bertrand Caplet 24 Oct '15

24 Oct '15

Hi all, I have a galera cluster of 4 MariaDB server and sometimes a node fail. But when a node fail, others nodes doesn't want to respond to query. I have in log : "MYSQL: query failed: WSREP has not yet prepared node for application use" It's really embarrassing, because it happen like once a week. Is there a parameter to modify to get this working even when split brain ? Like If 2 of the 4 server are ok, I can still make query ? Thanks in advance, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

2 2

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

24 Oct '15

Thanks for the feedback, Kolbe. On 10/23/2015 06:41 PM, Kolbe Kegel wrote: > I find the use of environment variables to hold passwords to be a really troubling feature of the way many Docker images are built and used. I agree this is not a very good solution and we need to come up with something better, that will also work in kubernetes. If anybody knows about something handy, I'd be glad to hear about it. So far, we've just used what other images do, which is not ideal at all. > In an environment where Docker linking is not used, perhaps the environment variable problem is somewhat less severe. But I'm really troubled by this statement: > > "Changing database passwords through SQL statements or any way other than through > the environment variables aforementioned will cause a mismatch between the > values stored in the variables and the actual passwords. Whenever a database > container starts it will reset the passwords to the values stored in the > environment variables." > > That sounds to me like a security catastrophe. In cases user cares about keeping the container password unknown to other containers and docker daemon itself, the stack can be initialized with some init-only root password and changed afterwards. If I understand what your concern is, it's the reset of the password, right? I guess we may change that behavior to not do anything if password is not set and data directory is already initialized. Is it something what would help here from your point of view? Honza > Kolbe > >> On Oct 22, 2015, at 11:26 PM, Honza Horak <hhorak(a)redhat.com> wrote: >> >> 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 >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >

2 1

[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 23 Oct '15

23 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