MySQL Sock Path Problem In MySQLdb Python and Django

Yesterday, I posted an article about the way to installing and configuring mod wsgi. After application hooked up successfully, I faced new problem. Because I use MySQL in XAMPP for Linux package, the MySQLdb for python didn’t find mysql sock on the default path. So, you need to manually specify the unix socket.

If you run the connection manually, probably the example is just like this :

import MySQLdb
db = MySQLdb.connect( host = 'localhost', user = 'root', passwd = '', db = 'djangodb')

Then I got error like this :

Traceback (most recent call last):
  File "", line 1, in 
  File "/usr/lib/pymodules/python2.7/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/pymodules/python2.7/MySQLdb/connections.py", line 188, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)")

So that means I need to specify unix socket. The syntax will be like this :

db = MySQLdb.connect( host = 'localhost', user = 'root', passwd = '', db = 'djangodb', unix_socket = '/opt/lampp/var/mysql/mysql.sock')

How I found mysql sock file path ? Just type this at terminal. And I got the path

ps -aux | grep mysqld
nobody    6959  0.0  1.3 187900 27788 pts/4    Sl   01:41   0:14 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --plugin-dir=/opt/lampp/lib/mysql/plugin --user=nobody --log-error=/opt/lampp/var/mysql/work085.err --pid-file=/opt/lampp/var/mysql/work085.pid --socket=/opt/lampp/var/mysql/mysql.sock --port=3306
root     11925  0.0  0.0   4448   796 pts/4    S+   16:04   0:00 grep --color=auto mysqld

So, I need to change django settings too. I just put socket path (/opt/lampp/var/mysql/mysql.sock) as database host. Seems ridiculous but it works properly.

Cheers,

Source :

http://passingcuriosity.com/2009/specifying-a-unix-socket-using-mysql-with-django/

https://code.djangoproject.com/ticket/1481

tar xvfz xampp-linux-1.7.7.tar.gz -C /opt
tar xvfz xampp-devel-1.7.7.tar.gz -C /opt

tar xvfz mod_wsgi.X.Y.tar.gz

sudo apt-get install python-dev

./configure --with-apxs=/opt/lampp/bin/apxs --with-python=/usr/bin/python
make
make install