Hello,

Today, while trying to install the apsw package for python on an IBM POWER 
system I found I needed a new version of sqlite.

I tried to build sqlite from sqlite-configure-3801001.tar.gz on an IBM 
POWER system running ubuntu and the build failed due to a lack of 
knowledge of ppc64le in the embedded config.guess / config.sub scripts.

On my target system "uname -a" gives:
        Linux pip-test 3.13.0-32-generic #57-Ubuntu SMP Tue Jul 15 
03:50:31 UTC 2014 ppc64le ppc64le ppc64le GNU/Linux

The commands I used (as suggested on the sqlite download page of 
http://www.sqlite.org/cgi/src/doc/trunk/README.md ) are:

        mkdir test_area
        cd test_area
        mkdir sqlite
        cd sqlite
        wget https://www.sqlite.org/2015/sqlite-autoconf-3081001.tar.gz
        tar xvf *gz
        mkdir bld
        cd bld
        ../sqlite-autoconf-3081001/configure 

Here I am told that the config.guess command in the source does not know 
about ppc64le.

I then tried the same commands on an x86 system and all went smoothly. 
Back on the POWER system I downloaded new versions for config.guess and 
config.sub, overlaid the versions in the sqlite directory, then tried 
again:

        cd ..
        find . -name config.guess
        find . -name config.sub
        cd ..
        wget  -O config.guess 
'http://git.savannah.gnu.org/gitweb/?p=config.git;a=blob_plain;f=config.guess;hb=HEAD'
        wget  -O config.sub 
'http://git.savannah.gnu.org/gitweb/?p=config.git;a=blob_plain;f=config.sub;hb=HEAD'
        chmod +x con*
        ./config.guess 
        cd sqlite/sqlite-autoconf-3081001/
        ls config.*
        mv config.guess config.guess.orig
        mv config.sub config.sub.orig
        cp ../../config.* .
        ../bld/
        ../sqlite-autoconf-3081001/configure
        make
        make sqlite3.c
        make test
        sudo make install

The test target is not present in the Makefile but all the other 
operations succeeded on my ppc64le target.

Before submitting this report I found 
http://article.gmane.org/gmane.comp.db.sqlite.general/85660/match=config+guess 
which may be related.  Replacing config.guess and config.sub worked for 
me. 

I am happy to validate operation on the POWER system for you once the 
latest config.guess and config.sub files are in the sqlite source.

Thank you,
Paul


Paul G Crumley
STSM & Manager
IBM Research

Reply via email to