Hello Please learn ./configure and make tools first.
The above are standard Unixy tool. Please search by google and learn about the tools. However I'll show short instruction $ CPPFLAGS=-DSQLITE_ENABLE_COLUMN_METADATA ./configure $ make $ make install Note $ means the shell prompt. On Unix, sometime you need login by su to use make install. Regards Tatsuro --- Alex Hindle wrote: > Hi Tatsuro > > I have installed sqlite-amalgamation-3.6.16. > > How do I tell "make" to look in /usr/local/lib (where the sqlite library > is) ? > > The Makefile just seems more complex than what I'm used to, sorry. > > When I add -L/usr/local/lib to the command > > g++ -shared -Wl,-Bsymbolic -o sqlite3.oct sqlite3_wrap.o -lsqlite3 > -L/usr/lib/octave-3.0.2 -loctinterp -loctave -lcruft -Wl,--as-needed > -Wl,--no-undefined -llapack -lblas -lfftw3 -lreadline -lncurses -ldl > -lhdf5 -lz -lm -L/usr/lib/gcc/i586-manbo-linux-gnu/4.3.1 > -L/usr/lib/gcc/i586-manbo-linux-gnu/4.3.1/../../.. -lhdf5 -lz > -lgfortranbegin -lgfortran -lm > > and compile manually (ie without "make") then it compiles successfully. > > Thanks for you help. > > Alex > > > Tatsuro MATSUOKA wrote: > > Hello > > > > -DSQLITE_TESTCTRL_ASSERT=1 -DSQLITE_TESTCTRL_ALWAYS=2 are not required for > > sqlite-amalgamation-3.6.16.tar.gz (recommended for user) but are for > > sqlite-3.6.16.tar.gz(for > > develpper). > > > > For user, sqlite-amalgamation-3.6.16.tar.gz is recommneded, I have > > confirmed that > > -DSQLITE_TESTCTRL_ASSERT=1 -DSQLITE_TESTCTRL_ALWAYS=2 are not needed for > > sqlite-amalgamation-3.6.16.tar.gz. > > > > $ CPPFLAGS=-DSQLITE_ENABLE_COLUMN_METADATA ./configure > > > > is enough for configration. > > > > Regards > > > > Tatsuro > > > > --- Tatsuro MATSUOKA wrote: > > > > > >> Hello > >> > >> The error may be occurred because the sqlite library you use was not > >> complied with > >> #define SQLITE_ENABLE_COLUMN_METADATA > >> > >> You may have to build the sqlite library by yourself with addition of > >> #define > >> SQLITE_ENABLE_COLUMN_METADATA in proper space or ./configure with > >> CPPFLAGS='-DSQLITE_ENABLE_COLUMN_METADATA' > >> > >> If you use source of sqlite-3.6.16, the CPPFLAGS of ./configure should be > >> CPPFLAGS='-DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_TESTCTRL_ASSERT=1 > -DSQLITE_TESTCTRL_ALWAYS=2' > >> > >> For exmaple > >> $ CPPFLAGS = \ > >> '-DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_TESTCTRL_ASSERT=1 > >> -DSQLITE_TESTCTRL_ALWAYS=2' \ > >> ./configure > >> > >> Regards > >> > >> Tasturo > >> --- Alex Hindle wrote: > >> > >> > >>> Hi Tatsuro > >>> > >>> > >>> > >>> Tatsuro MATSUOKA wrote: > >>> > >>>> Please modify line 6768 in src/sqlite3_wrap.cpp > >>>> > >>>> From > >>>> result = (int)sqlite3_auto_extension(arg1); > >>>> to > >>>> result = (int)sqlite3_auto_extension((void (*)())arg1); > >>>> > >>>> > >>> Thank you, this fixed that problem. > >>> > >>> > >>> Now I get a new error which seems to be related to the C++ compiler not > >>> being able to find a procedure: > >>> > >>> octave:7> pkg install ../youtube/database-1.0.4 > >>> sqlite3_wrap.o: In function `_wrap_sqlite3_enable_load_extension': > >>> /home/userx/CS/youtube/database-1.0.4/src/sqlite3_wrap.cpp:6838: > >>> undefined reference to `sqlite3_enable_load_extension' > >>> sqlite3_wrap.o: In function `_wrap_sqlite3_load_extension': > >>> /home/userx/CS/youtube/database-1.0.4/src/sqlite3_wrap.cpp:6803: > >>> undefined reference to `sqlite3_load_extension' > >>> collect2: ld returned 1 exit status > >>> make: *** [sqlite3.oct] Error 1 > >>> error: 'make' returned the following error: make: Entering directory > >>> `/home/userx/CS/youtube/database-1.0.4/src' > >>> CXXFLAGS="-g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions > >>> -fstack-protector --param=ssp-buffer-size=4 -fomit-frame-pointer > >>> -march=i586 -mtune=generic -fasynchronous-unwind-tables" mkoctfile > >>> -DHAVE_OCTAVE_30 -v -o sqlite3.oct -lsqlite3 sqlite3_wrap.cpp > >>> g++ -c -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions > >>> -fstack-protector --param=ssp-buffer-size=4 -fomit-frame-pointer > >>> -march=i586 -mtune=generic -fasynchronous-unwind-tables -DH5_USE_16_API > >>> -fPIC -I/usr/include/octave-3.0.2 -I/usr/include/octave-3.0.2/octave > >>> -mieee-fp -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions > >>> -fstack-protector --param=ssp-buffer-size=4 -fomit-frame-pointer > >>> -march=i586 -mtune=generic -fasynchronous-unwind-tables -DHAVE_OCTAVE_30 > >>> sqlite3_wrap.cpp -o sqlite3_wrap.o > >>> g++ -shared -Wl,-Bsymbolic -o sqlite3.oct sqlite3_wrap.o -lsqlite3 > >>> -L/usr/lib/octave-3.0.2 -loctinterp -loctave -lcruft -Wl,--as-needed > >>> -Wl,--no-undefined -llapack -lblas -lfftw3 -lreadline -lncurses -ldl > >>> -lhdf5 -lz -lm -L/usr/lib/gcc/i586-manbo-linux-gnu/4.3.1 > >>> -L/usr/lib/gcc/i586-manbo-linux-gnu/4.3.1/../../.. -lhdf5 -lz > >>> -lgfortranbegin -lgfortran -lm > >>> make: Leaving directory `/home/userx/CS/youtube/database-1.0.4/src' > >>> error: called from `pkg:configure_make' in file > >>> /usr/share/octave/3.0.2/m/pkg/pkg.m near line 1248, column 2 > >>> > >>> > >>> > >>> I have installed sqlite3 and its libraries and header files so I don't > >>> know what the problem is. > >>> > >>> > >>> > >>> > >>> > >>>> I do not remember in octave 3.0.2 supports that 'pkg install' can also > >>>> be used untarred > >>>> > >>> folder like > >>> > >>>> octave> pkg datadabe-1.0.x > >>>> > >>>> > >>> Yes this works in Octave 3.0.2 > >>> > >>> I am trying database-1.0.4 in Octave 3.2 and older database-pkg versions > >>> in older Octave 3.0.2 now. > >>> > >>> > >>> Regards > >>> > >>> Alex > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >> -------------------------------------- > >> Power up the Internet with Yahoo! Toolbar. > >> http://pr.mail.yahoo.co.jp/toolbar/ > >> > >> ------------------------------------------------------------------------------ > >> _______________________________________________ > >> Octave-dev mailing list > >> Octave-dev@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/octave-dev > >> > >> > > > > > > -------------------------------------- > > Power up the Internet with Yahoo! Toolbar. > > http://pr.mail.yahoo.co.jp/toolbar/ > > > > -------------------------------------- Power up the Internet with Yahoo! Toolbar. http://pr.mail.yahoo.co.jp/toolbar/ ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Octave-dev mailing list Octave-dev@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/octave-dev