Wednesday 17 March 2021

How to make a Product Launch?

 

Hi everyone,
Here I am listing out steps for any generic product launch, right from product conceptualization till post product launch activities.
This is my version of the flow and there are many versions available already. There is no exact "holy grail" for the process but I am sure, this could be definitely help many of you to start and eventually, make finer adjustments, as and when required!
This article is slightly lengthy but I find it useful and informative! So, let's begin.

Steps for product launch:
  • Research on available competitive products in specific market and collect Customer's feedback
     
  • Identify 4-5 most popular customer pain points in those products and discuss with development team about those
     
  • Identify exactly what customer problem we would be able to solve, in given time frame and available resources. These goals must be SMART, Specific, Measurable, Attainable, Reachable and Timely
     
  • Now entire development phase would be divided into 3 phases, alpha launch, beta launch and final launch
     
  • Each launch would have its set of activities or milestones to be accomplished; only once predefined milestones are met in respective phase, phased launch is considered successful
     
  • Towards the end of each phase, product need thorough evaluation and backup is created to avoid and last minute glitches later
     
  • Once alpha phase completes, a product specific website need to be created, which would start engaging potential customers around the product under development. Discuss about the technology used, how this product is going to create real difference and address already identified pain points. This website would also helps to line up B2B deals and collect feedback from potential customers. This would also help to create leads or customers to buy product when it is ready to launch, thus creates pre-orders channels
     
  • Development/technical team is busy in developing product. Meanwhile, other teams need to be involved for various other activities in parallel, such as:
    • Product marketing
    • Product management
    • General marketing teams, such as PR, analyst relations, and investor relations.
    • Field sales,
    • Legal,
    • Sales operations
       
  • Each team should have their checklist where they have their set of scheduled activities
     
  • Marketing team should be primarily engaged in:
    • fueling interest among people by writing promo materials
    • Connects with journalists or editors from respectable media outlets who will write a news story about your company and the upcoming release
    • Involves popular influencers, who would receive beta products, try and share feedback with their followers
       
  • Product manager coordinates activities of each team and list them in project management tool such as Jira so that each activity, responsible person/team and timeline is visible to everyone. Daily Standup activity, sprints, retrospectives / SCRUM would help to keep track of each activities, identify task dependencies, any potential blockers and maintain them on track
     
  • Pricing strategy
    • Competitor-based and value-based pricing are common options for products purchased with a single payment.
    • Freemium model and only charge for the product’s upgraded versions, or
    • One-time payment for access or download.
    • Subscription plans and the pay-as-you-go approach are popular as well
       
  • Promotion strategy
    • Outline a promotion strategy and assign employees that will be responsible for it. Popular tactics for promoting software solutions are
    • Lead generation
      • email campaigns,
      • social media contact,
      • organic searches,
      • paid searches,
      • referrals,
      • website.
    • Content marketing
      • organic search with articles,
      • videos,
      • landing pages,
      • podcasts, or infographics about your industry.
    • Social media marketing
      • using ads on social media,
      • posting your content and industry news about to grow your fanbase
         
  • Once product reached towards end of main phase, a Go/No Go launch meeting, during which each department gives their feedback about the product and readiness of the product
     
  • Product Launch Done!
     
  • Measure launch success
    • The percentage of positive reviews vs negative and neutral ones,
    • Customer retention,
    • The actual number of purchases or subscriptions (with a breakdown by subscription types) vs forecast, and
    • The influence of added features on the total conversion
       
  • Post Launch
    • Continue building up the interest in the product among potential customers,
    • nurturing emails,
    • free trials,
    • demos,
    • in-depth, product-focused webinars and activities
       
  • Product manager collect and analyze user feedback and use analytics to gain insights and prioritize between:
     
    • Building new features which were initially identified and specified in user stories OR
    • Making critical urgent changes in the launched product that can affect product performance and acceptance metrics and user experience.

      Hope you would have found this article informative and interesting.
      Happy learning:-)
       

Monday 23 September 2019

Install OpenCV 4.1.1 using Python3.5 in Ubuntu 16.04

Hi all
I am sharing tried and tested steps for installation of latest version of OpenCV using Python3.5 in Ubuntu 16.04. Python3.5 is installed by default in Ubuntu 16.04.

sudo apt update
sudo apt upgrade
sudo apt-get install build-essential
sudo apt-get install cmake git libgtk2.0-dev pkg-config libavcodec-dev libavformat-dev libswscale-dev
sudo apt-get install python-dev python-numpy libtbb2 libtbb-dev libjpeg-dev libpng-dev libtiff-dev libjasper-dev libdc1394-22-dev
sudo apt-get install libavcodec-dev libavformat-dev libswscale-dev libv4l-dev
sudo apt-get install libxvidcore-dev libx264-dev
sudo apt-get install libgtk-3-dev
sudo apt-get install libatlas-base-dev gfortran
sudo apt-get install python2.7-dev python3.5-dev

