/ Register

Learn about Centmin Mod LEMP Stack today
Become a Member

phpmyadmin.sh Addon

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

Previous Thread Next Thread
Loading...
Page 11 of 23
  1. Apr 17, 2017 #201
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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. Apr 17, 2017 #202
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    i just tested myself install phpmyadmin.sh and then upgrade php and it works fine for me, login and log out etc
     
  3. Apr 17, 2017 #203
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:26 AM
    Nginx-1.29.x
    MariaDB 10.6.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. Apr 17, 2017 #204
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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. Apr 17, 2017 #205
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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. Apr 17, 2017 #206
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:26 AM
    Nginx-1.29.x
    MariaDB 10.6.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. Apr 17, 2017 #207
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    yup
    no way
     
  8. Apr 17, 2017 #208
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:26 AM
    Nginx-1.29.x
    MariaDB 10.6.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. Apr 17, 2017 #209
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    yup
     
  10. May 1, 2017 #210
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    10:26 PM
    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. May 1, 2017 #211
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
  12. May 2, 2017 #212
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    10:26 PM
    10
  13. May 2, 2017 #213
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    ah will have to check then and update docs accordingly :)
     
  14. May 31, 2017 #214
    elargento

    elargento Member

    353
    18
    18
    Jan 4, 2016
    Ratings:
    +45
    Local Time:
    10:26 PM
    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. May 31, 2017 #215
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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. Jun 19, 2017 #216
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:26 AM
    Nginx-1.29.x
    MariaDB 10.6.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. Jun 19, 2017 #217
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Not really needed that is MySQL's own error message which I can't intercept.
     
  18. Oct 11, 2017 #218
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    4:26 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    Can we use for phpmyadmin another include directory from:

    to avoid loading the other pools config files?
     
  19. Oct 11, 2017 #219
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:26 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    nope php-fpm can only use one directory
     
  20. Oct 28, 2017 #220
    dcg

    dcg Member

    67
    24
    8
    Oct 17, 2015
    Florida, USA
    Ratings:
    +49
    Local Time:
    9:26 PM
    1.21.x
    10.3.x
    Code:
    git pull
error: Your local changes to the following files would be overwritten by merge:
        composer.lock
Please, commit your changes or stash them before you can merge.
Aborting
Updating b6c9556..b8d0188
2017-10-26 02:19:04 URL:https://getcomposer.org/composer.phar [1852795/1852795] -> "composer.phar" [1]
/root/tools/phpmyadmin_update.sh: line 18: php: command not found

Total phpmyadmin Update Time: 2.544258739 seconds
    I have version 4.7.4 installed. Haven't edited any files just did a phpmyadmin.sh install on Oct 10th 2017. This is the cron job's log output
    phpmyadmin update is failing. Have latest version of phpmyadmin.sh
     
Previous Thread Next Thread
Loading...
Page 11 of 23

.