Google Compute Engine - MappingSystem/Tutorial-Buka-Toko GitHub Wiki

$ sudo apt-get install apache2 php libapache2-mod-php
$ sudo /usr/sbin/apachectl start
$ sudo chkconfig apache2ctl on
$ sudo sh -c 'echo "<?php phpinfo();?>" > /var/www/html/phpinfo.php'

/etc/apache2/
|-- apache2.conf
|       `--  ports.conf
|-- mods-enabled
|       |-- *.load
|       `-- *.conf
|-- conf-enabled
|       `-- *.conf
|-- sites-enabled
|       `-- *.conf

$ sudo apt-get -y install postgresql postgresql-client postgresql-contrib
$ sudo -s
root@instance-sql:~# sudo -u postgres psql postgres 
postgres=# SELECT version();
                                                   version                                                    
--------------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.24 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.4) 4.8.4, 64-bit
(1 row)

$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory               Log file
9.3 main    5432 online postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log
9.5 main    5433 online postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log
10  main    5434 online postgres /var/lib/postgresql/10/main  /var/log/postgresql/postgresql-10-main.log

$ sudo nano /etc/postgresql/9.3/main/start.conf 
#ubah 'auto' ke 'disabled'

$ sudo nano /etc/postgresql/10/main/start.conf 
#ubah 'auto' ke 'disabled'

$ sudo nano /etc/postgresql/9.5/main/postgresql.conf 
#hapus tagar dan ubah 'localhost' ke '*' dan
#ubah '5433' ke '5432'

$ sudo nano /etc/postgresql/9.5/main/pg_hba.conf
#tambahkan di baris paling bawah
#host    all             all           0.0.0.0/0        trust

$ sudo service postgresql restart
$ sudo -s
root@instance-sql:~# sudo -u postgres psql postgres 
postgres=# SELECT version();
                                                      version                                                      
-------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.5.14 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit
(1 row)
postgres=# \password postgres
postgres=# CREATE EXTENSION adminpack;
CREATE EXTENSION
postgres=# \q
root@instance:~# exit
exit
$

$ psql "host=127.0.0.1 sslmode=disable dbname=saleor user=saleor"
saleor=# CREATE EXTENSION adminpack;
saleor=# \q

$ gcloud compute instances add-tags instance-sql --tags postgres-server
$ gcloud compute firewall-rules create "postgres-remote-access" \
    --allow tcp:5432 --source-tags "postgres-client" \
    --target-tags "postgres-server"
$ psql "host=[IPV4_ADDRESS] port=5432 Modesto=disable dbname=saleor user=saleor"
$ psql -h [IPV4_ADDRESS] -p 5432 -U saleor

$ psql postgresql://saleor:saleor@[IPV4_ADDRESS]:5432/saleor
$ psql postgres://saleor:saleor@[IPV4_ADDRESS]/saleor

$ sudo apt-get -y install mysql-server
$ sudo mysql_secure_installation
$ sudo mysql --user=root -p[ROOT_PASSWORD] -e "show databases"
$ sudo mysql -u root -p admin
mysql> CREATE DATABASE dbname;
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
mysql> SELECT User FROM mysql.user;
mysql > exit
$ sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
cat bind-address            = 0.0.0.0
$ sudo service mysql restart

$ gcloud compute instances add-tags instance-sql --tags mysql-server
$ gcloud compute firewall-rules create "mysql-remote-access" \
    --allow tcp:3306 --source-tags "mysql-client" \
    --target-tags "mysql-server"
$ mysql --host=[IPV4_ADDRESS] -u wordpress -p
MySQL > exit

$ sudo apt-get -y install redis-server
$ ps -f -u redis

sudo service redis-server restart
$ ps -f -u redis

$ sudo apt install redis-tools
$ redis-cli -h [REDIS_IPV4_ADDRESS] ping
PONG
$ (printf "PING\r\n";) | nc [REDIS_IPV4_ADDRESS] 6379 
+PONG
$ curl -w '\n' http://[REDIS_IPV4_ADDRESS]:6379/ping
{"ping":"PONG"}
$ exec 3<>/dev/tcp/[REDIS_IPV4_ADDRESS]/6379 && echo -e "PING\r\n" >&3 && head -c 7 <&3
+PONG

$ gcloud compute instances add-tags instance-sql --tags redis-server
$ gcloud compute firewall-rules create "redis-remote-access" \
    --allow tcp:6379 --source-tags "redis-client" \
    --target-tags "redis-server"

$ redis-cli -h [IPV4_ADDRESS]                                                   
redis> ping
PONG
redis> set mykey somevalue
OK
redis> get mykey
"somevalue"
redis> exit

$ do-release-upgrade
$ sudo apt-get update

$ sudo netstat -plnt
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State  PID/Program name    
tcp        0      0 0.0.0.0:6379  0.0.0.0:*       LISTEN 874/redis-server 0. 
tcp        0      0 127.0.0.53:53 0.0.0.0:*       LISTEN 636/systemd-resolve 
tcp        0      0 0.0.0.0:22    0.0.0.0:*       LISTEN 1065/sshd           
tcp        0      0 0.0.0.0:5432  0.0.0.0:*       LISTEN 902/postgres        
tcp6       0      0 :::3306       :::*            LISTEN 905/mysqld          
tcp6       0      0 :::80         :::*            LISTEN 891/apache2         
tcp6       0      0 :::22         :::*            LISTEN 1065/sshd           
tcp6       0      0 :::5432       :::*            LISTEN 902/postgres