wget -O opencv.zip https://github.com/opencv/opencv/archive/4.1.1.zip
unzip opencv.zip
wget -O opencv_contrib.zip https://github.com/opencv/opencv_contrib/archive/4.1.1.zip
unzip opencv_contrib.zip
sudo apt-get install python-pip && pip install --upgrade pip
sudo python -m pip uninstall pip && sudo apt install python-pip --reinstall 

sudo pip install virtualenv virtualenvwrapper
sudo rm -rf ~/.cache/pip

nano .bashrc
Add following lines:
# virtualenv and virtualenvwrapper
export WORKON_HOME=$HOME/.virtualenvs
source /usr/local/bin/virtualenvwrapper.sh


source ~/.bashrc
mkvirtualenv py3cv4 -p python3


x


pip install numpy
cd ~/opencv-4.1.1/
mkdir build
cd build

cmake -D BUILD_TIFF=ON -D WITH_CUDA=OFF -D ENABLE_AVX=OFF -D WITH_OPENGL=OFF -D WITH_OPENCL=OFF -D WITH_IPP=OFF -D WITH_TBB=ON -D BUILD_TBB=ON -D WITH_EIGEN=OFF -D WITH_V4L=OFF -D WITH_VTK=OFF -D BUILD_TESTS=OFF -D BUILD_PERF_TESTS=OFF CMAKE_BUILD_TYPE=RELEASE -D CMAKE_INSTALL_PREFIX=/usr/local -D INSTALL_PYTHON_EXAMPLES=ON -D INSTALL_C_EXAMPLES=ON -D OPENCV_EXTRA_MODULES_PATH=~/opencv_contrib-4.1.1/modules -D PYTHON_EXECUTABLE=~/.virtualenvs/py3cv4/bin/python -D BUILD_EXAMPLES=ON ..

make -j4 (for core i3 system)
sudo make install
sudo ldconfig
cd /usr/local/lib/python3.5/site-packages/
cd cv2
cd python-3.5/
sudo mv cv2.cpython-35m-x86_64-linux-gnu.so cv2.so
(py3cv4) abhi@ubuntu:~$ cd ~/.virtualenvs/py3cv4/lib/python3.5/site-packages/
(py3cv4) abhi@ubuntu:~$ ln -s /usr/local/lib/python3.5/site-packages/cv2/python-3.5/cv2.so cv2.so

To move out from Virtual environment, type "deactivate". To switch inside virtual environment, type "workon py3cv4".

To test proper installation of OpenCV in Ubuntu, open terminal, activate python interpreter and type commands:
$python
>>import cv2
>>cv2.__version__
'4.1.1'

Hope it helps. Keep learning!

Thursday 9 May 2019

My github repository

Hi all
Follow my github repository to find and reuse source code of work done by me! Hope it would help many of you in your technical pursuit.

https://github.com/abhi-84

Keep learning!

Saturday 22 December 2018

Installing Oracle 18c SQL Developer & Oracle 11g Express Edition Database on Ubuntu 16.04 LTS


             Installing Oracle SQL Developer & Oracle 11g Database in Ubuntu

NOTE: DO NOT MISS ANY LINE OR COMMAND MENTIONED HERE; 
BE EXTREMELY CAREFUL ELSE YOU WOULD NOT GET WHAT YOU WANT !

Install Oracle JAVA10 in ubuntu 16.04

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer

To validate the Java installation, execute the following command:
java -version

This should result in the following (or something similar).

java version “1.7.0_51”
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

The next next step is to set the JAVA_HOME environment variable. To do this, open the /etc/bash.bashrc file by executing the following statement.

sudo gedit /etc/bash.bashrc

Scroll to the bottom of the file and add the following lines.

export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export PATH=$JAVA_HOME/bin:$PATH

Save the file and close the editor. To load the changes, execute the following statement.
source /etc/bash.bashrc

To validate the changes you can execute the following statement.
echo $JAVA_HOME

The result of this statement should be the following.
/usr/lib/jvm/java-8-oracle

generate soft link for sqldeveloper.sh

sudo ln -s ~/Downloads/sqldeveloper/sqldeveloper.sh /usr/local/bin/sqldeveloper


Open file sqldeveloper.sh using gedit

$gedit sqldeveloepr.sh

