Testsuite: MySQL portability

diff --git a/test/runtest b/test/runtest
index 5671fead24ab93a1ee3ff9f7cab4f39bacb6571d..1b6e0d62849830fc83e85ec9e6039ed7ab2828b4 100755 (executable)
--- a/test/runtest
+++ b/test/runtest
@@ -1126,6 +1126,11 @@ RESET_AFTER_EXTRA_LINE_READ:
     s/^(returned from EXIM_DBOPEN: )(0x)?[0-9a-f]+/${1}0xAAAAAAAA/;
     s/^(EXIM_DBCLOSE.)(0x)?[0-9a-f]+/${1}0xAAAAAAAA/;
 
+    # Platform-dependent output during MySQL startup
+    next if /PerconaFT file system space/;
+    next if /^Waiting for MySQL server to answer/;
+    next if /mysqladmin: CREATE DATABASE failed; .* database exists/;
+
     # When Exim is checking the size of directories for maildir, it uses
     # the check_dir_size() function to scan directories. Of course, the order
     # of the files that are obtained using readdir() varies from system to

diff --git a/test/scripts/2610-MySQL/2610 b/test/scripts/2610-MySQL/2610
index f5765c0941c5d6d77bd34b5f8713aa7a9328b9e2..e59c80822d7bb4965c00e9b9722ce91444546e3c 100644 (file)
--- a/test/scripts/2610-MySQL/2610
+++ b/test/scripts/2610-MySQL/2610
@@ -1,9 +1,11 @@
 # mysql lookups
+# The mysql-devel (or equivalent) package will be need for Exim to build, and
+# the mysql-server (or mariadb-server or equivalent) package for this test to run.
 #
 # first, populate a DB to test against
 sudo rm -fr DIR/mysql
 perl
-system 'mysql_install_db --datadir=DIR/mysql';
+system 'mysql_install_db --no-defaults --datadir=DIR/mysql --user=CALLER';
 ****
 sudo rm test-stdout test-stderr
 #
@@ -24,6 +26,9 @@ system 'mysql --protocol=TCP -P PORT_N -u root -D test \
      INSERT INTO them VALUES ( CONCAT(\'before\', CHAR(13), CHAR(10), \'after\'), \'newline\' ); \
      INSERT INTO them VALUES ( CONCAT(\'x\', CHAR(9), \'x\'), \'tab\' ); \
      INSERT INTO them VALUES ( CONCAT(CHAR(39), \'stquot\'), \'quote1\' ); \
+     CREATE USER IF NOT EXISTS \'root\'@\'HOSTIPV4\', \'CALLER\'@\'HOSTIPV4\'; \
+     GRANT ALL ON *.* TO \'root\'@\'HOSTIPV4\'; \
+     GRANT ALL ON *.* TO \'CALLER\'@\'HOSTIPV4\'; \
  "';
 ****
 sudo rm test-stderr-server

diff --git a/test/scripts/2620-Postgresql/2620 b/test/scripts/2620-Postgresql/2620
index cf45726f4f3370bb6ae080e7f150a7ab0e6cc45c..1f8f3abe1b707912d2ca2b82b06e92940775904c 100644 (file)
--- a/test/scripts/2620-Postgresql/2620
+++ b/test/scripts/2620-Postgresql/2620
@@ -1,4 +1,6 @@
 # pgsql lookups
+# The pgsql-devel (or equivalent) package will be need for Exim to build, and
+# the postgresql-server (or equivalent) package for this test to run.
 #
 # first, populate a DB to test against
 sudo rm -fr DIR/pgsql

diff --git a/test/stderr/2610 b/test/stderr/2610
index 60d964387f172a4982b614025c628980452a08fd..57dda8a0789f171db939d543d6f0f09f5903b6ec 100644 (file)
--- a/test/stderr/2610
+++ b/test/stderr/2610
@@ -1,5 +1,3 @@
-Tue Mar 02 09:44:33 1999 PerconaFT file system space is low
-\amysqladmin: CREATE DATABASE failed; error: 'Can't create database 'test'; database exists'
 Exim version x.yz ....
 configuration file is TESTSUITE/test-config
 admin user