Debian Codegraph @

tools/test-setup.sh

raw
1 #!/bin/bash -xe
2
3 # This script will be run by OpenStack CI before unit tests are run,
4 # it sets up the test system as needed.
5 # Developers should setup their test systems in a similar way.
6
7 # This setup needs to be run as a user that can run sudo.
8
9 # The root password for the MySQL database; pass it in via
10 # MYSQL_ROOT_PW.
11 DB_ROOT_PW=${MYSQL_ROOT_PW:-insecure_slave}
12
13 # This user and its password are used by the tests, if you change it,
14 # your tests might fail.
15 DB_USER=openstack_citest
16 DB_PW=openstack_citest
17
18 sudo -H mysqladmin -u root password $DB_ROOT_PW
19
20 # It's best practice to remove anonymous users from the database. If
21 # a anonymous user exists, then it matches first for connections and
22 # other connections from that host will not work.
23 sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e "
24 DELETE FROM mysql.user WHERE User='';
25 FLUSH PRIVILEGES;
26 CREATE USER '$DB_USER'@'%' IDENTIFIED BY '$DB_PW';
27 GRANT ALL PRIVILEGES ON *.* TO '$DB_USER'@'%' WITH GRANT OPTION;"
28
29 # Now create our database.
30 mysql -u $DB_USER -p$DB_PW -h 127.0.0.1 -e "
31 SET default_storage_engine=MYISAM;
32 DROP DATABASE IF EXISTS openstack_citest;
33 CREATE DATABASE openstack_citest CHARACTER SET utf8;"
34
35 # Same for PostgreSQL
36 # The root password for the PostgreSQL database; pass it in via
37 # POSTGRES_ROOT_PW.
38 DB_ROOT_PW=${POSTGRES_ROOT_PW:-insecure_slave}
39
40 # Setup user
41 root_roles=$(sudo -H -u postgres psql -t -c "
42 SELECT 'HERE' from pg_roles where rolname='$DB_USER'")
43 if [[ ${root_roles} == *HERE ]];then
44 sudo -H -u postgres psql -c "ALTER ROLE $DB_USER WITH SUPERUSER LOGIN PASSWORD '$DB_PW'"
45 else
46 sudo -H -u postgres psql -c "CREATE ROLE $DB_USER WITH SUPERUSER LOGIN PASSWORD '$DB_PW'"
47 fi
48
49 # Store password for tests
50 cat << EOF > $HOME/.pgpass
51 *:*:*:$DB_USER:$DB_PW
52 EOF
53 chmod 0600 $HOME/.pgpass
54
55 # Now create our database
56 psql -h 127.0.0.1 -U $DB_USER -d template1 -c "DROP DATABASE IF EXISTS openstack_citest"
57 createdb -h 127.0.0.1 -U $DB_USER -l C -T template0 -E utf8 openstack_citest