Hi Tatsuro

Tatsuro MATSUOKA wrote:
> $ CPPFLAGS=-DSQLITE_ENABLE_COLUMN_METADATA ./configure
> $ make
> $ make install
>   
Yes I had done this before the last email was sent.

I ended up hacking the database-package Makefile to include the new
libraries and now the package is installed.

Thanks

Alex


> --- 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

Reply via email to