BoxBilling is a free, open-source, and community-driven billing client management platform based on PHP and MySQL, and also capable of doing anything, extensible for any need. If you want to a true open-source platform to automate your invoicing, incoming payments, client management, and communication, then BoxBilling should be a great fit. This tutorial is based on Ubuntu Linux. We’ll be installing an Apache web server, MariaDB database server, and additional PHP modules. We’ll also link to another post that will show you how to secure your BoxBilling website using Let’s Encrypt free SSL certificates. For more about BoxBilling, please check its homepage To get started with installing BoxBilling on Ubuntu Linux, follow the steps below:
How to install Apache on Ubuntu Linux
As mentioned above, we’re going to be using the Apache web server to run BoxBilling. BoxBilling requires a web server to function, and Apache is the most popular open-source web server available today. To install Apache on Ubuntu, run the commands below: After installing Apache, the commands below can be used to stop, start and enable Apache services always to start up every time your server starts up. To test whether Apache is installed and functioning, open your web browser and browse to the server’s IP address or hostname. http://localhost If you see the above page in your browser, then Apache is working as expected.
How to install MariaDB on Ubuntu Linux
A database server is required for BoxBilling to function. BoxBilling stores its content in a database, and MariaDB is probably the best database server available to run BoxBilling. MariaDB is fast, secure and the default server for almost all Linux servers. To install MariaDB, run the commands below: After installing MariaDB, the commands below can be used to stop, start and enable MariaDB services always to start up when the server boots. Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation. When prompted, use the guide below to answer: To verify and validate that MariaDB is installed and working, log in to the database console using the commands below: You should automatically be logged in to the database server since we initiated the login request as root. Only the root can log in without a password, and only from the server console. If you see a similar screen as shown above, then the server was successfully installed.
How to install PHP on Ubuntu Linux
As we also mentioned above, we’re installing PHP on Ubuntu since BoxBilling requires it. PHP packages are added to Ubuntu repositories. The versions of the repositories might not be the latest. If you need to install the latest versions, you’ll need to add a third-party PPA repository. To a third-party repository with the latest versions of PHP, run the commands below. At the time of this writing, the latest PHP version is 8.0. Next, run the commands below to install PHP 8.0 and related modules. Next, you’ll want to change some PHP configuration settings that work great with BoxBilling. Run the commands below to open the PHP default configuration file. Then change the line settings to be something like the lines below. Save your changes and exit.
How to create a BoxBilling database on Ubuntu
At this point, we’re ready to create the BoxBilling database. As mentioned above, BoxBilling uses databases to store its content. To create a database for BoxBilling, run the commands below: sudo mysql -u root -p Then create a database called boxbilling CREATE DATABASE boxbilling; Next, create a database user called boxbillinguser and set a password CREATE USER ‘boxbillinguser’@’localhost’ IDENTIFIED BY ’new_password_here’; Then grant the user full access to the database. GRANT ALL ON boxbilling.* TO ‘boxbillinguser’@’localhost’ WITH GRANT OPTION; Finally, save your changes and exit.
How to download BoxBilling
We’re ready to download BoxBilling and begin configuring it. First, run the commands below to download the latest version of BoxBilling from its repository. Next, extract the downloaded content into a new folder called boxbilling. Then run the command below to allow the www-data user to own the new BoxBilling directory.
How to configure Apache for BoxBilling
We have downloaded BoxBilling content into a new folder we called BoxBilling. Now, let’s configure Apache to create a new server block to use with our BoxBilling website. You can create as many server blocks with Apache. To do that, run the commands below to create a new configuration file called boxbilling. conf in the /etc/apache2/sites-available/ directory to host our BoxBilling server block. In the file, copy and paste the content below into the file and save. Save the file and exit. After saving the file above, run the commands below to enable the new file that contains our BoxBilling server block. Restart Apache after that. At this stage, BoxBilling is ready and can be launched by going to the server’s IP or hostname. However, we want to make sure our server is protected with Let’s Encrypt free SSL certificates. So, continue below to learn how to generate a Let’s Encrypt SSL certificate for websites.
How to setup Let’s Encrypt for BoxBilling
We have written a great post on how to generate and manage Let’s Encrypt SSL certificates for Apache web servers. You can use that post, to apply it here for your BoxBilling website. To read the post on how to generate Let’s Encrypt SSL certificates for a website, click on the link below: How to Setup Let’s Encrypt on Ubuntu Linux with Apache – Website for Students If you were successful in generating a Let’s Encrypt SSL certificate, you should then reopen the server block for our BoxBilling website by running the commands below. The new BoxBilling server block configurations should look similar to the line below. Take notes of the highlighted lines.
The first server block listens on port 80. It contains a 301 redirect to redirect HTTP to HTTPS. The second server block listens on port 443. It contains a 301 redirect to redirect www to the non-www domain.
Save the file above, then restart Apache and PHP using the commands below. Finally, if everything went as planned, you should be able to start the BoxBilling setup wizard by browsing to the server hostname or IP address over HTTPS. A BoxBilling setup wizard should appear. Follow the wizard to complete the setup. Validate that all requirements are met and click Next. You will need to know the following items before proceeding. Use the database connection info you created above.
Database name Database Username Database password Database host
On the next page, create an administrator account. Username, email address and password, then click Next. BoxBilling should successfully install. Even though BoxBilling was installed successfully, you must take a few more actions. Normally, install folder should be automatically deleted. But if it still exists, you have to delete the installer from your web server before getting started. Change configuration file permissions to read-only (CHMOD 644) Setup this cron job to run every five minutes When you’re done, BoxBilling should be installed and ready to use. That should do it! Conclusion: This post showed you how to install BoxBilling on Ubuntu Linux with a link to set up Let’s Encrypt. If you find any error above or have something to add, please use the comment form below.
