Welcome to Centmin Mod Community
Register Now

phpmyadmin.sh Addon

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

  1. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    It doesn't work :(

    /etc/hosts


    Code:
    127.0.0.1  localhost.localdomain localhost
    178.32.217.66  server.domain.com server
    i use as hostname the server.domain.com and for vhost the domain.com so there is no conflicts...

    Also on cloudflare i have a working A record as it was ok before i reinstall the server...
     
  2. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    try run uninstall and reinstall /root/tools/phpmyadmin_uninstall.sh
     
  3. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    also ensure virtual.conf server_name (server.domain.com) is a hostname unique to just that nginx vhost and no other nginx vhosts use same name = server.domain.com as outlined in step 1 of Getting Started Guide
     
  4. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    did you do local pc hosts file edit ? if not server.domain.com resolves to your ISP/dns provider pointed IP and not custom one you set in /etc/hosts
     
  5. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Ok i uninstall it and reinstall it and i have the same issue :(

    Code:
    did you do local pc hosts file edit ? if not server.domain.com resolves to your ISP/dns provider pointed IP and not custom one you set in /etc/hosts
    No i didn't.

    Before i reinstall the server it was ok with hostname....
     
  6. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    that might be the problem if you server.domain.com at your ISP/dns provide points to a different IP from server
     
  7. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Is there anything that i can do for it other than editing my host file?

    Damn yesterday on the same server was working great without any edits on my host file.
     
  8. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    well i just tested 123.09beta01 and phpmyadmins.sh addon install and no problems with accessing the https version of generated phpmyadmin install directory

    you can check all references to that server name to see if other server_names are setup
    Code:
    grep -R 'server.domain.com' /usr/local/nginx/conf/*
     
  9. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    also what's contents of /usr/local/nginx/conf/phpmyadmin.conf
     
  10. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    I just add an entry to my hosts file to test it (as i hate to do it this way) and it's opening now with this error:

    Your connection is not private
    Attackers might be trying to steal your information from server.domain.com(for example, passwords, messages, or credit cards).

    NET::ERR_CERT_AUTHORITY_INVALID

    Then i click proceed and is working great :)

    the grep returns this:

    Code:
    [root@server ~]# grep -R 'server.domain.com' /usr/local/nginx/conf/*
    /usr/local/nginx/conf/conf.d/virtual.conf:            server_name server.domain.com;
    /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf:            server_name server.domain.com;
    /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf:        ssl_certificate      /usr/local/nginx/conf/ssl/server.domain.com.crt;
    /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf:        ssl_certificate_key  /usr/local/nginx/conf/ssl/server.domain.com.key;
    /usr/local/nginx/conf/phpmyadmin.conf:  rewrite ^/(.*) https://server.domain.com/$1 permanent;
    and the phpmyadmin.conf:

    Code:
    location ^~ /13721_mysqladmin32179/ {
            rewrite ^/(.*) https://server.domain.com/$1 permanent;
    }
    
     
    Last edited: Jan 28, 2016
  11. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    yup normal for self-signed ssl certificates :)
     
  12. ndha

    ndha Member

    82
    10
    8
    Sep 28, 2014
    Ratings:
    +29
    Local Time:
    2:29 PM
    Latest
    10
    @eva2000 I had some trouble after reinstall phpmyadmin..
    i got this Screenshot by Lightshot
    it's stuck like that for 3 hours maybe..
    what's wrong with that??
    i need your advice :) Thanks...
     
  13. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    git download was slow, so just terminate process and try again later
     
  14. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Phpmyadmin was ok and now when i open it i am getting this:

    Code:
    Login without a password is forbidden by configuration (see AllowNoPassword)
    but i didn't even click to login......

    And when i login all is ok and then if i click to check anything it goes back to this login page with the same error :(
     
  15. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    tried restart nginx and php-fpm ? and clearing browser cache and restart browser ?
     
  16. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    yup :(

    Now when i login and click in any function i am going back and ask for login again but without any error this time...

    Maybe to try remove and install again the phpmyadmin ?
     
  17. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Found something after installing and reinstalling phpmyadmin:

    Code:
    Feb 04 14:04:07 server.mydomain.com nginx[19762]: Starting nginx: nginx: [emerg] "fastcgi_pass" directive is duplicate in /usr/local/nginx/conf/php_6183_mysqladmin15188.conf:8
    Feb 04 14:04:07 server.mydomain.com nginx[19762]: [FAILED]
     
  18. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    First 12 lines of the file:

    Code:
    location ~ \.php$ {
        try_files $uri =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        ##fastcgi_pass   127.0.0.1:9001;
        fastcgi_next_upstream error timeout http_500 http_503;
        fastcgi_pass phpbackend;
        fastcgi_keep_conn on;
        fastcgi_pass   unix:/tmp/phpfpm_myadmin.sock;
        fastcgi_index  index.php;
        #fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
        fastcgi_param  SCRIPT_FILENAME    $request_filename;
        fastcgi_param PHP_ADMIN_VALUE open_basedir=$document_root/:/usr/local/lib/php/:/tmp/;
    I am using php-fpm pools......

    Ok i comment :

    Code:
        #fastcgi_next_upstream error timeout http_500 http_503;
        #fastcgi_pass phpbackend;
        #fastcgi_keep_conn on;
    and now is working with the same logout without the error problem :(
     
    Last edited: Feb 5, 2016
  19. eva2000

    eva2000 Administrator Staff Member

    50,460
    11,661
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,082
    Local Time:
    5:29 PM
    Nginx 1.25.x
    MariaDB 10.x
    remove
    Code:
    fastcgi_pass phpbackend;
    as phpmyadmin is setup solely to run on it's own unix socket separate from php TCP pools via
    Code:
    fastcgi_pass   unix:/tmp/phpfpm_myadmin.sock;
     
  20. pamamolf

    pamamolf Well-Known Member

    4,022
    421
    83
    May 31, 2014
    Ratings:
    +816
    Local Time:
    10:29 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    now is working but with the same logout issue on any click :(