By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,330 Members | 1,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,330 IT Pros & Developers. It's quick & easy.

py2app chokes on MySQLdb

P: 6
I am currently trying to convert a program I just wrote to application form, on the Mac. I'm using py2app to accomplish this, and everything works fine up until the last stage; when I try to complete the conversion with:
Expand|Select|Wrap|Line Numbers
  1.  python py2app 
and then run the resulting executable, I get the error:
Expand|Select|Wrap|Line Numbers
  1.  ImportError: No module named MySQLdb 
The really strange thing is that when I was testing the application creation by making an app bundle, using
Expand|Select|Wrap|Line Numbers
  1.  python py2app -A 
the resulting application bundle worked perfectly. So something is going wrong between making the app bundle and creating the actual app itself. The entire purpose of my program is database connection, so commenting out that portion of its capabilities is not an option.

Thanks ahead of time,
Jun 27 '08 #1
Share this Question
Share on Google+
3 Replies

P: 314
I've had similar problems when building executables for Windows and Linux machines. Within your script you'll need to package up the MySQL module so that it gets distributed along with the rest of your source code.

Try googling py2app with the MySQL module to see if results come up, as different packages require different steps to get them to play nice with py2exe (in my case). Here's an example of my script for making matplotlib distributable:

Expand|Select|Wrap|Line Numbers
  1. #!/usr/bin/python
  3. import sys
  5. try:
  6.     # if this doesn't work, try import modulefinder
  7.     import as modulefinder
  8.     import win32com
  9.     for p in win32com.__path__[1:]:
  10.         modulefinder.AddPackagePath("win32com", p)
  11.     for extra in [""]: #,"win32com.mapi"
  12.         __import__(extra)
  13.         m = sys.modules[extra]
  14.         for p in m.__path__[1:]:
  15.             modulefinder.AddPackagePath(extra, p)
  16. except ImportError:
  17.     # no build path setup, no worries.
  18.     pass
  20. from distutils.core import setup
  21. from distutils.filelist import findall
  22. import matplotlib
  23. import py2exe
  24. import os
  26. manifest = """[redacted for length]"""
  28. mpdatadir = matplotlib.get_data_path()
  29. mpdata = findall(mpdatadir)
  30. dataFiles = []
  31. for f in mpdata:
  32.     dir = os.path.join('matplotlibdata', f[len(mpdatadir)+1:])
  33.     dataFiles.append((os.path.split(dir)[0], [f]))
  35. setup(
  36.     zipfile = None,
  37.     # We use os.path.join for portability
  38.     package_dir = {'': os.path.join('..', 'Common')},
  39.     py_modules = [ """[redacted, my own modules]""" ],
  40.     options={
  41.         'py2exe': {
  42.             'packages' :    ['matplotlib.numerix', 'pytz',
  43.                             'matplotlib.backends.backend_tkagg'],
  44.             'includes':        'matplotlib.numerix.random_array',
  45.             'excludes':        ['_gtkagg', '_tkagg'],
  46.             'dll_excludes':['libgdk-win32-2.0-0.dll',
  47.                             'libgobject-2.0-0.dll',
  48.                             'MSVCP80.dll',
  49.                             'MSVCR80.dll']
  50.         }
  51.     },
  52.     data_files = dataFiles,
  53.     windows = [
  54.         {
  55.             "script": "[redacted]",
  56.             "icon_resources": [(1, "iconJ.ico")],
  57.             "other_resources": [(24,1,manifest)]
  58.         }
  59.     ],
  60. )
I had to do this different ways for different modules.
Some simply needed to be imported into the script.
Some needed to use the modulefinder in the beginning (but only matplotlib that I found)
Others simply needed to be included in the packages or includes lists that are part of the py2exe dictionary. I would try doing the import method first, then the packages/includes list entries. But of course that's if a quick google doesn't turn anything up!

As a last resort there may be some similar modulefinder ( within py2app that you could try out
Jun 27 '08 #2

P: 6
oy, ok thanks. I just discovered some major bugs in my code, so I'm gonna hold off on converting it for a little while.
Jun 29 '08 #3

P: 1
I had the same issue and was able to get py2app to correctly build the .app with MySQLdb after manually unzipping the MySQLdb .egg under site-packages.

It seems that the MySQLdb is distributed as a compressed .egg file and that confuses py2app. No special py2app recipe needed.

To manually uncompress the .egg file, under site-packages/ instead of
* MySQL_python-1.2.2-py2.5-macosx-10.3-fat.egg (as a binary .zip file)

make a MySQL_python-1.2.2-py2.5-macosx-10.3-fat.egg directory and uncompress it
Expand|Select|Wrap|Line Numbers
  1. mv MySQL_python-1.2.2-py2.5-macosx-10.3-fat.egg
  2. mkdir MySQL_python-1.2.2-py2.5-macosx-10.3-fat.egg
  3. mv MySQL_python-1.2.2-py2.5-macosx-10.3-fat.egg
  4. cd MySQL_python-1.2.2-py2.5-macosx-10.3-fat.egg
  5. unzip
Re-run the py2app and it should pick up the MySQLdb module as expected.

Dec 2 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.