Manually Install Frappe on Ubuntu 14.04 With a Remote SQL Server

Manually Install Frappe on Ubuntu 14.04 With a Remote SQL Server

Get Social!

frappeFrappe is a full stack web framework based on Python and Javascript which can be used to build and deploy web applications. The main focus of this post is to set up a Frappe environment that can be used for ERPNext.

Before starting, install MariaDB 10.x on a remote host (or local, but that’s less common in a production environment) as we’ll use that later.

Create a user for Frappe – here we’ll use frappe but you can change this for anything you like. If you do change the user remember to update the home directory.

Set the password for the frappe user with passwd.

Install the required dependencies. Notice that we’ve not included an SQL server as we’ll use a remote MariaDB SQL Server.

Download and install the latest version of wkhtmltopdf from Sourceforge.

Download Frappe from Github as the frappe user.

Run the pip installer for Frappe.

Create a new Bench as the frappe user.

Add the default site configuration file with the remote SQL database hostname/ IP and port number.

And add:

Before you create any sites, you’ll need to apply a few settings to your SQL server. This guide assumes you have a remote MariaDB SQL Server – log into it and add the below to your my.conf file.

And restart your SQL server for the changes to take affect.

Copy the Supervisor config file into place so that Frappe automatically starts up with the system.