summaryrefslogtreecommitdiff
path: root/scripts
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-18275 Live upgrade from 5.5 does not work: InnoDB stat tables are used ↵Sergei Golubchik2019-03-201-29/+13
| | | | | | | | | before creation let mysql_upgrade to work even when innodb_index_stats or innodb_table_stats are missing. (mysql_upgrade knows to ignore "unknown table" errors)
* Merge 10.3 into 10.4Marko Mäkelä2019-03-201-3/+6
|\ | | | | | | | | | | | | | | | | | | The MDEV-17262 commit 26432e49d37a37d09b862bb49a021e44bdf4789c was skipped. In Galera 4, the implementation would seem to require changes to the streaming replication. In the tests archive.rnd_pos main.profiling, disable_ps_protocol for SHOW STATUS and SHOW PROFILE commands until MDEV-18974 has been fixed.
| * Merge branch '10.2' into 10.3Sergei Golubchik2019-03-171-3/+6
| |\
| | * Merge branch '10.1' into 10.2Sergei Golubchik2019-03-151-3/+6
| | |\
| | | * MDEV-18934: Document missing mysqldumpslow sort optionsIan Gilfillan2019-03-151-3/+6
| | | |
* | | | Merge 10.3 into 10.4Marko Mäkelä2019-03-113-18/+9
|\ \ \ \ | |/ / /
| * | | Merge 10.2 into 10.3Marko Mäkelä2019-03-113-20/+11
| |\ \ \ | | |/ /
| | * | Merge 10.1 into 10.2Marko Mäkelä2019-03-114-39/+43
| | |\ \ | | | |/
| | | * remove WSREP_SST_OPT_SUFFIX_VALUE, checking [mysqld] is covered in the ↵Jan Lindström2019-03-091-3/+0
| | | | | | | | | | | | | | | | parse_cnf --mysqld case also in wsrep_sst_xtrabackup-v2
| | | * wsrep_sst: remove WSREP_SST_OPT_SUFFIX_VALUE, checking [mysqld] is covered ↵Daniel Black2019-03-093-10/+2
| | | | | | | | | | | | | | | | in the parse_cnf --mysqld case
| | | * MDEV-18830: Port SST fixes from 10.4 to 10.1Jan Lindström2019-03-091-34/+59
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | modified: mysql-test/suite/galera/disabled.def modified: mysql-test/suite/galera/r/galera_many_rows.result modified: mysql-test/suite/galera/t/galera_kill_nochanges.test new file: mysql-test/suite/galera/t/galera_many_rows.cnf modified: mysql-test/suite/galera/t/galera_many_rows.test modified: mysql-test/suite/galera/t/galera_var_dirty_reads.test modified: scripts/wsrep_sst_mariabackup.sh
* | | | mysql_install_db: make sure the variable's value is visibleSergei Golubchik2019-02-211-5/+5
| | | | | | | | | | | | | | | | | | | | move the assignment out of a function, so that it wouldn't happen in a subshell
* | | | MDEV-18297 clarify mysql_install_db help textSergei Golubchik2019-02-211-0/+10
| | | |
* | | | MDEV-7597 Expiration of user passwordsRobert Bindar2019-02-211-1/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch adds support for expiring user passwords. The following statements are extended: CREATE USER user@localhost PASSWORD EXPIRE [option] ALTER USER user@localhost PASSWORD EXPIRE [option] If no option is specified, the password is expired with immediate effect. If option is DEFAULT, global policy applies according to the default_password_lifetime system var (if 0, password never expires, if N, password expires every N days). If option is NEVER, the password never expires and if option is INTERVAL N DAY, the password expires every N days. The feature also supports the disconnect_on_expired_password system var and the --connect-expired-password client option. Closes #1166
* | | | try harder to link unix_socket plugin staticallySergei Golubchik2019-02-211-1/+1
| | | | | | | | | | | | | | | | fix unix_socket tests to work if unix_socket is a built-in
* | | | Merge branch '10.3' into 10.4Oleksandr Byelkin2019-02-213-9/+23
|\ \ \ \ | |/ / /
| * | | Merge branch '10.2' into bb-10.3-mergeOleksandr Byelkin2019-02-191-3/+5
| |\ \ \ | | |/ /
| | * | Merge branch '10.1' into 10.2Oleksandr Byelkin2019-02-191-3/+5
| | |\ \ | | | |/
| | | * 1. centos has symlinks /bin->usr/bin and /sbin -> usr/sbin,Oleksandr Byelkin2019-02-191-3/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | but even if this script called as /bin/mysql_install_db it is still standard install and scripts are in /usr/share/ (but not in the /share/) 2. fix of bindir path
| | | * MDEV-18426: Most of the mtr tests in the galera_3nodes suite failJulius Goryavsky2019-02-122-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Most of the mtr tests in the galera_3nodes suite fail for a variety of reasons with a variety of errors. This patch fixes several substantial flaws in the galera_3nodes suite tests and in the mtr framework service files, adapting the tests from galera_3nodes for the current version of MariaDB. This patch also synchronizes some galera_3nodes-related files with the latest changes made for MDEV-17835 (v2 patch) and for MDEV-18379 in other branches (10.2 and 10.3). Closes #1161
| * | | dirty mergeOleksandr Byelkin2019-02-073-9/+20
| |\ \ \ | | |/ /
| | * | Merge 10.1 into 10.2Marko Mäkelä2019-02-031-5/+16
| | |\ \ | | | |/ | | | | | | | | | | | | | | | | Temporarily disable a test for commit 2175bfce3e9da8332f10ab0e0286dc93915533a2 because fixing it in 10.2 requires updating libmariadb.
| | | * Merge 10.1 into 10.1Marko Mäkelä2019-02-021-5/+15
| | | |\ | | | | | | | | | | | | | | | This is joint work with Oleksandr Byelkin.
| | | | * Merge branch '5.5' into 10.0Oleksandr Byelkin2019-01-281-5/+14
| | | | |\
| | | | | * MDEV-14580: mysql_install_db elements based on dirname of mysql_install_dbSergei Golubchik2019-01-211-4/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Avoid introducing new dependencies or new syntax. That is, don't use $(...) and don't assume dirname is present. And remove unsighty /foo/bar/../xyz from the path. Use dirname instead of ../
| | | | | * MDEV-14580: mysql_install_db elements based on dirname of mysql_install_dbDaniel Black2019-01-211-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | Closes #1086
| | | | | * remove duplicated paragraph from mysql_install_db.shAlexander Kuleshov2019-01-161-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | Signed-off-by: Alexander Kuleshov <kuleshovmail@gmail.com>
| | * | | | MDEV-18379: IPv6 compatibility changes/Unification of check for IPv6Julius Goryavsky2019-02-022-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch contains the port of the MDEV-18379 patch for 10.2 branch, but also includes a number of changes made within MDEV-17835, which are necessary for the normal operation of tests that use IPv6: 1) Currently, the three-node mtr suite for Galera (galera_3nodes) uses a separate IPv6 availability check using the "have_ipv6.inc" file. This check duplicates a more accurate check at suite.pm level, which can be used by including the file "check_ipv6.inc". This patch removes this discrepancy between suites. 2) Fixed numerous bugs in the SST scripts and in the mtr test files (galera_3nodes mtr suite) that prevented the use of Galera with IPv6 addresses. 3) Fixed flaws in the galera_3nodes mtr suite control scripts, because of which they could not work with mariabackup. 4) Fixed flaws in the rsync and mysqldump tests (for galera_3nodes mtr tests suite). These tests were not performed successfully without these fixes. 5) GAL-501 test in the galera_3nodes suite does not contain the option "--bind-address=::" that is needed for the test to work correctly with IPv6 (at least on some systems), since without it the server will not wait for connections on the IPv6 interface. https://jira.mariadb.org/browse/MDEV-18379 and partially https://jira.mariadb.org/browse/MDEV-17835
| | * | | | Merge 10.1 into 10.2Marko Mäkelä2019-02-023-11/+34
| | |\ \ \ \ | | | |/ / /
| | | * | | MDEV-18379: Unification of check for IPv6Julius Goryavsky2019-01-263-10/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch contains the port of the MDEV-18379 patch for 10.1 branch, but also includes a number of changes made within MDEV-17835, which are necessary for the normal operation of tests that use IPv6: 1) Fixed flaws in the galera_3nodes mtr suite control scripts, because of which they could not work with mariabackup. 2) Fixed numerous bugs in the SST scripts and in the mtr test files (galera_3nodes mtr suite) that prevented the use of Galera with IPv6 addresses. 3) Fixed flaws in tests for rsync and mysqldump (for galera_3nodes mtr tests suite). These tests were not performed successfully without these fixes. 4) Currently, the three-node mtr suite for Galera (galera_3nodes) uses a separate IPv6 availability check using the "have_ipv6.inc" file. This check duplicates a more accurate check at suite.pm level, which can be used by including the file "check_ipv6.inc". This patch removes this discrepancy between suites. 5) GAL-501 test in the galera_3nodes suite does not contain the option "--bind-address=::" which is needed for the test to work correctly with IPv6 (at least on some systems), since without it the server will not wait for connections on the IPv6 interface. https://jira.mariadb.org/browse/MDEV-18379 and partially https://jira.mariadb.org/browse/MDEV-17835
* | | | | | MDEV-13095 Implement User Account lockingRobert Bindar2019-02-141-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add server support for user account locking. This patch extends the ALTER/CREATE USER statements for denying a user's subsequent login attempts: ALTER USER user [, user2] ACCOUNT [LOCK | UNLOCK] CREATE USER user [, user2] ACCOUNT [LOCK | UNLOCK] The SHOW CREATE USER statement was updated to display the locking state of an user. Closes #1006
* | | | | | bugfix: mysql_fix_privilege_tables table_schema=database()Sergei Golubchik2019-02-141-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | fix mysql_fix_privilege_tables to look for the `user` table in the correct schema when deciding whether to convert it to `global_priv` table make related tests a bit more verbose
* | | | | | MDEV-12834 mysql_secure_installation should ask about unix_socket authenticationSergei Golubchik2019-02-121-2/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Optionally, restore the default root authentication, that is mysql_native_password USING 'invalid' OR unix_socket
* | | | | | MDEV-12834 mysql_secure_installation should ask about unix_socket authenticationSergei Golubchik2019-02-121-10/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | recognize new unix_socket protected accounts, and don't scare the user into setting the password for them
* | | | | | MDEV-12484 Enable unix socket authentication by defaultSergei Golubchik2019-02-122-13/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Change the default authentication for root@localhost to IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket which provides secure passwordless login, while still allowing SET PASSWORD to work as expected. Also create a second all-privilege account for the user that owns datadir (and thus has full access to the data anyway). Compile unix_socket plugin statically into the server.
* | | | | | cleanup: remove reduntant variableSergei Golubchik2019-02-122-3/+1
| | | | | |
* | | | | | MDEV-18178 Galera test failure on galera_sst_rsync2mkaruza2019-02-081-11/+12
| | | | | | | | | | | | | | | | | | | | | | | | * Donor node will now provide binlog-index argument to wsrep_sst_rsync script if binlog is used. * Write correct path and binlog file names into joiner binlog-index file
* | | | | | Extend mariabackup archive timestamp in SST scriptmkaruza2019-02-081-2/+2
| | | | | | | | | | | | | | | | | | During parallel execution mariabackup script can fail when trying to create archive because of non unique name. Extending archive timestamp with nanosecond.
* | | | | | Fix the bug introduced in MDEV-17658Sergei Golubchik2019-02-041-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | if auth_root_socket is set, root user should be using unix_socket Followup for 4abb8216a05
* | | | | | MDEV-18119 upgrading from 10.3 to 10.4 can result in the password for a user ↵Sergei Golubchik2019-02-041-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | to be wiped ou
* | | | | | Merge 10.3 into 10.4Marko Mäkelä2019-01-251-3/+0
|\ \ \ \ \ \ | |/ / / / /
| * | | | | MDEV-18372: Minor MDEV-17973-related merge issue to 10.3Geoff Montee2019-01-241-3/+0
| | | | | |
* | | | | | Merge 10.3 into 10.4Marko Mäkelä2019-01-243-20/+108
|\ \ \ \ \ \ | |/ / / / /
| * | | | | Merge 10.2 into 10.3Marko Mäkelä2019-01-241-6/+71
| |\ \ \ \ \ | | |/ / / /
| | * | | | Merge 10.1 into 10.2Marko Mäkelä2019-01-231-8/+70
| | |\ \ \ \ | | | |/ / /
| | | * | | MDEV-17973: Don't overwrite xtrabackup-v2/mariabackup SST logs by defaultGeoff Montee2019-01-211-8/+70
| | | | | |
| * | | | | Merge pull request #1120 from tempesta-tech/sysprg/MDEV-17835v2Jan Lindström2019-01-233-14/+37
| |\ \ \ \ \ | | | | | | | | | | | | | | MDEV-17835: Remove wsrep-sst-method=xtrabackup
| | * | | | | MDEV-17835: Remove wsrep-sst-method=xtrabackupJulius Goryavsky2019-01-223-14/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The second line of changes related to replacing xtrabackup with mariabackup: 1) All unnecessary references to xtrabackup are removed from the documentation, from some comments, from the control files that are used to prepare the packages. 2) Made corrections of the tests from the galera_3nodes suite that mentioned xtrabackup or the old (associated with xtrabackup) version of innobackupex. 3) Fixed flaws in the galera_3nodes mtr suite control scripts, because of which they could not work with mariabackup. 4) Fixed numerous bugs in the SST scripts and in the mtr test files (galera_3nodes mtr suite) that prevented the use of Galera with IPv6 addresses. 5) Fixed flaws in tests for rsync and mysqldump (for galera_3nodes mtr tests suite). These tests were not performed successfully without these fixes. https://jira.mariadb.org/browse/MDEV-17835
* | | | | | | Galera4Brave Galera Crew2019-01-234-8/+20
| | | | | | |
* | | | | | | Merge 10.3 into 10.4Marko Mäkelä2019-01-081-6/+15
|\ \ \ \ \ \ \ | |/ / / / / /
View Lorry Controller Status