On Nov 2, 2008, at 2:07 PM, Roger Binns wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Michael Muratet wrote: >> Can someone please tell me where I could start looking for the >> problem? > > You seem to be mixing system supplied SQLite libraries, your own > compiled ones and Python SQLite module. It also looks like you are > using a Mac.
Roger Thanks for the reply. The mail client is Mac but the problem I'm having is on RedHat ES3 on a Dell 8-core. > The OSX platform does go out of its way to ensure you use > the system SQLite and not any others you have specified first in link > lines. One workaround was to rename any SQLite library you built to > something else and then link against it. You also need to be careful > that you don't end up with SQLite twice in the same process (eg iirc > CoreData also uses system SQLite). > I had pysqlite but removed it. I'm at python 2.6 and pysqlite was in the 2.5 tree it that makes a difference. > For my Mac users I recommend only using the amalgamation which ensures > no link time issues. It is also used in such a way that it can > coexist > with other versions of SQLite in the same process. See > http://code.google.com/p/apsw/ I installed from the amalgamation and there is something peculiar occurring: [EMAIL PROTECTED] sqlite-3.6.4]# make if /bin/sh ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME= \"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.6.4\" - DPACKAGE_STRING=\"sqlite\ 3.6.4\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org \" -DPACKAGE=\"sqlite\" -DVERSION=\"3.6.4\" -DSTDC_HEADERS=1 - DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 - DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 - DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 - DHAVE_DLFCN_H=1 -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 - DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_READLINE=1 -I. -I. - DSQLITE_THREADSAFE=1 -g -O2 -MT sqlite3.lo -MD -MP -MF ".deps/ sqlite3.Tpo" -c -o sqlite3.lo sqlite3.c; \ then mv -f ".deps/sqlite3.Tpo" ".deps/sqlite3.Plo"; else rm -f ".deps/ sqlite3.Tpo"; exit 1; fi mkdir .libs gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" - DPACKAGE_VERSION=\"3.6.4\" "-DPACKAGE_STRING=\"sqlite 3.6.4\"" - DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE=\"sqlite\" - DVERSION=\"3.6.4\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 - DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 - DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 - DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 - DHAVE_READLINE=1 -I. -I. -DSQLITE_THREADSAFE=1 -g -O2 -MT sqlite3.lo - MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -fPIC -DPIC -o .libs/ sqlite3.o gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" - DPACKAGE_VERSION=\"3.6.4\" "-DPACKAGE_STRING=\"sqlite 3.6.4\"" - DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE=\"sqlite\" - DVERSION=\"3.6.4\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 - DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 - DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 - DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 - DHAVE_READLINE=1 -I. -I. -DSQLITE_THREADSAFE=1 -g -O2 -MT sqlite3.lo - MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -o sqlite3.o >/dev/null 2>&1 /bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1 -g - O2 -o libsqlite3.la -rpath /usr/local/lib -no-undefined -version- info 8:6:8 sqlite3.lo -ldl -lpthread gcc -shared .libs/sqlite3.o -ldl -lpthread -Wl,-soname - Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6 (cd .libs && rm -f libsqlite3.so.0 && ln -s libsqlite3.so.0.8.6 libsqlite3.so.0) (cd .libs && rm -f libsqlite3.so && ln -s libsqlite3.so.0.8.6 libsqlite3.so) ar cru .libs/libsqlite3.a sqlite3.o ranlib .libs/libsqlite3.a creating libsqlite3.la (cd .libs && rm -f libsqlite3.la && ln -s ../libsqlite3.la libsqlite3.la) if gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" - DPACKAGE_VERSION=\"3.6.4\" -DPACKAGE_STRING=\"sqlite\ 3.6.4\" - DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE=\"sqlite\" - DVERSION=\"3.6.4\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 - DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 - DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 - DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 - DHAVE_READLINE=1 -I. -I. -DSQLITE_THREADSAFE=1 -g -O2 -MT shell.o - MD -MP -MF ".deps/shell.Tpo" -c -o shell.o shell.c; \ then mv -f ".deps/shell.Tpo" ".deps/shell.Po"; else rm -f ".deps/ shell.Tpo"; exit 1; fi /bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1 -g - O2 -o sqlite3 shell.o ./libsqlite3.la -lreadline -lcurses -ldl - lpthread gcc -DSQLITE_THREADSAFE=1 -g -O2 -o .libs/sqlite3 shell.o ./.libs/ libsqlite3.so -lreadline -lcurses -ldl -lpthread creating sqlite3 [EMAIL PROTECTED] sqlite-3.6.4]# make check make: Nothing to be done for `check'. [EMAIL PROTECTED] sqlite-3.6.4]# make install make[1]: Entering directory `/usr/local/src/sqlite-3.6.4' test -z "/usr/local/lib" || mkdir -p -- "/usr/local/lib" /bin/sh ./libtool --mode=install /usr/bin/install -c 'libsqlite3.la' '/usr/local/lib/libsqlite3.la' /usr/bin/install -c .libs/libsqlite3.so.0.8.6 /usr/local/lib/ libsqlite3.so.0.8.6 (cd /usr/local/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so.0 || { rm -f libsqlite3.so.0 && ln -s libsqlite3.so.0.8.6 libsqlite3.so. 0; }; }) (cd /usr/local/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so || { rm -f libsqlite3.so && ln -s libsqlite3.so.0.8.6 libsqlite3.so; }; }) /usr/bin/install -c .libs/libsqlite3.lai /usr/local/lib/libsqlite3.la /usr/bin/install -c .libs/libsqlite3.a /usr/local/lib/libsqlite3.a chmod 644 /usr/local/lib/libsqlite3.a ranlib /usr/local/lib/libsqlite3.a PATH="$PATH:/sbin" ldconfig -n /usr/local/lib ---------------------------------------------------------------------- Libraries have been installed in: /usr/local/lib If you ever happen to want to link against installed libraries in a given directory, LIBDIR, you must either use libtool, and specify the full pathname of the library, or use the `-LLIBDIR' flag during linking and do at least one of the following: - add LIBDIR to the `LD_LIBRARY_PATH' environment variable during execution - add LIBDIR to the `LD_RUN_PATH' environment variable during linking - use the `-Wl,--rpath -Wl,LIBDIR' linker flag - have your system administrator add LIBDIR to `/etc/ld.so.conf' See any operating system documentation about shared libraries for more information, such as the ld(1) and ld.so(8) manual pages. ---------------------------------------------------------------------- test -z "/usr/local/bin" || mkdir -p -- "/usr/local/bin" /bin/sh ./libtool --mode=install /usr/bin/install -c 'sqlite3' '/ usr/local/bin/sqlite3' /usr/bin/install -c .libs/sqlite3 /usr/local/bin/sqlite3 test -z "/usr/local/include" || mkdir -p -- "/usr/local/include" /usr/bin/install -c -m 644 'sqlite3.h' '/usr/local/include/sqlite3.h' /usr/bin/install -c -m 644 'sqlite3ext.h' '/usr/local/include/ sqlite3ext.h' make[1]: Leaving directory `/usr/local/src/sqlite-3.6.4' [EMAIL PROTECTED] sqlite-3.6.4]# which sqlite3 /usr/local/bin/sqlite3 [EMAIL PROTECTED] sqlite-3.6.4]# sqlite3 SQLite version 3.3.6 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> The image in the directory is version 3.6.4, but the image that gets installed is 3.3.6. How can that be? Thanks Mike > > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > > iEYEARECAAYFAkkOCH8ACgkQmOOfHg372QSQNACgvqe4/7eMh1autwLqTOX5u6G6 > qDQAoI6RpOKuNBlGyHaaPDigymQcNXqU > =i+gy > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
