Want more timely Centmin Mod News Updates?
Become a Member

phpmyadmin.sh Addon

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

  1. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    no semi-colon as it's php-fpm config file not nginx

    phpmyadmin.sh addon needs to uncomment and enable in php-fpm.conf (does it automatically on phpmyadmin.sh install runs) as phpmyadmin.sh's unix socket for php is located at /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf
    Code (Text):
    include=/usr/local/nginx/conf/phpfpmd/*.conf
    


    if it's commented out, phpmyadmin unix socket in /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf will fail to load and php will be down for phpmyadmin = 502 error
     
  2. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    i just tested myself install phpmyadmin.sh and then upgrade php and it works fine for me, login and log out etc
     
  3. pamamolf

    pamamolf Well-Known Member

    2,469
    223
    63
    May 31, 2014
    Ratings:
    +382
    Local Time:
    9:39 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    confused :(

    Code:
    /usr/local/etc/php-fpm.conf 
    That file is using ; for commenting correct?

    So having uncomment :
    Code:
    include=/usr/local/nginx/conf/phpfpmd/*.conf
    it will be ok if i use or not phpmyadmin and doesn't mean that i use multiple pools and will not cause any issues?

    As at this path are:
    Code:
    phpfpm_pool2.conf  phpfpm_pool3.conf  phpfpm_pool4.conf  phpfpm_pool5.conf
    and will be loaded....
     
  4. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    oh i thought you mean ending semi-colon as in nginx synax

    commenting in front with semi-colon ; is correct for php-fpm.conf
     
  5. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    uncommented then multiple php-fpm pools AND phpmyadmin.sh installed instance all work

    multiple php-fpm pools only work if you configure them as per https://community.centminmod.com/th...03-multiple-php-fpm-pools-support-added.3672/
     
  6. pamamolf

    pamamolf Well-Known Member

    2,469
    223
    63
    May 31, 2014
    Ratings:
    +382
    Local Time:
    9:39 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    So if i have the include line enabled to get the phpmyadmin work and have the rest edits for multiple pools disabled that means that multiple pools config files will be loaded but multiple pools will not work?

    Is there a way for you to separate the phpmyadmin and multiple pools or the configs of them maybe?
     
  7. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    yup
    no way
     
    • Informative Informative x 1
  8. pamamolf

    pamamolf Well-Known Member

    2,469
    223
    63
    May 31, 2014
    Ratings:
    +382
    Local Time:
    9:39 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Please verify that having:

    Code:
    include=/usr/local/nginx/conf/phpfpmd/*.conf
    and

    Code:
        fastcgi_pass   127.0.0.1:9000;
        #fastcgi_next_upstream error timeout http_500 http_503;
        #fastcgi_pass phpbackend;
        #fastcgi_keep_conn on;
    Multiple pools will be disabled ...... ?
     
  9. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    yup
     
  10. elargento

    elargento Member

    240
    16
    18
    Jan 4, 2016
    Ratings:
    +31
    Local Time:
    3:39 AM
    10
    phpmyadmin URL was loading in HTTPS (I think it was LetEncrypt since I haven't set up any SSL). However the browser doesn't recognize the certificate now and I think that happened after I restarted mysql service.

    Any ideas?
     
  11. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
  12. elargento

    elargento Member

    240
    16
    18
    Jan 4, 2016
    Ratings:
    +31
    Local Time:
    3:39 AM
    10
  13. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    ah will have to check then and update docs accordingly :)
     
  14. elargento

    elargento Member

    240
    16
    18
    Jan 4, 2016
    Ratings:
    +31
    Local Time:
    3:39 AM
    10
    I'm getting a HSTS error and can't load phpmyadmin in Chrome:
    [​IMG]

    This is a screenshot I took from another website. How can I open the admin panel on Chrome? On Edge it works fine and I get the popup asking for htaccess username and password
     
  15. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    Are the host.domain.com and HTTPS enabled site also on same top level domain.com ? did you enable HSTS with include subdomain too ? if you did then you're telling browsers to force HTTP to HTTPS redirected connections for domain.com and any *.domain.com subdomain as well

    see Enabling HSTS for SSL for specifics
    As accessing host.domain.com is usually reserved for stats and admin pages the Centmin Mod LEMP stack owner only needs to access, you can just clear your web browser's HSTS record for the domain.com and host.domain.com so the web browser no longer redirects from HTTP to HTTPS. I posted a thread at SSL - How to clear HSTS browser cache | Centmin Mod Community specifically for this :)
     
  16. pamamolf

    pamamolf Well-Known Member

    2,469
    223
    63
    May 31, 2014
    Ratings:
    +382
    Local Time:
    9:39 AM
    Nginx-1.13.x
    MariaDB 10.1.x
    Is it possible to add a check and display a more friendly error when a user exist and fail to create it?

    Code:
    ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'user123'@'localhost'
    That's the error when a user exists...

    thanks :)
     
  17. eva2000

    eva2000 Administrator Staff Member

    28,348
    6,438
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,533
    Local Time:
    4:39 PM
    Nginx 1.13.x
    MariaDB 5.5
    Not really needed that is MySQL's own error message which I can't intercept.
     
    • Informative Informative x 1