472,374 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,374 software developers and data experts.

py2app chokes on MySQLdb

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 setup.py 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 setup.py 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
3 3357
314 100+
I've had similar problems when building executables for Windows and Linux machines. Within your setup.py 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 setup.py 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 py2exe.mf as modulefinder
  8.     import win32com
  9.     for p in win32com.__path__[1:]:
  10.         modulefinder.AddPackagePath("win32com", p)
  11.     for extra in ["win32com.shell"]: #,"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 setup.py 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 (py2exe.mf) within py2app that you could try out
Jun 27 '08 #2
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
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 MySQL_python-1.2.2-py2.5-macosx-10.3-fat.zip
  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.zip 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 MySQL_python-1.2.2-py2.5-macosx-10.3-fat.zip
Re-run the py2app and it should pick up the MySQLdb module as expected.

Dec 2 '08 #4

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

Similar topics

by: Peter Nikolaidis | last post by:
Greetings, I am attempting to get MySQLdb 0.9.2 installed on Mac OS 10.2 with a Fink distribution of Python 2.2.2. I have seen only a few posts on the subject, some of them relate to...
by: Bob Swerdlow | last post by:
I'm trying to move my application from bundlebuilder to py2app. I upgraded to PyObjC 1.2, which include py2app 1.7, but I got the following error. I saw a note on the py2app site that earlier...
by: bex | last post by:
Im baffled about this one... Im running OS 10.3, and Python 2.3. I installed py2app 0.17 and never used it, then installed py2app 0.2. It refuses to work. None of the samples will build....
by: bsharitt | last post by:
I'm trying to get Bittornado to run on Mac OS X (10.4 with Python 2.3.5) but I've only ever dealt with Python at lower lever scripting stuff, never wxPython or another GUI stuff. py2app is supposed...
by: Richard Taylor | last post by:
User-Agent: OSXnews 2.07 Xref: number1.nntp.dca.giganews.com comp.lang.python:437315 Hi I am trying to use py2app (http://undefined.org/python/) to package a gnome-python application...
by: SPE - Stani's Python Editor | last post by:
Hi, I'm creating a GUI program with wxPython which will be distributed for Mac and Windows. The audience of the program is not technical at all (eg they've never heard about Python yet ;-), so...
by: loren.davie | last post by:
Hi, I'm attempting to build a small app that uses pythoncard for a gui layer. The intention is to use py2app to construct an .app bundle for the Mac. I'm running OS 10.4 on an Intel MacBook...
by: James Stroud | last post by:
Hello All, I am trying to create a semi-standalone with the vendor python on OS X 10.4 (python 2.3.5). I tried to include some packages with both --packages from the command and the 'packages'...
by: Joe Strout | last post by:
I'm trying to use py2app to convert the pySketch wxPython example into a stand-alone OS X app. I've found the documentation at <http://undefined.org/python/py2app.html like this: #!/usr/bin/env...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...
by: F22F35 | last post by:
I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.