MySQL on an Alpine python image is failing - Error loading shared library libmariadb?

Question

My Dockerfile:

FROM python:3.8-alpine

...

RUN apk add --no-cache --virtual .build-deps gcc libffi-dev openssl-dev musl-dev mariadb-dev \
    && pip install --no-cache-dir -r /code/requirements/production.txt \
    && apk del .build-deps gcc libffi-dev musl-dev openssl-dev mariadb-dev

...

Requirements:

django==2.2.9
mysqlclient==1.4.6
gunicorn==20.0.4
django-bootstrap3==12.0.3
django-fsm==2.7.0
djangorestframework==3.11.0

When I run the application I get this from django:

ImportError: Error loading shared library libmariadb.so.3: No such file or directory (needed by /usr/local/lib/python3.8/site-packages/MySQLdb/_mysql.cpython-38-x86_64-linux-gnu.so)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.
Did you install mysqlclient?

How can I fix this as I have already installed the MySQL db adapter recommeneded?

tread · Accepted Answer · 2020-01-13 07:41:24Z

11

I found the issue on docker-alpine github

The solution was to add the mariadb-connector-c-dev package, before installing dependencies.

RUN apk add --no-cache mariadb-connector-c-dev

answered Jan 13, 2020 at 7:41

tread

11.3k19 gold badges108 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

tread Over a year ago

Even better though is to use something other than alpine for python when connecting to MySQL

mixja Over a year ago

You can actually just use apk add --no-cache mariadb-connector-c

Nick M Over a year ago

Doesn't seem to work on alpine 14 with either of them packages installed

zx1986 Over a year ago

It works, you save my day!

Y.Wang Over a year ago

Works nicely! Thank you!

Collectives™ on Stack Overflow

MySQL on an Alpine python image is failing - Error loading shared library libmariadb?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related