This document explains how to install phpLiteAdmin as an administration tool for SQLite databases on an Elemental Linux Server (ELS) system.
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 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.
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 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.
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"
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:
You may also want to consult the phpliteadmin documentation wiki at http://code.google.com/p/phpliteadmin/w/list