Want more timely Centmin Mod News Updates?
Become a Member

phpmyadmin.sh Addon

Discussion in 'Add Ons' started by eva2000, May 25, 2014.

  1. Dannymh

    Dannymh New Member

    12
    3
    3
    Oct 23, 2014
    Ratings:
    +3
    Local Time:
    7:21 PM
    1.7.x
    5.5
    I ran the phpmyadmin script, but when it got to the part where it restarts php-fpm, it failed as it had set no user for the php-fpm pool so tried to run as root.

    I altered the config and for the pool to the nginx user and tried to run the script again, however now it fails with a duplicate location in the phpmyadminconfig.

    I remove this and then try to re-run the script, it then fails after the same php-fpm restart with

    Code:
    ./phpmyadmin.sh: line 390: cecho: command not found
    
    Restarting nginx (via systemctl):  Job for nginx.service failed because the control process exited with error code. See "systemctl status nginx.service" and "journalctl -xe" for details.
    
                                                              [FAILED]
    
    Gracefully shutting down php-fpm . done
    
    Starting php-fpm  done
    
    ./phpmyadmin.sh: line 489: syntax error near unexpected token `fi'
    
    ./phpmyadmin.sh: line 489: `fi'
    
    It looks like i need to go back and clean everything up, but looks like there is no simple way to do this and will need to scroll back through the .sh and reverse everything from up to line 489.

    Is there any other quick cleanup I could do to try and get the install running again?
     
  2. pamamolf

    pamamolf Premium Member Premium Member

    3,237
    305
    83
    May 31, 2014
    Ratings:
    +557
    Local Time:
    8:21 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Wondering if I can get Phpmyadmin working behind HSTS Cloudflare certificate.....

    I know that it is related to the self signed certificate but is it possible to use Let’s encrypt on it or any other solution?

    As using HSTS there is no way to open phpmyadmin ....

    Thank you
     
  3. eva2000

    eva2000 Administrator Staff Member

    39,155
    8,647
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,296
    Local Time:
    3:21 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    can you run your phpmyadmin.sh script in debug mode
    Code (Text):
    bash -x phpmyadmin.sh

    then post output in a gist.github.com or pastebin.com entry and share the link - you can mask any sensitive info
     
  4. eva2000

    eva2000 Administrator Staff Member

    39,155
    8,647
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,296
    Local Time:
    3:21 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    There's no automated way for main hostname SSL HTTPS. But you can manually setup main hostname outlined in Getting Started Guide step 1 with HTTPS using vhost generator at Generate Centmin Mod Nginx Vhost - CentminMod.com LEMP Nginx web stack for CentOS

    type on domain field in main host name domain which has to have valid DNS A record pointing to server ip i.e. host.domain.com and check box that says Generate Self-Signed SSL / Letsencrypt SSL HTTPS Vhost (File ONLY) *

    Vhost type = basic and hit submit

    follow first 3 acme.sh commands only to get letsencrypt ssl cert but edit web root from
    /home/nginx/domains/host.domain.com/public to point to /usr/local/nginx/html and remove www. domain from -d

    enable letsencrypt in 123.09beta01 - 3 commands
    Code (Text):
    touch /etc/centminmod/custom_config.inc
    echo "LETSENCRYPT_DETECT='y'" >> /etc/centminmod/custom_config.inc
    /usr/local/src/centminmod/addons/acmetool.sh acmeupdate
    

    get letsencrypt ssl cert - 1 line cmd - webroot defined by -w /usr/local/nginx/html
    Code (Text):
    /root/.acme.sh/acme.sh --force --issue --days 60 -d host.domain.com -w /usr/local/nginx/html -k 2048 --useragent centminmod-centos-acmesh-webroot --log /root/centminlogs/acmetool.sh-debug-log-host.domain.com.log --log-level 2
    

    install letsencrypt ssl cert - 2 line cmds
    Code (Text):
    mkdir -p /usr/local/nginx/conf/ssl/host.domain.com
    /root/.acme.sh/acme.sh --installcert -d host.domain.com --certpath /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-acme.cer --keypath /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-acme.key --capath /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-acme.cer --reloadCmd /usr/bin/ngxreload --fullchainpath /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-fullchain-acme.key
    

    then make a copy of /usr/local/nginx/conf/conf.d/virtual.conf as /usr/local/nginx/conf/conf.d/virtual.ssl.conf
    Code (Text):
    cp -a /usr/local/nginx/conf/conf.d/virtual.conf /usr/local/nginx/conf/conf.d/virtual.ssl.conf
    

    now edit within /usr/local/nginx/conf/conf.d/virtual.ssl.conf with ssl cert lines so looks like
    Code (Text):
    server {
      listen 443 ssl http2;
      server_name host.domain.com;
    
      ssl_certificate      /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-acme.cer;
      ssl_certificate_key  /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-acme.key;
      ssl_certificate_key  /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com.key;
      include /usr/local/nginx/conf/ssl_include.conf;
    
      http2_max_field_size 16k;
      http2_max_header_size 32k;
      # dual cert supported ssl ciphers
      ssl_ciphers     EECDH+CHACHA20-draft:EECDH+CHACHA20:EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA256:EECDH+ECDSA+SHA384:EECDH+aRSA+SHA256:EECDH+aRSA+SHA384:EECDH+AES128:!aNULL:!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS:!RC4:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!CAMELLIA;
      ssl_prefer_server_ciphers   on;
      #add_header Alternate-Protocol  443:npn-spdy/3;
      #add_header Strict-Transport-Security "max-age=31536000; includeSubdomains;";
      #add_header X-Frame-Options SAMEORIGIN;
      #add_header X-Xss-Protection "1; mode=block" always;
      #add_header X-Content-Type-Options "nosniff" always;
      #spdy_headers_comp 5;
      ssl_buffer_size 1369;
      ssl_session_tickets on;
    
      # enable ocsp stapling
      resolver 8.8.8.8 8.8.4.4 valid=10m;
      resolver_timeout 10s;
      ssl_stapling on;
      ssl_stapling_verify on;
      ssl_trusted_certificate /usr/local/nginx/conf/ssl/host.domain.com/host.domain.com-acme.cer;
    
            root   html;
            access_log              /var/log/nginx/localhost.access.log     combined buffer=8k flush=1m;
            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;
         
                }
    
    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;
    
           }
    

    restart nginx
    Code (Text):
    ngxrestart
    

    now you should be able to access both https and non-https hostname and then if all is working do a non-https to https 302 temp redirect



    If you do have phpmyadmin.sh installed phpmyadmin, you can probably try this to fix the conflict via these steps.

    1. Get the contents of /usr/local/nginx/conf/phpmyadmin_https.conf and place it in your above created
    /usr/local/nginx/conf/conf.d/virtual.ssl.conf main hostname HTTPS nginx vhost within server{} context

    2. Backup locally copy of phpmyadmin.sh auto generated self-signed SSL cert HTTPS vhost at /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf

    3. Then take the below following values contained within /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf and transpose them into your above created
    /usr/local/nginx/conf/conf.d/virtual.ssl.conf main hostname HTTPS nginx vhost within server{} context
    Code (Text):
    keepalive_timeout 3000;
    client_body_buffer_size 256k;
    client_body_timeout 3000s;
    client_header_buffer_size 256k;
    ## how long a connection has to complete sending
    ## it's headers for request to be processed
    client_header_timeout 60s;
    client_max_body_size 512m;
    connection_pool_size 512;
    directio 512m;
    ignore_invalid_headers on;
    large_client_header_buffers 8 256k;
    


    4. Then remove /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf

    5. Test Nginx config & Restart Nginx & PHP-FPM
    Code (Text):
    nginx -t
    nprestart
    
     
    • Winner Winner x 1
    • Informative Informative x 1
  5. pamamolf

    pamamolf Premium Member Premium Member

    3,237
    305
    83
    May 31, 2014
    Ratings:
    +557
    Local Time:
    8:21 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    One question....
    Should i generate the vhost for my hostname using menu 2 or i just need only to generate the vhost from the online generator?

    Thank you
     
  6. eva2000

    eva2000 Administrator Staff Member

    39,155
    8,647
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,296
    Local Time:
    3:21 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    no generating needed ;)
     
    • Informative Informative x 1
  7. Dannymh

    Dannymh New Member

    12
    3
    3
    Oct 23, 2014
    Ratings:
    +3
    Local Time:
    7:21 PM
    1.7.x
    5.5
    will do shortly, because the world has a sardonic sense of humor, a week after OS and software hell, my server just ran into an SSD disk array issue
     
  8. pamamolf

    pamamolf Premium Member Premium Member

    3,237
    305
    83
    May 31, 2014
    Ratings:
    +557
    Local Time:
    8:21 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hello

    I did it and I have a valid certificate now and all are ok ...

    Before that I was create a valid certificate for my domain using the same tool acme and I got one entry at crontab related to auto updating of it...

    That previous entry will auto update the certificate for the Phpmyadmin also or I should do something else for it ?

    Thank you
     
  9. eva2000

    eva2000 Administrator Staff Member

    39,155
    8,647
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,296
    Local Time:
    3:21 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    acme.sh cron renews all ssl certs created via acme.sh and thus via acmetool.sh addon.
     
    • Informative Informative x 1
  10. alex_cmm

    alex_cmm New Member

    4
    3
    3
    Apr 2, 2019
    Ratings:
    +3
    Local Time:
    7:21 PM
    Well I am using Adminer instead of phpmyadmin. Single php file, less then 500 kb in size. You just need to put it in public folder of your domain, rename it and you are done :)

    Adminer: https://www.adminer.org/

    You just rename it into something like this:

    Code:
    From adminer-4.7.1.php
    
    Into something like this:
    
    Q3TjHmau67xwsB6E7ZUCXYhJuQJuY23q.php
     
  11. eva2000

    eva2000 Administrator Staff Member

    39,155
    8,647
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,296
    Local Time:
    3:21 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    I would put it in a http password and/or IP restricted directory instead or even on a nginx vhost created site on a subdomain without a valid DNS entry and just use local host file edit on your local pc devices etc + http password and/or IP restricted directory so only you can resolve the subdomain to access it. Much safer :)
     
    • Like Like x 3
  12. alex_cmm

    alex_cmm New Member

    4
    3
    3
    Apr 2, 2019
    Ratings:
    +3
    Local Time:
    7:21 PM
    Well I only need to import my .sql file into db and delete adminer .php file from my vps. No need to hold it there :)
     
..