Cara Instal otomatis mengkonfigurasi Nginx dengan php-fpm dan satu dari MySQL, database PostgreSQL

Cara Instal otomatis mengkonfigurasi Nginx menggunakan php-fpm & satu dari MySQL, database PostgreSQL - Artikel ini akan membantu kita seluruh buat menginstal secara otomatis, mengkonfigurasi Nginx menggunakan PHP-FPM, mengkonfigurasi impian host dan akan menciptakan kita memilih salah satu database MySQL atau PostgreSQL. 

Kami mempunyai 2 server. CentOS7 & FreeBSD10.

GIT repository untukdannbsp;kode . Untuk mendownload kode menurut gudang GIT Anda wajib menginstal GIT & menggunakan perintah berikut: 
# git clone https://github.Com/jamalshahverdiev/nginx-phphpm-mysql-postgresql.Git

Untuk menginstal dan mengkonfigurasi Python2.7 atau Python3.4 di laptop atau di server kita bisa menggunakandannbsp;script ini .

./ngphfpmypg.Py script memerlukan masukan dari konsol buat IP, login, pass, nama host virtual, nama db, pengguna db dan buat db pass. 
apabila masuk Virtual Host terdapat pada script server akan memberikan script baru menggunakan nama ./add-vhost-ngphfpmypg.Py untuk menambahkan impian host. 
Script bekerja pada server CentOS7 dan FreeBSD10. Saya melakukan tes buat masing-masing server.

Cara Instal otomatis mengkonfigurasi Nginx menggunakan php-fpm & satu dari MySQL, database PostgreSQL - Mari kita mulai menginstal & mengkonfigurasi Nginx menggunakan MySQL dan PHP-FPM buat setiap server:
fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
dua. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select: 1
You have selected "Enter" button!!!
Please be patient, it will take some time...
SQL service already running...
Enter name for new database: linuxdb
Enter user name for database: linuxuser
Enter pass for linuxuser:
Repeat pass for linuxuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
MySQL, Nginx and PHP-FPM installed and configured...

fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
dua. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select: 1
You have chose MySQL with PHP-FPM!
Please be patient, it will take some time...
SQL service already running...
Enter name for new database: linuxdb
Enter user name for database: linuxuser
Enter pass for linuxuser:
Repeat pass for linuxuser:
MySQL, Nginx and PHP-FPM installed and configured...

Sekarang saya akan menginstal & mengkonfigurasi Nginx menggunakan php-fpm dan PostgreSQL buat masing-masing sevrers:
fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
2. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select: dua
You have chose PostgreSQL with PHP-FPM!
Please be patient, it will take some time...
SQL service already running...
Enter name for new database: linuxdb
Enter user name for database: linuxuser
Enter pass for linuxuser:
Repeat pass for linuxuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
PostgreSQL, Nginx and PHP-FPM installed and configured...

fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
dua. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select: dua
You have chose PostgreSQL with PHP-FPM!
Please be patient, it will take some time...
SQL service already running...
Enter name for new database: linuxdb
Enter user name for database: linuxuser
Enter pass for linuxuser:
Repeat pass for linuxuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
PostgreSQL, Nginx and PHP-FPM installed and configured...

Cobalah menambahkan virtual host yg ada buat masing-masing server:
fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
You have already installed and running Nginx web server...
If you want add new VirtualHost, please usedannbsp;./add-vhost-ngphfpmypg.Py script.

fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
You have already installed and running Nginx web server...
If you want add new VirtualHost, please usedannbsp;./add-vhost-ngphfpmypg.Py script.

Cobalah buat menambahkan impian host baru dan nir menginstal database apapun:
fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
dua. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select:
You pressed "Enter" button, exiting!!!

fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
2. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select:
You pressed "Enter" button, exiting!!!

Sekarang aku akan menggunakandannbsp;scriptdannbsp;./add-vhost-ngphfpmypg.Py buat setiap server untuk menambahkan virtual host baru.

Cobalah menambahkan impian host yang terdapat buat masing-masing server:
fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
You have already installed and running Nginx web server...
If you want add new VirtualHost, please usedannbsp;./add-vhost-ngphfpmypg.Py script.

fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
You have already installed and running Nginx web server...
If you want add new VirtualHost, please usedannbsp;./add-vhost-ngphfpmypg.Py script.

Cobalah buat menambahkan virtual host baru dan nir menginstal database apapun:
fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
dua. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select:
You pressed "Enter" button, exiting!!!

fpyvenv ngmysqlphpng # ./ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
Please be patient, installing nginx server...
Nginx server installed and configured...
1. If you want install and configure MySQL with PHP-FPM write 1 and press "Enter"!!!
2. If you want install and configure PostgreSQL with PHP-FPM write 2 and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select:
You pressed "Enter" button, exiting!!!

Sekarang aku akan menggunakan scriptdannbsp;./add-vhost-ngphfpmypg.Py buat setiap server buat menambahkan virtual host baru.

