Moinuddin Quadri Moinuddin Quadri - 23 days ago 6
Apache Configuration Question

(Nginx +gunicorn)/Apache not reading environment variables

I am getting:

[01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/nz/lib64/libnzodbc.so' : file not found (0) (SQLDriverConnect)"


error while creating connection using
PyODBC
. This works fine when I use it via Django Development server. But on using it via.
Gunicorn
and
Nginx
, it fails.

I faced this issue in the past (while configuring the Development server) when:


  1. Some of the libraries needed by UnixODBC were missing. Since, it is working with Django development server, this couldn't be the issue

  2. When environment variables
    PATH
    and
    LD_LIBRARY_PATH
    do not had the path to my driver.



Most likely I think 2nd is the cause. I tried setting up the environment variables in
/etc/profile
and
/etc/environment
but no luck. Does anyone have idea regarding what might be wrong here?

Edit: It has nothing to do with
Gunicorn
as directly running the gunicorn server using:

gunicorn --bind 0.0.0.0:8000 my_project.wsgi:application


works fine. Issue is while communication with Nginx via wsgi.




All the required environment methods are setted up correctly:

mquadri@MY_HOST:/tmp/webadmin$ env
LD_LIBRARY_PATH=/usr/local/nz/lib64
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/usr/local/nz/bin64
NZ_ODBC_INI_PATH=/home/mquadri/CONFIG
HOME=/home/mquadri
ODBCINI=/home/mquadri/CONFIG/odbc.ini
NETEZZA=/usr/local/nz


Output of
ldd
in case someone might find it useful (all these files listed here are already present)

mquadri@MY_HOST:/tmp/webadmin$ ldd /usr/local/nz/lib64/libnzodbc.so
linux-vdso.so.1 => (0x00007fff96dfa000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f286f0f1000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f286edeb000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f286ebcc000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f286e9c8000)
libkrb5.so.3 => /usr/local/nz/lib64/libkrb5.so.3 (0x00007f286e7e8000)
libkrb5support.so.0 => /usr/local/nz/lib64/libkrb5support.so.0 (0x00007f286e6da000)
libcom_err.so.3 => /usr/local/nz/lib64/libcom_err.so.3 (0x00007f286e5d7000)
libk5crypto.so.3 => /usr/local/nz/lib64/libk5crypto.so.3 (0x00007f286e494000)
/lib64/ld-linux-x86-64.so.2 (0x00007f286f806000)
libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f286e278000)





Edit 2: If I set these environment variables explicitly in
settings.py
development server runs fine, but
nginx
gives
Internal Server Error
.

Answer

Later I tried with Apache and found the same behavior. On doing a lot of research, I found that apache uses the external environment variables defined in its: apache2/envars. I added to the file my variables as:

export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/usr/local/nz/lib64"
export PATH="$PATH:/usr/local/nz/bin64"
export NETEZZA="/usr/local/nz"
export NZ_ODBC_INI_PATH="/etc"