[Bnr2 Disuapin] Cara Install WordPress di Unmanaged VPS (Nginx MariaDB PHP)

Pake plugin MandrillApp, daftar dulu aja untuk dapetin API nya untuk ngehub domain agan dengan MandrillApp. Panduannya di sini _http://www.wpbeginner.com/wp-tutorials/how-to-fix-wordpress-not-sending-email-issue/

 

Maap gan baru nyoba lagi, sekarang semua oke

root@server1:~# ls /usr/share/nginx/html/
50x.html index.html ex.com
root@server1:~# service mysql restart
[ ok ] Stopping MariaDB database server: mysqld.
[ ok ] Starting MariaDB database server: mysqld.
[info] Checking for corrupt, not cleanly closed and upgrade needing tables..
root@server1:~# service php5-fpm restart
[ ok ] Restarting PHP5 FastCGI Process Manager: php5-fpm.
root@server1:~# ls /usr/share/nginx/html/
50x.html index.html ex.com

vi /usr/share/nginx/html/ex.com/wp-config.php udah bener, tapi kok muncul

[h=1]403 Forbidden[/h][HR][/HR]nginx/1.6.2


Kenapa ya? bisa dicoba situs belajar ane tipsbisnispemula.com

hanya memang ada masalah sewaktu install apanya gitu lupa, locale nya error

root@server1:~# locale
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
LANG=
LANGUAGE=
LC_CTYPE=UTF-8
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

dicoba gogling dengan

root@server1:~# dpkg-reconfigure locales
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
/usr/bin/locale: Cannot set LC_CTYPE to default locale: No such file or directory
/usr/bin/locale: Cannot set LC_ALL to default locale: No such file or directory
Generating locales (this might take a while)...
Generation complete.
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_CTYPE = "UTF-8",
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

apakah ada hubungannya ya??

 

^^
403 Forbidden itu si nginx bingung nyariin file index yang ditunjuk di virtual host. Solusinya ada dua saran:

1. Agan pake Wordpress kan? Coba buka lagi virtual host nya, pastikan di baris kode index ada index.php (lihat yang saya warnain biru)

Code:

server {
    listen 80;
    server_name www.example.com;
    return 301 http://example.com$request_uri;
}