#!/bin/bash
#cd "`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*

unset -v GNOME_DESKTOP_SESSION_ID
cd ~/Downloads/sqldeveloper/sqldeveloper/bin && bash sqldeveloper $*

Save

now type $sqldeveloper on command line to open SQLdeveloper

Oracle 18c SQL Developer is Installed successfully on Ubuntu 16.04 LTS 



Installing Oracle Database 11g in Ubuntu 16.04

For the installation of Oracle 11g R2 Express Edition (XE), a couple of additional Linux packages are required. These packages can be installed by executing the following statement.

sudo apt-get install alien libaio1 unixodbc

The next step is to download the Oracle 11g R2 Express Edition from the Oracle website.

cd Downloads

The next step step is to unzip the downloaded file. To do this, execute the following command.
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

A new directory (Disk1) is added to the Download directory. Navigate to this directory:

cd Disk1

Now we have to convert the Red Hat package (rpm) to a Debian package. This may be done using the alien command. The -d parameter is used to inform alien that a Debian package should be generated.

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

The Red Hat package, relies on the /sbin/chkconfig file, which is not used in Ubuntu. To successfully install Oracle XE we use a simple trick. Start by creating a custom /sbin/chkconfig file by executing the following statement.

sudo gedit /sbin/chkconfig

Copy and paste the following into the editor:

#!/bin/bash
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
file=/etc/init.d/oracle-xe
if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo >> $file
echo '### BEGIN INIT INFO' >> $file
echo '# Provides: OracleXE' >> $file
echo '# Required-Start: $remote_fs $syslog' >> $file
echo '# Required-Stop: $remote_fs $syslog' >> $file
echo '# Default-Start: 2 3 4 5' >> $file
echo '# Default-Stop: 0 1 6' >> $file
echo '# Short-Description: Oracle 11g Express Edition' >> $file
echo '### END INIT INFO' >> $file
fi
update-rc.d oracle-xe defaults 80 01
#EOF

Save the file and close the editor. Now we have to provide the file with the appropriate execution privileges.

sudo chmod 755 /sbin/chkconfig

After this, we have to create the file /etc/sysctl.d/60-oracle.conf to set the additional kernel parameters. Open the file by executing the following statement.

sudo gedit /etc/sysctl.d/60-oracle.conf

Copy and paste the following into the file. Kernel.shmmax is the maximum possible value of physical RAM in bytes. 536870912 / 1024 /1024 = 512 MB.

# Oracle 11g XE kernel parameters 
fs.file-max=6815744 
net.ipv4.ip_local_port_range=9000 65000 
kernel.sem=250 32000 100 128
kernel.shmmax=536870912

Save the file. The changes in this file may be verified by executing:

sudo cat /etc/sysctl.d/60-oracle.conf

Load the kernel parameters:

sudo service procps start

The changes may be verified again by executing:

sudo sysctl -q fs.file-max

This method should return the following:

fs.file-max = 6815744

After this, execute the following statements to make some more required changes:

sudo ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener

Close the second terminal window and return to the first terminal window.

sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb

NOTE THE PASSWORD YOU WOULD SPECIFY HERE FOR YOUR DATABASE. YOU WOULD BEED THAT TO CONNECT WHILE ACCESSING DATABASE FROM SQL DEVELOPER !

Execute the following to avoid getting a ORA-00845: MEMORY_TARGET error. Note: replace “size=4096m” with the size of your machine’s RAM in MBs.

sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=4096m /dev/shm

Create the file /etc/rc2.d/S01shm_load.

sudo gedit /etc/rc2.d/S01shm_load

Copy and paste the following in the file. Note: replace “size=4096m” with the size of your machine’s RAM in MBs.

#!/bin/sh
case "$1" in
start) mkdir /var/lock/subsys 2>/dev/null
touch /var/lock/subsys/listener
rm /dev/shm 2>/dev/null
mkdir /dev/shm 2>/dev/null
mount -t tmpfs shmfs -o size=4096m /dev/shm ;;
*) echo error
exit 1 ;;
esac

Save the file, close the editor and provide the appropriate execution privileges.

sudo chmod 755 /etc/rc2.d/S01shm_load


Configuring Oracle 11g R2 Express Edition

If you have successfully installed to Oracle 11g R2 Express Edition server, it’s time to configure the server. Default values are shown between brackets for each question.

sudo /etc/init.d/oracle-xe configure


Now it is time to set-up some environmental variables. Open the /etc/bash.bashrc file by executing the following statement:

sudo gedit /etc/bash.bashrc

Scroll to the bottom of the file and add the following lines.

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

