Cannot Import Python MySQL module when running a script using crontab
Defining the PYTHONPATH inside crontab worked for me, first I entered crontab using:
sudo crontab -e
I then added the libraries path to the PYTHONPATH variable. In my case it was this:
PYTHONPATH=/home/username/.local/lib/python2.7/site-packages
To find the path of the library I first imported it using python and then used the file attribute.
import library
library.__file__
It may be that you're using a different Python executable. On the shell, enter which python
to find out where the Python executable is located. Let's say this returns something other than /usr/bin/python
, say /home/myuser/bin/python
, then in the first line of your script, you would write:
#!/home/myuser/bin/python
It may also be that your shell has environment variable called PYTHONPATH
. If that's the case and you find where it's importing the library from, then this is how you would add the path to find the library in the first line of your script, before the import of "MySQLdb":
import sys; sys.path.append('/path/to/MySQLdb-lib/')
Define PYTHONPATH at the top of your crontab. Defining all these environment variables (below) can help you avoid some common cron problems relating to the lack of environment variables:
USER=...
HOME=/home/...
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin:$HOME/bin
PYTHONPATH=...
DISPLAY=:0.0
MAILTO=...
LANG=en_US.UTF-8
To find out the path to MySQLdb, open a python shell and type:
>>> import MySQLdb
>>> MySQLdb.__file__
'/usr/lib/pymodules/python2.7/MySQLdb/__init__.pyc'
Your path my differ. In the example above, the appropriate dir to add to PYTHONPATH
would be /usr/lib/pymodules/python2.7
(though you should not have to add this particular path since your python executable should have this path in its sys.path automatically).