I’m running Python 2.7.2 on OS 10.8.5
Trying to use pymssql, but I get the following error:
JavaScript
x
6
1
File "time_reporting.py", line 32, in <module>2
import pymssql3
File "/Users/xx/.virtualenvs/oracle/lib/python2.7/site-packages/pymssql.py", line 30, in <module>4
import _mssql, types, string, time, datetime, warnings5
ImportError: No module named _mssql6
I’ve tried installing mssql with pip and brew only to be told that there’s no package by that name. The docs don’t seem to cover installation.
EDIT:
When I try to pip install pymssql I get:
JavaScript
1
99
99
1
Downloading/unpacking pymssql2
Running setup.py egg_info for package pymssql3
setup.py: platform.system() => 'Darwin'4
setup.py: platform.architecture() => ('32bit', '')5
setup.py: platform.linux_distribution() => ('', '', '')6
setup.py: platform.libc_ver() => ('', '')7
setup.py: Detected Darwin/Mac OS X.8
You can install FreeTDS with Homebrew or MacPorts, or by downloading9
and compiling it yourself.10
11
Homebrew (http://brew.sh/)12
--------------------------13
brew install freetds14
15
MacPorts (http://www.macports.org/)16
-----------------------------------17
sudo port install freetds18
19
setup.py: Not using bundled FreeTDS20
Traceback (most recent call last):21
File "<string>", line 16, in <module>22
File "/Users/xxx/.virtualenvs/oracle/build/pymssql/setup.py", line 181, in <module>23
if compiler.has_function('clock_gettime', libraries=['rt']):24
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 808, in has_function25
objects = self.compile([fname], include_dirs=include_dirs)26
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 616, in compile27
depends, extra_postargs)28
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 412, in _setup_compile29
self.mkpath(os.path.dirname(obj))30
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 931, in mkpath31
mkpath(name, mode, dry_run=self.dry_run)32
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/dir_util.py", line 76, in mkpath33
"could not create '%s': %s" % (head, exc.args[-1]))34
distutils.errors.DistutilsFileError: could not create 'var': Permission denied35
Complete output from command python setup.py egg_info:36
setup.py: platform.system() => 'Darwin'37
38
setup.py: platform.architecture() => ('32bit', '')39
40
setup.py: platform.linux_distribution() => ('', '', '')41
42
setup.py: platform.libc_ver() => ('', '')43
44
setup.py: Detected Darwin/Mac OS X.45
46
You can install FreeTDS with Homebrew or MacPorts, or by downloading47
48
and compiling it yourself.49
50
51
52
Homebrew (http://brew.sh/)53
54
--------------------------55
56
brew install freetds57
58
59
60
MacPorts (http://www.macports.org/)61
62
-----------------------------------63
64
sudo port install freetds65
66
67
68
setup.py: Not using bundled FreeTDS69
70
Traceback (most recent call last):71
72
File "<string>", line 16, in <module>73
74
File "/Users/xxx/.virtualenvs/oracle/build/pymssql/setup.py", line 181, in <module>75
76
if compiler.has_function('clock_gettime', libraries=['rt']):77
78
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 808, in has_function79
80
objects = self.compile([fname], include_dirs=include_dirs)81
82
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 616, in compile83
84
depends, extra_postargs)85
86
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 412, in _setup_compile87
88
self.mkpath(os.path.dirname(obj))89
90
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/ccompiler.py", line 931, in mkpath91
92
mkpath(name, mode, dry_run=self.dry_run)93
94
File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/distutils/dir_util.py", line 76, in mkpath95
96
"could not create '%s': %s" % (head, exc.args[-1]))97
98
distutils.errors.DistutilsFileError: could not create 'var': Permission denied99
So I try brew install freetds and I get:
Warning: freetds-0.91 already installed, it's just not linked
which at least makes sense, but I don’t know how to fix it.
EDIT: I’ve linked it, so brew install freetds gives the message that it’s already installed, but pip install pymssql still gives the above error message.
EDIT:
JavaScript
1
8
1
export CFLAGS=-Qunused-arguments2
export CPPFLAGS=-Qunused-arguments3
4
pip uninstall MySQL-python5
brew uninstall mysql6
brew install mysql --universal7
pip install MySQL-python8
Which now gives me the error:
JavaScript
1
8
1
Traceback (most recent call last):2
File "time_reporting.py", line 34, in <module>3
import pymssql4
ImportError: dlopen(/Users/xxx/.virtualenvs/oracle/lib/python2.7/site-packages/pymssql.so, 2): Symbol not found: _dbversion5
Referenced from: /Users/xxx/.virtualenvs/oracle/lib/python2.7/site-packages/pymssql.so6
Expected in: flat namespace7
in /Users/xxx/.virtualenvs/oracle/lib/python2.7/site-packages/pymssql.so8
Which I’ve had and fixed before but I don’t remember what I did.
EDIT:
OK, I’ve re-installed the 32-bit oracle and forced Python to run the 32-bit version (I think. I really have no idea what that last sentence means, but I think I’ve followed instructions correctly).
At any rate, here’s my error message now:
JavaScript
1
7
1
File "time_reporting.py", line 31, in <module>2
import cx_Oracle3
File "build/bdist.macosx-10.8-x86_64/egg/cx_Oracle.py", line 7, in <module>4
File "build/bdist.macosx-10.8-x86_64/egg/cx_Oracle.py", line 6, in __bootstrap__5
ImportError: dlopen(/Users/xxx/.python-eggs/cx_Oracle-5.1.3-py2.7-macosx-10.8-x86_64.egg-tmp/cx_Oracle.so, 2): no suitable image found. Did find:6
/Users/xxx/.python-eggs/cx_Oracle-5.1.3-py2.7-macosx-10.8-x86_64.egg-tmp/cx_Oracle.so: mach-o, but wrong architecture7
Advertisement
Answer
Ran these as root:
JavaScript
1
3
1
export CFLAGS=-Qunused-arguments2
export CPPFLAGS=-Qunused-arguments3
Then had to do:
JavaScript
1
5
1
pip uninstall MySQL-python2
brew uninstall mysql3
brew install mysql --universal4
pip install MySQL-python5
Not sure if it will be successful but it’s at least a new error message.