Any Python people here? > All Things Tech

Posted: 12/31/2012 10:18:36 AM EDT

I'm trying to pick up Python and connect to MySQL. I installed MySQLdb for Python and everything eventually installed OK. The database is running; the user, pass, etc. are correct.

It's just not finding the library.


Traceback (most recent call last):

  File "/Users/michael/Desktop/mysqltest.py", line 1, in <module>

    import MySQLdb

  File "/Library/Python/2.7/site-packages/MySQLdb/__init__.py", line 19, in <module>

    import _mysql

ImportError: dlopen(/Library/Python/2.7/site-packages/_mysql.so, 2): no suitable image found.  Did find:

/Library/Python/2.7/site-packages/_mysql.so: mach-o, but wrong architecture

[Finished in 0.1s with exit code 1]

I've searched the web and found some solutions, but I think it's pointing in the right direction:

michael [/Library/Python/2.7/site-packages/mysqldb] -> ls

__init__.pyconnections.pyconstantsconverters.pyccursors.pycrelease.pyctimes.pyc

__init__.pycconnections.pycconverters.pycursors.pyrelease.pytimes.py

Any ideas what it could be? I've tried most of the stuff that's popped up on SourceForge, etc., namely adding it to the path. Maybe it's something stupid I'm overlooking.

Thanks!

(P.S. --- By the way, this is on OSX Lion)

Posted: 12/31/2012 2:00:27 PM EDT

[#1]

Quoted:
ImportError: dlopen(/Library/Python/2.7/site-packages/_mysql.so, 2): no suitable image found. Did find:
/Library/Python/2.7/site-packages/_mysql.so: mach-o, but wrong architecture

(P.S. --- By the way, this is on OSX Lion)

Given that error message, you might check to see if it is a problem of unix vs mac libraries (wrong install type)?

Posted: 12/31/2012 3:02:53 PM EDT

[#2]

Quoted:

Quoted:
ImportError: dlopen(/Library/Python/2.7/site-packages/_mysql.so, 2): no suitable image found. Did find:
/Library/Python/2.7/site-packages/_mysql.so: mach-o, but wrong architecture

(P.S. --- By the way, this is on OSX Lion)

Given that error message, you might check to see if it is a problem of unix vs mac libraries (wrong install type)?

This. Sounds like it's either a wrong version or it was compiled on a different processor than you're using

Posted: 1/4/2013 9:19:10 AM EDT

[#3]

Thanks guys. It appears from reading stemming off of this thread that there are issues with 64 bit MySQL installs and this connector... At the moment I'm thinking I just need to wipe MySQL and the connector and start over. (I realized I had several MySQL installs for different projects ... oops.

)

Warning

Confirm Action

[ARCHIVED THREAD] - Any Python people here?

[ARCHIVED THREAD] - Any Python people here?