Want more timely Centmin Mod News Updates?
Become a Member

phpmyadmin.sh Addon

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

  1. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    Today i did one more installation on another server and all was working great but i had to do the custom edits for ssl.

    It's weird how it worked on the previous server but anyway...

    Do i have to adjust anything for getting the updates with the new install method?

     
  2. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    How old is the Centmin Mod install ? and have you previously edited /usr/local/nginx/conf/php.conf include file as 130.00beta01 was updated to combat one issue https://community.centminmod.com/threads/add-phpmyadmin-php-base-template-in-130-00beta01.24994/ Centmin Mod 124.00stable or 130.00beta01 fresh install ?
    phpmyadmin-tar.sh uses updated cronjob auto update routine to use tarball tar.gz method so no changes needed
     
  3. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    That installation was a few years ago using:

    Code:
    yum -y update; curl -O https://centminmod.com/betainstaller73.sh && chmod 0700 betainstaller73.sh && bash betainstaller73.sh
    About any edits on /usr/local/nginx/conf/php.conf i don't remember....

    130.00beta01 install
     
  4. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    compare the contents of existing /usr/local/nginx/conf/php.conf with one in Centmin Mod 130.00beta01 default templates at /usr/local/src/centminmod/config/nginx/php.conf

    via diff compare check
    Code (Text):
    diff -u /usr/local/nginx/conf/php.conf /usr/local/src/centminmod/config/nginx/php.conf
     
  5. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    Results:


    Code:
    --- /usr/local/nginx/conf/php.conf      2024-04-16 22:11:48.514856551 +0000
    +++ /usr/local/src/centminmod/config/nginx/php.conf     2022-09-06 13:18:56.231517500 +0000
    @@ -7,7 +7,7 @@
         #fastcgi_keep_conn on;
         fastcgi_pass dft_php;
         #fastcgi_pass   127.0.0.1:9000;
    -    #fastcgi_pass   unix:/tmp/php5-fpm.sock;
    +    #fastcgi_pass   unix:/var/run/php-fpm/php-fpm.sock;
         fastcgi_index  index.php;
         #fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
         fastcgi_param  SCRIPT_FILENAME    $request_filename;
    @@ -24,7 +24,7 @@
     fastcgi_connect_timeout 360s;
     fastcgi_send_timeout 360s;
     fastcgi_read_timeout 360s;
    -fastcgi_buffer_size 512k;
    +fastcgi_buffer_size 32k;
     fastcgi_buffers 512 32k;
     fastcgi_busy_buffers_size 1m;
     fastcgi_temp_file_write_size 4m;
    @@ -88,4 +88,4 @@
     # PHP only, required if PHP was built with --enable-force-cgi-redirect
     fastcgi_param  REDIRECT_STATUS    200;
     
    -                   }
    +                   }
    \ No newline at end of file
    Thanks in advance !
     
  6. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    I just test it on brand new installation on Alma Linux using:

    installer-el8x-82.sh

    and the https doesn't work for PhpMyadmin and i had to do it manually...

    and i didn't adjust any settings...

    Diff results:

    Code:
    --- /usr/local/nginx/conf/php.conf      2024-04-23 14:10:43.487883391 +0100
    +++ /usr/local/src/centminmod/config/nginx/php.conf     2024-04-23 13:47:44.800933967 +0100
    @@ -7,7 +7,7 @@
         #fastcgi_keep_conn on;
         fastcgi_pass dft_php;
         #fastcgi_pass   127.0.0.1:9000;
    -    #fastcgi_pass   unix:/run/php-fpm/php-fpm.sock;
    +    #fastcgi_pass   unix:/var/run/php-fpm/php-fpm.sock;
         fastcgi_index  index.php;
         #fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
         fastcgi_param  SCRIPT_FILENAME    $request_filename;
     
  7. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    What did you manually had to change ?
     
  8. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
  9. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Oh you're not suppose to issue Letsencrypt SSL certificate for main hostname. For fresh Centmin Mod Install, first time phpmyadmin.sh install afterwards for 2nd or third time phpmyadmin.sh install, did you run uninstall script first? Or you running phpmyadmin.sh installer again without running uninstaller first ?
     
  10. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    Each time it's on different server :)

    First time on server that had already PhpMyadmin that i uninstall first as you mention and then install with the new method and https was working without touching anything. Not sure how it had a valid certificate.

    Then on a second server with existing Centminmod i did the same. Uninstall and install using the new method but https was not working (no valid certificate) and i had to do the manual edits to make it work.

    Today on a third new server i did a clean install of Centminmod and i install directly Phpmyadmin using the new method and https was not working (no valid certificate) and i had to do the manual edits to make it work.

    I hope now is more clear as my English is not good at all :)
     
  11. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    5:09 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    I don't reinstall it without removing it first.

    One of the above is on clean install too...

    Any ideas?

    Thanks in advance !
     
  12. mknobbe

    mknobbe New Member

    16
    3
    3
    Jul 12, 2022
    Ratings:
    +13
    Local Time:
    9:09 PM
    Nginx 1.31.0
    Maria DB 11.4.x
    Running php 8.1.33, AlmaLinux 9
    Had transferred data from a Centos 7 install including phpmyadmin which threw a 502 error when I ran it. Uninstall/Re-Install was my choice to fix.

    The phpmyadmin install would bomb on the composer part

    Specifically

    Code:
    Loading composer repositories with package information
    
    In Process.php line 147:
    
      The Process class relies on proc_open, which is not available on your PHP i
      nstallation.
    
    
    Leading to the dreaded
    Screenshot 2025-11-12 132255.jpg

    proc_open isn't disabled. An extensive google search everywhere couldn't seem to point me in a direction on how to enable/fix/install this.

    If this is a known issue, perhaps i was pulling a funky phpmyadmin installer because in retrospect I might have just pulled a random git pull from centminmod

    ----------------------------------------------------------
    However, running the Zip installer listed below worked perfectly.

     
  13. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Thanks for heads up. Definitely will need to look into this :)
     
  14. redbird

    redbird Member

    109
    15
    18
    Aug 28, 2015
    Web
    Ratings:
    +29
    Local Time:
    12:09 PM
    Hi just installed centminmod 140 beta on almalinux 9 and having issues installing phpmyadmin.sh

    By the way in almalinux 9 service command needs to be replaced with systemctl as it throws errors everywhere in the phpmyadmin.sh phpmyadmin_uninstall.sh including shortcuts such as ngxrestart.

    So I tried installing from git, from zip from tar options always having the same issue: 403 error.
    it does pops a user/pass popup at some point but after entering correct credentials it just ends with 403 access denied blue screen of death.

    Need some help in resolving this @eva2000 if possible
     
    Last edited: Feb 4, 2026
  15. Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    7:09 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    I have never had good success installing this either. Might give it another go soon....
     
  16. redbird

    redbird Member

    109
    15
    18
    Aug 28, 2015
    Web
    Ratings:
    +29
    Local Time:
    12:09 PM
    @eva2000 can you please look into this?
     
  17. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    what is output for these 3 commands
    Code (Text):
    python --version
    python3 --version
    cminfo versions
    
     
  18. redbird

    redbird Member

    109
    15
    18
    Aug 28, 2015
    Web
    Ratings:
    +29
    Local Time:
    12:09 PM
    Code:
    [22:10][root@ovh1 ~]# python --version
    -bash: python: command not found
    [22:10][root@ovh1 ~]# python3 --version
    Python 3.9.25
    [22:10][root@ovh1 ~]# cminfo versions
    
    Installed:
      tree-1.8.0-10.el9.x86_64
    
    
    Installed:
      smem-1.5-11.el9.x86_64
    
    
    1st:
    140.00beta01.b283 #Sun Feb  1 10:25:30 PM UTC 2026
    ..
    last 10:
    140.00beta01.b283 #Sun Feb  1 10:25:30 PM UTC 2026
    140.00beta01.b283 #Sun Feb  1 10:58:55 PM UTC 2026
    140.00beta01.b283 #Sun Feb  1 11:02:50 PM UTC 2026
    140.00beta01.b283 #Mon Feb  2 04:28:30 PM UTC 2026
    
     
  19. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    12:09 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Ok updated phpmyadmin.sh installer to use zip method of install and update by default so try this

    Code (Text):
    # uninstall existing phpmyadmin install
    /root/tools/phpmyadmin_uninstall.sh
    
    # download phpmyadmin.sh
    cd /usr/local/src/centminmod/addons
    wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh -O phpmyadmin.sh
    
    # permissions
    chmod 0700 /usr/local/src/centminmod/addons/phpmyadmin.sh
    
    # install phpmyadmin lastest stable
    ./phpmyadmin.sh install
    
     
  20. redbird

    redbird Member

    109
    15
    18
    Aug 28, 2015
    Web
    Ratings:
    +29
    Local Time:
    12:09 PM
    I mentioned in the first post that I tried all three methods: git, zip and tar. all lead to the same 403 error (

    Also what about replacing "service" with "systemctl"? in those addons and shortcuts. Can it somehow be recognized which OS is used and use appropriate syntax to properly restart nginx and phpfpm?

    Another thing I noticed in the log was: line 237: python: command not found
    Could that be an issue?