Difference between revisions of "FrontAccounting/C2/Installation-of-FrontAccounting-on-Linux-OS/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with "'''Title of the Script :FrontAccounting on Linux''' '''Author: Sheetal Prabhu''' '''Keywords: Installation on Linux, version, mysql server''' {| style="border-spacing:0;"...")
 
 
Line 22: Line 22:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| In this tutorial, we will learn -
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| In this tutorial, we will learn -
  
* To install '''Frontaccounting''' on the '''Linux '''Operating System
+
* To install '''Frontaccounting''' on the '''Linux ''' operating system
 
* Using the '''Terminal'''  
 
* Using the '''Terminal'''  
  
Line 47: Line 47:
 
* A working '''HTTP web server '''eg: '''Apache'''
 
* A working '''HTTP web server '''eg: '''Apache'''
 
* '''PHP5 '''installed on the '''web server'''.
 
* '''PHP5 '''installed on the '''web server'''.
* A working '''MySQL server'''- with '''innodb tables '''enabled.
+
* A working '''MySQL server'''.
  
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Open browser>> '''download frontaccounting 2.3.25'''>>
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Open browser>> '''download frontaccounting 2.3.25'''>>
  
https://sourceforge.net/projects/frontaccounting/files/latest/download?source=files
+
https://sourceforge.net/projects/frontaccounting/
 +
 
 +
Click on the '''Download''' button.
 +
 
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Open any web browser and go to this URL:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Open any web browser and go to this URL:
  
https://sourceforge.net/projects/frontaccounting/files/latest/download?source=files
+
https://sourceforge.net/projects/frontaccounting/
 +
 
 +
Click on the '''Download''' button.
  
 
|-
 
|-
Line 82: Line 87:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To update the software source, type the command
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To update the software source, type the command
  
'''sudo apt-get update''' and press '''Enter.'''
+
'''sudo space apt hyphen get space update''' and press '''Enter.'''
  
Give your desktop user password.
+
Give your '''Desktop''' user password.
  
 
|-
 
|-
Line 95: Line 100:
 
To install '''apache2''', type the command
 
To install '''apache2''', type the command
  
'''Sudo space apt-get space install space apache2 space libapache2-mod-auth-mysql'''
+
'''Sudo space apt hyphen get space install space apache2 space libapache2 hyphen mod hyphen auth hyphen mysql'''
  
 
and press '''Enter.'''
 
and press '''Enter.'''
Line 102: Line 107:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| o you want to continue<nowiki>? [</nowiki>Y/n]
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| o you want to continue<nowiki>? [</nowiki>Y/n]
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| I will type '''y''' to continue this installation.
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| I will type '''y''' to continue this installation.
 
Press '''Enter'''.
 
  
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To install php5 and php5-mysql  
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To install php5 and php5-mysql  
  
Type '''sudo apt-get install php5 php5-mysql'''  
+
Type '''sudo apt-get install php5 php5-mysql mysql-server'''  
  
  
 
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Next, we have to install '''php5''', '''php5-mysql''' and '''mysql-server'''.
| style="border:0.75pt solid #000000;padding:0.106cm;"| Next, we have to install '''php5''' and '''php5-mysql'''.
+
  
  
 
So, type  
 
So, type  
  
'''Sudo space apt-get space install space php5 space php5-mysql'''
+
'''sudo space apt hyphen get install space php5 space php5 hyphen mysql space mysql hyphen server'''  
 
+
and press '''Enter.'''
+
 
+
|-
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| To install mysql  
+
 
+
Type '''sudo apt-get install mysql-server '''
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Now, we need to install '''mysql''', type the command
+
  
'''sudo space apt-get space install space mysql-server '''
 
  
 
and press '''Enter.'''
 
and press '''Enter.'''
Line 158: Line 151:
  
 
I will not mention this explicitly.
 
I will not mention this explicitly.
 +
 +
|-
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"|
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"|Now, we need to create '''mysql database'''.
 +
 +
So we need to login in '''mysql server'''.
  
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To enter in '''mysql server''' type '''mysql -u root -p'''
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To enter in '''mysql server''' type '''mysql -u root -p'''
| style="border:0.75pt solid #000000;padding:0.106cm;"| Now, type
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| For this, type the command
  
'''mysql -u root -p'''
+
'''mysql space hyphen u space root space hyphen p'''
 +
 
 +
|-
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type the '''mysql root''' password >> '''root123'''
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type '''mysql root''' password, which is already created.
 +
 
 +
I will type '''root123'''
 +
 
 +
Now we have successfully logged in, in '''mysql server'''.
  
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To create Databases in mysql,  
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To create Databases in mysql,  
  
type '''create''' '''database''' '''frontacc'''<nowiki>;</nowiki>
+
type '''create''' '''database frontacc;'''
| style="border:0.75pt solid #000000;padding:0.106cm;"| To create '''Databases '''in '''mysql''', type the command
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| To create '''Database '''in '''mysql''', type the command
 +
 
 +
'''create database frontacc;'''
 +
 
 +
|-
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"|
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"| '''frontacc''' is the name for my '''database'''.
 +
 
  
'''create''' '''database frontacc'''<nowiki>;</nowiki>
+
You can give any name for your '''database'''.
  
 
|-
 
|-
Line 181: Line 195:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To go to the '''Downloads''' folder, type
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To go to the '''Downloads''' folder, type
  
'''cd Downloads'''
+
'''cd space Downloads'''
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type '''tar -zxvf frontaccounting-2.3.25.tar.gz'''
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type '''sudo tar -zxvf frontaccounting-2.3.25.tar.gz'''
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Next, we have to extract the contents of the '''tar.gz '''file that we downloaded earlier.
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Next, we have to extract the contents of the '''tar.gz '''file that we downloaded earlier.
  
  
So, type '''tar -zxvf frontaccounting-2.3.25.tar.gz'''
+
So, type '''sudo space tar space hyphen zxvf frontaccounting hyphen 2.3.25.tar.gz'''
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| To rename extracted frontaccounting folder as account
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| To rename extracted '''frontaccounting''' folder as '''account'''
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type the command.  
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| I will rename the extracted '''frontaccounting''' folder as '''account'''.
  
'''mv frontaccounting account '''
 
  
 +
Type the command-
  
This will rename the extracted '''frontaccounting '''folder as''' account.'''
+
'''mv frontaccounting account'''
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type '''/var/www/html'''
 
+
'''/var/www/html'''
+
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To move '''account''' folder to '''apache home '''directory, type
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To move '''account''' folder to '''apache home '''directory, type
  
'''sudo mv account /var/www/html/'''
+
'''sudo space mv space account space /var/www/html/'''
 
+
|-
+
| style="border:0.75pt solid #000000;padding:0.106cm;"|
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| And type the '''user password.'''
+
  
 
|-
 
|-
Line 216: Line 224:
  
  
To do that, type '''cdspace/var/www/html'''
+
To do that, type '''cd space /var/www/html'''
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type '''chmod -R 777 account'''
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type '''sudo chmod -R 777 account'''
  
  
Line 225: Line 233:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To change '''account''' folder '''permission''', type  
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| To change '''account''' folder '''permission''', type  
  
'''Chmod space-R 777 account'''
+
'''sudo chmod space -R space 777 space account'''
  
 
|-
 
|-
Line 234: Line 242:
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| Window system diagnostics window
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| '''FrontAccounting''' webpage
| style="border:0.75pt solid #000000;padding:0.106cm;"| The window opens with various software packages that are necessary for '''Frontaccounting. '''
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| We can see the '''FrontAccounting''' webpage showing
 +
 
 +
'''Step 1: System Diagnostics'''.
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the on the '''Continue '''button.
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| '''Comments''' column
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the on the '''Continue '''button.
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| This shows that we have successfully installed the software packages with the '''Comments''' as '''OK'''.
 +
 
 +
|-
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click '''Continue '''.
 +
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the '''Continue '''button.
  
 
|-
 
|-
Line 263: Line 277:
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type in Company Name >>''' ST Co. Pvt. Ltd.'''
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Type in Company Name >>''' ST Co. Pvt. Ltd.'''
| style="border:0.75pt solid #000000;padding:0.106cm;"| I will type the '''Company Name''' as
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| I will type the '''Company Name''' as '''ST Co. Pvt. Ltd.'''
 
+
'''ST Co. Pvt. Ltd.'''
+
  
 
|-
 
|-
Line 283: Line 295:
 
|-
 
|-
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the dropdown box>> '''select Charts of Accounts>>'''
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the dropdown box>> '''select Charts of Accounts>>'''
| style="border:0.75pt solid #000000;padding:0.106cm;"| We can see two options for the '''charts of accounts.'''  
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| We can see two options for the '''Charts of Accounts.'''  
  
I will select '''Standard new company American COA (4digits).'''
+
I will select '''Standard new company American COA.'''
  
 
|-
 
|-
Line 296: Line 308:
  
 
|-
 
|-
| style="border:0.75pt solid #000000;padding:0.106cm;"| Frontaccounting page opens
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| '''FrontAccounting''' page opens
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| We can see the window that shows the '''Frontaccounting ERP''' has been installed successfully.  
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| We can see the window that shows the '''Frontaccounting ERP''' has been installed successfully.  
  

Latest revision as of 15:13, 9 September 2016

Title of the Script :FrontAccounting on Linux

Author: Sheetal Prabhu

Keywords: Installation on Linux, version, mysql server


Visual Cue
Narration
Slide Number 1

Title Slide

Hello and welcome to this tutorial on Installation of FrontAccounting on Linux OS.
Slide Number 2
  • Install Frontaccounting on Linux OS
In this tutorial, we will learn -
  • To install Frontaccounting on the Linux operating system
  • Using the Terminal
Slide Number 3

System Requirements


To record this tutorial, I am using
  • Ubuntu Linux OS version 14.04 and
  • FrontAccounting version 2.3.25

For installation, you will need-

  • A working internet connection.
Slide Number 4

Pre-Requisites

The pre-requisites for installation are-
  • A working HTTP web server eg: Apache
  • PHP5 installed on the web server.
  • A working MySQL server.
Open browser>> download frontaccounting 2.3.25>>

https://sourceforge.net/projects/frontaccounting/

Click on the Download button.

Open any web browser and go to this URL:

https://sourceforge.net/projects/frontaccounting/

Click on the Download button.

Download window Immediately, the download begins.


Save the tar.gz file that is displayed on the screen.


To save, click on the OK button.

Install apache2 and PHP5 Next, we need to install apache2 and PHP5 in Ubuntu 14.04 OS.
Open terminal or type Ctrl+Alt+t key Open the Terminal by pressing Ctrl+Alt+T keys simultaneously, on the keyboard.
Type the command

sudo apt-get update

To update the software source, type the command

sudo space apt hyphen get space update and press Enter.

Give your Desktop user password.

Type the command

apt-get install apache2 libapache2-mod-auth-mysql

Let us install apache2


To install apache2, type the command

Sudo space apt hyphen get space install space apache2 space libapache2 hyphen mod hyphen auth hyphen mysql

and press Enter.

o you want to continue? [Y/n] I will type y to continue this installation.
To install php5 and php5-mysql

Type sudo apt-get install php5 php5-mysql mysql-server


Next, we have to install php5, php5-mysql and mysql-server.


So, type

sudo space apt hyphen get install space php5 space php5 hyphen mysql space mysql hyphen server


and press Enter.

Do you want to continue?[Y/N] I will type y to continue this installation.

Press Enter.

It will prompt for the mysql space server password.
Type root123 Type the new password as per your choice.


I will give the password as root123 and press Enter.

Type root123 Repeat the password again, if prompted.
From here on, please press Enter after every command that we type on the Terminal.


I will not mention this explicitly.

Now, we need to create mysql database.

So we need to login in mysql server.

To enter in mysql server type mysql -u root -p For this, type the command

mysql space hyphen u space root space hyphen p

Type the mysql root password >> root123 Type mysql root password, which is already created.

I will type root123

Now we have successfully logged in, in mysql server.

To create Databases in mysql,

type create database frontacc;

To create Database in mysql, type the command

create database frontacc;

frontacc is the name for my database.


You can give any name for your database.

Type the command quit Type the quit command to exit from mysql server.
Go to Download folder type cd Downloads To go to the Downloads folder, type

cd space Downloads

Type sudo tar -zxvf frontaccounting-2.3.25.tar.gz Next, we have to extract the contents of the tar.gz file that we downloaded earlier.


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

To rename extracted frontaccounting folder as account I will rename the extracted frontaccounting folder as account.


Type the command-

mv frontaccounting account

Type /var/www/html To move account folder to apache home directory, type

sudo space mv space account space /var/www/html/

Type cd /var/www/html Now, let’s go to the apache home directory.


To do that, type cd space /var/www/html

Type sudo chmod -R 777 account


To change account folder permission, type

sudo chmod space -R space 777 space account

Go to the web browser >> URL >> localhost/account Now, let’s go to the web browser and type

localhost/account and press Enter.

FrontAccounting webpage We can see the FrontAccounting webpage showing

Step 1: System Diagnostics.

Comments column This shows that we have successfully installed the software packages with the Comments as OK.
Click Continue . Click on the Continue button.
Setup Frontaccounting Database server setting

Click as per narration.

Click on the following details:

Database root password: root123

Database name frontacc


Click on the Continue button.

Next step is 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 Co. Pvt. Ltd. I will type the Company Name as ST Co. Pvt. Ltd.
Point to the Admin password I will type the password as spoken.


You can give any password of your choice.

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


Remember this is the login password.

Click on the dropdown box>> select Charts of Accounts>> We can 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 Continue button Click on the Continue button.
FrontAccounting page opens We can see the window that shows the Frontaccounting ERP has been installed successfully.
This is how we can install Frontaccounting on Linux machine.


Let us summarize.

Slide Number 5

In this tutorial, we have learnt to

In this tutorial, we have learnt how to install Frontaccounting software on a Linux machine.
Slide Number 6

Acknowledgement

This video summarizes the Spoken Tutorial project

If you do not have good bandwidth, you can download and watch it.

Acknowledgement

This video summarizes the Spoken Tutorial project.


Please download and watch it.

Slide Number 7


We conduct workshops using Spoken Tutorials and give Certificates.

For more information, please contact us.

Slide Number 11 The Spoken Tutorial Project is funded by NMEICT MHRD Government of India.

This tutorial has been contributed by Sheetal Prabhu. from IIT Bombay.

Thank you for joining.

Contributors and Content Editors

Nancyvarkey