MySQL Root Access

Step 1
Shut down Mysql. Try
sudo service mysql stop
or
sudo /etc/init.d/mysql stop
or looking up the PID and killing it. Make sure it's stopped via:
service mysql status

TODO LIST for VestaCP Fresh Installastion

Beberapa kali install ulang vestaCP ada aja yang kelupaan....
Baik itu konfigurasi mysql, phpmyadmin, PHP version dlll.
So biar ga lup nih TODO nya :

CHMOD ...

Jadi gini bro....

Sistem aplikasi penjualan mo ane UP, dipakai untuk multi site. Kebayang kan, kalo ada 10 domain harus upload di masing2 public_html nya? 

Anggaplah besarnya 200mb, kali 10 jadi 2 GB. Weeew....

Sooo, ane oprek dikit deh biar bisa di pake bareng, alias share.

Di vesta harus bikin template share nya dlu. Bisa aja sih langsung edit di template yang udah ada. tapi daripada oprek yang ori mending kopi trus modif.

VestaCP File Backup upload automatically to google Drive

Vesta Control Panel biasanya diinstall di VPS, atau server fisik. Salah satu fasilitas yang ane anggap ciamik, dia punya feature auto backup ke local disk.
Ga cuma backup file web aja, tapi juga DNS Zone, Email akun beserta isinya, database, user right(Privilage), sampai ke log nya.

Vesta Control Panel Multi PHP Version

VestaCP - MultiPHP

Mo posting ini ga sempet mulu masbro, , ,
Beberapa kali lupa terus kalo abis insttal VESTACP.
Kadang ada beberapa project yang butuh versi PHP berbeda, waktu dulu nyari caranya gimana pakai Multi PHP di masing2 domain(web) cuma ada tutor buat Centos, server kita kan Ubuntu
(Uuuuuu, BUNTU)....

Change Exim4 Port 25 to xxxx on VestCP

Masbroooo.......

Salah satu server kita kena blacklist google dan blacklist lainnya, otomatis ngirim email jadi ga bisa pake ip vps yang ntu.

Ujung2nya vps di suspend karna dianggap mengirimkan spam. Diaktifin lagi tapi port 25 ditutup.

Ngubek2 exim config standar sih gampang, tapi ternyata di vestacp file konfigurasi di masing masing domain.

Alih2 sambil nunggu proses whitelist dan mencegah supaya ga di jadiin spam server ane ganti dah port SMTP nya.

masuk ke direktori /etc/exim4
standar nya file config exim4 ada di /etc/exim4/exim4.conf, ternya  kalo di ls isinya beginian.

dah ane coba bikin file exim4.conf, restart service, ampe restart server tetep masih jalan di port 25.
Alhasil ane ubek2 dah tuh semua file satu2 eh akhirnya ketemu juga, ternyata ada di "exim4.conf.template"
Kalo dilihat pake nano ini isinya :

Noh ada disono, ane ganti jadi port 5xxxxx, simpan terus restart service...(sekarang ga perlu restart server). Check port yg jalan "$netstat -tulnp"

Trus ane tes lagi coba kirim email lewat console (padahal udah di blacklist, tapi karna penasaran ya ane coba aja)...... 

dan hahahahahhahahhahahah nih hasil nya...

root@/home# exim -v disketsa@gmail.com

LOG: MAIN

  Warning: purging the environment.

 Suggested action: use keep_environment.

Subject : Testing exim

LOG: MAIN

  bla bla bla

LOG: MAIN

  bla blabla

LOG: MAIN

  bla blaa