server {
    listen 80;
    
    root /usr/share/nginx/html/example.com;
    index index.html index.htm [COLOR=#0000ff]index.php[/COLOR];
    
    server_name example.com;
    
    location / {
        try_files $uri $uri/ /index.php?$args;
    }
    
    location ~ \.php$ {
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass unix:/var/run/php5-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
    
    location ~ /\.ht {
        deny all;
    }

}

2. chown direktori nya agar milik nginx

chown -R www-data:www-data /usr/share/nginx/html/example.com

Reload konfigurasi nginx

service nginx reload

Akses web-nya.

 

Sukses tapi, muncul
[h=1]Error establishing a database connection[/h]Saya ricek,

MariaDB [(none)]> CREATE DATABASE db_domain;
ERROR 1007 (HY000): Can't create database 'db_domain'; database exist
MariaDB [(none)]> CREATE USER 'u_tipsbisnispemula'@'localhost' IDENTIFIED BY 'xxx';
ERROR 1396 (HY000): Operation CREATE USER failed for 'u_domain'@'localhost'
MariaDB [(none)]> GRANT ALL PRIVILEGES ON db_domain.* TO 'u_domain'@'localhost';
Query OK, 0 rows affected (0.01 sec)
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

sama kok dengan di confignya
19 define('DB_NAME', 'db_domain');
20
21 /** MySQL database username */
22 define('DB_USER', 'u_domain');
23
24 /** MySQL database password */
25 define('DB_PASSWORD', 'xxx');


Kenapa ya gan

 

Ulangi lagi aja. Masih ada kan backup an DB nya? Kalo ada ulangi, kalo ngga ada backup dulu.

mysql -u root -p
drop database db_example;
drop user 'u_example'@'localhost';
flush privileges;
quit;

Quit dulu ya biar afdol.

Sekarang create lagi db + user nya:

mysql -u root -p
create database db_example;
create user 'u_example'@'localhost' identified by 'password';
grant all on privileges db_example.* TO 'u_example'@'localhost';
flush privileges;
quit;

Kalo fresh WP harus nya udah bisa install, kalo ini web pindahan, import dulu file sql nya.

mysql -u u_example -p db_example < /folder/file/sql/berada/

masukin password u_example

Cek lagi bagian database di wp-config termasuk DB host harus localhost.

Selesai.

 

Wah pelan2 gan ane newbie nih..

MariaDB [(none)]> create database db_tipsbisnispemula;
Query OK, 1 row affected (0.00 sec)


MariaDB [(none)]> create user 'u_tipsbisnispemula'@'localhost' identified by 'xxx';
Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> grant all on privileges db_tipsbisnispemula.* TO 'u_tipsbisnispemula'@'localhost';
ERROR 1046 (3D000): No database selected

kenapa ya hehe maap...

 

Saya yg salah harusnya:

grant all privileges on db_tipsbisnispemula.* TO 'u_tipsbisnispemula'@'localhost';

Silahkan lanjutkan dari perintah di atas.

 

Duh makasih banget nih... happy banget dibantu,

MariaDB [(none)]> grant all privileges on db_tipsbisnispemula.* TO 'u_tipsbisnispemula'@'localhost';
Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> quit;
Bye

tapi dicek kok masih ya
Error establishing a database connection

bisa dicoba di tipsbisnispemula.com

Oh ya, apa karena masalah ini

root@server1:~# locale
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory

 

Kayanya kalo locale ngga ya, saya ngga tau apa ngaruh karena setau saya locale itu untuk config aja, kalo di windows kaya regional setting

Spoiler

Hmm, kenapa ya error trs, saya juga bingung. Udah dipastikan nama username (warna biru), database (warna merah), host (warna ungu), dan password (warna ijo) yang di perintah

create database db_example;
create user 'u_example'@'localhost' identified by 'password';
grant all privileges on db_example.* TO 'u_example'@'localhost';
flush privileges;
quit;

Sama dengan yang ada di

/usr/share/nginx/html/tipsbisnispemula.com/wp-config.php ??

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'db_example');

/** MySQL database username */
define('DB_USER', 'u_example');

/** MySQL database password */
define('DB_PASSWORD', 'password');

/** MySQL hostname */
define('DB_HOST', 'localhost');

Bisa tolong copy-paste isi dari:

1. /etc/nginx/sites-enabled/tipsbisnispemula.com

Caranya: cat /etc/nginx/sites-enabled/tipsbisnispemula.com

2. /usr/share/nginx/html/tipsbisnispemula.com/wp-config.php

Caranya cat /usr/share/nginx/html/tipsbisnispemula.com/wp-config.php

Untuk password yang ada di wp-config nanti diganti di-XXX-in aja ya.

 

saya posting dulu ampe 10 kali ya
ga boleh posting link soalnya, 3x lg

 

2 kali lagi

 

1x lagi biar lulus hehe

 

1.
##
server {
listen 80;
server_name xxx.com
return 301 http://tipsbisnispemula.com$request_uri;
}
server {
listen 80;


root /usr/share/nginx/html/tipsbisnispemula.com;
index index.html index.htm index.php;


server_name tipsbisnispemula.com;


location / {
try_files $uri $uri/ /index.php?$args;
}
location ~ \.php$ {
fastcgi_split_path_info ^(.+\.php)(/.+)$;
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}


#error_page 404 /404.html;


# redirect server error pages to the static page /50x.html
#
#error_page 500 502 503 504 /50x.html;
#location = /50x.html {
# root /usr/share/nginx/html;
#}


# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
#
location ~ \.php$ {
fastcgi_split_path_info ^(.+\.php)(/.+)$;
# # NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
# # With php5-cgi alone:
# fastcgi_pass 127.0.0.1:9000;
# # With php5-fpm:
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_index index.php;
include fastcgi_params;
}
2.
/** The name of the database for WordPress */
define('DB_NAME', 'db_tipsbinispemula');


/** MySQL database username */
define('DB_USER', 'u_tipsbisnispemula');


/** MySQL database password */
define('DB_PASSWORD', 'xxx');


/** MySQL hostname */
define('DB_HOST', 'localhost');

 

Solusi terakhir:

Ini web pindahan apa fresh install?, Kalo web pindahan dari Shared, pastikan:

1. Agan udah mengimport database dari web pindahan ke VPS, perintahnya pernah saya bahas:

mysql -u u_example -p db_example < /lokasi/database/berada/db.sql

2. Baris kode no. 62 di wp-config harus sesuai dengan database asal, secara default, wordpress menulis kode nya seperti ini:

$table_prefix = 'wp_';

Mugnkin saja prefix nya nya berbeda misal malah wp123_

Kalo masih error trs, hmm, nyerah deh, Kalo agan udah jalanin fresh install WP langkah demi langkah sesuai panduan ini tp masih salah, saya jg g ngerti apanya yang salah. Kemungkinan ada langkah yang terlewat, tapi saya ngga tau yang mana.... Mending reinstall dan mulai lagi dari 0 kode per kode nya karena di awal2 pun saya liat kemaren ada yang ngga teliti misalnya penambahan index.php ,

Oia, memang di sini ngga boleh pasang link yang bisa di klik (istilahnya live link) kalo ttp masang agan akan dibanned dari keanggotaan. mending edit tulisan agan di atas agar ngga live link, caranya Edit, lalu:

Spoiler

Spoiler

Spoiler

Save, maka hasilnya ngga ada live link seperti ini:

http://www.example.com

 

Sepertinya itu masalahnya,
keburu diarahkan ke IP baru website 1, saya ga bisa akses mySQL,
harus diingat2 lagi berarti..

btw, klo tanpa import mySQL, misal via import XML di dashboard nya ga bisa memang ya,
atau anggap saja install fresh terus nanti via FTP
soalnya rencana kalo lulus, mau naek level 2, mindahin site ke2 dari WP.com, dimana ga bisa import database bisanya via xml
nah klo berhasil baru mau mindahin website utamanya di level 3 dari shared host hehe

makasih gan masih sabar membantu

 

gan, kalo untuk akses ke phpmyadmin bagaimana ?

 

- Bisa kok lewat file XML juga.
- Kalo mau pake FTP lebih tepatnya SFTP karena port nya 22 dan agan ingin fresh install wordpress juga bisa.

Ini tanpa PhpMyAdmin, agar server lebih ringan, kalo misal RAM nya 1GB boleh pake PhPMyAdmin. Tutorial nya saya bahas di sini:

http://ads.id/forums/showthread.php/203551

 

wah ane install pake ram 512 gan, oiya gan, saya pake sitemapnya yoast ini dan saya coba summit ke webmaster. tapi di dasboard nya kok ada tulisan "Google couldn't access your site because of a server connectivity error".. apa karena ane ga nulis rewrite di htaccess,

nah kalo di nginx, kn emank ga support htacces kn mas,? terus ngeditnya di mana ? apa di /etc/nginx/sites-enabled/situsanda..

 

Betul, tambahkan di virtual host nya /etc/nginx/sites-enabled/situsanda di bawah server { . Catatan nginx nya seperti ini juga bisa.

Code:

[COLOR=#0000ff]...[/COLOR]
server {
    listen 80;

    root /usr/share/nginx/html/example.com;
    index index.html index.htm index.php;

    [COLOR=#ff0000]#WordpressSEO Yoast XML Sitemap Rule
    rewrite ^/sitemap_index\.xml$ /index.php?sitemap=1 last;
    rewrite ^/([^/]+?)-sitemap([0-9]+)?\.xml$ /index.php?sitemap=$1&sitemap_n=$2 last;[/COLOR]

[COLOR=#0000ff]...dst[/COLOR]

 

Aduh gan, baru saya dapet akses spanel nih jadi masih bisa impor db nya walau IP dah ga di hosting lama, itu apalagi PhPMyAdmin?
haruskah pake itu, sy baca di threadnya kaya ga aman gitu,
btw vps saya paketnya seperti ini

Spoiler: Paket VPS Saya

[ATTACH]47915.vB[/ATTACH][IMG][/spoiler]

haruskah saya install PHPMYAdmin juga?

lah koq spoilernya ga bisa hihi