Save the file and close the editor. To load the changes, execute the following statement:

source /etc/bash.bashrc

To validate the changes you can execute the following statement.

echo $ORACLE_HOME

This statement should result in the following output.

/u01/app/oracle/product/11.2.0/xe

After this step it is recommended to reboot the machine. After the reboot is completed, you should be able to start the Oracle server using the following command:

sudo service oracle-xe start

A file named oraclexe-gettingstarted.desktop is placed on your desktop. To make this file executable, navigate to you desktop.

cd ~/Desktop

To make the file executable, execute the following statement.

sudo chmod a+x oraclexe-gettingstarted.desktop


Now, you got your Oracle 11g Database installed in Ubuntu 16.04 with its Desktop icon also.

Next step is to open Oracle SQL Developer and connect it to Database using specified password (set during database installation).

Hope you would have understood the steps. Feel free to contact in case of any issue!
Happy Learning :-)  

Tuesday 29 May 2018

Configure, Build and Install Linux Kernel for Ubuntu 16.04

Hello Everyone
I am here again with another interesting topic for technology enthusiastic community. From where exactly we can configure our Linux kernel as per our need, How to build our custom kernel once configuration is over and how to install our new kernel so that our Ubuntu uses new configured kernel.


Procedure:

Step 1: Getting the dependencies:
abhi@vb:~$ sudo apt install install git build-essential kernel-package fakeroot 
libncurses5-dev libssl-dev ccache git bison flex libelf-dev libncursesw5-dev 

Step 2: Update the existing system:
abhi@vb:~$ sudo apt update
abhi@vb:~$ sudo apt upgrade
abhi@vb:~$ sudo apt dist-upgrade


Step 3: Getting the Kernel Source
abhi@vb:~$ uname -r
4.4.0-124-generic

abhi@vb:~$ mkdir kernelbuild
abhi@vb:~$ cd kernelbuild/
abhi@vb:~$ git clone -b linux-4.11.y git://git.kernel.org/pub/scm/linux/kernel/git/stable/linux-stable.git
abhi@vb:~$ cd linux-stable/
abhi@vb:~$ cp /boot/config-`uname -r` .config
abhi@vb:~$ yes '' | make oldconfig
abhi@vb:~$ make menuconfig



You can configure your kernel as per requirement, where you can add some features, select a particilar driver and remove few features, as needed. Select the option that you want and hit the Space bar. The Space bar cycles between “M,” “*,” and empty. “M” signifies that the feature will be built as a module that will be loaded if needed when Ubuntu starts. “*” means that the feature will be built into the kernel and always loaded. The script does not include blank options in the final product.

When you’re done setting things up, clean the directory.
abhi@vb:~/kernelbuild/linux-stable$ make clean

Now your kernel is ready to build.

Step 4: Building Kernel Packages

abhi@vb:~/kernelbuild/linux-stable$ make -j `getconf _NPROCESSORS_ONLN` deb-pkg LOCALVERSION=-custom

All that line does is compile the kernel into .deb packages using the amount of CPU cores on your system plus one. It also adds on “custom” to the end of the package version to differentiate your custom kernel from others.
It takes 4-5 Hours to compile kernel on Core i3 processor with 8 GB RAM.

Step 5: Installing the Kernel
You’ll find your new kernel packages one directory up. They’ll be easily identifiable by their version number. You can use “dpkg” to install them.

abhi@vb:~/kernelbuild/linux-stable$ cd ..
abhi@vb:~/kernelbuild$ sudo dpkg -i linux-firmware-image-4.11.12-custom_4.11.12-custom-1_amd64.deb
abhi@vb:~/kernelbuild$ sudo dpkg -i linux-libc-dev_4.11.1-custom-1_amd64.deb
abhi@vb:~/kernelbuild$ sudo dpkg -i linux-headers-4.11.1-custom_4.11.1-custom-1_amd64.deb
abhi@vb:~/kernelbuild$ sudo dpkg -i linux-image-4.11.1-custom-dbg_4.11.1-custom-1_amd64.deb
abhi@vb:~/kernelbuild$ sudo dpkg -i linux-image-4.11.1-custom_4.11.1-custom-1_amd64.deb


When the installation finishes, restart your computer. Ubuntu will automatically boot into your new kernel. You can double-check that it did by runing “uname -r” in a terminal when it starts up. If you see your version, congratulations! You’re running your own custom kernel.

abhi@vb:~$ uname -r
4.11.12-custom

Hope you enjoyed updating your kernel and learnt lot in this process.
Happy learning!

Thursday 10 May 2018

10 steps to install WordPress with LAMP stack on Ubuntu 16.04.



