dangermouse - 2016-07-07

I recently acquired a Raspberry Pi 3, a wonderful and cheap ARM machine you get for less than 70$, here the steps to install deltasql on it. I use Raspbian GNU/Linux 8 jessie as operating system:

First, I followed this tutorial to install Apache with PHP and mySQL:
https://www.stewright.me/2015/08/tutorial-install-apache-php-and-mysql-on-a-raspberry-pi-2/

Then install also phpmyadmin, which could be useful later on

sudo apt-get install phpmyadmin
sudo cp /etc/phpmyadmin/apache.conf /etc/apache2/sites-available/phpmyadmin.conf
cd /etc/apache2/sites-available
sudo a2ensite phpmyadmin.conf
sudo service apache2 reload

Now checkout the latest deltasql from git repository. To do so, you first need to install git with

sudo apt-get install git

cd /var/www/html
sudo git clone git://git.code.sf.net/p/deltasql/code deltasql

Temporarily give full access rights to the "conf" folder

cd deltasql
sudo chmod 777 conf
sudo service apache2 restart

Now you can visit http:// [Raspberry address] /deltasql

Choose the link "Setup deltasql"
and carefully fill the fields according to the provided instructions. Hit the "Install" button at the bottom.

The install script will run and you should have now a running deltasql instance on
http:// [Raspberry address] /deltasql

Remember to change the permissions on the conf folder back to correct defaults with

sudo chmod 755 conf
sudo chmod 644 conf/config.inc.php

If you did everything correctly, you will have a running deltasql instance at:
http:// [Raspberry address] /deltasql

POST SCRIPTUM
If after installing deltasql, the install_execution.php complains that it can not write the config.inc.php because of the permissions on the directory

You can then do this

cd /var/www/html/deltasql/conf
sudo cp example_config config.inc.php
modify config.inc.php, it will contain the same fields you were filling before
sudo nano config.inc.php
Hit Ctrl+O to save the changes

Then set the permissions to the file

sudo chmod 644 config.inc.php

And restart apache with

sudo service apache2 restart

Additional note: I wrote the instructions later on and though I put care on it, there might be some lurking mistake. If you encounter problems, just write below and we will help you!

 

Last edit: dangermouse 2016-07-08