Skip to content

Instantly share code, notes, and snippets.

Created July 5, 2016 15:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/64f3a4b080cea549a3ed8cb46628c40b to your computer and use it in GitHub Desktop.
Save anonymous/64f3a4b080cea549a3ed8cb46628c40b to your computer and use it in GitHub Desktop.
useradd: user 'phpmyadmin' already exists
---------------------------------------------------------------
(BCreate User: phpmyadmin
(Buid=502(phpmyadmin) gid=502(phpmyadmin) groups=502(phpmyadmin),500(nginx)
(B---------------------------------------------------------------
(B
---------------------------------------------------------------
(BInstalling phpmyadmin from official git repository...
(B---------------------------------------------------------------
(BThis process can take some time depending on
(Bspeed of the repository and your server...
(B
Initialized empty Git repository in /usr/local/nginx/html/27718_mysqladmin7402/.git/
---------------------------------------------------------------
(BSetup /usr/local/nginx/conf/phpmyadmin.conf ...
(B---------------------------------------------------------------
(B---------------------------------------------------------------
(BCreate phpmyadmin htaccess user/pass...
(Bpython /usr/local/nginx/conf/htpasswd.py -c -b /usr/local/nginx/conf/htpassphpmyadmin adminTTQ8npCCaJA= ae7jdE3Yc57zBjjgykOcsvF7i1I=
(B---------------------------------------------------------------
(B
\cp -af /usr/local/nginx/conf/php.conf /usr/local/nginx/conf/php_27718_mysqladmin7402.conf
---------------------------------------------------------------
(Bserver {
# listen 80;
listen 80 default_server backlog=2048 reuseport;
server_name THBX-Cloud001-I002;
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;
}---------------------------------------------------------------
(BNON-STATIC IP configuration
(B---------------------------------------------------------------
(Bcat /usr/local/nginx/conf/phpmyadmin.conf
(B---------------------------------------------------------------
(Blocation ^~ /27718_mysqladmin7402/ {
rewrite ^/(.*) https://THBX-Cloud001-I002/$1 permanent;
}
---------------------------------------------------------------
(Bcat /usr/local/nginx/conf/phpmyadmin_https.conf
(B---------------------------------------------------------------
(Blocation ^~ /27718_mysqladmin7402/ {
#try_files $uri $uri/ /27718_mysqladmin7402/index.php?$args;
include /usr/local/nginx/conf/php_27718_mysqladmin7402.conf;
auth_basic "Private Access";
auth_basic_user_file /usr/local/nginx/conf/htpassphpmyadmin;
allow 127.0.0.1;
#allow 116.106.32.35;
#deny all;
}
---------------------------------------------------------------
(B
touch /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf
(B
Dynamically set PHP memory_limit based on available system memory...
(B
Total Mem: 7870 MB
(BReal Free Mem: 3198 MB
(BMem Limit: 1421 MB
(B
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 [05-Jul-2016 14:40:24] NOTICE: PHP message: PHP Warning: Version warning: Imagick was compiled against Image Magick version 1682 but version 1683 is loaded. Imagick will run but may behave surprisingly in Unknown on line 0
done
---------------------------------------------------------------
(BSSL Vhost Setup...
(B---------------------------------------------------------------
(B
---------------------------------------------------------------
(BGenerating self signed SSL certificate...
(BJust hit enter at each of the prompts
(B---------------------------------------------------------------
(B
Generating RSA private key, 2048 bit long modulus
...........................................................................................................................+++
..........+++
e is 65537 (0x10001)
Signature ok
subject=/C=US/ST=California/L=Los Angeles/O=THBX-Cloud001-I002/OU=IT/CN=THBX-Cloud001-I002
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 [05-Jul-2016 14:40:55] NOTICE: PHP message: PHP Warning: Version warning: Imagick was compiled against Image Magick version 1682 but version 1683 is loaded. Imagick will run but may behave surprisingly in Unknown on line 0
done
---------------------------------------------------------------
(BCreate update script:
(B/root/tools/phpmyadmin_update.sh
(B---------------------------------------------------------------
(B---------------------------------------------------------------
(BCreate cronjob for auto updating phpmyadmin:
(B/root/tools/phpmyadmin_update.sh
(B---------------------------------------------------------------
(B---------------------------------------------------------------
(BCreate uninstall script:
(B/root/tools/phpmyadmin_uninstall.sh
(B---------------------------------------------------------------
(B
---------------------------------------------------------------
(BPassword protected 27718_mysqladmin7402
(Bat path /usr/local/nginx/html/27718_mysqladmin7402
(Bconfig.inc.php at: /usr/local/nginx/html/27718_mysqladmin7402/config.inc.php
(B WEB url:
(B
 https://THBX-Cloud001-I002/27718_mysqladmin7402
(B
Login with your MySQL root username / password
(B---------------------------------------------------------------
(B
phpmyadmin htaccess login details:
(BUsername: adminTTQ8npCCaJA=
(BPassword: ae7jdE3Yc57zBjjgykOcsvF7i1I=
(BAllowed IP address: 116.106.32.35
(B
---------------------------------------------------------------
(Bphpmyadmin update script at: /root/tools/phpmyadmin_update.sh
(BAdd your own cron job to automatically run the update script i.e.
(B
 15 01 * * * /root/tools/phpmyadmin_update.sh
(B
---------------------------------------------------------------
(Bphpmyadmin uninstall script at: /root/tools/phpmyadmin_uninstall.sh
(B
 /root/tools/phpmyadmin_uninstall.sh
(B
---------------------------------------------------------------
(BSSL vhost: /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf
(Bphp-fpm includes: /usr/local/nginx/conf/php_27718_mysqladmin7402.conf
(Bphp-fpm pool conf: /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf
(Bdedicated php-fpm pool user: phpmyadmin
(Bdedicated php-fpm pool group: nginx
(Bdedicated php error log: /var/log/php_myadmin_error.log
(B---------------------------------------------------------------
(BSSL vhost access log: /var/log/nginx/localhost_ssl.access.log
(BSSL vhost error log: /var/log/nginx/localhost_ssl.error.log
(B---------------------------------------------------------------
(B
Total phpmyadmin Install Time: 118.819128588 seconds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment