Want to subscribe to topics you're interested in?
Become a Member

Install Error 502 after upgrading on phpmyadmin

Discussion in 'Add Ons' started by Shirkit, Jun 27, 2019.

  1. Shirkit

    Shirkit New Member

    6
    1
    3
    Feb 6, 2019
    Ratings:
    +1
    Local Time:
    4:49 PM
    1.15.8
    Hey,

    Before update I was able to remotely access my PhpMyAdmin interface. Now it's giving me error 502 when trying to access it.

    I've attached all relevant files I could think of to try to make it easier

    Please fill in any relevant information that applies to you:
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: 1.17.0
    • PHP Version Installed: 7.2.18
    • MariaDB MySQL Version Installed: 10.1.40-MariaDB
    • When was last time updated Centmin Mod code base ? : About 1month or so
    • Persistent Config: Do you have any persistent config file options set in /etc/centminmod/custom_config.inc ? You can check via this command:
      Code (Text):
      LETSENCRYPT_DETECT='y'
      #NGINX_PAGESPEEDGITMASTER='n'
      NGINX_PAGESPEED='y'
      NGXDYNAMIC_NGXPAGESPEED='y'
      #NGXPGSPEED_VER='1.12.34.2-stable'
      #NGINX_PAGESPEEDPSOL_VER='1.12.34.2'
      MARCH_TARGETNATIVE='n'
      

    Code (Text):
     cat localhost_ssl.error.log
    2019/06/26 19:47:17 [crit] 20404#20404: *112730 connect() to unix:/tmp/phpfpm_myadmin.sock failed (2: No such file or directory) while connecting to upstream, client: 177.xxx.xxx.xxx., server: host.domain.com, request: "GET /1xxx_mysqladminxxx/ HTTP/2.0", upstream: "fastcgi://unix:/tmp/phpfpm_myadmin.sock:", "
    
     
    Last edited by a moderator: Jun 27, 2019
  2. eva2000

    eva2000 Administrator Staff Member

    40,634
    9,023
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,891
    Local Time:
    5:49 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    If you get errrors due to unix:/tmp/phpfpm_myadmin.sock with phpmyadmin installed via phpmyadmin.sh like
    Code (Text):
    connect() to unix:/tmp/phpfpm_myadmin.sock failed (2: No such file or directory) while connecting to upstream
    

    Then it's due to 123.09beta01 updated php-fpm default config so phpmyadmin's php-fpm pool needs to switch over to using TCP instead of unix sockets.

    The fix is to:

    1. uninstall existing phpmyadmin install made via phpmyadmin.sh by running uninstaller
    Code (Text):
    /root/tools/phpmyadmin_uninstall.sh


    2. download updated phpmyadmin.sh as per Addon phpmyadmin.sh - CentminMod.com LEMP Nginx web stack for CentOS
    Code (Text):
    cd /usr/local/src/centminmod/addons
    wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh -O phpmyadmin.sh
    


    3. install phpmyadmin again - the location of install will change as it's randomly generated and unique to each install run
    Code (Text):
    cd /usr/local/src/centminmod/addons/
    ./phpmyadmin.sh install
    
     
    • Winner Winner x 1
  3. Shirkit

    Shirkit New Member

    6
    1
    3
    Feb 6, 2019
    Ratings:
    +1
    Local Time:
    4:49 PM
    1.15.8
    Eva,

    I don't know how you manage to reply in 10 minutes, but thank you very much!

    And thanks for supporting this awesome project. My company would literally not be possible to have an online presence without it.

    Thank you very much!
     
    style="display:inline-block;min-width:400px;max-width:970px;width:95%;height:90px" data-ad-client="ca-pub-6669518204467592" data-ad-slot="4024536743" data-ad-format="auto">
  4. eva2000

    eva2000 Administrator Staff Member

    40,634
    9,023
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,891
    Local Time:
    5:49 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x