Skip to content

Instantly share code, notes, and snippets.

@JT501

JT501/ServerSetup.md

Last active December 6, 2019 13:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save JT501/0ce0d69c23dcabc4914ab47fe0f2fbaf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save JT501/0ce0d69c23dcabc4914ab47fe0f2fbaf to your computer and use it in GitHub Desktop.
Download ZIP
Google Cloud Server (CentOS 7) Setup Steps
Raw
ServerSetup.md

Google Cloud Server (CentOS 7) Setup Steps

  1. Install Virtualmin:
  1. Change root password:
  • sudo passwd root
  1. Set Firewall Rule:
  • TCP: 10000
  1. Install PHP 7.2:
  1. Setup SFTP:
  1. Upgrade MySQL/MariaDB Server
  1. Install Composer
  • cd /tmp
  • curl -sS https://getcomposer.org/installer | php
  • mv composer.phar /usr/local/bin/composer
@JT501
Copy link
Author

JT501 commented Nov 17, 2019 •
edited
Loading

Postgresql 11

Install Postgresql Server

Webmin PostgreSQL Server Module Setting

  • Path to psql command: /usr/pgsql-11/bin/psql
  • Command to start PostgreSQL: systemctl start postgresql-11.service
  • Paths to host access config file: /var/lib/pgsql/11/data/pg_hba.conf
  • Path to pg_dump command: /usr/pgsql-11/bin/pg_dump
  • Path to pg_restore command: /usr/pgsql-11/bin/pg_restore

Install Postgresql PDO

@JT501
Copy link
Author

JT501 commented Dec 6, 2019

Iden Issue

Change allow host config to following:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment