How to install ERPNext in Ubuntu ?


Install ERPNext :-

Step1: Use upgrade command to actually installs newer versions of the packages.
sudo apt-get update && sudo apt-get upgrade

Update and Upgrade

Step2: You have to install the following package.
sudo apt -y install python-minimal

Python Minimal

Step3 : You have to install the following dependancy.
sudo apt -y install git build-essential python-setuptools python-dev libffi-dev libssl-dev

Python Setup Tools

Step4: Now The next step is install pip3 package for python
wget https://bootstrap.pypa.io/get-pip.py

Get Pip

sudo python get-pip.py

Get Pip Install

sudo pip install –upgrade pip setuptools

Setup Tools Update

sudo pip install ansible

Ansible Install

Step 5: Next to install python3
sudo apt install python3-pip

Python3 Pip

Step 6: Next step is to install curl
sudo apt -y install curl

Curl Install

Step 7: Next you have to configure the yarn package repository.
curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | sudo apt-key add –

Apt Key Add

echo “deb https://dl.yarnpkg.com/debian/ stable main” | sudo tee /etc/apt/sources.list.d/yarn.list

Yarn List

Step 8: Next following command to install yarn.
sudo apt -y update && sudo apt -y install yarn

Update and Install Yarn

Step 9: Now next For install mariaDB you have to run following command
sudo apt -y install mariadb-server libmysqlclient-dev

Install Mariadb

Step 10: Now next step is to update “my.conf” file for database.
For that to open file in command prompt in edit mode enter below command.
sudo nano /etc/mysql/my.cnf

Mariadb Configuration File

Add the following lines in config file

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

Add Code In ConfIguration File

Step 11: Next, you have to restart MariaDB and enable it to auto start MariaDB at boot time.
sudo systemctl restart mariaDB

Restart Mariadb

sudo systemctl enable mariaDB

Enable Mariadb

Step 12: Next, the mysql_secure_installation tool to configure additional security options.
sudo mysql_secure_installation

Enter current password for root (enter for none): xxxxxx

Change the root password? [Y/n] n

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

My Sql Secure Installation

Step 13:you have to add the Node source Node.js 8.x respository.
sudo curl –silent –location https://deb.nodesource.com/setup_8.x | sudo bash –

Curl Location

Step 14: To install Nginx, Node.js and Redis on Ubuntu, run the commands below.
sudo apt -y install nginx nodejs redis-server

Install Nginx

Step 15: Next step is to start and enable Nginx service to always start up with the boots.
sudo systemctl start nginx

Start Nginx

sudo systemctl enable nginx
Enable Nginx

Step 16: Start and enable Redis service to always start up with the boots.
sudo systemctl start redis-server

Start Redis Server

sudo systemctl enable redis-server

Enable Redis Server

Step 17: For installation and activation of virtual environment.
sudo systemctl enable redis-server

Mkdir ERPNext

cd erpnext

CD ERPNext

Run below command to install virtual environment
sudo apt install virtualenv

Install Virtualenv

you need to create virtual environment on “erpnext” directory using the following command
virtualenv .

Virtualenv

For activation of virtual environment.
source ./bin/activate

Active Virtualenv

Step 18: Now Next step is to install bench and there dependencies.
git clone https://github.com/frappe/bench bench-repo

Install Bench

sudo pip install -e bench-repo

Install Bench Repo

Step 19: The next step is to init command will create a bench directory with frappe framework installed.
bench init –frappe-branch master –frappe-path https://github.com/frappe/frappe.git frappe-bench Continue reading

OpenERP 7 with SSL on Ubuntu 12.04


Lets assume that apache and required packages are installed on system.

There are some commands needs to execute to run OpenERP on SSL.

sudo apt-get install apache2
sudo a2enmod ssl proxy_http headers rewrite

Now we have created certificate and key so we have to execute these commands one by one.

sudo mkdir /etc/ssl/openerp

