dosubot[bot] commented on issue #28365:
URL: https://github.com/apache/superset/issues/28365#issuecomment-2098331174
<!-- Answer -->
To resolve the issue with `pymssql` not persisting through Docker image
updates, you should incorporate the installation of `pymssql` directly into
your Dockerfile. This ensures that the module is installed every time the image
is built, thus avoiding the need to manually reinstall it after updates. Here's
a concise guide on how to do this:
1. **Modify Your Dockerfile**: Add a `RUN` command in your Dockerfile to
install `pymssql`. If you're using an official Superset image as your base,
you'll need to create a custom Dockerfile that builds from it.
2. **Example Dockerfile Snippet**:
```Dockerfile
FROM apache/superset:4.0.0
RUN pip install pymssql
```
3. **Build Your Custom Image**: After adding the `RUN` command, use the
`docker build` command to create your custom image. For example:
```bash
docker build -t my-custom-superset-image .
```
4. **Use Your Custom Image**: Deploy your Docker setup using this newly
built image to ensure `pymssql` is included and persists through any future
updates.
By following these steps, you integrate `pymssql` installation into your
Docker image build process, ensuring it's always present in your Superset
environment and eliminating the issue with MSSQL connections.
<!-- Dosu Comment Footer -->
<details>
<summary>
#### Details
</summary>
**Sources**
-
[superset/db_engine_specs/mssql.py](https://github.com/apache/superset/blob/master/superset/db_engine_specs/mssql.py)
-
[docker-compose-image-tag.yml](https://github.com/apache/superset/blob/master/docker-compose-image-tag.yml)
-
[docker/docker-init.sh](https://github.com/apache/superset/blob/master/docker/docker-init.sh)
-
[docker/docker-bootstrap.sh](https://github.com/apache/superset/blob/master/docker/docker-bootstrap.sh)
-
[docker-compose-non-dev.yml](https://github.com/apache/superset/blob/master/docker-compose-non-dev.yml)
-
[pyproject.toml](https://github.com/apache/superset/blob/master/pyproject.toml)
-
[docs/docs/configuration/databases.mdx](https://github.com/apache/superset/blob/master/docs/docs/configuration/databases.mdx)
<br/>
**About Dosu**
This response is meant to be useful and save you time. It is **not meant to
be a precise solution**, but rather a starting point for your own research.
Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is
irrelevant.
</details>
*To continue the conversation, mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
