交叉编译sqlite-3.3.5的经验.txt

交叉编译SQLITE的一些经验,嵌入式系统小型数据库的应用

交叉编译sqlite-3.3.5的经验，与大家分享,希望对大家有帮助!
native: fedora core 4
cross-gcc: arm-linux-3.4.1
#download tools
readline-5.1.tar.gz
ncurses-5.5.tar.gz
sqlite-3.3.5.tar.gz 
tcl8.4.12.tar.gz
and File (parse.out parse.c parse.h)

#arm-linux with readline-5.1
export LD=/usr/local/arm/3.4.1/bin/arm-linux-ld
export CC=/usr/local/arm/3.4.1/bin/arm-linux-gcc
export RANLIB=/usr/local/arm/3.4.1/bin/arm-linux-ranlib
./configure --prefix=/usr/local/readline-5.1-arm --host=i686-pc-linux-gnu
make install

cp -af /usr/local/readline-5.1-arm/lib/* /usr/local/arm/3.4.1/arm-linux/lib/
cp -af /usr/local/readline-5.1-arm/include/* /usr/local/arm/3.4.1/arm-linux/include/

#arm-linux with ncurses-5.5
export LD=/usr/local/arm/3.4.1/bin/arm-linux-ld
export CC=/usr/local/arm/3.4.1/bin/arm-linux-gcc
export RANLIB=/usr/local/arm/3.4.1/bin/arm-linux-ranlib
./configure --prefix=/usr/local/ncurses-5.5-arm --host=i686-pc-linux-gnu
make install

cp -af /usr/local/ncurses-5.5-arm/lib/* /usr/local/arm/3.4.1/arm-linux/lib/
cp -af /usr/local/ncurses-5.5-arm/include/* /usr/local/arm/3.4.1/arm-linux/include/


#arm-linux with tcl8.4.12
export ac_cv_func_strtod=yes
export tcl_cv_strtod_buggy=1
export LD=/usr/local/arm/3.4.1/bin/arm-linux-ld
export CC=/usr/local/arm/3.4.1/bin/arm-linux-gcc
export RANLIB=/usr/local/arm/3.4.1/bin/arm-linux-ranlib
./configure --prefix=/usr/local/tcl8.4.12-arm --host=i686-pc-linux-gnu
make install

cp -af /usr/local/tcl8.4.12-arm/lib/* /usr/local/arm/3.4.1/arm-linux/lib/
cp -af /usr/local/tcl8.4.12-arm/include/* /usr/local/arm/3.4.1/arm-linux/include/


#arm-linux with sqlite-3.3.5
1. change file configure line 19258
 if test "$cross_compiling" = "yes"; then  ->  if test "$cross_compiling" = "no"; then
 
2. change file configure line 20404 , 20430
test "$cross_compiling" = yes &&  -> test "$cross_compiling" = no && 

3. copy file (parse.out parse.c parse.h) to sqlite-3.3.5/

4.
export LD=/usr/local/arm/3.4.1/bin/arm-linux-ld
export CC=/usr/local/arm/3.4.1/bin/arm-linux-gcc
export RANLIB=/usr/local/arm/3.4.1/bin/arm-linux-ranlib
./configure --prefix=/usr/local/sqlite-3.3.5 --host=i686-pc-linux-gnu


5. change file Makefile line 39
TCC += -I/usr/local/arm/3.4.1/arm-linux/include

6. make (generate error)
./lemon  -DSQLITE_OMIT_CURSOR           parse.y
./lemon: ./lemon: cannot execute binary file
make: *** [parse.c] 错误 126

7. change file Makefile line 362
#./lemon $(OPTS) parse.y

8. manual "./lemon  -DSQLITE_OMIT_CURSOR parse.y" in your arm system again (be sure you have private)

9. make (generate error)
./mkkeywordhash >keywordhash.h
/bin/sh: ./mkkeywordhash: cannot execute binary file
make: *** [keywordhash.h] 错误 126

10. manual "./mkkeywordhash >keywordhash.h" in your arm system (be sure you have private)

11. change file Makefile line 396
#./mkkeywordhash$(BEXE) >keywordhash.h

12. make install