Re: [IBMiOSS] beginning python

Hi Mike,

The Python code is trying to call a routine (SSL_CTX_set_post_handshake_auth) that doesn't exist in your version of OpenSSL.   This routine was added to OpenSSL in version 1.1.1, so you'll need to update OpenSSL to that version or newer.

I don't know the answers to your other questions (I haven't coded Python in many years.)

-SK

On 12/9/2019 2:29 PM, Smith, Mike wrote:

I'm starting to play around with python a little. I've run into small problems and have a couple basic questions.

I have python 2.7 and and just upgraded python3 from 3.4.6 to 3.6.9 .
I also have two different user profiles. QSECOFR level and a user level.
When I do a call qp2term with my user level profile I only see python 3.4.6
On my QSECOFR level I see python 3.6.9
However when I try to run a script from my QSECOFR level I keep getting
Error in sitecustomize; set PYTHONVERBOSE for traceback:
ImportError: rtld: 0712-001 Symbol SSL_CTX_set_post_handshake_auth was referenced
from module /QOpenSys/pkgs/lib/python3.6/lib-dynload/_ssl.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-002 fatal error: exiting.
Python 3.6.9 (default, Oct 31 2019, 11:30:53)

I renamed the sitecustomize.py file, but as soon as I rename and refresh it is back to its original name.

That's my immediate concerns.

Now a couple of basic questions.

From python can I create spool files? Don't know if I want to just wondering!

Trying out a sample I found to create a spreadsheet, I found I needed to import xlsxwriter. I did not see that listed under the ACS Package manager, but was able to do a PIP Install. Just trying to understand when and why I should use ACS vs PIP.

Can I connect to sql server from python running on the I. I tried to import pyodbc, but it is failing. Should I be using this?

Can someone point me to some slightly more advanced example of connecting to db2 and creating a report.

Thanks

MIke