Here are my travails thus far. I have been singularly unable to build SQLite 3.5.2 with fts3 on Intel Mac OS X 10.4.11
I added the following to my Makefile.in #TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1 TCC += -DSQLITE_CORE=1 TCC += -DSQLITE_ENABLE_FTS3=1 and then added all the fts3 .c and .h files in the appropriate places as documented by Joe Wilson in another email. Then I did the following $ export MACOSX_DEPLOYMENT_TARGET=10.3 $ ./configure $ make make croaks with the following error /usr/bin/ld: Undefined symbols: _sqlite3Fts3InitHashTable collect2: ld returned 1 exit status make: *** [sqlite3] Error 1 This train is not going anywhere at all. In another post, my experience with fts2 On Nov 18, 2007 5:28 PM, P Kishor <[EMAIL PROTECTED]> wrote: > > On Nov 18, 2007 2:59 PM, P Kishor <[EMAIL PROTECTED]> wrote: > > On Nov 17, 2007 2:22 PM, P Kishor <[EMAIL PROTECTED]> wrote: > > > I need to build a DBD::SQLite package using SQLite with fts > > > capabilities. Can someone on this list kindly give me painless, easy > > > to understand instructions to do so? I need to do this on a Mac OS X > > > 10.4 first, and then on my web host subsequently (running some flavor > > > of Linux, natch). > > > > > > > > > ok, let's try this again. > > > > I found instructions for building a loadable extension at > > <http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions> > > > > Note to Richard on the subject of improving the website -- please make > > such instructions easier to find by perhaps linking them somewhere > > prominently under "building or compiling" right off the download page > > for the source code. > > > > That said, I tried to build the fts2 extension and got the following -- > > > > $ tar xvzf sqlite-3.4.2 > > $ mkdir sqlite-3.4.2-build > > $ cd sqlite-3.4.2 > > <edit Makefile.in by commenting line 119 to enable loadable extensions> > > <line 119: # TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1> > > $ cd .. > > $ cd sqlite-3.4.2-build > > $ ../sqlite-3.4.2/configure LIBS=-ldl > > $ make > > $ export LD_LIBRARY_PATH="`pwd`:$LD_LIBRARY_PATH" > > $ gcc -I`pwd` -shared ../sqlite-3.4.2/ext/fts2/fts2.c -o fts2.so > > i686-apple-darwin8-gcc-4.0.1: unrecognized option '-shared' > > /usr/bin/ld: Undefined symbols: > > _main > > _sqlite3Fts2HashClear > > _sqlite3Fts2HashFind > > _sqlite3Fts2HashInit > > _sqlite3Fts2HashInsert > > _sqlite3Fts2InitHashTable > > _sqlite3Fts2PorterTokenizerModule > > _sqlite3Fts2SimpleTokenizerModule > > collect2: ld returned 1 exit status > > > > > > so, this is the first step that I have surmount. Once this is done, I > > would really like fts2 to not be shared but be permanently jammed into > > sqlite3 so I don't have to load it manually (unless, there is any > > significant advantage to building a shared library). > > this is getting more and more a happy waste of time (hopefully I would > have learned something out of this). After much searching, I found Joe > Wilson's instructions at > <http://readlist.com/lists/sqlite.org/sqlite-users/2/11644.html> > > Following those pretty much to the t, I almost got everything working. > Except, I got the following during make > > ../sqlite-3.5.2/ext/fts1/fts1.c:7:2: error: #error fts1 has a design > flaw and has been deprecated. > make: *** [fts1.lo] Error 1 > > Fantastic. If it is has a design flaw and has been deprecated, then > why include it? Or, if it is included, where is the information that > it has been deprecated that one can read *before* doing make? > > Anyway, I went back into Makefile.in and commented out all references > to fts1 and ran make again. This time I got > > ../sqlite-3.5.2/ext/fts2/fts2.c:7:2: error: #error fts2 has a design > flaw and has been deprecated. > make: *** [fts2.lo] Error 1 > > So, I went back into the ext library and discovered that there was > fts3. So, I went back into Makefile.in and commented out all > references to fts2, added similar looking lines for fts3 and ran make > again. This time it all worked. Great! > > Well, not so great. Now when I run the new sqlite3, I get the following > > dyld: lazy symbol binding failed: Symbol not found: _sqlite3Fts1Init > Referenced from: > /Users/punkish/Projects/sqlite-3.5.2-build/.libs/libsqlite3.0.dylib > Expected in: flat namespace > > dyld: Symbol not found: _sqlite3Fts1Init > Referenced from: > /Users/punkish/Projects/sqlite-3.5.2-build/.libs/libsqlite3.0.dylib > Expected in: flat namespace > > Trace/BPT trap > > If I can get some clear instructions on how to do this successfully, I > promise to record them on the wiki for other poor souls who might try > this. > > Many thanks in advance. > > And, oh yes, still will need help with the following once the above is > possible. > > > > > > > Once I am successful with the above, I would like to build a > > DBD::SQLite with my new library. > > > > Many thanks for your guidance. > > > > -- > > Puneet Kishor > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
