Deploy this powerful open-source invoicing system to your data center

In case you’re searching for an open-source bill system to deploy, Jack Wallen believes Bill Airplane could be simply the answer to fulfill your wants.

reading an invoice

Picture: iStock/AndreyPopov

Just lately, I noticed I used to be having to work too arduous to bill all of my numerous purchasers. I would been utilizing the identical previous spreadsheets for years, however it was getting a bit too cumbersome to take care of. I might have turned to a industrial platform for this, however given open-source was my jam, I figured it might be even higher to discover a strong answer for my on-premise digital knowledge heart. Seems, there is a rock-solid instrument, known as Bill Airplane, that is simply the ticket.

SEE: Kubernetes: A cheat sheet (free PDF) (TechRepublic)

Bill Airplane contains the required options so that you can handle invoices, akin to simple invoicing, buyer administration, fee monitoring and quotations. It may not have the entire bells and whistles related to bigger, industrial instruments, however of the open-source choices I’ve discovered, that is (by far) the perfect.

Let’s stroll by the method of deploying Bill Airplane.

What you will want

I will be demonstrating the set up on Ubuntu Server 20.04, so you will want a operating, up to date occasion of that platform, in addition to a person with sudo privileges. That is it, let’s set up.

Tips on how to set up the required dependencies

The very first thing we’ll do is set up the required dependencies. Log into your Ubuntu Server and first set up Apache with the command:

sudo apt-get set up apache2 -y

When the set up completes, begin and allow Apache with the instructions:

sudo systemctl begin apache2
sudo systemctl allow apache2

Subsequent, we’ll set up MariaDB as our database. That is completed with the command:

sudo apt set up mariadb-server mariadb-client -y

As soon as MariaDB is put in, safe it with the command:

sudo mysql_secure_installation

Ensure that to offer the database admin person a password and reply Y to the remaining questions.

Now, we are able to set up PHP. First, set up a useful package deal with:

sudo apt-get set up software-properties-common -y

Add the PHP repo with:

sudo add-apt-repository ppa:ondrej/php

Replace apt:

sudo apt-get replace

Lastly, set up the required PHP elements with the command:

sudo apt-get set up php7.1 libapache2-mod-php7.1 php7.1-common php7.1-mbstring php7.1-xmlrpc php7.1-soap php7.1-gd php7.1-xml php7.1-intl php7.1-mysql wget unzip php7.1-cli php7.1-zip php7.1-curl php7.1-mcrypt -y

Tips on how to create the database

Time to create a database. Log in to the MariaDB console with:

sudo mysql

Create the Bill Airplane database and person with the instructions:

CREATE DATABASE invoice_plane_db;
CREATE USER 'invoiceplane'@'localhost' IDENTIFIED BY 'PASSWORD';

Grant the required privileges with:

GRANT ALL PRIVILEGES ON invoice_plane_db.* TO 'invoiceplane'@'localhost';

Flush the privileges and exit with:


Tips on how to obtain and set up Bill Airplane

We’re able to obtain and set up Bill Airplane. The newest model is Ensure that to verify the official obtain web page, so that you’re downloading the right model. To obtain Bill Airplane, problem the command:


When the obtain completes, create a brand new listing with the command:

mkdir invoiceplane

Extract the downloaded file with the command:

unzip v1.5.11.1 -d invoiceplane

Transfer the brand new listing into the Apache doc root with:

sudo mv /invoiceplane /var/www/html/invoiceplane

Develop into the brand new listing:

cd /var/www/html/invoiceplane

Copy the config and htaccess recordsdata with the instructions:

sudo cp ipconfig.php.instance ipconfig.php
sudo cp htaccess .htaccess

Give the listing the right permissions and possession:

sudo chown -R www-data:www-data /var/www/html/invoiceplane/
sudo chmod -R 755 /var/www/html/invoiceplane/

Create the required Apache host file with:

sudo nano /and many others/apache2/sites-available/invoiceplane.conf

In that file, paste the next contents:

<VirtualHost *:80>
     ServerAdmin [email protected]
     DocumentRoot /var/www/html/invoiceplane
<Listing /var/www/html/invoiceplane/>
          Choices +FollowSymlinks
          AllowOverride All
          Require all granted
     ErrorLog ${APACHE_LOG_DIR}/error.log
     CustomLog ${APACHE_LOG_DIR}/entry.log mixed

Save and shut the file. 

Allow the positioning with the next command:

sudo a2ensite invoiceplane.conf

Allow the rewrite module with:

sudo a2enmod rewrite

Restart Apache:

sudo systemctl restart apache2

Tips on how to run the Bill Airplane setup wizard

Open an internet browser and level it to http://SERVER/invoiceplane/index.php/welcome (the place SERVER is the IP deal with of the internet hosting server). At this level, you will stroll by a quite simple GUI to finish the set up. The steps within the wizard are:

  • Select a Language
  • Prerequisite verify
  • Database particulars (Determine A)
  • Create Person Account

Determine A


Configuring the database particulars for Bill Airplane.

When configuring the database particulars, you will use:

  • Hostname—localhost
  • Port—3306
  • Username—invoiceplane
  • Password—the password you set within the MariaDB console for PASSWORD
  • Database—invoice_plane_db

After you have created the person account, you will be offered with the Login display. Upon profitable authentication, you will end up on the Bill Airplane principal window (Determine B), the place you can begin establishing purchasers and creating invoices.

Determine B


The Bill Airplane principal window is able to go.

Congratulations, you now have an easy-to-use invoicing system operating in your on-premise knowledge heart. Hopefully, this shall be an enormous enchancment over your previous spreadsheet technique.

Subscribe to TechRepublic’s How To Make Tech Work on YouTube for all the most recent tech recommendation for enterprise execs from Jack Wallen.

Additionally see

Recent Articles


Related Stories

Leave A Reply

Please enter your comment!
Please enter your name here

Stay on op - Ge the daily news in your inbox