{ "name": "mysql", "version": "8.4.11", "summary": "MySQL 8.4 LTS: the server, the mysql client and tools, libmysqlclient", "category": "server", "license": "GPL-2.0-only", "homepage": "https://www.mysql.com/", "source": { "url": "https://cdn.mysql.com/Downloads/MySQL-8.4/mysql-8.4.11.tar.gz", "sha256": "eb3051164d625dd346a8203f76e0d5d5d9aec51dbe9d51788e39ec6b3f1394c2" }, "watch": {"kind": "github-tag", "repo": "mysql/mysql-server", "tag_regex": "^mysql-(8\\.4\\.[0-9]+)$", "pin": "8.4"}, "deps": [ "openssl", "ncurses" ], "env_packages": [], "static": false, "nss": true, "check": "v=$(sbin/mysqld --no-defaults --version | sed -n 's/.* Ver \\([^ ]*\\) .*/\\1/p') && [ -n \"$v\" ] && t=$(mktemp -d) && chmod 755 \"$t\" && chown 65534:65534 \"$t\" && p=$(free_port) && xp=$(free_port) && [ \"$xp\" != \"$p\" ] && gp=$(free_port) && [ \"$gp\" != \"$p\" ] && [ \"$gp\" != \"$xp\" ] && pw=bvs-$RANDOM$RANDOM && m=v$RANDOM$RANDOM && setpriv --reuid=65534 --regid=65534 --clear-groups sbin/mysqld --no-defaults --initialize-insecure --basedir=\"$PREFIX\" --datadir=\"$t/data\" --tmpdir=\"$t\" --log-error=\"$t/init.log\" && { sbin/mysqld --no-defaults --user=nobody --basedir=\"$PREFIX\" --datadir=\"$t/data\" --socket=\"$t/mysql.sock\" --port=\"$p\" --bind-address=127.0.0.1 --mysqlx-port=\"$xp\" --mysqlx-bind-address=127.0.0.1 --mysqlx-socket=\"$t/mysqlx.sock\" --secure-file-priv=\"$t\" --pid-file=\"$t/mysql.pid\" --log-error=\"$t/error.log\" --tmpdir=\"$t\" --skip-name-resolve --gtid-mode=ON --enforce-gtid-consistency=ON --loose-group-replication-start-on-boot=OFF > \"$t/stdout.log\" 2>&1 & pid=$!; } && for i in $(seq 1 600); do bin/mysqladmin --no-defaults -S \"$t/mysql.sock\" -u root ping > /dev/null 2>&1 && break; kill -0 \"$pid\" 2> /dev/null || break; sleep 0.5; done && bin/mysqladmin --no-defaults -S \"$t/mysql.sock\" -u root ping > /dev/null && wait_port \"$p\" && wait_port \"$xp\" && grep -E '^Uid:[[:space:]]+65534[[:space:]]' \"/proc/$pid/status\" > /dev/null && r() { bin/mysql --no-defaults -S \"$t/mysql.sock\" -u root -N -B \"$@\"; } && r -e \"CREATE DATABASE bvs; CREATE USER 'bvs'@'127.0.0.1' IDENTIFIED BY '$pw'; GRANT ALL ON bvs.* TO 'bvs'@'127.0.0.1'\" && b() { bin/mysql --no-defaults -h 127.0.0.1 -P \"$p\" -u bvs --password=\"$pw\" -N -B bvs \"$@\" 2> /dev/null; } && b -e \"CREATE TABLE t (id INT PRIMARY KEY, v VARCHAR(64)) ENGINE=InnoDB; INSERT INTO t VALUES (1, '$m')\" && [ \"$(b -e 'SELECT v FROM t WHERE id = 1')\" = \"$m\" ] && b -e \"SHOW SESSION STATUS LIKE 'Ssl_version'\" | has -E '^Ssl_version[[:space:]]+TLSv1\\.[23]$' && [ \"$(b -e \"SELECT REGEXP_REPLACE(v, '[0-9]+', '#') FROM t WHERE id = 1\")\" = 'v#' ] && tui_screen 3 env MYSQL_HISTFILE=/dev/null \"$PREFIX/bin/mysql\" --no-defaults -S \"$t/mysql.sock\" -u root | has 'mysql>' && CHECK_CPPFLAGS=\"-DPORT=$p -DPW=\\\"$pw\\\" -DVAL=\\\"$m\\\"\" check_lib mysqlclient mysql.h 'MYSQL *c = mysql_init(NULL); MYSQL_RES *r; MYSQL_ROW w; if (!mysql_real_connect(c, \"127.0.0.1\", \"bvs\", PW, \"bvs\", PORT, NULL, 0)) { fprintf(stderr, \"libmysqlclient: %s\\n\", mysql_error(c)); return 1; } if (mysql_query(c, \"SELECT v FROM t WHERE id = 1\") || !(r = mysql_store_result(c)) || !(w = mysql_fetch_row(r)) || strcmp(w[0], VAL)) return 2; mysql_free_result(r); mysql_close(c)' && r -e \"INSTALL PLUGIN group_replication SONAME 'group_replication.so'; SET GLOBAL group_replication_group_name = 'b5c0a9e2-5d9a-4f3e-9a51-6d1f0e2c7a10'; SET GLOBAL group_replication_local_address = '127.0.0.1:$gp'; SET GLOBAL group_replication_bootstrap_group = ON; START GROUP_REPLICATION; SET GLOBAL group_replication_bootstrap_group = OFF\" && [ \"$(r -e 'SELECT MEMBER_STATE, MEMBER_ROLE FROM performance_schema.replication_group_members')\" = $'ONLINE\\tPRIMARY' ] && b -e \"INSERT INTO t VALUES (2, 'g$m')\" && [ \"$(r -e 'SELECT COUNT_TRANSACTIONS_CHECKED FROM performance_schema.replication_group_member_stats')\" -ge 1 ] && r -e 'STOP GROUP_REPLICATION; SET GLOBAL super_read_only = OFF; UNINSTALL PLUGIN group_replication' && { bin/mysql --no-defaults -h 127.0.0.1 -P \"$p\" -u bvs --password=\"x$pw\" -e 'SELECT 1' > \"$t/wrong.log\" 2>&1; has 'ERROR 1045' < \"$t/wrong.log\"; } && bin/mysqladmin --no-defaults -S \"$t/mysql.sock\" -u root shutdown && { wait \"$pid\"; pid=; } ; [ -z \"${pid:-}\" ] && has 'Shutdown complete' < \"$t/error.log\" && ! grep -lsa -- \"$t/dat[a]\" /proc/[0-9]*/cmdline > /dev/null && { bin/mysql --no-defaults -h 127.0.0.1 -P \"$p\" -u bvs --password=\"$pw\" -e 'SELECT 1' > \"$t/stopped.log\" 2>&1; has 'ERROR 2002\\|ERROR 2003' < \"$t/stopped.log\"; }; x=$?; [ -n \"${pid:-}\" ] && kill \"$pid\" 2> /dev/null && wait \"$pid\" 2> /dev/null; [ $x = 0 ] || cat \"$t/init.log\" \"$t/error.log\" \"$t/wrong.log\" \"$t/stopped.log\" >&2 2> /dev/null; rm -rf -- \"${t:?}\"; [ $x = 0 ] && echo \"MySQL $v: mysqld --initialize-insecure as uid 65534, mysqld switching to nobody with the X Plugin listening, a database, a user, an InnoDB table and a row over TCP with TLS (the mysql client and a program linked with libmysqlclient) and over the unix socket, an ICU regular expression, the mysql client's prompt in a terminal (libedit with the prefix's ncurses), a one-member Group Replication group started, a row certified through it, the group stopped and its plugin unloaded; a wrong password and a stopped server refused, no process left\"; exit $x" }