diff options
author | Aaron Andersen <aaron@fosslib.net> | 2020-03-20 20:46:26 -0400 |
---|---|---|
committer | Aaron Andersen <aaron@fosslib.net> | 2020-03-21 15:47:38 -0400 |
commit | 6c47902e01ae1dab9967966b9a24536861436c6a (patch) | |
tree | fe57de81848c18e1105ef78fb3b7837b0d08dccb /nixos/tests | |
parent | 3474b55614775de1ddfa99368ef1c75ec8d7797f (diff) |
nixos/mysql: test with mysql80 package
Diffstat (limited to 'nixos/tests')
-rw-r--r-- | nixos/tests/mysql.nix | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/nixos/tests/mysql.nix b/nixos/tests/mysql.nix index 924bac84e26c..84673181e1a4 100644 --- a/nixos/tests/mysql.nix +++ b/nixos/tests/mysql.nix @@ -22,6 +22,27 @@ import ./make-test-python.nix ({ pkgs, ...} : { services.mysql.package = pkgs.mysql57; }; + mysql80 = + { pkgs, ... }: + + { + # prevent oom: + # Kernel panic - not syncing: Out of memory: compulsory panic_on_oom is enabled + virtualisation.memorySize = 1024; + + services.mysql.enable = true; + services.mysql.initialDatabases = [ + { name = "testdb"; schema = ./testdb.sql; } + { name = "empty_testdb"; } + ]; + # note that using pkgs.writeText here is generally not a good idea, + # as it will store the password in world-readable /nix/store ;) + services.mysql.initialScript = pkgs.writeText "mysql-init.sql" '' + CREATE USER 'passworduser'@'localhost' IDENTIFIED BY 'password123'; + ''; + services.mysql.package = pkgs.mysql80; + }; + mariadb = { pkgs, ... }: @@ -61,6 +82,12 @@ import ./make-test-python.nix ({ pkgs, ...} : { # ';' acts as no-op, just check whether login succeeds with the user created from the initialScript mysql.succeed("echo ';' | mysql -u passworduser --password=password123") + mysql80.wait_for_unit("mysql") + mysql80.succeed("echo 'use empty_testdb;' | mysql -u root") + mysql80.succeed("echo 'use testdb; select * from tests;' | mysql -u root -N | grep 4") + # ';' acts as no-op, just check whether login succeeds with the user created from the initialScript + mysql80.succeed("echo ';' | mysql -u passworduser --password=password123") + mariadb.wait_for_unit("mysql") mariadb.succeed( "echo 'use testdb; create table tests (test_id INT, PRIMARY KEY (test_id));' | sudo -u testuser mysql -u testuser" |