Learn about Centmin Mod LEMP Stack today
Become a Member

phpmyadmin.sh Addon

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

  1. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    @Andy got the same PHP - PHP 7.0.0RC releases + Centmin Mod Updating PHP-FPM | Centmin Mod Community but I haven't experienced this.. what VPS virtualisation you using ? Xen, OpenVZ, KVM ? OS used ? CentOS 6 or 7 ?
    edit: oh i believe that is because after centmin.sh menu option 23 submenu option 1 or 3, you did not exit out centmin.sh and change to /usr/local/src/centminmod directory again
     
  2. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Yup the problem was that i was using the centminmod09beta directory and after running the update it turns to simple centminmod folder and i run centmin command before i run the script again and the shortcut was not working.

    Then i run the script once and then all working fine now no nginx errors and no shortcut error :)

    Thanks
     
  3. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    yes /usr/local/src/centminmod is the new standard folder for .08 stable and higher so if centmin.sh runs it auto fixes that for future .08+ and higher builds. The problem is if you're coming from .07 stable or older and transition to .08 stable. Once you run .08 stable's centmin.sh it auto fixes this
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Now from https when i accept the certificate on the browser it auto goes to http and phpmyadmin is not working :(

    Code:
    # https SSL SPDY phpmyadmin
    server {
            listen 443 ssl http2;
                server_name server.mytestdomain.com;
                root   html;
    and i comment this:

    Code:
    #        spdy_headers_comp 6;
    My nano /etc/hosts :
    Code:
    127.0.0.1  localhost server
    104.xxx.xxx.xxx server.mytestdomain.com server
     
  5. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  6. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Done working now :)
     
  7. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  8. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
  9. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    cheers, doh typo ! will leave it heh
     
  10. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    And what it will be happened if i have both to yes?

    Code:
    NGINX_HTTP2=y
    NGINX_SPDY=y
     
  11. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  12. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    On a new reinstall i got this:

    Code:
    Cloning into '32401_mysqladmin7339'...
    fatal: Cannot update paths and switch to branch 'STABLE' at the same time.
    Did you intend to checkout 'origin/STABLE' which can not be resolved as commit?
    And the default installation is giving me a 404 not found :(

    But i have the correct info here by default installation:

    Code:
     listen 443 ssl http2;
    server_name server.mydomain.com;
    Using:

    Code:
    https://mydomain.com/32401_mysqladmin7339/
    or
    https://myserverip/32401_mysqladmin7339/
    I can see a certificate error that doesn't match it's address ....

    My /etc/hosts :

    Code:
    127.0.0.1   localhost server
    104.238.189.109 server.mydomain.com server
     
    Last edited: Aug 28, 2015
  13. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    did you uninstall first ?
     
  14. KeVo

    KeVo Active Member

    180
    71
    28
    May 28, 2014
    Ratings:
    +101
    Local Time:
    4:48 AM
    1.11.x
    10.1.18
  15. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    is this an old Centmin Mod install upgraded through major versions i.e. .07 stable to .08 stable or phpmyadmin created via .08 stable+ and higher ?

    if you have a valid hostname.domain.com that resolves in DNS via valid DNS A record entry in server_name for main hostname Nginx vhost at /usr/local/nginx/conf/conf.d/virtual.conf then it should only work via hostname.domain.com. It shouldn't actually work with ip address in latest version of phpmyadmin.sh

    you can try uninstall via
    Code:
    /root/tools/phpmyadmin_uninstall.sh
    and download latest copy of phpmyadmin.sh from phpmyadmin/phpmyadmin.sh at master · centminmod/phpmyadmin · GitHub and reinstall
     
  16. KeVo

    KeVo Active Member

    180
    71
    28
    May 28, 2014
    Ratings:
    +101
    Local Time:
    4:48 AM
    1.11.x
    10.1.18
    It actually happened for me via both means, but I'll give the latest copy a try and report back.
     
  17. pamamolf

    pamamolf Premium Member Premium Member

    3,885
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    12:48 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    My installation is based on a clean (format server Centos 7.1) Centminmod install 09 beta and latest phpmyadmin.sh ...... :(
     
  18. Sunka

    Sunka Well-Known Member

    1,142
    313
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +510
    Local Time:
    11:48 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    installed phpmyadmin 10 minutes ago, and this tip solved problem for log in.
    One question, could I manually somewhere edit username and password for htaccess login?
     
  19. eva2000

    eva2000 Administrator Staff Member

    45,663
    10,362
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,081
    Local Time:
    8:48 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    like xenforo admin password protection you can do same for phpmyadmin addon

    Code:
    /usr/local/nginx/conf/htpasswd.sh create /usr/local/nginx/conf/htpassphpmyadmin USERNAME PASSWORD
    then restart nginx and php-fpm services
    Code:
    nprestart
     
  20. Sunka

    Sunka Well-Known Member

    1,142
    313
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +510
    Local Time:
    11:48 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    it seems that when I changed to ssl address, phpmyadmin page is show error:
    502 error - Bad gateway

    Any thougts?