Hey, that is a sys env issue ;) you would need to look at your user profile and make sure all sys paths are in line with what is expected... did you try doing an export of the path?
I did spot something new that may help: http://friendlybit.com/tutorial/install-mysql-python-on-mac-os-x-leopard/ let me know how it works out Mart :) On Oct 21, 9:49 am, mIREK <mko...@gmail.com> wrote: > Hi Mart and Franklin, > > I have the same problem. I have OS X 10.6 with MySQL from binary > installer. I am using python 2.6.6 from ports and yes I have switched > it by python_select. I am trying to build it from sources, beacuse > py26-mysql is also "building" mysql5 which I do not want, when I have > it from installer... > > Last time year ago it works perfectly on 1.2.3b and I didn't even > think there should be a problem, but now after complete reinstall of > the system I want back my working mysql ;-) > > Here's what I got after build and install: > > bash-3.2# python setup.py build > running build > running build_py > copying MySQLdb/release.py -> build/lib.macosx-10.6-x86_64-2.6/MySQLdb > running build_ext > > bash-3.2# python setup.py install > running install > running bdist_egg > running egg_info > writing MySQL_python.egg-info/PKG-INFO > writing top-level names to MySQL_python.egg-info/top_level.txt > writing dependency_links to MySQL_python.egg-info/dependency_links.txt > reading manifest file 'MySQL_python.egg-info/SOURCES.txt' > reading manifest template 'MANIFEST.in' > warning: no files found matching 'MANIFEST' > warning: no files found matching 'ChangeLog' > warning: no files found matching 'GPL' > writing manifest file 'MySQL_python.egg-info/SOURCES.txt' > installing library code to build/bdist.macosx-10.6-x86_64/egg > running install_lib > running build_py > copying MySQLdb/release.py -> build/lib.macosx-10.6-x86_64-2.6/MySQLdb > running build_ext > creating build/bdist.macosx-10.6-x86_64/egg > copying build/lib.macosx-10.6-x86_64-2.6/_mysql.so -> build/ > bdist.macosx-10.6-x86_64/egg > copying build/lib.macosx-10.6-x86_64-2.6/_mysql_exceptions.py -> build/ > bdist.macosx-10.6-x86_64/egg > creating build/bdist.macosx-10.6-x86_64/egg/MySQLdb > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/__init__.py -> build/ > bdist.macosx-10.6-x86_64/egg/MySQLdb > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/connections.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb > creating build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/__init__.py > -> build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/CLIENT.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/CR.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/ER.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/ > FIELD_TYPE.py -> build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/FLAG.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/constants/REFRESH.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants > > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/converters.py -> > build/bdist.macosx-10.6-x86_64/egg/MySQLdb > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/cursors.py -> build/ > bdist.macosx-10.6-x86_64/egg/MySQLdb > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/release.py -> build/ > bdist.macosx-10.6-x86_64/egg/MySQLdb > copying build/lib.macosx-10.6-x86_64-2.6/MySQLdb/times.py -> build/ > bdist.macosx-10.6-x86_64/egg/MySQLdb > byte-compiling build/bdist.macosx-10.6-x86_64/egg/_mysql_exceptions.py > to _mysql_exceptions.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/__init__.py > to __init__.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/ > connections.py to connections.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > __init__.py to __init__.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > CLIENT.py to CLIENT.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > CR.py to CR.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > ER.py to ER.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > FIELD_TYPE.py to FIELD_TYPE.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > FLAG.py to FLAG.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/constants/ > REFRESH.py to REFRESH.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/ > converters.py to converters.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/cursors.py > to cursors.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/release.py > to release.pyc > byte-compiling build/bdist.macosx-10.6-x86_64/egg/MySQLdb/times.py to > times.pyc > creating stub loader for _mysql.so > byte-compiling build/bdist.macosx-10.6-x86_64/egg/_mysql.py to > _mysql.pyc > creating build/bdist.macosx-10.6-x86_64/egg/EGG-INFO > copying MySQL_python.egg-info/PKG-INFO -> build/bdist.macosx-10.6- > x86_64/egg/EGG-INFO > copying MySQL_python.egg-info/SOURCES.txt -> build/bdist.macosx-10.6- > x86_64/egg/EGG-INFO > copying MySQL_python.egg-info/dependency_links.txt -> build/ > bdist.macosx-10.6-x86_64/egg/EGG-INFO > copying MySQL_python.egg-info/top_level.txt -> build/bdist.macosx-10.6- > x86_64/egg/EGG-INFO > writing build/bdist.macosx-10.6-x86_64/egg/EGG-INFO/native_libs.txt > zip_safe flag not set; analyzing archive contents... > creating 'dist/MySQL_python-1.2.3-py2.6-macosx-10.6-x86_64.egg' and > adding 'build/bdist.macosx-10.6-x86_64/egg' to it > removing 'build/bdist.macosx-10.6-x86_64/egg' (and everything under > it) > Processing MySQL_python-1.2.3-py2.6-macosx-10.6-x86_64.egg > Copying MySQL_python-1.2.3-py2.6-macosx-10.6-x86_64.egg to /opt/local/ > Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site- > packages > Adding MySQL-python 1.2.3 to easy-install.pth file > > Installed /opt/local/Library/Frameworks/Python.framework/Versions/2.6/ > lib/python2.6/site-packages/MySQL_python-1.2.3-py2.6-macosx-10.6- > x86_64.egg > Processing dependencies for MySQL-python==1.2.3 > Finished processing dependencies for MySQL-python==1.2.3 > > I found the files under /opt/local/Library/Frameworks/Python.framework/ > Versions/2.6/lib/python2.6/site-packages/ here I can see > MySQL_python-1.2.3-py2.6-macosx-10.6-x86_64.egg and in easy- > install.pth is line ./MySQL_python-1.2.3-py2.6-macosx-10.6-x86_64.egg > > but still after importing in python I got: > > mIREK$ python > Python 2.6.6 (r266:84292, Sep 27 2010, 23:02:58) > [GCC 4.2.1 (Apple Inc. build 5664)] on darwin > Type "help", "copyright", "credits" or "license" for more information.>>> > import MySQLdb > > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File "build/bdist.macosx-10.6-x86_64/egg/MySQLdb/__init__.py", line > 19, in <module> > File "build/bdist.macosx-10.6-x86_64/egg/_mysql.py", line 7, in > <module> > File "build/bdist.macosx-10.6-x86_64/egg/_mysql.py", line 6, in > __bootstrap__ > ImportError: dlopen(/Users/mIREK/.python-eggs/MySQL_python-1.2.3-py2.6- > macosx-10.6-x86_64.egg-tmp/_mysql.so, 2): Library not loaded: > libmysqlclient.16.dylib > Referenced from: /Users/mIREK/.python-eggs/MySQL_python-1.2.3-py2.6- > macosx-10.6-x86_64.egg-tmp/_mysql.so > Reason: image not found > > > > I really don't know what to do/try more... > > mIREK > > On 20 říj, 19:18, mart <msenecal...@gmail.com> wrote:> few questions: > > * were you able to install it without any errors? > > * that pah below... is pointing to temp... Can you check where it has > > been installed to and are sure that what you have os for 2.6, and not > > 2.7? - 2.6 is you current version and you have a a path set to it? > > (pointing to the actual folder or a link?) > > > On Oct 20, 9:13 am, Franklin Freitas <freitas.frank...@gmail.com> > > wrote: > > > > Hi Mart, > > > > Thanks for your detailed explanation. I had tried before with out any > > > results. I tried it again anyway from scratch and here is the error I > > > get when trying to import MySQLdb > > > > >>> import MySQLdb > > > > Traceback (most recent call last): > > > File "<stdin>", line 1, in <module> > > > File "build/bdist.macosx-10.6-universal/egg/MySQLdb/__init__.py", > > > line 19, in <module> > > > File "build/bdist.macosx-10.6-universal/egg/_mysql.py", line 7, in > > > <module> > > > File "build/bdist.macosx-10.6-universal/egg/_mysql.py", line 6, in > > > __bootstrap__ > > > ImportError: dlopen(/Users/ffreitas/.python-eggs/MySQL_python-1.2.3- > > > py2.6-macosx-10.6-universal.egg-tmp/_mysql.so, 2): Library not loaded: > > > libmysqlclient.16.dylib > > > Referenced from: /Users/ffreitas/.python-eggs/MySQL_python-1.2.3- > > > py2.6-macosx-10.6-universal.egg-tmp/_mysql.so > > > Reason: image not found > > > > On Oct 18, 1:33 pm, mart <msenecal...@gmail.com> wrote: > > > > > Yes, a little more involved that I remembered. So, to go through the > > > > steps correctly, I started from scratch. This is what I did: > > > > > 1) downloaded latest version of MySQLdb > > > > formhttp://sourceforge.net/projects/mysql-python/ > > > > 2) went to my default Python folder, and checked for any file or > > > > folder with a reference to *MySQL* (remove if any) > > > > 3) opened Vim in a terminal, opened setup_posix.py and made this > > > > change (you may not have to do this if MySQL was already installed - > > > > but i changed it anyways): > > > > > <----- changed this line > > > > mysql_config.path = "mysql_config" > > > > > ------> to this > > > > mysql_config.path = "/usr/local/mysql/bin/mysql_config" > > > > > 4) ran these at the terminal: > > > > python setup.py clean > > > > python setup.py build > > > > sudo python setup.py install > > > > > 5) for good measure, did an export: export PATH=/usr/local/mysql/bin: > > > > $PATH > > > > > and there you have it. MyQSLdb is ready to be imported! > > > > > good luck and feel free to ask, if you would like me to test a > > > > different way of getting it insalled. > > > > > Mart :) > > > > > On Oct 18, 1:49 am, mart <msenecal...@gmail.com> wrote: > > > > > > hum.. let me check on my end to make sure I didn't miss mentioning > > > > > something. It has been a little while... > > > > > > On Oct 18, 12:40 am, Franklin Freitas <freitas.frank...@gmail.com> > > > > > wrote: > > > > > > > Hi, the thing is that MySQLdb is not even working outside the Web2py > > > > > > environment. I haven't been able to make it work in the regular > > > > > > Python > > > > > > interpreter. I tried copying everything to the Web2py sites-packages > > > > > > folder, but it didn't work > > > > > > > Thanks > > > > > > > Franklin > > > > > > > On Oct 17, 8:03 pm, mart <msenecal...@gmail.com> wrote: > > > > > > > > you can throw in in the installed python/lib folder, or in site- > > > > > > > packages folder (sibling to the applications folder of the web2py > > > > > > > root > > > > > > > dir, or do an export within your scripts (controller?),or.... my > > > > > > > favorite, I usually do web2py stuff with Aptana,so, i throw of > > > > > > > copy of > > > > > > > all dependencies within my project and reference it there... so, > > > > > > > many > > > > > > > possibilities, depends how you prefer to reference it.... > > > > > > > > Hope it helps, > > > > > > > Mart :) > > > > > > > > On Oct 17, 7:11 pm, Franklin Freitas <freitas.frank...@gmail.com> > > > > > > > wrote: > > > > > > > > > Has anyone been able to install MySQLdb in Mac OSX ??? > > > > > > > > > I want to use it with Web2py but haven't been able to make it > > > > > > > > work. > > > > > > > > I've read a whole bunch of forums saying how hard it is, I've > > > > > > > > done > > > > > > > > everything I've reead about it without any results. I even used > > > > > > > > macports as recommended by my Web2py teacher but it didn't work > > > > > > > > either. > > > > > > > > > If anyone knows a sure way on how to achieve this I would > > > > > > > > appreciate > > > > > > > > it. > > > > > > > > > Thanks for your time > >
