Using phpLiteAdmin with Raspberry Pi

Users who using a Sqlite3 database on their raspberry pi, might need this tutorial, for easy managing the content of each databse. We are using phpLiteAdmin which is a php based tool to manage and manipulate your lokal databases.

This tutorial requires that Php, Web server, and sqlite components are already installed.
First of all, we activate a ssh connection to our raspberry pi. Alternatively the way to open the terminal via the graphical user interface on the Raspberry Pi is also possible. Now we use the existing terminal connection, and type in the following commands.
The script which we are using is phpLiteAdmin and can be found on their projectsite.
Moreover there are additional languagepackages and screenshots available. Using the terminalconnection we would like to download the latest skriptfile and save them in this directory /var/www/admin.

cd /var/www
mkdir admin
cd admin
wget https://bitbucket.org/phpliteadmin/public/downloads/phpliteAdmin_v1-9-5.zip
unzip phpliteAdmin_v1-9-5.zip

With these commands we created a directory named admin. And we downloaded the scriptfiles.
Now we have to rename the included configurationfile:

sudo cp phpliteadmin.config.sample.php phpliteadmin.config.php

After that, we have to modify the configurationfile:

sudo nano phpliteadmin.config.php

There we have to type in an individual password for the loginpage:

$password = 'YourPassword';
$directory = 'AbsolutePathToDatabase';

Finally we have to modify the access rights for all files and directories:

sudo chmod 755 php*
cd ..
sudo chmod 755 admin

So that’s it! We try to connect to the adminpanel using our browser of choise. E.g. 192.168.1.12/admin
If you have done everything right, then you can now log in into the admin panel and find your records and modify if necessary.

One comment

  • Hi –

    I followed your instructions, but when I navigate to [IP]/admin it takes me to the Ghost blog I am hosting on my Pi. If I use [IP]/phpliteadmin.php It just get the Ghost blog 404 error page.

    Any ideas?

    Cheers.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.