openssl genrsa -des3 -out oeserver.pkey 1024
openssl rsa -in oeserver.pkey -out oeserver.key
openssl req -new -key oeserver.key -out oeserver.csr

At last we signed certificate here.

openssl x509 -req -days 365 -in oeserver.csr -signkey oeserver.key -out oeserver.crt

We also created apache configuration file.

sudo vim /etc/apache2/sites-available/openerp

<VirtualHost *:443>

SSLEngine on
SSLCertificateFile /etc/ssl/openerp/oeserver.crt
SSLCertificateKeyFile /etc/ssl/openerp/oeserver.key

ProxyRequests Off

<Proxy *>
Order deny,allow
Allow from all
</Proxy *>
ProxyVia On
ProxyPass / http://127.0.0.1:8078/
<location />
ProxyPassReverse /
</location>

RequestHeader set “X-Forwarded-Proto” “https”

SetEnv proxy-nokeepalive 1
</VirtualHost>

Now enable above configuration execute below command

sudo a2ensite openerp

After above configuration, just restart OpenERP server and use this URL to test: https://127.0.0.1

How to change default Python version in Ubuntu ?


Sometimes, you may require to change default python version of your linux operating system.
you can accomplish it by using following steps. First make sure you have root level privileges.

Now, you can see following lines which will be different according to operating system. Make changes into ‘default-version’ and save this file.

In next step, we have to change default link file of python.

Just move old file to another location.

Now again create symbolic link for python.

Check your python version.

 

How to install Magento in Ubuntu ?


Now it’s turn to install another eCommerceMagento‘ which is feature-rich eCommerce platform built on open-source technology. Magento is available in two editions: Community and Enterprise.

Installing and Configuring Apache

$ sudo apt-get install apache2

You may see following message during installation:

apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

To fix that problem, you need to edit the httpd.conf file. Open the terminal and type

$ sudo gedit /etc/apache2/httpd.conf

By default httpd.conf file will be blank. Now, simply add the following line to the file.

ServerName localhost

Save the file and exit from gEdit.

Finally restart the server.
$ sudo /etc/init.d/apache2 restart

* Restarting web server apache2
…. waiting             [ OK ]

sudo a2enmod rewrite

Installing PHP

sudo apt-get install php5 php5-curl php5-gd php5-mcrypt php5-mysql

Installing MySQL

sudo apt-get install mysql-server

To know more system requirements click on following link :

http://www.magentocommerce.com/system-requirements

Now create directory for magento

mkdir /home/magento
chgrp www-data /home/magento
mkdir -p /home/magento/{public,log}

Configuring Apache Virtual Host

Now we are going to create simple virtual host configuration file that will help Apache to display the data of directory /home/ubuntu/magento for any HTTP request to localhost.magento.com

Create “magento.com” file in this location “/etc/apache2/sites-available/” with following content.

<VirtualHost *:80>

ServerName localhost.magento.com
ServerAlias http://www.localhost.magento.com

DocumentRoot /home/ubuntu/magento/public

LogLevel warn
ErrorLog /home/ubuntu/magento/log/error.log
CustomLog /home/ubuntu/magento/log/access.log combined

</VirtualHost>

Use a2ensite command and restart Apache to load the new configuration file.

sudo a2ensite magento.com
sudo service apache2 restart

To ensure that the domain localhost.magento.com resolves locally to the computer require entries to /etc/hosts file.

# For magento

127.0.0.1 localhost.magento.com
127.0.0.1 http://www.localhost.magento.com

Now hit localhost.magento.com in your browser to check working status after completion of above entries.

Now we will execute installation steps of main topic.

Type following command on prompt. It will ask for root user password.

mysql -u root -p

Now lets create database for Magento.

CREATE DATABASE magento;
INSERT INTO mysql.user (User,Host,Password) VALUES(‘magento’,’localhost’,PASSWORD(‘magento’));
GRANT ALL PRIVILEGES ON magento.* TO magento@localhost;

Now download latest stable Magento from
http://www.magentocommerce.com/download
and put zip file into /home/ubuntu/magento/public

