FrontAccounting-2.4.7/C2/Installation-of-FrontAccounting-on-Linux-OS/English-timed
|
|
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. |