Hi everyone,

Lets try to host Wordpress on our Ubuntu 16.04 using LAMP stack. For these steps, I have referred the following website. Since I have found few issues while trying to establish my wordpress server so tried to recreate one single and ready-to-follow post for your reference based upon my experience. This is tried and tested process which you can follow directly. Here I am using latest Ubuntu 16.04 with all packages updated as on dated 9/05/18.

Source: https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-with-lamp-on-ubuntu-16-04

Step 1: Install Apache and Allow in Firewall

To remove apache2

server@ubuntu:/home/abhi$ sudo apt-get purge apache2 
server@ubuntu:/home/abhi$ sudo apt-get update

To reinstall

server@ubuntu:/home/abhi$ sudo apt-get install apache2

Set Global ServerName to Suppress Syntax Warnings

Add a single line to the /etc/apache2/apache2.conf file at the end to suppress a warning message: “ServerName 192.168.43.43”
While harmless, if you do not set ServerName globally, you will receive the following warning when checking your Apache configuration for syntax errors:

server@ubuntu:/home/abhi$ sudo apache2ctl configtest

Output 
AH00558: apache2: Could not reliably determine the server's fully
qualified domain name, using 127.0.1.1. Set the 'ServerName'  directive globally to suppress this message Syntax OK At the bottom of the file, add a ServerName directive, pointing  to your primary domain name or IP address.

Next, check for syntax errors by typing:

server@ubuntu:/home/abhi$ sudo apache2ctl configtest 

[sudo] password for server: 
 Syntax OK

Since we added the global ServerName directive, all you should see is:
Syntax OK

Restart Apache to implement your changes:

server@ubuntu:/home/abhi$ sudo service apache2 restart


Adjust the Firewall to Allow Web Traffic

Next, assuming that you have followed the initial server setup instructions to enable the UFW firewall, make sure that your firewall allows HTTP and HTTPS traffic

server@ubuntu:/home/abhi$ sudo ufw app list

Available applications:
Apache
Apache Full
Apache Secure
CUPS

If you look at the Apache Full profile, it should show that it enables traffic to ports 80 and 443:

server@ubuntu:/home/abhi$ sudo ufw app info "Apache Full" 

Profile: Apache Full 
Title: Web Server (HTTP,HTTPS) 
Description: Apache v2 is the next generation of the omnipresent Apache web server. 

Ports: 80,443/tcp

Allow incoming traffic for this profile:

server@ubuntu:/home/abhi$ sudo ufw allow in "Apache Full"

You can do a spot check right away to verify that everything went as planned by visiting your server's public IP address in your web browser 

  http://192.168.43.43 (use your own IP address here)
You will see the default Ubuntu 16.04 Apache web page, which is there for informational and testing purposes. It should look something like this:

                                      

If you see this page, then your web server is now correctly installed and accessible through your firewall.

Step 2: Install MySQL

Now that we have our web server up and running, it is time to install MySQL. MySQL is a database management system. Basically, it will organize and provide access to databases where our site can store information.

server@ubuntu:/home/abhi$ sudo apt-get install mysql-server

During the installation, your server will ask you to select and confirm a password for the MySQL "root" user. This is an administrative account in MySQL that has increased privileges. Think of it as being similar to the root account for the server itself (the one you are configuring now is a MySQL-specific account, however). Make sure this is a strong, unique password, and do not leave it blank.

When the installation is complete, we want to run a simple security script that will remove some dangerous defaults and lock down access to our database system a little bit. Start the interactive script by running:

server@ubuntu:/home/abhi$ mysql_secure_installation

You will be asked to enter the password you set for the MySQL root account. Next, you will be asked if you want to configure the VALIDATE PASSWORD PLUGIN.
Answer y for yes, or anything else to continue without enabling.

If you enabled password validation, you'll be shown a password strength for the existing root password, and asked you if you want to change that password. If you are happy with your current password, enter n for "no" at the prompt:

For the rest of the questions, you should press Y and hit the Enter key at each prompt. This will remove some anonymous users and the test database, disable remote root logins, and load these new rules so that MySQL immediately respects the changes we have made.
At this point, your database system is now set up and we can move on.

Step 3: Install PHP

PHP is the component of our setup that will process code to display dynamic content. It can run scripts, connect to our MySQL databases to get information, and hand the processed content over to our web server to display.

We're going to include some helper packages as well, so that PHP code can run under the Apache server and talk to our MySQL database:

server@ubuntu:/home/abhi$ sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql

