Install LAMP on Centos 7

rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
yum -y install epel-release
yum -y install mariadb-server mariadb
systemctl start mariadb.service
systemctl enable mariadb.service

yum -y install httpd
systemctl start httpd.service
systemctl enable httpd.service
firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
firewall-cmd --reload
yum -y install php
systemctl restart httpd.service
yum search php
yum -y install php-mysql
yum -y install php-gd php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-snmp php-soap curl curl-devel
systemctl restart httpd.service
yum -y install phpMyAdmin

configure phpMyAdmin. add code :
vi /etc/httpd/conf.d/phpMyAdmin.conf

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
AddDefaultCharset UTF-8

<IfModule mod_authz_core.c>
# Apache 2.4
#Require ip
#Require ip ::1
Require all granted
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from
Allow from ::1

<Directory /usr/share/phpMyAdmin/>
Options none
AllowOverride Limit
Require all granted


change the authentication in phpMyAdmin from cookie to http:

vi /etc/phpMyAdmin/

$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?

Restart Apache:
systemctl restart httpd.service

Using Tmux (Terminal Multiplexer) to Keep SSH Sessions Running

Tmux is another software which is created to be a replacement for screen. It has most of the capabilities of screen, with few additional capabilities which make it more powerful than screen.

Install tmux

yum -y install tmux

Start a Tmux Session

$ tmux

After performing your operations on the terminal, you can detach that session from the controlling terminal so that it goes into background and you can safely logout.

Detach Tmux Session from Terminal

use the shortcut (Ctrl+b then d)
After this your current session will be detached and you will come back to your terminal from where you can log out safely.

Resuming the Closed Tmux Session

tmux attach


Install VNC on Centos ^

install dekstop
yum -y groupinstall Desktop

install VNC server
yum -y install tigervnc-server

install font
yum -y install xorg-x11-fonts-Type1

chkconfig vncserver on

Set Password

Setting VNC Server
vi /etc/sysconfig/vncservers

VNCSERVERARGS[1]="-geometry 1024x600"

Restart VNC
service vncserver restart

edit file start up
vncserver -kill :1
vi .vnc/xstartup

#twm &
exec gnome-session &

Restart VNC
service vncserver start
service vncserver restart


yum -y groupinstall Desktop
yum -y install tigervnc-server
yum -y install xorg-x11-fonts-Type1
chkconfig vncserver on

MS Excel: Compare two columns and delete duplicates from just ONE column

I have column A that is 1,500 records.
I have column B with 40,000 records.

Among the 40,000 records in column B, duplicates of ALL 1,500 records from column A exist.
How do I find WHERE the 1,500 dupes are and how can I delete JUST those records?

In Column-C use something like this (adjusted for your actual ranges):


Note the use absolute references for the column-A.

Which will return either TRUE or #N/A. Extend the formula down column-C for as many rows as usedin column-B.

Next, use Advanced Filter with criteria and the option to copy the non-matching entries to another location.

Make sure column-C has a header say, “Match” (w/o quotes)

For the AF criteria cell use: ="<>TRUE"

Google Drive Linux Client using GDrive

Installing GDrive – Google Drive Linux Client

Simply download the latest version from their github page HERE

For my Centos 6 server I used this one : drive-linux-x64 v1.9.0

(right click and copy link url then paste into wget below)

wget -O /usr/local/bin/gdrive “paste url here”

I copied the file into /usr/local/bin so it is globally available to all users on my server, and I also renamed it to gdrive juat as I thought that would be easier to remember !! Dont forget to make the file executable (chmod +x /usr/local/bin/gdrive) and thats it !!!

When you first run any gdrive command it will prompt you to link it to your google drive account and give it permissions.
The program will then return with a url you need to link it to your account. Here is how I did it :
1) Open Chrome (or any browser) and log in to the Google account you want to link gdrive with
2) Make sure you can see in your apps Google Drive appearing (the menu in the top right is normally where it appears
3) Paste in the url from the output of the ‘gdrive list’ you did earlier, and accept the permissions prompt it needs to enable gdrive to upload and download files.

Uploading a file – Google Drive Linux Client
gdrive upload -r /var/www/html

Downloading a file from Google Drive Linux Client with GDrive
gdrive list
Id Title Size Created
0B0tRrdcY7CwJZHh5ZmVpZHRMYW8 drive-linux-amd64 10 MB 2014-09-25 17:47:08
0B0tRrdcY7CwJY2lNS2x3NC1lQUU drive-linux-386 8 MB 2014-09-25 17:47:01
0B0tRrdcY7CwJR3lmZnlRaFZwOHc drive-linux-arm 9 MB 2014-09-25 17:46:57
0B0tRrdcY7CwJQlRfQUVxY2hkWUE drive-linux-rpi 9 MB 2014-09-25 17:46:52

gdrive download -i 0B0tRrdcY7CwJZHh5ZmVpZHRMYW8

Instalasi Webuzo

Anggaplah sudah ada ip, user sama pass VPS

Login dengan putty atau bitvise

Instal wget jika belum terinstall yum install wget -y
install nano yum install nano -y
Download Webuzo installer wget -N
Ubah permission chmod 0755
Jalankan installer Webuzo ./
Tunggu hingga proses instal Webuzo rampung

————————————————————-lanjut di broswer

Selesaikan proses instalasi dengan membuka via browser http://x.x.x.x:2004 dimana x.x.x.x adalah IP dari server anda (cek dan perhatikan output setelah selesai tahap nomor 5)
Setelah terbuka di browser anda akan mendapati Webuzo initial setup. Silahkan isikan dengan data yg benar dan valid. Pada primary domain isikan dg IP VPS ANDA, Pada isian Nameserver 1 dan 2 isikan NS sembarang saja, kalau saya isinya dan kalau ramnode NS1.RAMNODE.COM NS2.RAMNODE.COM sesuaikan saja. sebenarnya tidak pengaruh karena kita ngk gunain domain diawal ini. License key kosongkan saja karena kita akan memakai free license

Mudah sekali kan? Next, silahkan klik tombol “Install” dan tunggu beberapa menit hingga muncul “Installation completed successfully”
Loginlah via browser http://x.x.x.x:2004
Arahkan kursor ke Setting > General > Centang pilihan bahwa server yg digunakan adalah VPS
Selanjutnya klik tombol “Edit Settings” untuk menyimpannya (paling bawah)
Bukalah Enduser panel lewat browser http://x.x.x.x:2002. Dari panel tsb nanti anda bisa menambahkan domain, edit DNS zone, membuat database, setting email, instal aplikasi dan script (auto), dan lain2. Namun ikuti dulu tahapan berikutnya dibawah ini bagi yang mau mindahin ke nginx dan install wordpress.


Login kedalam Webuzo panel http://x.x.x.x:2002
Kita akan instal WordPress via console, mari login ke server dg Putty atau bitvise
Masuklah ke direktori domain dimana anda ingin instal WordPress. cd /home/kampret/public_html/xxxx dimana kampret adalah username Webuzo yg sudah dibuat pada proses instal dan xxxx adalah addon domain atau domain2 lain yg anda tambahkan kemudian
Download script wordpress wget
Ekstrak file tsb unzip
Pindahkan semua isi file wordpress ke direktori root domain cp -rf ./wordpress/* .
Copy file sample konfigurasi wordpress cp wp-config-sample.php wp-config.php
Kembali ke Webuzo dan buatlah sebuah database untuk instalasi wordpress
Buatlah user utk database tsb dan tambahkan user ke database wordpress yg sudah dibuat. Jangan lupa catat passwordnya karena nanti akan ditambahkan pada file wp-config.php
Beri all privileges kepada user
Kembali ke console (langkah nomor 7) dan editlah file tsb vim wp-config.php
Tambahkan nama database, user database dan passwordnya kedalam file tsb lalu save
Lanjutkan instalasi WordPress dg membuka pada browser http://xxxx dimana xxxx adalah domain yg sudah terpasang di server yg ingin diinstali blog dg platform wordpress. Ikuti instruksi yg ada pada halaman instal tsb dan selesai.
Agar tidak terjadi error pada permalinks (404 not found) maka ubah ownership domain beserta isinya menurut username Webuzo, contoh chown -R kampret:kampret /home/kampret/public_html/xxxx atau jika pada primary domain chown -R kampret:kampret /home/kampret/public_html/xxxx (kampret adalah username)
Sekarang blog wordress anda sudah up dan siap digunakan utk blogging, mengeruk dollar, dll.  Login dulu ke dashboard wp untuk kustomisasi blog anda (ganti theme, instal plugin, dll) di http://xxxx/wp-admin (xxxx = domain anda)


Bagi yang mau mengganti APACE di webuzo ke NGINX atau bagi yang mengalami 500 Internal Server Error

Login ke panel http://x.x.x.x:2002
Instal NGINX dan centang set as default (enduser panel -> APPS -> Web Servers)
Buang Apache: yum remove httpd -y
Agar tidak 404 not found, lanjutkan

Loginlah sebagai root ke ssh server anda kemudian buka mantra berikut ini:

nano /usr/local/apps/nginx/etc/conf.d/common

Setelah terbuka, tambahkan  baris ini:

location / {try_files $uri $uri/ /index.php?q=$request_uri&$args;}

menyimpannya ctrl+x kemudian tekan y dan ENTER

Simpan kembali lalu restart NGINX webserver:service nginx restart


-untuk merestart dan melihat service apa saja yang berjalan di webuzo anda bisa ke end user di webuzo dan cari service. dari sini anda bisa menghentikan/menjalankan atau merestart service : nginx, apace, php, dan lain-lain.

-untuk melihat password phpMyAdmin pada terminal putty atau bitvise ketikan perintah

nano /var/webuzo/my.conf

jika perintah nano tidak bekerja

yum install nano

catet atau copy passwordnya dan login ke phpMyAdmin dengan user root dan pass yang disimpan tadi.

sumber: diedit dikit dari ari-f*com untuk penyesuainan pengguna AGC..

-Salam Persekongkolan-