How To Install the Apache Web Server on Ubuntu

Desktop installation Ubuntu 18.04 and Ubuntu 16.04

List running processes ordered by RAM usage

ps aux | awk '{print $2, $4, $11}' | sort -k2rn | head -n 20
covery.zen.ping.multicast.enabled: false
#install SSH service for root access
Sudo apt-get install ssh
Sudo apt-get install vim
Sudo vim /etc/ssh/sshd_config
Find PermitRootLogin without-password change to PermitRootLogin yes
Service ssh restart

#Install Flash Player

sudo apt-get install ubuntu-restricted-extras
sudo apt-get install flashplugin-installer //Package install Like
sudo apt-get install flashplugin-installer

#Install Ubuntu and Required Softwares

sudo apt-get install tasksel

in Tasksel select Lampp and openssh-server and sambha file
After install Lampp and Sambha server install phpmyadmin

#Install Spark Clients
Install Spark in Ubuntu
Step 1: Download Spark Zip File

wget http://download.igniterealtime.org/spark/spark_2_6_3.tar.gz

Step 2: Extract spark files

tar -zxvf spark_2_6_3.tar.gz

Step 3:create directory spark in opt path

sudo mkdir /opt/spark

Step 4: cp -rv Spark/* /opt/spark/

Step 5: cd /opt/spark/

Step 6:craete Desktop Icons

sudo vim /usr/share/applications/spark.desktop
[Desktop Entry]
Name=Spark
Version=2.7.4
GenericName=Spark
X-GNOME-FullName=Spark
Comment=ignite realtime Spark IM client
Type=Application
Categories=Application;Utility;
Path=/opt/spark
Exec=/bin/bash Spark
Terminal=false
StartupNotify=true
Icon=/opt/spark/spark.png
TargetEnvironment=Unity

Step 7: download Spark png files

sudo wget https://dl.dropbox.com/u/50880014/spark.png

Step 8: Install Library Files

sudo apt-get install libxtst6:i386 libxi6:i386

For spark file transfer issue please do this:-

Chown -R username:root /opt/spark
Chmod -R 755 /opt/spark

Then restart spark and it will done

#Setting For Apache
Allow Htaacess file in apache

sed -i 's/AllowOverride None/AllowOverride All/' /etc/apache2/apache2.conf
Alow All Html Folder
sed -i 's/denied/granted/' /etc/apache2/apache2.conf
Enable Rewrite Modules
a2enmod rewrite
Restart Apache
service apache2 restart

#Tar Ball Document
1)How to show content in tar ball by using this Command

Tar -tf tar.tar

2) How to Delete Particular File in Tar Ball

tar --delete -f crybit.tar file4.txt

#Install Vlc Media Player

sudo apt-get install vlc

install JDK

apt install default-jre

How to get serial Number from Laptop

wmic bios get serialnumber

Get mac address of a remote computer
netstat -a ip-address(IP Address)
getmac /v /fo list

URL:- how to import large DB

innodb_buffer_pool_size = 512M
innodb_log_buffer_size = 500M
innodb_log_file_size = 512M
innodb_write_io_threads = 8
innodb_flush_log_at_trx_commit = 0

For more info:- http://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster
System Performance Increasing steps
sudo vim /etc/sysctl.conf

Scroll to the bottom and just add these lines to it.

net.core.rmem_default = 524288
net.core.rmem_max = 524288
net.core.wmem_default = 524288
net.core.wmem_max = 524288
net.ipv4.tcp_wmem = 4096 87380 524288
net.ipv4.tcp_rmem = 4096 87380 524288
net.ipv4.tcp_mem = 524288 524288 524288
net.ipv4.tcp_rfc1337 = 1
net.ipv4.ip_no_pmtu_disc = 0
net.ipv4.tcp_sack = 1
net.ipv4.tcp_fack = 1
net.ipv4.tcp_window_scaling = 1
net.ipv4.tcp_timestamps = 1
net.ipv4.tcp_ecn = 0
net.ipv4.route.flush = 1

run the sysctl to take effect.

sudo sysctl -p
sudo vim /etc/default/grub &
sudo update-grub
And change GRUB_TIMEOUT=10 to GRUB_TIMEOUT=2.
sudo apt-get install preload
sudo add-apt-repository ppa:apt-fast/stable
sudo apt-get update
sudo apt-get install apt-fast
sudo vim /etc/apt/apt.conf.d/00aptitude
Acquire::Languages "none";

#System

#Install Sublime Text Editor

sudo add-apt-repository -y ppa:webupd8team/sublime-text-3

sudo apt-get update && sudo apt-get install -y sublime-text-installer

curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer

Install Apache open office

$ wget sourceforge.net/projects/openofficeorg.mirror/files/4.1.1/binaries/en-GB/Apache_OpenOffice_4.1.1_Linux_x86-64_install-deb_en-GB.tar.gz

$ tar -xzvf Apache_OpenOffice_4.1.1_Linux_x86-64_install-deb_en-GB.tar.gz

$ cd en-GB/DEBS

$ sudo dpkg -i *.deb

$ cd desktop-integration

$ sudo dpkg -i *.deb

Install Google-Chrome In Linux

wget -q -O - https://dl-ssl.google.com/linux/linux_signing_key.pub | sudo apt-key add -

sudo sh -c 'echo "deb http://dl.google.com/linux/chrome/deb/ stable main" >> /etc/apt/sources.list.d/google-chrome.list'

sudo apt-get update

sudo apt-get install google-chrome-stable
getmac /s system /u username /p password

Install Notepad+ In Ubuntu

sudo add-apt-repository ppa:notepadqq-team/notepadqq
sudo apt-get update
sudo apt-get install notepadqq

Install ionCube in Linux

cd /usr/local/src
wget http://downloads3.ioncube.com/loader_downloads/ioncube_loaders_lin_x86-64.tar.gz
tar zxvf ioncube_loaders_lin_x86-64.tar.gz
cd ioncube
mkdir /usr/local/ioncube
cp ioncube_loader_lin_5.5.so /usr/local/ioncube
echo “zend_extension = /usr/local/ioncube/ioncube_loader_lin_5.5.so”
service apache2 restart

sudo add-apt-repository ppa:klaus-vormweg/bluefish
sudo add-apt-repository ppa:klaus-vormweg/bluefish-gtk2

Install SmartGIT

sudo add-apt-repository ppa:eugenesan/ppa

sudo apt-get update

sudo apt-get install smartgit

Libra office

sudo add-apt-repository ppa:libreoffice/ppa
sudo apt-get update
sudo apt-get install libreoffice
wget http://download.documentfoundation.org/libreoffice/stable/5.0.0/deb/x86_64/LibreOffice_5.0.0_Linux_x86-64_deb.tar.gz
tar xvf LibreOffice_5.0.0_Linux_x86-64_deb.tar.gz
sudo dpkg -i DEBS/*.deb

Sql Group By Command is not Working
If you want to disable permanently error sql_mode=only_full_group_by do those steps:
sudo nano /etc/mysql/my.cnf
Add this to the end of the file
[mysqld] sql_mode = “STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
sudo service mysql restart
This will disable ONLY_FULL_GROUP_BY for ALL users
Install Apache open-Office
tar -xvzf Apache_OpenOffice_incubating_3.4.0_Linux_x86_install-deb_en-US.tar.gz
● The Extracted directory will be named after the Language you selected to download like
● en-US
● Navigate into DEBS folder
● Install the .deb files by typing
● sudo dpkg -i *.deb
By default, this will install Apache OpenOffice in your /opt directory.
For installing the desktop integration features for your setup navigate to desktop-integration in the DEBS installation directory and do
sudo dpkg -i *.deb
NOTE Be careful ppa:upubuntu-com/office refers to older version of open office.

Thank You