How To Install PHP iAddressbook using SQLite on Debian Linux (sarge)

I've recently discovered a little application with wonderful potential called PHP iAddressbook. It provides a web interface which allows you to maintain an online addressbook with similar functionality to Apple's Addressbook application (which I love). The killer part of it is that it allows you to import and export vcards of your address data so getting all of your data into it is dead simple.

I'd never actually installed an application which used SQLite before (it does support MySQL but I wanted to use SQLite) so it took me a while to learn all I needed to know. I thought I'd write up and contribute my experience getting it all working in the hopes that it will help other get it up and running easily.

This assumes that you already have a web server with PHP support installed and configured.

Make sure that you have all of the other bits and pieces installed:
```
# apt-get install libphp-adodb php4-pear php4-sqlite sqlite
```
Unzip iAddressbook into your web servers DocumentRoot and rename the folder appropriately:
```
# unzip -a ab_095.zip -d /tmp
# mv /tmp/ab2 /var/www/iaddressbook
```
Change into the iAddressbook directory:
```
# cd /var/www/iaddressbook
```
Change permissions on the provided sqlite database so that the web server has write permissions (www-data is the default web server user on Debian, if you've changed it to use another user you'll need to change the below command appropriately):
```
# chown -R www-data sqlite/
```

Copy in the new config files you are going to use:

# cp conf/config.php.dist conf/config.php
# cp conf/auth.php.dist conf/auth.php

Edit config.php and change it so that it uses the SQLite database, the database section should look something like this (note that the dbname, username and password variables aren't needed for SQLite):

$conf['dbtype'] = 'sqlite';
$conf['dbserver'] = '/var/www/iaddressbook/sqlite/sqlite-db2';
$conf['dbtable_ab'] = 'addressbook';
$conf['dbtable_cat'] = 'addressbook_cat';
$conf['dbtable_catmap'] = 'addressbook_catmap';

You should now be ready to go, you can test your installation by going to the URL (eg. http://www.yourdomain.com/iaddresssbook/).