dosubot[bot] commented on issue #33415:
URL: https://github.com/apache/superset/issues/33415#issuecomment-2876211096
<!-- Answer -->
To resolve the "No module named 'MySQLdb'" error in Superset version
5.0.0rc2, ensure that you have the correct dependencies and configurations:
1. **Install System Dependencies**:
Update your Dockerfile to include the necessary system dependencies:
```dockerfile
USER root
RUN apt update && apt install -y python3-dev default-libmysqlclient-dev
build-essential pkg-config
```
2. **Install `mysqlclient` Using `uv`**:
Use the `uv` package manager to install `mysqlclient`:
```dockerfile
USER superset
RUN uv pip install --no-cache-dir mysqlclient
```
3. **For Helm Deployment**:
If you're using Helm, add a `bootstrapScript` in your `dev-values.yaml`:
```yaml
bootstrapScript: |
#!/bin/bash
set -e
apt update && apt install -y gcc libpq-dev python3-dev pkg-config
libmariadb-dev-compat && \
pip install psycopg2==2.9.6 sqlalchemy-bigquery==1.6.1
elasticsearch-dbapi==0.2.5 mysqlclient && \
if [ ! -f ~/bootstrap ]; then
echo "Running Superset with uid {{ .Values.runAsUser }}" > ~/bootstrap
fi
```
4. **Check SQLAlchemy URI**:
Ensure your SQLAlchemy URI is correctly formatted:
`mysql://user:password@host:port/dbname[?key=value&key=value...]`.
These steps should help resolve the issue with MySQLdb in Superset 5.0.0rc2
<sup>[[1]](https://github.com/apache/superset/issues/33241)</sup><sup>[[2]](https://github.com/apache/superset/discussions/31432)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great
Response](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=great_response)
| [Irrelevant
Answer](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=irrelevant_answer)
| [Incorrect
Sources](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=incorrect_sources)
| [Too
Verbose](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=hallucination)
| [Bug
Report](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/7de771dd-17e9-4143-8062-25b0671b8f61?feedback_type=other)</sup>
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
