Re: [IBMiOSS] beginning python

[Scott Klement <opensource@xxxxxxxxxxxxxxxx>]

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