FrontAccounting-2.4.7/C2/Installation-of-FrontAccounting-on-Linux-OS/English

From Script | Spoken-Tutorial
Revision as of 17:40, 6 November 2019 by Nirmala Venkat (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Visual Cue
Narration
Show Slide 1:

Title Slide

Welcome to the Spoken Tutorial on Installation of FrontAccounting on Linux OS.
Show Slide 2:

Learning Objectives:

In this tutorial, we will learn to -
  • Install XAMPP
  • Download FrontAccounting software
  • Do the database setup and
  • Install FrontAccounting in Linux OS
Show Slide 3:

System Requirements OS, Web Server and Versions

To record this tutorial, I‘m using:
  • Ubuntu Linux OS version 16.04
  • Apache, MySQL and PHP obtained through XAMPP 5.5.19
  • FrontAccounting 2.4.7
  • Firefox web browser and
  • A working Internet connection.

You can use any web browser of your choice.

Show Slide:

FrontAccounting

  • FA is a server based Accounting System
  • Use XAMPP to setup the web server on our machine
FrontAccounting is a server based Accounting System.

So we will be using XAMPP to setup the web server on our machine.

[Firefox]

Type https://sourceforge.net/projects/xampp/files/

Open a web browser.

In the address bar, type this URL and press Enter.

[Firefox]Show XAMPP for all OS This will take us to the XAMPP download page.

Here XAMPP is available to download for all operating systems.

[Firefox] Point to XAMPP download green button. The latest version of XAMPP can be downloaded by clicking this green button.
Only narration However, depending upon your software requirement, you may need a different version of XAMPP.

In my case I need XAMPP version 5.5.19

[Firefox] Scroll down and select XAMPP Linux.
[Firefox] Scroll and show the XAMPP versions The redirected page will display all the XAMPP versions till date.
[Firefox] Highlight 5.5.19 For this installation, I will select the XAMPP version 5.5.19
[Firefox]

Point to xampp-linux-x64-5.5.19-0-installer.run

My system is a 64bit OS. So I will download, xampp-linux-x64-5.5.19-0-installer.run
Select save radio button Now, click on the Save file button and then click on the OK button.

In my machine, it has been saved in the Downloads folder.

Open terminal by pressing Ctrl+Alt+T Let’s open a terminal by pressing Ctrl + Alt + T keys together.
[Terminal]

Type: cd Downloads [Enter]

On the terminal, type the command

cd space Downloads and press Enter.

This will change the current working directory to Downloads.

[Terminal] Type:

chmod +x xampp-linux-x64-5.5.19-0-installer.run

Then type the command as shown and press Enter.
[Terminal] Type:

sudo ./xampp-linux-x64-5.5.19-0-installer.run

Now to run the installer file, type the command as shown and press Enter.

Enter the admin password if prompted.

Setup Box opens. Now the Setup wizard dialog box opens.

Click on the Next button whenever prompted and follow the installation steps as shown.

Uncheck Learn more about Bitnami for XAMPP check box >> Click on Next. Uncheck Learn more about Bitnami for XAMPP check box.

Then continue by clicking on the Next button.

Uncheck Launch XAMPP check box >> Click on Finish. Once the installation done, uncheck Launch XAMPP check box.

Lastly, click on Finish button.

Only Narration Now we should check whether XAMPP is successfully installed on our machine or not.
sudo /opt/lampp/lampp start In the terminal, start XAMPP service by typing

sudo space slash opt slash lampp slash lampp space start

And press Enter.

Type the admin password at the prompt. Type the admin password when prompted and press Enter.
Highlight the message Starting XAMPP for Linux on the terminal.

Highlight Mysql in the starting XAMPP for Linux command

You may get a message as shown here.

This indicates that XAMPP is installed on your system and you have started the service.

Slide:4

XAMPP not installed

Show screenshot.

In case you get a message saying, Command not found, then XAMPP is not installed on your machine.
Slide 5:

Error Messages

You may get some error messages like:

Apache shutdown unexpectedly

or

Port 80 in use for Apache Server

or

Unable to connect to any of the specified MySQL hosts for MySQL database.”

This is because the default ports allotted to Apache and MySQL is taken by another software.

Slide 6:

Default port

Default port number for Apache is 80 and for MySQL is 3306.
Slide 7:

Change in Ports

To change these ports, refer to the Additional Reading Material of this tutorial.

And allot the proper port numbers before proceeding further. For eg: 8080

Open Firefox >> In the address bar type localhost >> press Enter. Now, open Firefox web browser.

In the address bar, type localhost and press Enter.

We should be able to see the XAMPP screen.

Select English if prompted. If prompted for language selection, select English.
Only Narration We are now in the XAMPP homepage.
In the left side menu >> click on phpinfo In the menu at the left of the screen, click on PHPinfo.
Type Ctrl+F >> type DOCUMENT_ROOT in the search window>> Press Enter Now press Ctrl + F keys and search for DOCUMENT underscore ROOT.
Point to Apache Environment. It will be found in the table Apache Environment.
Only narration The value of DOCUMENT underscore ROOT will be either
  • slash opt slash lampp slash htdocs or
  • slash var slash www
Point or highlight /opt/lampp/htdocs. In my machine, it is slash opt slash lampp slash htdocs.
Only narration Please make a note of this path.

We are going to install FrontAccounting here.

Open browser>> go to this URL:

https://sourceforge.net/projects/frontaccounting/files/FrontAccounting%202.4/2.4.7/

>> click on frontaccounting-2.4.7.tar.gz
Let's start downloading Front Accounting.

Open another tab in the web browser and go to this URL.

Click on frontaccounting-2.4.7.tar.gz

Download window Immediately, the download begins.

Click on the Save File button and then click on the OK button.

Switch back to terminal: Switch back to the terminal.
Type sudo tar -zxvf frontaccounting-2.4.7.tar.gz Next, we have to extract the contents of the tar.gz file that we downloaded.

So, type sudo space tar space hyphen zxvf space frontaccounting hyphen 2.4.7.tar.gz

and press Enter.

Type the admin password at the prompt. Type the admin password if prompted and press Enter.
Once extracted, I will rename the extracted FrontAccounting folder as account.
To rename extracted frontaccounting folder as account Type the command-

mv space frontaccounting space account and press Enter.

Slide:6

Folder Renaming

Renaming of the folder name is optional, however.

It helps to identify multiple instances of FrontAccounting installed on a single machine.

Switch Back to the terminal.
Type sudo mv account /opt/lampp/htdocs Now we have to move the folder account into apache home directory.

To move account folder to apache home directory,

type

sudo space mv space account space /opt/lampp/htdocs/

and press Enter.

Type cd /opt/lampp/htdocs Now, let’s go to the apache home directory.

To do that, type cd space /opt/lampp/htdocs/

and press Enter.

Type sudo chmod -R 777 account To change account folder permission, type

sudo space chmod space -R space 777 space account slash

and press Enter.

Only narration We have successfully installed the XAMPP server.

Make sure that the FrontAccounting installer is in the web server’s root directory.

Slide:7

Adding admin user and Creating database

Next we need to create a database for FrontAccounting to proceed further.

We will do this in phpmyadmin, which is the graphical user interface for MySQL

It comes along with the XAMPP installation

Creating Database:

Click on phpmyadmin

Let us go back to the XAMPP Page in the browser.

On the XAMPP page, in the menu at the left, click on phpMyadmin.

Click on Users accounts >> click on Add User account Click on Users in the top menu and then click on Add User.
Type frontacc In the new window that opens enter a username of your choice.

I will type frontacc as my username.

Select Local from the dropdown From the Host drop-down list, select Local.
In Password textbox >> Type admin123 Enter a password of your choice in the Password text-box.

I will type admin123 as my password.

Re-type admin123 Type the same password in the Re-type textbox.
Point to the option Do not click on Generate Password prompt for now.
Point to Create a database with the same name and grant all privileges Under Database for user, we can see the option

Create database with the same name and grant all privileges.

Click on it >> Click on the Go button We will check that option and scroll down.

Then click the Go button at the bottom right of the page.

Point to the frontacc database in the side pane We see a message “You have added a new user” at the top of the window.

It means a new database with the name frontacc and with a user frontacc has been created.

This username and password is only for Database login purpose.

Make a note of the username, password and database names.

These will be required later to complete the FrontAccounting installation.

Show Slide:8


Rules and Naming Conventions

Please note:
  • Database name and username need not be the same.
  • To have different names, create the database first and then create a user for that database.
  • Also, as per naming convention, username should not have any spaces in between.
Point We now have XAMPP running and our database is ready.

We are now ready to proceed installing Front Accounting.

Go to the web browser >> URL >> localhost/account In the web browser open a new tab.

In the address bar type localhost/account and press Enter.

Point We can see the FrontAccounting webpage showing

Step 1: System Diagnostics

Make sure that Select install wizard language is English.

Scroll down Scroll down and click on Continue button at the bottom of the page.
Step 2: Database Server Settings The title of the next web page is

Step 2: Database Server Settings.

Type:

database user as frontacc

database password as admin123

database Name as frontacc

Here, I’ll keep the server port as empty.

If you have changed the MySQL default port number other than 3306, then enter that port number here.

Enter the following details which we have created earlier-

database Name as frontacc

database user as frontacc

database password as admin123

Click>>>Continue Button Ignore the rest of options and click on Continue button at the bottom.
Step 5: Company Settings. Next, you will need to put the details of your own company.

I will demonstrate how to do so.

Type in Company Name >> ST Company Pvt Ltd In Company Name field, I will type ST Company Pvt Ltd.
Point to the Admin password I will keep the Admin Login as admin.

Then I will type the Admin password as spoken.

You can give any password of your choice.

Point to the Re-enter password Re-enter the same password.

Remember this is the login password.

Click on the dropdown box >> select Charts of Accounts Next we see two options for the Charts of Accounts.

I will select Standard new company American COA.

Point to the Select Default Language>> English Select the Default Language as English.
Click on the Install button Click on the Install button.
FrontAccounting page open

Point towards message

We can see the final message on our screen, FrontAccounting ERP has been installed successfully.

Which confirms that our installation is successful.

Click on Click here to start Click on the link, Click here to start to log-in to the FrontAccounting interface.
Login to FrontAccounting

User name as admin

Password as spoken

Company as ST Company Pvt. Ltd.

In the log-in screen, enter the following details:

User name as admin

Password as spoken

Company as ST Company Pvt. Ltd.

And click on the Login button.

Point to the various tabs We are brought to the Front Accounting Administration page.

We can see various tabs on this page.

We will learn how to use many of these later in this series.

Only narration This brings us to the end of this tutorial.

Let us summarize.

Slide:

Summary

In this tutorial, we will learn to -
  • Download and Install XAMPP
  • Download and install FrontAccounting software
  • Do the database setup in Linux OS
Slide:

About Spoken Tutorial project

The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

Slide:

About Workshop

The Spoken Tutorial Project team conducts workshops and gives certificates.

For more details, please write to us.

Slide:

Forum for specific questions:

Do you have questions in THIS Spoken Tutorial?

Please visit this site.

Choose the minute and second where you have the question

Explain your question briefly

Someone from our team will answer them

Slide:

Forum for specific questions:

* The Spoken Tutorial forum is for specific questions on this tutorial
  • Please do not post unrelated and general questions on them
  • This will help reduce the clutter
  • With less clutter, we can use these discussion as instructional material
Slide:

Acknowledgement

Spoken Tutorial Project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

Slide:

Thanks

The script has been contributed by Spoken Tutorial team.

This is Arvind Pillai from IIT Bombay signing off.


Thanks for joining.

Contributors and Content Editors

Nancyvarkey, Nirmala Venkat