Phpliteadmin

Goal
Using FusionPBX and want to be able to manage your SQLite database(s)? This will show you how to integrate FusionPBX's login and privilege system.

Requirements
You will need: 1. A functioning installation of FusionPBX. 2. A functioning installation of SQLite. 3. phpliteadmin. I'll assume FusionPBX and SQLite are already installed and configured, as this information is out of the scope of this document.

Obtaining phpliteadmin
You may download my modified phpliteadmin file from pastebin here. You may also download the original from the project website, however it will require some modification. Once you've got the php use a text editor to put it into phpliteadmin.php then save the file on your server.

Working with FusionPBX
Once you've got your copy of phpliteadmin, drop it into FusionPBX's document root. For many people this means /var/www/fusionpbx/. DO NOT place it in a subdirectory unless you know what you're doing. Once it's there, you can check your webserver to see if it's working! Browse to: http://your.web.sever/phpliteadmin.php If you're not logged in and FusionPBX prompts you for your username/password, it's functioning correctly and you may move onto the next step. If it's not, seek help in #fusionpbx on irc.freenode.net or find someone who knows PHP.

Adding it to the FusionPBX system
To finalize the installation, you can add it to FusionPBX's system menus. Login as a superadmin privs user, and go to Advanced > Menu Manager. Hit the + icon to the right of the columns to add a new menu and add settings as follows: Title: phpLiteAdmin Link: /phpliteadmin.php Category: External Parent Menu: Advanced Group: Superadmin Description: phpLiteAdmin Interface

(Note: The 'Menu Order' field will auto-populate)

Now that it's added, go to Advanced > Upgrade Schema, and you will now have phpLiteAdmin integration to FusionPBX!