ELS Howto: phpLiteAdmin


Synopsis

This document explains how to install phpLiteAdmin as an administration tool for SQLite databases on an Elemental Linux Server (ELS) system.


Prerequisites

These instructions assume that you have a working PHP-enabled web server. If you do not, see the ELS Howto: Apache and PHP before beginning this document.


Installation

Installation instructions for phpLiteAdmin are available on the phpLiteAdmin web site. This document will guide you through the specifics of installing it to be consistent with the way SQLite is used in the other ELS Howto documents.

  1. Download the latest version of phpLiteAdmin from http://code.google.com/p/phpliteadmin/downloads/list.
  2. Extract it into your web server's document root directory.

Example

The following example shows how you would install phpLiteAdmin if your web server document root were /home/httpd.

cd /home/httpd
wget http://phpliteadmin.googlecode.com/files/phpliteadmin_v1-9-2.zip

unzip phpliteadmin_v1-9-2.zip

Configuration

Configuration of phpLiteAdmin is minimal. All that is needed is to set the location of your SQLite database files and to set a password for access.

Example

This example shows how you would change phpliteadmin.php to require a password of 'secret' and administer SQLite databases stored in the /home/sqlite directory.

vi /home/httpd/phpliteadmin.php
$password = "secret"
$directory = "/home/sqlite"

Testing

Point your web browser to the phpliteadmin.php page on your server, log in and view some of the databases.

If you are not able to manage your SQLite databases, follow the troubleshooting steps below:

  1. Verify that there are actually databases in the directory you specified.
  2. Follow the troubleshooting steps at the end of the Apache PHP Howto.

You may also want to consult the phpliteadmin documentation wiki at http://code.google.com/p/phpliteadmin/w/list