AIX Open Source

AIX Open Source

Share your experiences and connect with fellow developers to discover how to build and manage open source software for the AIX operating system

 View Only
Back to discussions
Expand all | Collapse all

yum no sqlite module

Archive User

Archive UserWed February 06, 2019 12:17 PM

Originally posted by: AyappanP not needed.

  • 1.  yum no sqlite module

    Posted Tue February 05, 2019 11:45 PM

    Originally posted by: GaryKortz_GHS


    AIX 7.1 TL5 SP02-1838.

    Installed yum with yum.sh script worked as expected.

    yum update generated an error that suggested openssl should be updated. Installed openssl-1.0.2.1300.

    yum update indicates no module sqlite for python.

    Based on related posts/comments

    reinstalled sqlite-3.23.0-1.aix6.1.ppc.rpm

    reinstalled glib2-2.56.1-2.aix6.1.pprc.rpm

     

    Still no change. Attached text file as additional details that spam filter would not allow me to post.



  • 2.  Re: yum no sqlite module

    Posted Wed February 06, 2019 05:31 AM

    Originally posted by: AyappanP


    Check whether you have this file in your machine.

    ls -l /opt/freeware/lib/python2.7/site-packages/pysqlite2/_sqlite.so



  • 3.  Re: yum no sqlite module

    Posted Wed February 06, 2019 10:16 AM

    Originally posted by: GaryKortz_GHS


    Results:

    ls -l /opt/freeware/lib/python2.7/site-packages/pysqlite2/_sqlite.so
    -rwxr-xr-x    1 root     system       174602 Jun 20 2018  /opt/freeware/lib/python2.7/site-packages/pysqlite2/_sqlite.so
     

    Thanks



  • 4.  Re: yum no sqlite module

    Posted Wed February 06, 2019 10:21 AM

    Originally posted by: AyappanP


    Okay. You seem to have the file. 

    Execute the below and copy the output in a file and attach.

    #python2

    >>> help('modules')                                 --> This will list all the available python modules.



  • 5.  Re: yum no sqlite module

    Posted Wed February 06, 2019 10:27 AM
      |   view attached

    Originally posted by: GaryKortz_GHS


    Requested output attached.

     

    Thanks

    Attachment(s)

    txt
    AIX_python_info.txt   5 KB 1 version


  • 6.  Re: yum no sqlite module

    Posted Wed February 06, 2019 11:21 AM

    Originally posted by: AyappanP


    Seems tricky. 

    Can you try downgrading the sqlite to 3.15.2 using rpm command (rpm --oldpackage <rpm> ) and check ?

    You can get it from here --> ftp://public.dhe.ibm.com/aix/freeSoftware/aixtoolbox/RPMS/ppc/sqlite/

     



  • 7.  Re: yum no sqlite module

    Posted Wed February 06, 2019 11:41 AM

    Originally posted by: GaryKortz_GHS


    # rpm -Uvh --force sqlite-3.15.2-1.aix6.1.ppc.rpm
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:sqlite-3.15.2-1                  ################################# [ 50%]
    Cleaning up / removing...
       2:sqlite-3.23.0-1                  ################################# [100%]
     

    # rpm -q sqlite
    sqlite-3.15.2-1.ppc
     

    Same results

    # yum update
    There was a problem importing one of the Python modules
    required to run yum. The error leading to this problem was:
       No module named sqlite
    Please install a package which provides this module, or
    verify that the module is installed correctly.
    It's possible that the above module doesn't match the
    current version of Python, which is:
    2.7.10 (default, Jun 22 2016, 05:57:59) [C]
    If you cannot solve this problem yourself, please go to
    the yum faq at:
      http://yum.baseurl.org/wiki/Faq

     

    python module list same date stamp on _sqlite.so unchanged.



  • 8.  Re: yum no sqlite module

    Posted Wed February 06, 2019 12:09 PM

    Originally posted by: AyappanP


    We should have done this for pysqlite rather than sqlite.

    Can you try downgrading pysqlite to 1.1.7-2 ?

    ftp://public.dhe.ibm.com/aix/freeSoftware/aixtoolbox/RPMS/ppc/python/



  • 9.  Re: yum no sqlite module

    Posted Wed February 06, 2019 12:14 PM

    Originally posted by: GaryKortz_GHS


    Will do. Do you want me to return the sqlite do the prior version?



  • 10.  Re: yum no sqlite module

    Posted Wed February 06, 2019 12:21 PM

    Originally posted by: GaryKortz_GHS


    # rpm -Uvh --force pysqlite-1.1.7-2.aix6.1.ppc.rpm
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:pysqlite-1.1.7-2                 ################################# [ 50%]
    Cleaning up / removing...
       2:pysqlite-2.8.3-1                 ################################# [100%]

     

    Moving forward:

    yum update now responds, however, have a new dependency error.

    --> Processing Dependency: libssl.a(libssl.so.1.0.2) for package: python-2.7.15-3.ppc
    --> Processing Dependency: libcrypto.a(libcrypto.so.1.0.2) for package: python-2.7.15-3.ppc
    --> Finished Dependency Resolution
    Error: Package: python-2.7.15-3.ppc (AIX_Toolbox)
               Requires: libssl.a(libssl.so.1.0.2)
    Error: Package: python-2.7.15-3.ppc (AIX_Toolbox)
               Requires: libcrypto.a(libcrypto.so.1.0.2)
     You could try using --skip-broken to work around the problem
     You could try running: rpm -Va --nofiles --nodigest
     



  • 11.  Re: yum no sqlite module

    Posted Wed February 06, 2019 12:17 PM

    Originally posted by: AyappanP


    not needed.



  • 12.  Re: yum no sqlite module

    Posted Wed February 06, 2019 12:27 PM

    Originally posted by: AyappanP


    Read this thread to resolve this error --> https://www.ibm.com/developerworks/community/forums/html/topic?id=96017324-8232-4242-9276-cd32f5d04486&ps=25



  • 13.  Re: yum no sqlite module

    Posted Wed February 06, 2019 12:58 PM
      |   view attached

    Originally posted by: GaryKortz_GHS


    Continue to have issue. Attaching details in file as I get spam posting when pasted in reply.

    I wanted to note that I updated openssl but not the SSH in the environment based on assumption that the issue was openssl so and not SSH related. Is this correct?

     

    Attachment(s)

    txt
    AIX_SSL_info.txt   1 KB 1 version


  • 14.  Re: yum no sqlite module

    Posted Thu February 07, 2019 01:01 AM

    Originally posted by: AyappanP


    You didn't went through the thread properly.

    Do you think "openssl 1.0.2.1300 " is the latest available version in AIX web download pack programs ? 



  • 15.  Re: yum no sqlite module

    Posted Thu February 07, 2019 03:27 AM

    Originally posted by: GaryKortz_GHS


    Yes, I agree I did not execute all of the steps in the link you provided. If you look at the very top of my post you will see that I previously installed openssl at 1.0.2.1300 which according to another article would address this issue. This seemed specific to my issue. (https://www.djouxtech.net/posts/aix-yum-upgrade-problem/). I will locate the latest version and try again.

     

    Thank-you



  • 16.  Re: yum no sqlite module

    Posted Thu February 07, 2019 06:53 AM

    Originally posted by: GaryKortz_GHS


    Located 1.0.2.1601 and installed openssl. I did not modify the existing SSH installation followed by updtvpkg. yum works as expected. The release notes indicate that no openssl release prior to 1.0.2.1600 contains 1.02 so.

     

    Thanks very much for your assistance.



Related Content