In most cases, we'll want to modify the way that Apache serves files when a directory is requested. Currently, if a user requests a directory from the server, Apache will first look for a file called index.html. We want to tell our web server to prefer PHP files, so we'll make Apache look for an index.ph file first.

                                

To do this, type this command to open the dir.conf file in a text editor with root privileges:

server@ubuntu:/home/abhi$ sudo nano /etc/apache2/mods-enabled/dir.conf 

<IfModule mod_dir.c> 
 DirectoryIndex index.html index.cgi index.pl index.php index.xhtml index.htm
</IfModule>

# vim: syntax=apache ts=4 sw=4 sts=4 sr noet

We want to move the PHP index file highlighted above to the first position after the Directory Index specification, like this:

<IfModule mod_dir.c>
DirectoryIndex index.php index.html index.cgi index.pl index.xhtml inde$
</IfModule>

# vim: syntax=apache ts=4 sw=4 sts=4 sr noet

When you are finished, save and close the file

After this, we need to restart the Apache web server in order for our changes to be recognized. You can do this by typing this:

server@ubuntu:/home/abhi$ sudo service apache2 restart
server@ubuntu:/home/abhi$ sudo service apache2 status 
apache2.service - LSB: Apache2 web server
   Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Thu 2018-05-10 13:54:48 IST; 1h 27min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 1128 ExecStart=/etc/init.d/apache2 start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/apache2.service
           ├─1220 /usr/sbin/apache2 -k start
           ├─1224 /usr/sbin/apache2 -k start
           ├─1225 /usr/sbin/apache2 -k start
           ├─1226 /usr/sbin/apache2 -k start
           ├─1227 /usr/sbin/apache2 -k start
           └─1228 /usr/sbin/apache2 -k start

May 10 13:54:46 ubuntu systemd[1]: Starting LSB: Apache2 web server...
May 10 13:54:46 ubuntu apache2[1128]:  * Starting Apache httpd web server apache2
May 10 13:54:48 ubuntu apache2[1128]:  *
May 10 13:54:48 ubuntu systemd[1]: Started LSB: Apache2 web server.

If we decided that php-cli is something that we need, we could type:

server@ubuntu:/home/abhi$ sudo apt-get install php-cli

Step 4: Test PHP Processing on your Web Server

In order to test that our system is configured properly for PHP, we can create a very basic PHP script.

We will call this script info.php. In order for Apache to find the file and serve it correctly, it must be saved to a very specific directory, which is called the "web root".
In Ubuntu 16.04, this directory is located at /var/www/html/. We can create the file at that location by typing:

server@ubuntu:/home/abhi$ sudo nano /var/www/html/info.php

This will open a blank file. We want to put the following text, which is valid PHP code, inside the file:

<?php 
phpinfo(); 
?>
When you are finished, save and close the file.

Now we can test whether our web server can correctly display content generated by a PHP script. To try this out, we just have to visit this page in our web browser.

The address you want to visit will be:
http://192.168.43.43/info.php   (Use your own IP address)

                           


This page basically gives you information about your server from the perspective of PHP. It is useful for debugging and to ensure that your settings are being applied correctly.
If this was successful, then your PHP is working as expected.

Step 5: Create a MySQL Database and User for WordPress

WordPress uses MySQL to manage and store site and user information. We have MySQL installed already, but we need to make a database and a user for WordPress to use.
To get started, log into the MySQL root (administrative) account by issuing this command:

server@ubuntu:/home/abhi$ mysql -u root -p

You will be prompted for the password you set for the MySQL root account when you installed the software.

First, we can create a separate database that WordPress can control. You can call this whatever you would like, but we will be using “wordpressdatabase” in this guide to keep it simple. You can create the database for WordPress by typing:

mysql > CREATE DATABASE wordpressdatabase DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Next, we are going to create a separate MySQL user account that we will use exclusively to operate on our new database. Creating one-function databases and accounts is a good idea from a management and security standpoint. We will use the name wordpressuser in this guide. Feel free to change this if you'd like.

We are going to create this account, set a password, and grant access to the database we created. We can do this by typing the following command. Remember to choose a strong password here for your database user:

mysql > GRANT ALL ON wordpressdatabase.* TO 'wordpressuser'@'localhost' IDENTIFIED BY 'password'; (Use strong password here)

You now have a database and user account, each made specifically for WordPress. We need to flush the privileges so that the current instance of MySQL knows about the recent changes we've made:

mysql > FLUSH PRIVILEGES;

Exit out of MySQL by typing:

mysql > EXIT;


Step 6: Install Additional PHP Extensions

When setting up our LAMP stack, we only required a very minimal set of extensions in order to get PHP to communicate with MySQL. WordPress and many of its plugins leverage additional PHP extensions.

