Install SQLite3 HOWTO

From GreenphoneWiki

Jump to: navigation, search

Contents

[edit] How to build and install SQLite3 on the GreenPhone

[edit] Introduction

These are the steps I've used to build the SQLite3 database for the GreenPhone.

[edit] Todo

  1. Add instructions on installing

[edit] Building SQLite3

1. Download the latest source from http://www.sqlite.org/download.html to a suitable location where you can build it, e.g. /devel

2. Extract the source

cd /devel
tar zxvf sqlite-3.5.2.tar.gz

3. Create a build directory

mkdir bld-sqlite

3. Configure it to build for greenphone

cd bld-sqlite
source /opt/Qtopia/SDK/scripts/devel-greenphone.sh
../sqlite-3.5.2/configure --host=arm-linux --prefix=/mnt/disk2 CC=/usr/local/arm-linux/bin/arm-linux-gcc CFLAGS=-lpthread CXX=/usr/local/arm-linux/bin/arm-linux-g++ CXXFLAGS=-lpthread

If you want to install SQLite somewhere other than /mnt/disk2 then change the --prefix parameter in the configure line above

4. Build the software. These instructions assume you don't have anything in /mnt/disk2. (You might need to change the permissions for /mnt/disk2 in order to run make install successfully)

make
export PATH=$PATH:/usr/local/arm-linux/bin
make install

You might need to run the last two steps (exporting PATH and make install) as root.

Personal tools