MySQLdb error when running python server on MacOSX10.6

Question

Running my server (python manage.py runserver) yielded this error:

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

I attempted the winning solution on this page with no avail: Django + MySQL on Mac OS 10.6.2 Snow Leopard

And then moved on to try Thierry Lam (5 votes) on Django - MySQLdb: Symbol not found: _mysql_affected_rows

After Thierry Lam's suggestions, my error now reads:

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: dlopen(/Users/steven/.python-eggs/MySQL_python-1.2.3-py2.6-macosx-10.3-fat.egg-tmp/_mysql.so, 2): Library not loaded: libmysqlclient.18.dylib

Which seems very much like the same linking issue. Any wisdom to share? Thanks in advance.

Jeff Holland · Accepted Answer · 2011-06-20 18:23:53Z

15

It looks like you have everything installed right, but it can't find libmysqlclient. Have you tried the following?

> sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib
> sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

answered Jun 20, 2011 at 18:23

Jeff Holland

2762 silver badges4 bronze badges

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

3 Comments

Steve Trevathan Over a year ago

Your first line solved my problem - what exactly does this do? Thanks so much for the help.

Jeff Holland Over a year ago

You are creating a symbolic link. Your python-mysql module expects it to be in a different place than where it was installed. Now when it looks for the library the symbolic link points it to the correct location.

locoboy Over a year ago

Worked for me too! Thanks. However, if I wanted to remove the symbolic link how would i do this? What exactly does a symbolic link do?

fijter · Accepted Answer · 2011-06-20 16:43:33Z

1

Sounds like your just missing the mysql-python dependancy for mysql and Django. Don't know how you installed Django though. Use pip or easy_install to install it.

pip install mysql-python

For Django it is recommended to use PostgreSQL though, for development purposes setting up a sqlite database is much, much easier.

answered Jun 20, 2011 at 16:43

fijter

18.1k2 gold badges27 silver badges28 bronze badges

Collectives™ on Stack Overflow

MySQLdb error when running python server on MacOSX10.6

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related