Akaunting is a free and open supply accounting software program to handle your invoices, quotes, and funds. It’s specifically designed for small companies and freelancers. It’s based mostly on the LAMP and constructed with trendy applied sciences corresponding to Laravel, Bootstrap, jQuery and RESTful API. It’s easy, straightforward to make use of and highly effective software that means that you can see your financials on-line from a central location.
On this tutorial, we’ll learn to set up Akaunting software program on Ubuntu 18.04 server.
Necessities
- A server working Ubuntu 18.04.
- A non-root consumer with sudo privileges.
Getting Began
Earlier than beginning, you have to to replace your system with the newest model. You are able to do this by working the next command:
sudo apt-get replace -y
sudo apt-get improve -y
Set up LAMP Server
First, you have to to put in Apache, MariaDB, PHP, and different required modules to your server. You may set up all of them by working the next command:
sudo apt-get set up apache2 mariadb-server php7.2 libapache2-mod-php7.2 php7.2-common php7.2-imap php7.2-mbstring php7.2-xmlrpc php7.2-soap php7.2-gd php7.2-xml php7.2-intl php7.2-mysql php7.2-cli php7.2-ldap php7.2-zip php7.2-curl unzip -y
As soon as all of the packages are put in, you have to to edit php.ini file and make some modifications. you are able to do this with the next command:
sudo nano /and so on/php/7.2/apache2/php.ini
Make the next modifications:
file_uploads = On allow_url_fopen = On memory_limit = 256M upload_max_filesize = 30M post_max_size = 40M max_execution_time = 60 zend.assertions = 0 display_errors = Off max_input_vars = 1500 date.timezone = Asia/Kolkata
Save and shut the file, if you end up completed. Then, begin Apache and MariaDB service and allow them to start out on boot time with the next command:
sudo systemctl begin apache2
sudo systemctl allow apache2
sudo systemctl begin mariadb
sudo systemctl allow mariadb
After getting completed, you may proceed to the following step.
Configure the Database
By default, MariaDB isn’t secured. So, you have to to safe it. You are able to do this by working the mysql_secure_installation script:
sudo mysql_secure_installation
This script will change your present root password, take away nameless customers, disallow root login remotely as proven beneath:
Enter present password for root (enter for none): Set root password? [Y/n]: N Take away nameless customers? [Y/n]: Y Disallow root login remotely? [Y/n]: Y Take away take a look at database and entry to it? [Y/n]: Y Reload privilege tables now? [Y/n]: Y
As soon as the MariaDB is secured, log in to MariaDB shell:
mysql -u root -p
Enter your root password when immediate. Then, create a database and consumer for Akaunting:
MariaDB [(none)]> CREATE DATABASE akauntingdb;
MariaDB [(none)]> CREATE USER 'akaunting'@'localhost' IDENTIFIED BY 'mypassword';
Substitute the phrase ‘mypassword’ within the above SQL assertion with a safe password of your selection. Subsequent, grant all privileges to the Akaunting with the next command:
MariaDB [(none)]> GRANT ALL ON akauntingdb.* TO 'akaunting'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
And once more, exchange ‘mypassword’ with the identical password that you just used above. Subsequent, flush the privileges and exit from the MariaDB shell:
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> EXIT;
Set up Akaunting
First, you have to to obtain the newest model of the Akaunting from their official web site. You are able to do this with the next command:
curl -O -J -L https://akaunting.com/download.php?version=latest
As soon as the obtain is accomplished, extract the downloaded file within the Apache internet root listing with the next command:
sudo mkdir -p /var/www/html/akaunting
sudo unzip Akaunting_*.zip -d /var/www/html/akaunting/
Subsequent, give correct permissions to the akaunting listing:
sudo chown -R www-data:www-data /var/www/html/akaunting/
sudo chmod -R 755 /var/www/html/akaunting/
After getting completed, you may proceed to the following step.
Configure Apache for Akaunting
Subsequent, you have to to create an Apache digital host file for Akaunting. You create it with the next command:
sudo nano /and so on/apache2/sites-available/akaunting.conf
Add the next traces:
<VirtualHost *:80> ServerAdmin [email protected] DocumentRoot /var/www/html/akaunting ServerName instance.com DirectoryIndex index.html index.php <Listing /var/www/html/akaunting/> Choices +FollowSymlinks AllowOverride All Require all granted </Listing> ErrorLog ${APACHE_LOG_DIR}/akaunting_error.log CustomLog ${APACHE_LOG_DIR}/akaunting_access.log mixed </VirtualHost>
Substitute ‘instance.com’ with your individual area identify within the above vhost file. Save and shut the file, if you end up completed. Then, allow Apache digital host with the next command:
sudo a2ensite akaunting
Subsequent, allow the Apache rewrite module and restart Apache service with the next command:
sudo a2enmod rewrite
sudo systemctl restart apache2
Entry Akaunting
Now, open your internet browser and sort the URL http://example.com. You can be redirected to the next web page:
Choose your language and click on on the Subsequent button. It is best to see the next web page:
Now, present your database particulars like, database identify, database username, and password. Then, click on on the Subsequent button. It is best to see the next web page:
Now, present your organization identify, firm e-mail tackle, admin e-mail and password, then click on on the Subsequent button. It is best to see the next web page:
Now, present your login credentials and click on on the Login button. It is best to see the next web page:
Now, enter your particulars and click on on the Save button. It is best to see the next web page:
Now, Add currencies or click on on the Skip button. It is best to see the next web page:
Now, Add taxes or click on on the Skip button. It is best to see the next web page:
Now, click on on the Go to Dashboard button. It is best to see the next web page:
Congratulations! you may have efficiently put in Akaunting on Ubuntu 18.04 server. Now you can simply handle your invoices, quote, and funds from anyplace. Be at liberty to ask me when you have any questions.
Comments