Coba masukkan nama host impian yg terdapat:
fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is CentOS server...
Entered domain name linux.Com is already exists on the 172.16.100.20 server!!!
Please enter different name than "linux.Com" !!!

fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linux.Com
This is FreeBSD server...
Entered domain name linux.Com is already exists on the 172.16.100.40 server!!!
Please enter different name than "linux.Com" !!!

Coba masukkan virtual host baru dengan database MySQL yg tidak terkonfigurasi:
fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: unixmen.Com
This is CentOS server...
You have already running Nginx web server...
Virtual host unixmen.Com already configured...
1. To add MySQL database for this impian host write 1 and press "Enter"!!!
dua. To add PostgreSQL database for this impian host write dua and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select: 1
You have chose MySQL with PHP-FPM!
Please check SQL service!!!

fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: unixmen.Com
This is FreeBSD server...
You have already running Nginx web server...
Virtual host unixmen.Com already configured...
1. To add MySQL database for this impian host write 1 and press "Enter"!!!
2. To add PostgreSQL database for this virtual host write dua and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select: 1
You have chose MySQL with PHP-FPM!
Please check SQL service!!!

Coba masukkan impian host baru dengan database PostgreSQL yg telah terkonfigurasi:
fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linuxmen.Com
This is CentOS server...
You have already running Nginx web server...
Virtual host linuxmen.Com already configured...
1. To add MySQL database for this impian host write 1 and press "Enter"!!!
2. To add PostgreSQL database for this virtual host write dua and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select: 2
You have chose PostgreSQL with PHP-FPM!
You have already running PostgreSQL database server...
Enter name for new database: linuxmendb
Enter user name for database: linuxmenuser
Enter pass for linuxmenuser:
Repeat pass for linuxmenuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
PostgreSQL database and Nginx configured for your site: linuxmen.Com

fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: linuxmen.Com
This is FreeBSD server...
You have already running Nginx web server...
Virtual host linuxmen.Com already configured...
1. To add MySQL database for this virtual host write 1 and press "Enter"!!!
2. To add PostgreSQL database for this impian host write 2 and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select: 2
You have chose PostgreSQL with PHP-FPM!
You have already running PostgreSQL database server...
Enter name for new database: linuxmendb
Enter user name for database: linuxmenuser
Enter pass for linuxmenuser:
Repeat pass for linuxmenuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
PostgreSQL database and Nginx configured for your site: linuxmen.Com

Cobalah menambahkan impian host baru menggunakan database PostgreSQL yang tidak terkonfigurasi:
fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: freebsd.Com
This is CentOS server...
You have already running Nginx web server...
Virtual host freebsd.Com already configured...
1. To add MySQL database for this virtual host write 1 and press "Enter"!!!
2. To add PostgreSQL database for this virtual host write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select: 2
You have chose PostgreSQL with PHP-FPM!
Please check SQL service!!!

fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: freebsd.Com
This is CentOS server...
You have already running Nginx web server...
Virtual host freebsd.Com already configured...
1. To add MySQL database for this virtual host write 1 and press "Enter"!!!
dua. To add PostgreSQL database for this virtual host write dua and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select: 2
You have chose PostgreSQL with PHP-FPM!
Please check SQL service!!!

Pada akhirnya, cobalah menambahkan impian host baru menggunakan database MySQL yg telah dikonfigurasi:
fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.20
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: unixmen.Com
This is CentOS server...
You have already running Nginx web server...
Virtual host unixmen.Com already configured...
1. To add MySQL database for this virtual host write 1 and press "Enter"!!!
2. To add PostgreSQL database for this impian host write dua and press "Enter"!!!
tiga. If you want to exit from script just press "Enter" button.
Please select: 1
You have chose MySQL with PHP-FPM!
You have already running MySQL database server...
Enter name for new database: unixmendb
Enter user name for database: unixmenuser
Enter pass for unixmenuser:
Repeat pass for unixmenuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
MySQL database and Nginx configured for your site: unixmen.Com

fpyvenv ngmysqlphpng # ./add-vhost-ngphfpmypg.Py
Please enter WEB server IP address: 172.16.100.40
Please enter username for UNIX/Linux server: root
Password:
Please enter site name: unixmen.Com
This is FreeBSD server...
You have already running Nginx web server...
Virtual host unixmen.Com already configured...
1. To add MySQL database for this virtual host write 1 and press "Enter"!!!
dua. To add PostgreSQL database for this virtual host write 2 and press "Enter"!!!
3. If you want to exit from script just press "Enter" button.
Please select: 1
You have chose MySQL with PHP-FPM!
You have already running MySQL database server...
Enter name for new database: unixmendb
Enter user name for database: unixmenuser
Enter pass for unixmenuser:
Repeat pass for unixmenuser:
Entered passwords must be the same. Please enter passwords again.
Please enter password:
Please repeat password:
The password set successfully!
MySQL database and Nginx configured for your site: unixmen.Com

Cara Instal otomatis mengkonfigurasi Nginx menggunakan php-fpm & satu dari MySQL, database PostgreSQL