Connecting to gmail-smtp-in.l.google.com [74.125.28.26]:25 ... connected

  SMTP<< 220 mx.google.com ESMTP r195si11456261pgr.210 - gsmtp

  SMTP>> EHLO xx.xxxxxxxx.xxxx

  SMTP<< 250-mx.google.com at your service, [104.129.5.203]

         250-SIZE 157286400

         250-8BITMIME

         250-STARTTLS

         250-ENHANCEDSTATUSCODES

         250-PIPELINING

         250-CHUNKING

         250 SMTPUTF8

  SMTP>> STARTTLS

  SMTP<< 220 2.0.0 Ready to start TLS

  SMTP>> EHLO xxx.xxxxxxx.com

  SMTP<< 250-mx.google.com at your service, [104.129.5.203]

         250-SIZE 157286400

         250-8BITMIME

         250-ENHANCEDSTATUSCODES

         250-PIPELINING

         250-CHUNKING

         250 SMTPUTF8

  SMTP>> MAIL FROM:<xxx@xxx.xxxxxxx.com> SIZE=1343

  SMTP>> RCPT TO:<disketsa@gmail.com>

  SMTP>> DATA

  SMTP<< 250 2.1.0 OK r195si11456261pgr.210 - gsmtp

  SMTP<< 250 2.1.5 OK r195si11456261pgr.210 - gsmtp

  SMTP<< 354  Go ahead r195si11456261pgr.210 - gsmtp

  SMTP>> writing message and terminating "."

PDKIM>>Hashed body data, canonicalized >>>>>>>>>>>>>>>>>>>>>>>>>>>>>

bla bla bla and bla <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

 c8afb89c4aa15c0561d140f852e347ea2f74a650757f77a33c957cc

  SMTP<< 550-5.7.1 [104.129.5.203       1] Our system has detected an unusual rate of

         550-5.7.1 unsolicited mail originating from your IP address. To protect our

         550-5.7.1 users from spam, mail sent from your IP address has been blocked.

         550-5.7.1 Please visit

         550-5.7.1  https://support.google.com/mail/?p=UnsolicitedIPError to review our

         550 5.7.1 Bulk Email Senders Guidelines. r195si11456261pgr.210 - gsmtp

  SMTP>> QUIT

Rapopo lah, toh kita make server mail canggih.................

PHPMyAdmin Connection for controluser as defined in your configuration failed

Udah anteng abis reinstall vps kita yg di server 4 eh ternyata pas nyoba buka phpmyadmin muncul error :

Connection for controluser as defined in your configuration failed

Cari solusi sana sini dapet di forum tetep aja ga bisa. Ternyata masalah instalasi di mysql & phpmyadmin ga tuntas. Jadi gada tabel phpmyadmin buat kontrol user sama akses database, view dan lain lain.

n ternyata sodara2 setelah 3 hari nyoba perbaiki tanpa hasil, secara ga sengaja dapet link buat fix ini bug. Just One step ... WTF....

Fixes for phpmyadmin (configuration storage and some extended features)

If you're tired of the message "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated", this patch for you ;-)

Installation:
Universal installer with OS Checker

CODE: 

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh

or

CODE: 

sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh

OS Installation:
Ubuntu

CODE: 

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh

or

CODE: 

sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && chmod +x pma-ubuntu.sh && ./pma-ubuntu.sh

Debian

CODE: 

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh

or

CODE: 

wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh && chmod +x pma-debian.sh && ./pma-debian.sh

CentOS

CODE: 

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

or

CODE: 

wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

What the script does:
- we don't use pwgen for generation password anymore, no extra utilities;
- check wget/curl before downloading dump for database;
- universal installer with os detector by Sergey Rodin (VestaCP - https://vestacp.com);
- options savedsearches / navigationhiding / users / usergroups are set (for 4.x phpmyadmin);
- added table pma__usergroups (for 4.x phpmyadmin);
- sql dump on github now;
- sh files on github too.

IPTABLES di vestacp

Vestacp yg baru ga masukin script iptables masbro, jadi harus di input manual...
:p
Suram, lupa mulu mau posting, jadi mumung lagi inget kalo dah install fresh vesta cp jangan lupa bikin script ini d konsol nya ( ane pake ubuntu server ).