PYODBC face smash

Just had a hell of a time installing pyodbc on AWS ECS Linux AMI. And since I think I smashed it… here’s what i did.

First go though everything on this post. An awesome start

AWS EC2 Linux AMI with pyodbc

However, the challenege I had next

(env) [ec2-user@ip-172-30-1-231 eurion]$ pip install pyodbc
Collecting pyodbc
Installing collected packages: pyodbc

Yet, pip freeze still had no pyodbc! FACESMASH!

So, after running through it 100 more times slightly differently, it occured, let’s go manually, shall we??

(env) $ cd ~/src
(env) $ curl -O -L
(env) $ tar xvzf 4.0.26.tar.gz
(env) $ cd pyodbc-4.0.25
(env) $ python build
(env) $ python install

not there… one more error.

TEST FAILED: env/lib64/python3.6/dist-packages/ does NOT support .pth files
error: bad install directory or PYTHONPATH

You are attempting to install a package to a directory that is not
on PYTHONPATH and which Python does not read ".pth" files from.  The
installation directory you specified (via --install-dir, --prefix, or
the distutils default setting) was:


and your PYTHONPATH environment variable currently contains:


So I guess I’m setting $PYTHONPATH

After trying a few try’s, I needed to knwo not just my virtural environment directory but also where my
site-packages and dist-packages. Which ended up being

export PYTHONPATH=$PROJROOT/env/:$PROJROOT/env/lib64/python3.6/dist-packages/:$PROJROOT/env/lib64/python3.6/site-packages/

Any now give python install a go.

And we’re good to go.