diff options
| author | ChaosKid42 <christoph.scholz@gmail.com> | 2020-04-28 16:22:42 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-04-28 16:22:42 +0200 |
| commit | abc3260e750348d01996598309b6701469f58863 (patch) | |
| tree | 9f49191545f325a171ff069eb0a3b43fc31dfa3f /test/docker/README.md | |
| parent | Merge pull request #3235 from weiss/xep-0215 (diff) | |
enable tests with mssql-backend (#3136)
Diffstat (limited to 'test/docker/README.md')
| -rw-r--r-- | test/docker/README.md | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/test/docker/README.md b/test/docker/README.md index 22324a6e0..24c675cab 100644 --- a/test/docker/README.md +++ b/test/docker/README.md @@ -4,7 +4,7 @@ You can start the Docker environment with Docker Compose, from ejabberd repository root. -The following command will launch MySQL, PostgreSQL, Redis and keep the console +The following command will launch MySQL, MSSQL, PostgreSQL, Redis and keep the console attached to it. ``` @@ -15,6 +15,17 @@ mkdir test/docker/db/postgres/data You can stop all the databases with CTRL-C. +## Creating database for MSSQL + +The following commands will create the necessary login, user and database, will grant rights on the database in MSSQL and create the ejabberd schema: + +``` +docker cp test/docker/db/mssql/initdb/initdb_mssql.sql ejabberd-mssql:/ +docker exec ejabberd-mssql /opt/mssql-tools/bin/sqlcmd -U SA -P ejabberd_Test1 -S localhost -i /initdb_mssql.sql +docker cp sql/mssql.sql ejabberd-mssql:/ +docker exec ejabberd-mssql /opt/mssql-tools/bin/sqlcmd -U SA -P ejabberd_Test1 -S localhost -i /mssql.sql +``` + ## Running tests Before running the test, you can ensure there is no running instance of Erlang common test tool. You can run the following @@ -43,4 +54,5 @@ If you want to clean the data, you can remove the data directories after the `do ``` rm -rf test/docker/db/mysql/data rm -rf test/docker/db/postgres/data +docker volume rm docker_mssqldata ``` |