itoolkit can be pip installed just fine* so long as you have GCC and some
   other tools installed.
    
   ibm-db can not be pip installed directly since the IBM i-related changes
   have not been merged upstream. My suggest would be to either git clone or
   download one of the tagged releases from my github, eg
   [1]
https://github.com/kadler/python-ibmdb/tree/2.0.5.9 or
   [2]
https://github.com/kadler/python-ibmdb/archive/2.0.5.9.zip
    
    
   From the cloned/extracted directory, you can do
    
   CFLAGS='-DPASE' python3 setup.py bdist_wheel
    
   to create a wheel file, then do
    
   pip install dist/ibm_db-*.whl
    
   to install it in to your virtual environment.
    
   You'll probably need to copy the SQLCLI header files as well. We have a
   package for this now (sqlcli-devel), but Python doesn't look there so you
   will have to pass -I/QOpenSys/pkgs/include/sqlcli (? I'm not sure the path
   here - currently doing this from memory as I try to recover my laptop).
    
    
   Good luck!
    
    
   *on non-IBM i systems it can also be pip installed, you just need a trick
   to disable building ilibcall, since that only works on IBM i
    
   ----
   Kevin Adler
   Software Development - Open Source, PASE, IBM i Access ODBC
   IBM Systems, Dept 47U
   Phone: +1-507-253-5111
   Email: kadler@xxxxxxxxxx
   015-3 C117
   3605 HWY 52 N
   Rochester, MN 55901-1407
   United States
    
    
     ----- Original message -----
     From: Craig Richards <craig@xxxxxxxxxxxxxxxx>
     Sent by: "OpenSource" <opensource-bounces@xxxxxxxxxxxxxxxxxx>
     To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
     Cc:
     Subject: Re: [IBMiOSS] ibm-db and itoolkit into venv
     Date: Mon, Apr 1, 2019 10:58 AM
      
     Hi John,
     Thanks for your reply.
     I installed 3.6.6 via the Open Souce Package Management option from IBMi
     ACS.
     Forgive my ignorance but I don't know if this uses yum under the covers
     or
     if there is another way to use yum to do the install directly.
     I can see a python3 update (on the Open Source Package Management
     Screen)
     to version 3.6.8-1.
     So I could for sure run that update.
     But I assume this will just update the version in /QOpenSys/pkgs/bin
     I could then re-create my venv and it would be at the 3.6.8-1 version of
     python but the venv wouldn't not contain ibm-db and itoolkit.
     To install packages into my venv I'd normally activate the venv then pip
     install the required packages.
     But I thought from Justin's response to an earlier email that that
     process
     would not work for ibm-db and itoolkit.
     If I can't pip-install them into the venv I'm not sure how to get them
     into
     the venv?
     thanks,
     Craig
     On Mon, 1 Apr 2019 at 15:47, John Yeung <gallium.arsenide@xxxxxxxxx>
     wrote:
     > On Mon, Apr 1, 2019 at 10:26 AM Craig Richards
     <craig@xxxxxxxxxxxxxxxx>
     > wrote:
     > > I'm running python 3.6.6 (on the IBMi) and have just set up a venv
     > version
     > > which seems to be working fine.
     >
     > The fact that you are running 3.6 rather than 3.4 suggests you have
     > installed Python 3 via yum. This is a Good Thing.
     >
     > > ibm-db
     > > itoolkit
     > >
     > > If these cannot be pip installed - are there any instructions anyone
     > could
     > > point me to that are complete and exact enough for a newbie to
     follow?
     >
     > These should also be installed via yum. Since you presumably installed
     > Python 3 via yum, you should be able to do these as well. If you don't
     > know the exact name to type, do 'yum list' to get a complete listing.
     >
     > Incidentally, the folks at IBM are releasing new RPMs fairly
     > frequently. We are at Python 3.6.8 now. If you have the time, 'yum
     > upgrade' will go through everything you've installed via yum and
     > update to the latest available. I'm not completely sure about the
     > difference between 'update' and 'upgrade', but it seems you use the
     > former for individual packages and the latter for your whole system.
     > Use 'yum --help' and/or Google for more information on how to use yum.
     >
     > John Y.
     > --
     > This is the IBMi Open Source Roundtable (OpenSource) mailing list
     > To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
     > To subscribe, unsubscribe, or change list options,
     > visit: [3]
https://lists.midrange.com/mailman/listinfo/opensource
     > or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
     > Before posting, please take a moment to review the archives
     > at [4]
https://archive.midrange.com/opensource.
     >
     > Help support midrange.com by shopping at amazon.com with our affiliate
     > link: [5]
https://amazon.midrange.com
     >
     --
     This is the IBMi Open Source Roundtable (OpenSource) mailing list
     To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx
     To subscribe, unsubscribe, or change list options,
     visit: [6]
https://lists.midrange.com/mailman/listinfo/opensource
     or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
     Before posting, please take a moment to review the archives
     at [7]
https://archive.midrange.com/opensource.
     Help support midrange.com by shopping at amazon.com with our affiliate
     link: [8]
https://amazon.midrange.com
      
    
References
   Visible links
   1. 
https://github.com/kadler/python-ibmdb/tree/2.0.5.9
   2. 
https://github.com/kadler/python-ibmdb/archive/2.0.5.9.zip
   3. 
https://lists.midrange.com/mailman/listinfo/opensource
   4. 
https://archive.midrange.com/opensource
   5. 
https://amazon.midrange.com/
   6. 
https://lists.midrange.com/mailman/listinfo/opensource
   7. 
https://archive.midrange.com/opensource
   8. 
https://amazon.midrange.com/
As an Amazon Associate we earn from qualifying purchases.