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 https://github.com/mkleehammer/pyodbc/archive/4.0.26.tar.gz
(env) $ tar xvzf 4.0.26.tar.gz
(env) $ cd pyodbc-4.0.25
(env) $ python setup.py build
(env) $ python setup.py 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:

    env/lib64/python3.6/dist-packages/

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 setup.py install a go.

And we’re good to go.

My Personality (2019 Edition)

Given that the past year has been a big one, it’s time to see how my personality test holds up to last years.

Your type is: INFP

“Questor”. High capacity for caring. Emotional face to the world. High sense of honor derived from internal values. 4.4% of total population.

Introverted (I) 54.29% / Extroverted (E) 45.71%
Intuitive (N) 86.67% / Sensing (S) 13.33%
Feeling (F) 64.52% / Thinking (T) 35.48%
Perceiving (P) 88.89% Judging (J) 11.11%

Type 1 Orderliness |||||| 23%
Type 2 Helpfulness |||||||||||||| 60%
Type 3 Image Awareness |||||||||||||||| 63%
Type 4 Individuality |||||||||||||||||||| 83%
Type 5 Rationality |||||||||||| 50%
Type 6 Cautiousness |||| 13%
Type 7 Adventurousness ||||||||||||||| 66%
Type 8 Aggressiveness ||| 20%
Type 9 Calmness |||||||||||||||||||| 83%

Your main type is Type 4

Your variant stacking is spsxso

type score type behavior motivation
4 25 I must be unique/different to survive.
9 25 I must maintain peace/calm to survive.
7 20 I must be fun and entertained to survive.
3 19 I must be impressive and attractive to survive.
2 18 I must be helpful and caring to survive.

High level – still INFP. Lower level my type has shifted a tad. Probably as priorities and desires have changed with the little man.

If you’re curious about yours, this was made using the Jung+Enneagram test.