Help Installing Frepple on the cloud

Frepple provides Debian packages suitable for use with Ubuntu or Debian. It comes with an Apache configuration file making it easy to get up and running quickly. Apache, Python 3, and PostgreSQL are required dependencies. Their documentation provides a full installation tutorial, so I’ll only provide a quick run down here based on Ubuntu 14.04.

First, we’ll install and configure PostgreSQL:

sudo apt-get install postgresql 
sudo -u postgres psql template1 -c "create user frepple with password 'frepple'"
sudo -u postgres psql template1 -c "create database frepple encoding 'utf-8' owner frepple"
sudo -u postgres psql template1 -c "create database scenario1 encoding 'utf-8' owner frepple"
sudo -u postgres psql template1 -c "create database scenario2 encoding 'utf-8' owner frepple"
sudo -u postgres psql template1 -c "create database scenario3 encoding 'utf-8' owner frepple"
sudo sed -i 's/local\(\s*\)all\(\s*\)all\(\s*\)peer/local\1all\2all\3\md5/g' /etc/postgresql/9.*/main/pg_hba.conf
sudo service postgresql restart

Next, we’ll install a number of other dependencies:

sudo apt-get install python3 python3-pip libxerces-c3.1 adduser apache2 libapache2-mod-wsgi-py3 python3-psycopg2

Now, with Python 3 installed, we will download the project’s requirements.txt file from GitHub in order to install the additional Python dependencies using pip:

wget https://raw.githubusercontent.com/frepple/frepple/3.1/contrib/django/requirements.txt
sudo pip3 install -r requirements.txt

Then, grab and install Frepple’s Debian package:

wget http://downloads.sourceforge.net/project/frepple/frepple/3.2.beta/Linux%20Debian/frepple_3.2.beta-1_amd64.deb
sudo dpkg -i frepple_*.deb
sudo apt-get -f -y -q install

Now we’ll enable a number of Apache modules including Frepple’s configuration:

sudo a2enmod expires
sudo a2enmod wsgi
sudo a2enmod ssl
sudo a2ensite default-ssl
sudo a2ensite frepple
sudo service apache2 restart

Finally, we can create Frepple’s database schema by running:

frepplectl migrate --noinput

You can now access your Frepple instance by visiting the IP address of your server. The default account is admin for both the username and the password. This should be updated the first time you log in.