If error: ERROR 1133 (42000): Can’t find any matching row in the user table
FLUSH PRIVILEGES;

For testing Magento, you can download it from
http://www.magentocommerce.com/downloads/assets/1.6.1.0/magento-sample-data-1.6.1.0.tar.gz

mv magento-sample-data-1.6.1.0/media/* media/
mv magento-sample-data-1.6.1.0/magento_sample_data_for_1.6.1.0.sql sample_data.sql

Now we have to insert sample data into database that we earlier created for Magento.

mysql -u magento -p
USE magento;
SOURCE sample_data.sql;

Now everything is setup so open your browser and type localhost.magento.com and follow installation steps. You will find following screen.

Here is your Magento is working.

How to install Joomla in ubuntu ?


Today we will discuss about how to install Joomla.

Lets start with LAMP Installation.

Please follow the command mentioned below. Note that caret (^) symbol is required.

sudo apt-get install lamp-server^

You will be asked to enter a new root password for the MySQL database. Press ENTER after password.

You will be prompted to enter the password again for confirmation.
Please wait upto completion of installation.

Let’s move on further step.

Check Apache

Launch your web browser (Firefox, Google Chrome, etc.) and open one of these addresses:

http://localhost/ or http://127.0.0.1/

Apache is working perfectly if you get this page:

Otherwise restart apache with following command:

sudo /etc/init.d/apache2 restart

Check PHP

You need to create PHP file in /var/www  and add following code into it:

<?php phpinfo();?>

and save this file as a test.php

Then open this address:

http://localhost/test.php

You should see a page like this:

Configure MySQL

Since you are using the LAMP web server locally, your MySQL database must uses the same IP address of your localhost which is: 127.0.0.1. Via the Terminal, run this command to verify it:

cat /etc/hosts | grep localhost

Here is the correct output you must get:

cat /etc/hosts | grep localhost
127.0.0.1 localhost
::1     ip6-localhost ip6-loopback

Also verify that the bind address is set correctly by running this command:

cat /etc/mysql/my.cnf | grep bind-address

You should get this output:

cat /etc/mysql/my.cnf | grep bind-address
bind-address = 127.0.0.1

If you get a different IP address, then edit the my.cnf file with this command:

sudo gedit /etc/mysql/my.cnf

Search for the line which has contain “bind-address” and correct its address by replacing it with 127.0.0.1

phpMyAdmin Installation

GUI for managing your MySQL databases:

sudo apt-get install libapache2-mod-auth-mysql phpmyadmin

You have to select a web server that will be configured automatically to run phpMyAdmin.
Select apache2 and press Enter:

You will be asked to configure a database for phpmyadmin with dbconfig-common, select Yes and press Enter:

Enter the MySQL password and press Enter:

phpMyAdmin installation is completed.

Now its turn to download joomla.

Download latest joomla version from following link :

http://www.joomla.org/download.html

Copy joomla directory in this directory : /var/www/joomla

Create a MySQL database and MySQL user

Disable Output_Buffering

The installation of Joomla requires to turn off output_buffering.

– Edit the “php.ini” file:

sudo gedit /etc/php5/apache2/php.ini

– Make following changes

output_buffering = 4096
To
output_buffering = off

– Save and close.

Now start the installation of joomla by opening following link:

http://localhost/joomla

Follow setup instructions :

In this page, provide database name, username and password as created above:

After finish installation process, click on ‘Remove Installation Folder’.

Now you will enter administrator information for access it.

Administrator console

How to install python2.5 in ubuntu 11.04 ?


Today for some urgent programs, need to work in Python 2.5 in Ubuntu 11.04.

But Ubuntu 11.04 is giving Python 2.7 by default. So I tried to install Python 2.5 but got some difficulties.
So I did R & D and found this solution. I know its very helpful so sharing with you guys.

sudo add-apt-repository ppa:fkrull/deadsnakes
sudo apt-get update
sudo apt-get install python2.5