baztian / jaydebeapi

JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.
GNU Lesser General Public License v3.0
364 stars 147 forks source link

installation on zOS USS is failing. #214

Open ValGaOnGitHub opened 2 years ago

ValGaOnGitHub commented 2 years ago

I installed IBM Python 3.8 for zOS in my personal space on GCC. It is working.

Now I’m trying to connect Python to DB2 zOS.

I’m trying to install JayDeBeApi Python package in my personal USS space on GCC.  Installation is failing.

Below is full stdout of the process.

I noticed that process is using /usr/lpp/cbclib/xlclang/exe/clcdrvr (FMID HLB77C1) and on our site it is at /usr/lpp/cbclib/xlc/exe/ccndrvr  (FMID HLB77C0)

The only control, without hacking, over the process I have are environmental variables that I set, highlighted are related to C/C++ compiler.

 

export LIBPATH=/u/xxxxxxxx/Python/lib:/usr/lpp/java/J8.0/bin/j9vm:$LIBPATH

export CC=/bin/xlclang

export CXX=/bin/xlclang++

export _BPXK_AUTOCVT='ON'

export _CEE_RUNOPTS='FILETAG(AUTOCVT,AUTOTAG) POSIX(ON)'

export _TAG_REDIR_ERR='TXT'

export _TAG_REDIR_IN='TXT'

export _TAG_REDIR_OUT='TXT'

export CLASSPATH=/apps/aj00/usr/lpp/db2/jdbc/jcc/classes/db2jcc.jar

unset JAVA_HOME

Can you suggest the way to change above path. Please?

 

Thanks,

 

 $ pip3 install JayDeBeApi --find-links ./

Looking in links: ./

WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x5009506970>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jaydebeapi/

WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x5009506B20>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jaydebeapi/

WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x50095144F0>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jaydebeapi/

WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x50095146D0>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jaydebeapi/

WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x5009514820>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jaydebeapi/

Processing ./JayDeBeApi-1.2.3-py3-none-any.whl

WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x50095778E0>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jpype1/

WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x5009514190>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jpype1/

WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x500954C580>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jpype1/

WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x500954C3A0>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jpype1/

WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ConnectTimeoutError(<pip._vendor.urllib3.connection.HTTPSConnection object at 0x500956F640>, 'Connection to pypi.org timed out. (connect timeout=15)')': /simple/jpype1/

Processing ./JPype1-1.3.0.tar.gz

Using legacy 'setup.py install' for JPype1, since package 'wheel' is not installed.

Installing collected packages: JPype1, JayDeBeApi

    Running setup.py install for JPype1 ... error

    ERROR: Command errored out with exit status 1:

     command: /u/XXXXXXX/Python/usr/lpp/IBM/cyp/v3r8/pyz/bin/python3.8 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/u/q4s6svs/Python/tmp/pip-install-20_q2nfc/jpype1_0d94756e717d49fa80a5af8de84fc64d/setup.py'"'"'; file='"'"'/u/q4s6svs/Python/tmp/pip-install-20_q2nfc/jpype1_0d94756e717d49fa80a5af8de84fc64d/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(file) if os.path.exists(file) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record /u/XXXXXXX/Python/tmp/pip-record-8jh5sixc/install-record.txt --single-version-externally-managed --compile --install-headers /u/XXXXXXX/Python/usr/lpp/IBM/cyp/v3r8/pyz/include/python3.8/JPype1

         cwd: /u/XXXXXXXX/Python/tmp/pip-install-20_q2nfc/jpype1_0d94756e717d49fa80a5af8de84fc64d/

    Complete output (57 lines):

    running install

    running build

    running build_py

    creating build

    creating build/lib.os390-27.00-8561-3.8

    creating build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/init.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_classpath.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_core.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_gui.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jarray.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jclass.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jcollection.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jcustomizer.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jexception.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jinit.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jio.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jmethod.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jobject.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jpackage.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jproxy.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jstring.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jthread.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jvmfinder.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_pykeywords.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/beans.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/config.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/dbapi2.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/imports.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/nio.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/pickle.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/protocol.py -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/types.py -> build/lib.os390-27.00-8561-3.8/jpype

    package init file 'jpype/_pyinstaller/init.py' not found (or not a regular file)

    creating build/lib.os390-27.00-8561-3.8/jpype/_pyinstaller

    copying jpype/pyinstaller/entrypoints.py -> build/lib.os390-27.00-8561-3.8/jpype/_pyinstaller

    copying jpype/_pyinstaller/example.py -> build/lib.os390-27.00-8561-3.8/jpype/_pyinstaller

    copying jpype/_pyinstaller/hook-jpype.py -> build/lib.os390-27.00-8561-3.8/jpype/_pyinstaller

    copying jpype/_pyinstaller/testjpypepyinstaller.py -> build/lib.os390-27.00-8561-3.8/jpype/_pyinstaller

    copying jpype/_core.pyi -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jcollection.pyi -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jio.pyi -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jstring.pyi -> build/lib.os390-27.00-8561-3.8/jpype

    copying jpype/_jthread.pyi -> build/lib.os390-27.00-8561-3.8/jpype

    running build_ext

    Call build extensions

    Using Jar cache

    copying native/jars/org.jpype.jar -> build/lib.os390-27.00-8561-3.8

    Call build ext

    building '_jpype' extension

    creating build/temp.os390-27.00-8561-3.8

    creating build/temp.os390-27.00-8561-3.8/native

    creating build/temp.os390-27.00-8561-3.8/native/common

    creating build/temp.os390-27.00-8561-3.8/native/python

    /bin/xlclang++ -fno-strict-aliasing -DNDEBUG -qarch=10 -q64 -Wc,DLL -D_XOPEN_SOURCE_EXTENDED -D_UNIX03_THREADS -D_POSIX_THREADS -D_OPEN_SYS_FILE_EXT -qexportall -qascii -qstrict -qnocsect -Wa,asa,goff -Wa,xplink -qgonumber -qenum=int -Inative/common/include -Inative/python/include -Inative/embedded/include -Inative/jni_include -I/u/q4s6svs/Python/usr/lpp/IBM/cyp/v3r8/pyz/include/python3.8 -c native/common/jp_array.cpp -o build/temp.os390-27.00-8561-3.8/native/common/jp_array.o

    FSUM3224 xlclang++: Fatal error in /usr/lpp/cbclib/xlclang/exe/clcdrvr: signal 9 received.

    error: command '/bin/xlclang++' failed with exit code 251

    ----------------------------------------

ERROR: Command errored out with exit status 1: /u/XXXXXXXXX/Python/usr/lpp/IBM/cyp/v3r8/pyz/bin/python3.8 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/u/XXXXXXXXX/Python/tmp/pip-install-20_q2nfc/jpype1_0d94756e717d49fa80a5af8de84fc64d/setup.py'"'"'; file='"'"'/u/q4s6svs/Python/tmp/pip-install-20_q2nfc/jpype1_0d94756e717d49fa80a5af8de84fc64d/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(file) if os.path.exists(file) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, file, '"'"'exec'"'"'))' install --record /u/q4s6svs/Python/tmp/pip-record-8jh5sixc/install-record.txt --single-version-externally-managed --compile --install-headers /u/xxxxxxxx/Python/usr/lpp/IBM/cyp/v3r8/pyz/include/python3.8/JPype1 Check the logs for full command output.