1name: Setup
2runs:
3  using: composite
4  steps:
5    - shell: bash
6      run: |
7        set -x
8
9        sudo service slapd start
10        docker exec sql1 /opt/mssql-tools18/bin/sqlcmd -S 127.0.0.1 -U SA -C -P "<YourStrong@Passw0rd>" -Q "create login pdo_test with password='password', check_policy=off; create user pdo_test for login pdo_test; grant alter, control to pdo_test;"
11        docker exec sql1 /opt/mssql-tools18/bin/sqlcmd -S 127.0.0.1 -U SA -C -P "<YourStrong@Passw0rd>" -Q "create login odbc_test with password='password', check_policy=off; create user odbc_test for login odbc_test; grant alter, control, delete to odbc_test;"
12        docker exec sql1 /opt/mssql-tools18/bin/sqlcmd -S 127.0.0.1 -U SA -C -P "<YourStrong@Passw0rd>" -Q "ALTER SERVER ROLE sysadmin ADD MEMBER odbc_test;"
13        docker exec sql1 /opt/mssql-tools18/bin/sqlcmd -S 127.0.0.1 -U SA -C -P "<YourStrong@Passw0rd>" -Q "CREATE DATABASE odbc;"
14        docker exec sql1 /opt/mssql-tools18/bin/sqlcmd -S 127.0.0.1 -U SA -C -P "<YourStrong@Passw0rd>" -Q "CREATE DATABASE pdo_odbc;"
15        sudo locale-gen de_DE
16
17        ./.github/scripts/setup-slapd.sh
18
19        sudo cp ext/snmp/tests/snmpd.conf /etc/snmp
20        sudo cp ext/snmp/tests/bigtest /etc/snmp
21        sudo service snmpd restart
22
23        sudo groupadd -g 5000 vmail
24        sudo useradd -m -d /var/vmail -s /bin/false -u 5000 -g vmail vmail
25        sudo cp ext/imap/tests/setup/dovecot.conf /etc/dovecot/dovecot.conf
26        sudo cp ext/imap/tests/setup/dovecotpass /etc/dovecot/dovecotpass
27        sudo service dovecot restart
28