Join the community today
Become a Member

phpmyadmin.sh Addon

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

  1. pamamolf

    pamamolf Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.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

    54,583
    12,224
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,793
    Local Time:
    3:31 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.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

    54,583
    12,224
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,793
    Local Time:
    3:31 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.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 Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.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

    54,583
    12,224
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,793
    Local Time:
    3:31 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    What did you manually had to change ?
     
  8. pamamolf

    pamamolf Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.x
  9. eva2000

    eva2000 Administrator Staff Member

    54,583
    12,224
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,793
    Local Time:
    3:31 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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 Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.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 Premium Member Premium Member

    4,084
    428
    83
    May 31, 2014
    Ratings:
    +834
    Local Time:
    7:31 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    I don't reinstall it without removing it first.

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

    Any ideas?

    Thanks in advance !