We can download and install some of the most popular PHP extensions for use with WordPress by typing:

server@ubuntu:/home/abhi$ sudo apt-get update 
server@ubuntu:/home/abhi$ sudo apt-get install php-curl php-gd php-mbstring php-mcrypt php-xml php-xmlrpc

We will restart Apache to leverage these new extensions in the next section. If you are returning here to install additional plugins, you can restart Apache now by typing:

server@ubuntu:/home/abhi$ sudo service apache2 restart

Step 7: Adjust Apache's Configuration to Allow for .htaccess Overrides and Rewrites

Next, we will be making a few minor adjustments to our Apache configuration. Currently, the use of .htaccess files is disabled. WordPress and many WordPress plugins use these files extensively for in-directory tweaks to the web server's behavior.

Additionally, we will enable mod_rewrite, which will be needed in order to get WordPress permalinks to function correctly. 

Enable .htaccess Overrides

Open the primary Apache configuration file to make our first change:

server@ubuntu:/home/abhi$ sudo nano /etc/apache2/apache2.conf

To allow .htaccess files, we need to set the AllowOverride directive within a Directory block pointing to our document root. Find out the

<Directory /var/www/html> and make following changes “AllowOverride All”
. . .

<Directory /var/www/html/> 
                 AllowOverride All 
</Directory> 

. . .

When you are finished, save and close the file.
Enable the Rewrite Module

Next, we can enable mod_rewrite so that we can utilize the WordPress permalink feature:

server@ubuntu:/home/abhi$ sudo a2enmod rewrite

Enable the Changes

Before we implement the changes we've made, check to make sure we haven't made any syntax errors:

server@ubuntu:/home/abhi$ sudo apache2ctl configtest

Restart Apache to implement the changes:

server@ubuntu:/home/abhi$ sudo service apache2 restart


Step 8: Download WordPress

Now that our server software is configured, we can download and set up WordPress. For security reasons in particular, it is always recommended to get the latest version of WordPress from their site.

Change into a writable directory and then download the compressed release by typing:

server@ubuntu:/home/abhi$ cd /tmp 
server@ubuntu:/home/abhi$ wget https://wordpress.org/latest.tar.gz

Extract the compressed file to create the WordPress directory structure:

server@ubuntu:/home/abhi$ tar -xzvf latest.tar.gz

We will be moving these files into our document root momentarily. Before we do, we can add a dummy .htaccess file and set its permissions so that this will be available for WordPress to use later.

Create the file and set the permissions by typing:

server@ubuntu:/home/abhi$ touch /tmp/wordpress/.htaccess server@ubuntu:/home/abhi$ chmod 660 /tmp/wordpress/.htaccess


We'll also copy over the sample configuration file to the filename that WordPress actually reads:

server@ubuntu:/home/abhi$ cp /tmp/wordpress/wp-config-sample.php /tmp/wordpress/wp-config.php


We can also create the upgrade directory, so that WordPress won't run into permissions issues when trying to do this on its own following an update to its software:

server@ubuntu:/home/abhi$ mkdir /tmp/wordpress/wp-content/upgrade
Now, we can copy the entire contents of the directory into our
document root. We are using the -a flag to make sure our
permissions are maintained. 

server@ubuntu:/home/abhi$ sudo cp -a /tmp/wordpress/. /var/www/html

Step 9: Configure the WordPress Directory

Before we do the web-based WordPress setup, we need to adjust some items in our WordPress directory.

Adjusting the Ownership and Permissions

One of the big things we need to accomplish is setting up reasonable file permissions and ownership. We need to be able to write to these files as a regular user, and we need the web server to also be able to access and adjust certain files and directories in order to function correctly.

We'll start by assigning ownership over all of the files in our document root to our username. We will use server as our username in this guide, but you should change this to match whatever your sudo user is called. We will assign group ownership to the www-data group:

server@ubuntu:/home/abhi$ sudo chown -R server:www-data /var/www/html

Next, we will set the setgid bit on each of the directories within the document root. This causes new files created within these directories to inherit the group of the parent directory (which we just set to www-data) instead of the creating user's primary group. This just makes sure that whenever we create a file in the directory on the command line, the web server will still have group ownership over it.

We can set the setgid bit on every directory in our WordPress installation by typing:

server@ubuntu:/home/abhi$ sudo find /var/www/html -type d -exec chmod g+s {} \;


There are a few other fine-grained permissions we'll adjust. First, we'll give group write access to the wp-content directory so that the web interface can make theme and plugin changes:

server@ubuntu:/home/abhi$ sudo chmod g+w /var/www/html/wp-content

