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

From Script | Spoken-Tutorial
Revision as of 15:59, 22 January 2020 by PoojaMoolya (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Time
Narration
00:01 Welcome to the Spoken Tutorial on Installation of FrontAccounting on Linux Operating System.
00:08 In this tutorial, we will learn to -

Install XAMPP

00:13 Download FrontAccounting software
00:15 Do the database setup and

Install FrontAccounting in Linux OS

00:22 To record this tutorial, I‘m using:

Ubuntu Linux OS version 16.04

00:29 Apache, MySQL and PHP obtained through XAMPP 5.5.19
00:36 FrontAccounting 2.4.7
00:40 Firefox web browser and A working Internet connection.
00:45 You can use any web browser of your choice.
00:50 FrontAccounting is a server based Accounting System.
00:54 So we will be using XAMPP to setup the web server on our machine.
00:59 Open a web browser.

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

01:06 This will take us to the XAMPP download page.
01:10 Here XAMPP is available to download for all operating systems.
01:15 The latest version of XAMPP can be downloaded by clicking this green button.
01:20 However, depending upon your software requirement, you may need a different version of XAMPP.
01:27 In my case I need XAMPP version 5.5.19
01:33 Scroll down and select XAMPP Linux.
01:37 The redirected page will display all the XAMPP versions till date.
01:42 For this installation, I will select the XAMPP version 5.5.19
01:49 My system is a 64bit Operating System. So I will download, xampp-linux-x64-5.5.19-0-installer.run
02:05 Now, click on the Save file button and then click on the OK button.
02:10 In my machine, it has been saved in the Downloads folder.
02:14 Let’s open a terminal by pressing Ctrl + Alt + T keys together.
02:21 On the terminal, type the command

cd space Downloads and press Enter.

02:27 This will change the current working directory to Downloads.
02:31 Then type the command as shown and press Enter.
02:36 Now to run the installer file, type the command as shown and press Enter.

Enter the admin password if prompted.

02:46 Now the Setup wizard dialog box opens.
02:50 Click on the Next button whenever prompted and follow the installation steps as shown.
02:56 Uncheck Learn more about Bitnami for XAMPP check box.

Then continue by clicking on the Next button.

03:05 Once the installation done, uncheck Launch XAMPP check box.
03:10 Lastly, click on Finish button.
03:13 Now we should check whether XAMPP is successfully installed on our machine or not.
03:19 In the terminal, start XAMPP service by typing

sudo space slash opt slash lampp slash lampp space start

03:31 Type the admin password when prompted and press Enter.
03:36 You may get a message as shown here.

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

03:46 In case you get a message saying, Command not found, then XAMPP is not installed on your machine.
03:54 You may get some error messages like:

Apache shutdown unexpectedly

or

04:00 Port 80 in use for Apache Server

or

04:05 Unable to connect to any of the specified MySQL hosts for MySQL database.”
04:13 This is because the default ports allotted to Apache and MySQL is taken by another software.
04:21 Default port number for Apache is 80 and for MySQL is 3306.
04:30 To change these ports, refer to the Additional Reading Material of this tutorial.
04:36 And allot the proper port numbers before proceeding further. For eg: 8080
04:44 Now, open Firefox web browser.

In the address bar, type localhost and press Enter.

04:52 We should be able to see the XAMPP screen.
04:56 If prompted for language selection, select English.
05:01 We are now in the XAMPP homepage.
05:04 In the menu at the left of the screen, click on PHPinfo.
05:10 Now press Ctrl + F keys and search for DOCUMENT underscore ROOT.
05:18 It will be found in the table Apache Environment.
05:22 The value of DOCUMENT underscore ROOT will be either

slash opt slash lampp slash htdocs or slash var slash www

05:35 In my machine, it is slash opt slash lampp slash htdocs.
05:41 Please make a note of this path.

We are going to install FrontAccounting here.

05:47 Let's start downloading Front Accounting.
05:50 Open another tab in the web browser and go to this URL.
05:57 Click on frontaccounting-2.4.7.tar.gz
06:04 Immediately, the download begins.

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

06:12 Switch back to the terminal.
06:15 Next, we have to extract the contents of the tar.gz file that we downloaded.
06:22 So, type sudo space tar space hyphen zxvf space frontaccounting hyphen 2.4.7.tar.gz
06:39 Type the admin password if prompted and press Enter.
06:44 Once extracted, I will rename the extracted FrontAccounting folder as account.
06:50 Type the command- mv space frontaccounting space account and press Enter.
06:58 Renaming of the folder name is optional, however,

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

07:08 Switch Back to the terminal.
07:11 Now we have to move the folder account into apache home directory.
07:17 To move account folder to apache home directory,

type sudo space mv space account space /opt/lampp/htdocs/ and press Enter.

07:34 Now, let’s go to the apache home directory.
07:37 To do that, type cd space /opt/lampp/htdocs/ and press Enter.
07:47 To change account folder permission, type

sudo space chmod space -R space 777 space account slash and press Enter.

08:01 We have successfully installed the XAMPP server.
08:05 Make sure that the FrontAccounting installer is in the web server’s root directory.
08:11 Next we need to create a database for FrontAccounting to proceed further.
08:17 We will do this in phpmyadmin, which is the graphical user interface for MySQL

It comes along with the XAMPP installation

08:28 Let us go back to the XAMPP Page in the browser.

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

08:39 Click on Users in the top menu and then click on Add User.
08:47 In the new window that opens enter a username of your choice.

I will type frontacc as my username.

08:56 From the Host drop-down list, select Local.
09:01 Enter a password of your choice in the Password text-box.
09:06 I will type admin123 as my password.
09:11 Type the same password in the Re-type textbox.
09:16 Do not click on Generate Password prompt for now.
09:21 Under Database for user, we can see the option

Create database with the same name and grant all privileges.

09:29 We will check that option and scroll down.
09:33 Then click the Go button at the bottom right of the page.
09:38 We see a message “You have added a new user”.

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

09:50 This username and password is only for Database login purpose.
09:56 Make a note of the username, password and database names.
10:01 These will be required later to complete the FrontAccounting installation.
10:06 Please note: Database name and username need not be the same.
10:11 To have different names, create the database first and then create a user for that database.
10:18 Also, as per naming convention, username should not have any spaces in between.
10:25 We now have XAMPP running and our database is ready.
10:29 We are now ready to proceed installing Front Accounting.
10:33 In the web browser open a new tab.

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

10:44 We can see the FrontAccounting webpage showing

Step 1: System Diagnostics

10:51 Make sure that Select install wizard language is English.
10:56 Scroll down and click on Continue button at the bottom of the page.
11:02 The title of the next web page is

Step 2: Database Server Settings.

11:08 Here, I’ll keep the server port as empty.
11:12 If you have changed the MySQL default port number other than 3306, then enter that port number here.
11:21 Enter the following details which we have created earlier-

database Name as frontacc

database user as frontacc

11:33 database password as admin123
11:38 Ignore the rest of options and click on Continue button at the bottom.
11:45 Next, you will need to put the details of your own company.

I will demonstrate how to do so.

11:53 In Company Name field, I will type ST Company Pvt Ltd.
11:59 I will keep the Admin Login as admin.
12:02 Then I will type the Admin password as spoken.

You can give any password of your choice.

12:10 Re-enter the same password.

Remember this is the login password.

12:16 Next we see two options for the Charts of Accounts.
12:21 I will select Standard new company American COA.
12:26 Select the Default Language as English.
12:30 Click on the Install button.
12:34 We can see the final message on our screen, FrontAccounting ERP has been installed successfully.

Which confirms that our installation is successful.

12:46 Click on the link, Click here to start to log-in to the FrontAccounting interface.
12:53 In the log-in screen, enter the following details:

User name as admin

Password as spoken

13:03 Company as ST Company Pvt. Ltd.

And click on the Login button.

13:11 We are brought to the Front Accounting Administration page.

We can see various tabs on this page.

13:18 We will learn how to use many of these later in this series.
13:23 This brings us to the end of this tutorial.

Let us summarize.

13:28 In this tutorial, we will learn to - Download and install XAMPP
13:34 Download and install FrontAccounting software
13:38 And Do the database setup in Linux OS
13:42 The video at the following link summarises the Spoken Tutorial project.

Please download and watch it.

13:50 The Spoken Tutorial Project team conducts workshops and gives certificates.

For more details, please write to us.

14:00 Do you have questions in THIS Spoken Tutorial?

Please visit this site.

14:05 Choose the minute and second where you have the question

Explain your question briefly

14:12 Someone from our team will answer them
14:15 The Spoken Tutorial forum is for specific questions on this tutorial

Please do not post unrelated and general questions on them

14:25 This will help reduce the clutter

With less clutter, we can use these discussion as instructional material

14:34 Spoken Tutorial Project is funded by MHRD, Government of India.
14:40 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

PoojaMoolya