> For the complete documentation index, see [llms.txt](https://niagads.gitbook.io/vcpa/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://niagads.gitbook.io/vcpa/step-2-create-your-tracking-database-instance/option-2-setup-sample-tracking-database-using-docker.md).

# Option 2: Setup sample tracking database using Docker

Start by installing docker-compose and downloading our sharing code

Download our sharing code:

```
 $ git clone --recurse-submodules https://bitbucket.org/NIAGADS/vcpa-web-api.git
```

Then go into the `vcpa-web-api` folder

```
 $ cd vcpa-web-api
```

and fill in the information to the `.env file` as shown below:

```
$ vi .envDB_NAME= ### tracking database nameDB_USER= ### tracking database user nameDB_PASSWORD= ### tracking database passwordDB_HOST= ### tracking database hostAWS_ACCESS_KEY_ID= ### AWS access key IDAWS_SECRET_ACCESS_KEY= ### AWS secret access keyAWS_REGION= ### AWS region
```

Users can verify their outcome by typing: docker-compose up; below is an example of what you will see

```
Successfully built af8f84acc855Successfully tagged gcadwebapi_web:latestRecreating gcadwebapi_web_1 ...Recreating gcadwebapi_web_1 ... doneAttaching to gcadwebapi_mysql_1, gcadwebapi_web_1mysql_1 | [Entrypoint] MySQL Docker Image 5.7.21-1.1.4mysql_1 | [Entrypoint] Starting MySQL 5.7.21-1.1.4web_1 | 172.18.0.1 - - [27/Mar/2018:18:05:55 +0000] "GET /index.php HTTP/1.1" 200 4
```

{% hint style="info" %}

* This docker instance has the web open to the public to allow remote analysis instances access to this API site.
* Please ensure that this docker host has the default web port (80) accessible by public hosts.
  {% endhint %}

### For Linux/MacOS Users

1. Make sure you turn off Firewall for private networks.
2. This image version could directly build on Linux/MacOS.

### For Windows Users

1. Make sure you turn off Windows Firewall for private networks.
2. Modify docker-compose.yml volumes:
   * C:/users/\<username>/path-to-bitbucket/vcpa-web-api/scripts/initdb:/docker-entrypoint-initdb.d also change Docker setting&#x20;

![Shared Drives](https://2340481123-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LDqjkDfgAQAY9Hn5Vg6%2F-LDrNs38yljLClzlgf__%2F-LDrOoLkKd_GfRQKT0_k%2Fdrives.png?alt=media\&token=7fc027f2-b05b-4add-bb96-a2e067894b42)

&#x20;    3\. Make sure init.sh file format is in unix format.
