Installing Invoiceplane on your LAMP server

Step to install LAMP

Type the following command in the terminal

1. sudo apt-get install tasksel
2. sudo tasksel install lamp-server
Note: Popup will appear during installation and ask you set the MYSQL root password.

Installing InvoicePlane

1. cd /var/www/html/
2. mkdir invoiceplane
3. wget https://invoiceplane.com/download/v1.4.6
4. unzip v1.4.3*
Now set the folder permission
sudo chow –R myuser invoiceplane/
Now configure MySQL
Type command
sudo mysql_secure_installation
Then configure:
Set root password? [Y/n] y
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
Next we will need to log in to the MySQL console and create a database for the InvoicePlane. Run the following command:

mysql -u root -p

CREATE DATABASE invoiceplane;
Now we will create newuser with the password danat123$
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'danat123$';
Grant Privileges to the user myuser
GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost';
FLUSH PRIVILEGES;
\q

Configuring Apache web server for InvoicePlane
Edit the apache2.config
Cd /ete/apache2
Sudo nano apache2.conf
Change below lines from
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride OFF
Require all granted
<Directory>

To

<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
<Directory>

Now goto below location and edit htaccess file

sudo cd /var/www/html
sudo nano

Change

RewriteEngine on
RewriteBase /subdirectory
RewriteRule  index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule . index.php [L]

To

RewriteEngine on
RewriteBase /
RewriteRule  index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule . index.php [L]

Note the only changes in second line RewriteBase /subdirectory to RewriteBase /

Save and restart apache service

Now goto http://localhost/index.php/setup/language and follow the instruction