[root@hostname ~]# cat /root/centminlogs/centminmod_phpmyadmin_install_060815-171457.log
useradd: user 'phpmyadmin' already exists
---------------------------------------------------------------
Create User: phpmyadmin
uid=502(phpmyadmin) gid=502(phpmyadmin) groups=502(phpmyadmin),500(nginx)
---------------------------------------------------------------
---------------------------------------------------------------
Installing phpmyadmin from official git repository...
---------------------------------------------------------------
This process can take some time depending on
speed of the repository and your server...
Initialized empty Git repository in /usr/local/nginx/html/2471_mysqladmin21680/.git/
Switched to a new branch 'STABLE'
Branch STABLE set up to track remote branch STABLE from origin.
---------------------------------------------------------------
Setup /usr/local/nginx/conf/phpmyadmin.conf ...
---------------------------------------------------------------
---------------------------------------------------------------
Create phpmyadmin htaccess user/pass...
python /usr/local/nginx/conf/htpasswd.py -c -b /usr/local/nginx/conf/htpassphpmyadmin adminS4SK1p3D/pI= n9cXNoYu4F1Gx22KBg12o0Eq6x0=
---------------------------------------------------------------
\\cp -af /usr/local/nginx/conf/php.conf /usr/local/nginx/conf/php_2471_mysqladmin21680.conf
---------------------------------------------------------------
server {
# listen 80;
listen 80 default_server backlog=2048 reuseport;
server_name hostname.cinebuffer.com;
root html;
access_log /var/log/nginx/localhost.access.log main buffer=256k flush=5m;
error_log /var/log/nginx/localhost.error.log error;
# ngx_pagespeed & ngx_pagespeed handler
#include /usr/local/nginx/conf/pagespeed.conf;
#include /usr/local/nginx/conf/pagespeedhandler.conf;
#include /usr/local/nginx/conf/pagespeedstatslog.conf;
# limit_conn limit_per_ip 16;
# ssi on;
location /nginx_status {
stub_status on;
access_log off;
allow 127.0.0.1;
#allow youripaddress;
deny all;
}
location / {
# block common exploits, sql injections etc
#include /usr/local/nginx/conf/block.conf;
# Enables directory listings when index file not found
# autoindex on;
# Shows file listing times as local time
# autoindex_localtime on;
# Enable for vBulletin usage WITHOUT vbSEO installed
# try_files $uri $uri/ /index.php;
}
# example nginx-http-concat
# /csstest/??one.css,two.css
#location /csstest {
#concat on;
#concat_max_files 20;
#}
include /usr/local/nginx/conf/phpmyadmin.conf;
include /usr/local/nginx/conf/staticfiles.conf;
include /usr/local/nginx/conf/include_opcache.conf;
include /usr/local/nginx/conf/php.conf;
#include /usr/local/nginx/conf/phpstatus.conf;
include /usr/local/nginx/conf/drop.conf;
#include /usr/local/nginx/conf/errorpage.conf;
include /usr/local/nginx/conf/vts_mainserver.conf;
}
---------------------------------------------------------------
NON-STATIC IP configuration
---------------------------------------------------------------
cat /usr/local/nginx/conf/phpmyadmin.conf
---------------------------------------------------------------
location ^~ /2471_mysqladmin21680/ {
rewrite ^/(.*) https://hostname.cinebuffer.com/$1 permanent;
}
---------------------------------------------------------------
cat /usr/local/nginx/conf/phpmyadmin_https.conf
---------------------------------------------------------------
location ^~ /2471_mysqladmin21680/ {
#try_files $uri $uri/ /2471_mysqladmin21680/index.php?$args;
include /usr/local/nginx/conf/php_2471_mysqladmin21680.conf;
auth_basic "Private Access";
auth_basic_user_file /usr/local/nginx/conf/htpassphpmyadmin;
allow 127.0.0.1;
#allow 198.48.224.216;
#deny all;
}
---------------------------------------------------------------
touch /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf
Dynamically set PHP memory_limit based on available system memory...
Total Mem: 1891 MB
Real Free Mem: 1702 MB
Mem Limit: 756 MB
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
Stopping nginx: [ OK ]
Starting nginx: [ OK ]
Gracefully shutting down php-fpm . done
Starting php-fpm done
---------------------------------------------------------------
SSL Vhost Setup...
---------------------------------------------------------------
---------------------------------------------------------------
Generating self signed SSL certificate...
Just hit enter at each of the prompts
---------------------------------------------------------------
Generating RSA private key, 1024 bit long modulus
..++++++
...++++++
e is 65537 (0x10001)
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [XX]:State or Province Name (full name) []:Locality Name (eg, city) [Default City]:Organization Name (eg, company) [Default Company Ltd]:Organizational Unit Name (eg, section) []:Common Name (eg, your name or your server's hostname) []:Email Address []:
Please enter the following 'extra' attributes
to be sent with your certificate request
A challenge password []:An optional company name []:Signature ok
subject=/C=CA/ST=Ontario/L=Ottawa/O=TC/CN=hostname/emailAddress=
Getting Private key
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
Stopping nginx: [ OK ]
Starting nginx: [ OK ]
Gracefully shutting down php-fpm done
Starting php-fpm done
---------------------------------------------------------------
Create update script:
/root/tools/phpmyadmin_update.sh
---------------------------------------------------------------
---------------------------------------------------------------
Create cronjob for auto updating phpmyadmin:
/root/tools/phpmyadmin_update.sh
---------------------------------------------------------------
---------------------------------------------------------------
Create uninstall script:
/root/tools/phpmyadmin_uninstall.sh
---------------------------------------------------------------
---------------------------------------------------------------
Password protected 2471_mysqladmin21680
at path /usr/local/nginx/html/2471_mysqladmin21680
config.inc.php at: /usr/local/nginx/html/2471_mysqladmin21680/config.inc.php
WEB url:
https://hostname.cinebuffer.com/2471_mysqladmin21680
Login with your MySQL root username / password
---------------------------------------------------------------
---------------------------------------------------------------
phpmyadmin update script at: /root/tools/phpmyadmin_update.sh
Add your own cron job to automatically run the update script i.e.
15 01 * * * /root/tools/phpmyadmin_update.sh
---------------------------------------------------------------
phpmyadmin uninstall script at: /root/tools/phpmyadmin_uninstall.sh
/root/tools/phpmyadmin_uninstall.sh
---------------------------------------------------------------
SSL vhost: /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf
php-fpm includes: /usr/local/nginx/conf/php_2471_mysqladmin21680.conf
php-fpm pool conf: /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf
dedicated php-fpm pool user: phpmyadmin
dedicated php-fpm pool group: nginx
dedicated php error log: /var/log/php_myadmin_error.log
---------------------------------------------------------------
SSL vhost access log: /var/log/nginx/localhost_ssl.access.log
SSL vhost error log: /var/log/nginx/localhost_ssl.error.log
---------------------------------------------------------------
Total phpmyadmin Install Time: 225.072256328 seconds