Installing SQLITE on minni2440

Can anyone tell me how to deploy or install sqlite on mini2440 after cross
compiling it

To make it work I had to copy driver from compiled libraries. It's in the
same folder as all QT libraries but not in 'lib' but in 'plugins'. In
'plugins You have 'sqldrivers'. Just copy 'plugin' folder to the same place
as You've copied libraries (You will have two folders: 'lib' and
'plugins'). And You can use Your SQLite databases.

good luck
best regards
Tom

Thanks for the reply Tom. I am having micro2440 SDK board having processor
S3C2440. Following are the steps which I had followed.

 Cross Compile:
./configure target=arm-linux

make
make install DESTDIR=~/sqlite

This created the installation files in sqlite folder. Following are folders
that was created after installation under sqlite:
usr/local/bin
usr/local/include
usr/local/lib
usr/local/share

Then I copied this installation folders to development board (micro2440) in
the respective folders i.e under usr/local using flash drive

Then in terminal I typed command as sqlite3. It gave me following error:
/usr/local/bin/sqlite3: line 1 : syntax error: word unexpected (expecting
")")

can you please tell me what is actually going wrong. Is it that my cross
compilation for sqlite is wrong?

I have more parameters in my configure:

./configure --prefix=/home/sqlite/sqlite --host=arm-linux
CC=arm-none-linux-gnueabi-gcc AR=arm-none-linux-gnueabi-ar
STRIP=arm-none-linux-gnueabi-strip RANLIB=arm-none-linux-gnueabi-ranlib
CFLAGS="-march=armv4t -mtune=arm920t -Os -lpthread -lrt" LDFLAGS=${LDFLAGS}

CFLAGS are importatant, they determine architecture. Just change --prefix
parameter. Then 'make' and 'make install'.

good luck
best regards
Tom

Hi.

I compile the SQLite 3.7.14 with Tom instructions.

In device add Sumeet folders to PATH:

[root@FriendlyARM sqlite]# $PATH
sh: /sbin:/usr/sbin:/bin:/usr/bin: not found
[root@FriendlyARM sqlite]# export PATH=/usr/local/bin:$PATH

The result:
[root@FriendlyARM sqlite]# sqlite3 --help
sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open
shared object file: No such file or directory

What is wrong?

Regards.

Hi.

I try create a link.

[root@FriendlyARM lib]# rm -rf libsqlite3.so.0
[root@FriendlyARM lib]# ls -lh
[root@FriendlyARM lib]# ln -s /usr/local/lib/libsqlite3.so.0
/usr/local/lib/libsqlite3.so.0.8.6
ln: /usr/local/lib/libsqlite3.so.0.8.6: File exists

The file libsqlite3.so.0 was not created.

What is wrong?

Regards.

read the ln's manual

Hi.

This does not work yet.

---
[root@FriendlyARM /]# cd /usr/local/lib/
[root@FriendlyARM lib]# ln -s libsqlite3.so.0.8.6 libsqlite3.so.0
[root@FriendlyARM lib]# export PATH=/usr/local/bin:$PATH
[root@FriendlyARM lib]# sqlite3 --help
sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open
shared object file: No such file or directory
[root@FriendlyARM lib]# export PATH=/usr/local/lib:$PATH
[root@FriendlyARM lib]# sqlite3 --help
sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open
shared object file: No such file or directory
---

What is wrong?

Configure your runtime linker to search for libraries in "/usr/local/lib"
-> man ldconfig

sqlite3 command not working what i do..

Hi.

I try create a link.

[root@FriendlyARM lib]# rm -rf libsqlite3.so.0
[root@FriendlyARM lib]# ls -lh
[root@FriendlyARM lib]# ln -s /usr/local/lib/libsqlite3.so.0
/usr/local/lib/libsqlite3.so.0.8.6
ln: /usr/local/lib/libsqlite3.so.0.8.6: File exists

The file libsqlite3.so.0 was not created.

What is wrong?

Regards.


i need sqlite3 command still not working, what i do..