How to host Akaunting on Digitalocean Droplet - ServerAvatar

Create Server in Digitalocean

Digitalocean is one of the most popular cloud platform right now. It offers on-demand cloud computing for various use cases as well as some managed solutions. We can deploy any PHP based applications on Digitalocean Droplets. Droplets are the servers or cloud computing instances in Digitalocean. If you want to learn everything about droplet management in Digitalocean in-depth, We recommend you to read our Digitalocean guide.

To deploy any application on Digitalocean, We first need a Droplet. So, we will first create a droplet and perform the initial set up.

Step 1: Go to the Create Droplets page.

Log in to your Digitalocean account and click on the Create button given on the top-right corner of the page. From the drop down menu, click on the Droplets option to see a droplet creation form.

Step 2: Choose Region

On the Droplet creation page, You will see lots of sections to select lots of things. We will go step by step.

The first thing you have to do is select the region for your droplet. Digitalocean provides lots of options when it comes to selecting the location. The general rule is to select the region that is closest to your audience. It means that for majority of your audience, Your sites will load faster due to lower latency.

Step 3: Choose an Image or an OS

In this step, you have to select the operating system for your droplet. We recommend you to use Ubuntu 20.04 LTS x64 or Ubuntu 22.04 LTS x64. Ubuntu is easy to configure and manage. If you are using ServerAvatar to manage your droplets, These operating systems are requirement.

Step 4: Choose the size of the Droplet

Here you have to choose the size of your Droplet. As we mentioned above, Digitalocean provides many different types of droplets. Select the one that fits best for your project.

If your site is brand new and does not have much traffic, start with a small plan. Once the project starts getting traction, you can upgrade the plan to handle more visitors on the site.

Step 5: Choose Authentication Method

Now you have to select the authentication method. There are two types of authentication methods. They are:

1. Authentication via SSH Keys
2. Authentication via Password

If you are using SSH keys for authentication, It is the best option. If you do not know what is SSH keys, You can go with the password method. Make sure to set the strong password for your root user, which is the most powerful user with all the privileges on Linux OS.

Step 6: Selecting Additional Options

There are three additional options you can choose. They are optional but important in different use cases. The additional options are:

1. Monitoring: It is a free feature by Digitalocean. It allows you to see additional monitoring data for your server.
2. Backups: We recommend you to enable full server backups if you are going to deploy in production environment. The cost of the backups depends on the size of the droplet.
3. Managed Database: You do not need a Managed database if you are using ServerAvatar to manage sites on a droplet. A managed database is a pre-configured MySQL Droplet.

Step 7: Finalise Details

In the last step of this process, We have to enter the name of the droplet, number of droplets you want to create, Define any tags, and select the project. Enter all the details and click on the Create Droplet button to create a droplet.

In a few minutes, You will have the Droplet up and running. Now, We have to perform the initial configuration on the Droplet to host PHP based frameworks and software.

Initial Server Configuration

The Initial server configuration includes installation and configuration of various packages required to host your website. Usually, You have to write commands and modify configuration files. Luckily, With ServerAvatar, Your full server configuration and optimisation can be automated.

Here are the three ways to automatically configure your server with ServerAvatar.

wget https://srvr.so/install
chmod +x install
./install

Install and Setup akaunting on cloud using ServerAvatar

Step 1. Create Database

Access the Database tab on the ServerAvatar server panel to create a MySQL Database.

Enter the credentials including Database name, Username, and Password and click on the Create Database button.

Step 2. Create a php application

Access the Applications tab from the server panel to create a new PHP application.

Click the Create button and fill up the required information, including the Application Name, Domain Name, and Advanced Options for more PHP settings.

Note that:

If you want to host Akaunting on your domain, then make sure to point your domain to the current IP address of your server, and for that:

1. Log in to your domain provider site, where you buy your domain. Click here for more info about your domain name.
2. Access DNS Manager to edit your DNS records(contact the support team if you don’t find them)
3. Change the IP address of A Record of your website to the current server’s IP address. To host Akaunting on your subdomain, for example, Akaunting.yourdomain.com, create a new application with the subdomain as your primary domain and follow the same procedure. For accessing Akaunting on the subdomain, you need to add your subdomain on A Record that points to the current IP address of your server. To point to an IPV6 address, you would need to use an AAAA record.

Proceeds to next by clicking on the Next step.

Now select method and service provider Git and GitHub, respectively (follow according to Snapshot).

Enter the required information as given below:
Repository Type: Public.
Deployment Key: generate new key by clicking on the Generate Key link.
Clone HTTPS URL: https://github.com/akaunting/akaunting.git
Branch: master
Deployment script:

composer install;
php artisan install --db-name="akaunting" --db-username="root" --db-password="pass" --admin-email="admin@company.com" --admin-password="123456";
composer dump-autoload;
php artisan sample-data:seed;

Enter db-name, db-username, db-password according to the database we have created you check your database credential in databases. Admin email and admin password is your login credential when it is deployed on server so you can set it any but remember it.

Move further by clicking on the Next Step.

Create a System User or choose a system user from an existing One.

Then choose PHP version 8.1 or above and leave Custom Webroot field as it is.

After filling up all the details. click the Next Step button.

Step 3. Install and Run npm

Access SSH credentials from the dashboard of the application panel.

Make sure that in your server, Node js is installed. If it is not, then go to the Server Panel > Settings. Click on install Node js.

Login using the SSH credentials using below command. Make sure to Replace the Username and Host with your actual credentials.

npm install;
npm run dev;

Now, the Akaunting software is successfully installed. You can go to the user interface by visiting the URL of your domain.

Tip:- It will run on HTTP, but to run it on HTTPs ServerAvatar provides a one-click solution to switch to HTTPs for that, go to the SSL Certificate in the application panel and click on force HTTP to HTTPs.