InvoicePlane is open source and which was built to offer a free application for client management, invoicing and payment tracking. InvoicePlane is a solid app to manage your complete billing circle, from quotes to invoices to payments. The application provides CRM-like management for your clients. Enter contact details, notes or add custom fields. You can customize InvoicePlane to make sure it fits your needs: amount formats, email and PDF templates and many more. InvoicePlane is fully translated into 23 languages by community members and more languages are coming soon.
You'll need a freshly installed CentOS 7 server and a user with root privileges over it, you can switch to root user from non root user using sudo -i command. This guide will help you to install InvoicePlane on your CentOS 7 server.
It is recommended to update your system and available packages before going through the installation process and to do so underneath command will do the job for you.
yum -y update
Installing Apache Web Server
Once the system is updated, you can install the dependencies required. To install InvoicePlane you will need to install the Apache web server along with MaraiDB and PHP with a few extensions.
Run the following command to install the Apache web server.
yum -y install httpd
Now you can start Apache and enable it to start at boot time, using the following commands.
You can check status of mariaDB using this below given command and you should see following output.
systemctl status mariadb.service
[root@Sajid ~]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2017-02-20 05:48:45 UTC; 20s ago
Main PID: 10704 (mysqld_safe)
├─10704 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─10861 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr...
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: The latest information about Ma....
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: You can find additional informa...:
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: http://dev.mysql.com
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: Support MariaDB development by ...B
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: Corporation Ab. You can contact....
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: Alternatively consider joining ...:
Feb 20 05:48:43 ip-172-31-25-114 mariadb-prepare-db-dir: http://mariadb.com/kb/en/contri.../
Feb 20 05:48:43 ip-172-31-25-114 mysqld_safe: 170220 05:48:43 mysqld_safe Logging to '/...'.
Feb 20 05:48:43 ip-172-31-25-114 mysqld_safe: 170220 05:48:43 mysqld_safe Starting mysq...ql
Feb 20 05:48:45 ip-172-31-25-114 systemd: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
We recommend you to make sure that this installation is secure and to do so run following command.
You'll be asked to provide root password so enter appropriate password and answer yes to all questions by pressing Y.
Enter current password for root (enter for none): Just press the Enter button
Set root password? [Y/n]: Y
New password: your-root-password
Re-enter new password: your-root-password
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y
Now you'll have to create a database for InvoicePlane so please follow the instructions.
mysql -u root -p
You'll be asked to enter password so simply enter a password and now execute the following queries to create a new database.
CREATE DATABASE InvoicePlane;
The above query will create a database named InvoicePlane. For the database you can use any name you prefer in the place of InvoicePlane. Make sure that you use semicolon at the end of each query as a query always ends with a semicolon. Once the database is created you can create a new user and grant the required permissions to the user for the database.
CREATE USER 'IP_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username IP_user. You can use any preferred username instead of IP_user. Replace StrongPassword with a strong password.
Now provide the appropriate privileges to your database user over the database you have created. Run the following query to do so.
GRANT ALL PRIVILEGES ON InvoicePlane.* TO 'IP_user'@'localhost';
Now run the following query to immediately apply the changes on the database privileges.
Now you can exit from MariaDB prompt using following command.
We will have to install PHP 7. To do so run following commands as shown below.
Next you'll have to set up preferred timezone for your machine and to do so we will have edit php.ini file using any text editor. Here we are using nano text editor you can also install it usingyum -y install nano
Now find the line ;date.timezone = and change it to date.timezone = Asia/Kolkata(You'll have to use your timezone) then save the file and exit from text editor.
Next you'll have to restart your apache web server to load new components that we just configured and use following command to restart apache web server.
systemctl restart httpd.service
Once we have installed all the required dependencies now we are ready to download and install InvoicePlane so so first of all download the latest the stable release available and unzip it. Simply run underneath command it will do the job for you.
Finally you'll have to modify firewall rules so if in case you don't have firewalld services installed on your server then you can install it using yum -y install firewalld and you can start it using systemctl start firewalld
Next run these below given commands to modify the firewalld rules.
Truth be told, it’s difficult for a web application that doesn’t have some kind of identification, even if you don’t see it as a security measure in and of itself. The Internet is a kind of lawless land, and even on free services like Google’s, authentication ensures that abuses will...
Although data persistence is almost always a fundamental element of applications, Node.js has no native integration with databases. Everything is delegated to third-party libraries to be included manually, in addition to the standard APIs. Although MongoDB and other non-relational databases are the most common choice with Node because if you...