As part of this process, we will give the web server write access to all of the content in these two directories:

server@ubuntu:/home/abhi$ sudo chmod -R g+w /var/www/html/wp-content/themes 
server@ubuntu:/home/abhi$ sudo chmod -R g+w /var/www/html/wp-content/plugins

This should be a reasonable permissions set to start with.
Setting up the WordPress Configuration File

Now, we need to make some changes to the main WordPress configuration file.

When we open the file, our first order of business will be to adjust some secret keys to provide some security for our installation. WordPress provides a secure generator for these values so that you do not have to try to come up with good values on your own. These are only used internally, so it won't hurt usability to have complex, secure values here.


To grab secure values from the WordPress secret key generator, type:

server@ubuntu:/home/abhi$ wget https://api.wordpress.org/secret-key/1.1/salt/

You will get back unique values that look something like this:

define('AUTH_KEY',  'nE.--7T`#b6:||P!=x@.rD4.dBx+95OlPH=Co;PAovNp2rK$-0H[.G|y0KlewD/Y');

define('SECURE_AUTH_KEY',  '+)[!da$)vYG.oC=m}q{A{z0~)_ -m]NyMT|!goYCoXDwA-Jvzk)Su@Cx-+i~X+.J');

define('LOGGED_IN_KEY',  'z//ZWYa@<9SYmMGvUPJ#-AACz2aD?ku2,F-jK<W+}|4BOT!Msg7(mN:%LQ9YUa-N');

define('NONCE_KEY', '>|r_Aiu5$W+5y#MD]EUc+]3$fbxw9^MaWSn7*#kxf6EJjIm#1#|A(D*$YAB+f4c');

define('AUTH_SALT', 'wn@FsGFY|:/8qFGkE,WOgaZ1|,.~4~-i@cW7zw!XKSXIy>.ib).VQ~W= C~PYu`2');

define('SECURE_AUTH_SALT',  '@xqXjA{+rpxUhD9}d RYe;4-L${Jaq-fFPgaKgx!Y-?_RB=BtSb!@7_Q*d7X=K|c');

define('LOGGED_IN_SALT', 'chYB7NysY]1:XDQ{c-/k:h0!<CzW#D`K=}!.0[U+bu Bv[{w|dT3_P]n,42z3RYg');
define('NONCE_SALT', '|X=)Rm:6&1Yq`sr7XeVOW)p#i8?]y--;@)W-+_qH:a2)[J*f7)U+sfMD++JyPi*V');

NOTE: It is important that you request unique values each time.
Do NOT copy the values shown below!


These are configuration lines that we can paste directly in our configuration file to set secure keys. Copy the output you received now.
Now, open the WordPress configuration file:

server@ubuntu:/home/abhi$ nano /var/www/html/wp-config.php

Find the section that contains the dummy values for those settings. Delete those lines and paste in the values you copied just now.

Next, we need to modify some of the database connection settings at the beginning of the file. You need to adjust the database name, the database user, and the associated password that we configured within MySQL.

The other change we need to make is to set the method that WordPress should use to write to the filesystem. Since we've given the web server permission to write where it needs to, we can explicitly set the filesystem method to "direct". Failure to set this with our current settings would result in WordPress prompting for FTP credentials when we perform some actions.

server@ubuntu:/home/abhi$ /var/www/html/wp-config.php

. . . 
define('DB_NAME', 'wordpressdatabase');           (Use your database name) 
/** MySQL database username */ 
define('DB_USER', 'wordpressuser');                   (Use your wordpress username) 
/** MySQL database password */ 
define('DB_PASSWORD', 'password');                (Use your wordpress password) 
. . . 

define('FS_METHOD', 'direct'); 
( Filesystem method as DIRECT for wordpress webserver to write  directly wherever it wants)

Save and close the file when you are finished.

Step 10: Complete the Installation Through the Web Interface

Now that the server configuration is complete, we can complete the installation through the web interface.

In your web browser, navigate to your server's domain name or public IP address:
http://192.168.43.43 (USE your own IP address here)

Select the language you would like to use:

                                  

Next, you will come to the main setup page.

Select a name for your WordPress site and choose a username (it is recommended not to choose something like "admin" for security purposes). Choose a strong password.

When you click ahead, you will be taken to a page that prompts you to log in:

Once you log in, you will be taken to the WordPress administration dashboard:

                            

Hope you have leaned lot following given steps and now hosting your wordpress based website on local serve run on Ubuntu 16.04

If you ever want to make your website global, you can do it using free "ngrok" service in Ubuntu 16.04.

Enjoy! Keep Learning :-)