Join the community today
Become a Member

Install phpmyadmin install

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Itworx4me, Aug 17, 2019.

  1. Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    5:20 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    I just tried to install phpmyadmin. Everything seems to install correctly expect for the web url. https://firegrilled/******_mysqladmin*****. How do I fix the web url ?

    Thanks,
    Itworx4me

     
  2. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    3:20 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    What's the problem with the url ?
     
  3. Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    5:20 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    Its just showing my hostname and not the full url. There should be a .com in the url.
     
  4. pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    3:20 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    It is designed to work with the hostname....

    For more details eva2000 can provide more details...

    usually i set a domain like mydomain.com and as hostname server.mydomain.com and all working great...
     
  5. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    10:20 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Ensure main hostname is setup as per step 1 of Getting Started Guide where main hostname is not the same as a site's nginx vhost domain name. They have to be different as outlined in the difference and summary of Getting Started Guide.
    This allows the main hostname vhost to house all the PHP and nginx statistic pages and phpmyadmin urls.
    • So ensure the server_name listed in main hostname vhost at /usr/local/nginx/conf/conf.d/virtual.conf isn't referenced in other nginx domain vhost files.
    Post contents of these files wrapped in BBCODE CODE tags
    • /usr/local/nginx/conf/conf.d/virtual.conf
    • /usr/local/nginx/conf/conf.d/phpmyadmin_ssl.conf
    • /usr/local/nginx/conf/phpmyadmin.conf
     
  6. Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    5:20 PM
    Nginx 1.27.4
    MariaDB 10.6.21
    I did a fresh install and still get this error 526: https://firegrilled.food-karts.com/28325_mysqladmin21003

    Code (Text):
    server {
                listen 80 default_server backlog=2048 reuseport;
                server_name firegrilled.food-karts.com;
                root   html;
    
            access_log              /var/log/nginx/localhost.access.log     combined buffer=256k flush=5m;
            error_log               /var/log/nginx/localhost.error.log      error;
    
    # ngx_pagespeed & ngx_pagespeed handler
    #include /usr/local/nginx/conf/pagespeed.conf;
    #include /usr/local/nginx/conf/pagespeedhandler.conf;
    #include /usr/local/nginx/conf/pagespeedstatslog.conf;
    
    # limit_conn limit_per_ip 16;
    # ssi  on;
    
            location /nginx_status {
            stub_status on;
            access_log   off;
            allow 127.0.0.1;
            #allow youripaddress;
            deny all;
            }
    
                location / {
    
    # block common exploits, sql injections etc
    #include /usr/local/nginx/conf/block.conf;
    
    #Enables directory listings when index file not found
    #autoindex  on;
    
    #Shows file listing times as local time
    #autoindex_localtime on;
    
    # Wordpress Permalinks example
    #try_files \$uri \$uri/ /index.php?q=\$uri&\$args;
                
                }
    
    include /usr/local/nginx/conf/phpmyadmin.conf;
    include /usr/local/nginx/conf/staticfiles.conf;
    include /usr/local/nginx/conf/include_opcache.conf;
    include /usr/local/nginx/conf/php.conf;
    #include /usr/local/nginx/conf/phpstatus.conf;
    include /usr/local/nginx/conf/drop.conf;
    #include /usr/local/nginx/conf/errorpage.conf;
    #include /usr/local/nginx/conf/vts_mainserver.conf;
    
           }


    Code (Text):
    # https SSL SPDY phpmyadmin
    server {
            listen 443 ssl http2;
                server_name firegrilled.food-karts.com;
                root   html;
    
    keepalive_timeout  3000;
    
     client_body_buffer_size 256k;
     client_body_timeout 3000s;
     client_header_buffer_size 256k;
    ## how long a connection has to complete sending
    ## it's headers for request to be processed
     client_header_timeout  60s;
     client_max_body_size 512m;
     connection_pool_size  512;
     directio  512m;
     ignore_invalid_headers on;
     large_client_header_buffers 8 256k;
    
            ssl_certificate      /usr/local/nginx/conf/ssl/firegrilled.food-karts.com.crt;
            ssl_certificate_key  /usr/local/nginx/conf/ssl/firegrilled.food-karts.com.key;
            ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
            ssl_session_cache      shared:SSL:10m;
            ssl_session_timeout  10m;
            # mozilla recommended
            ssl_ciphers EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA256:EECDH+ECDSA+SHA384:EECDH+aRSA+SHA256:EECDH+aRSA+SHA384:EECDH+AES128:!aNULL:!eNULL:!LOW:!3DES:!MD5:!EXP:!PSK:!SRP:!DSS:!RC4:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!CAMELLIA;
            ssl_prefer_server_ciphers   on;
            #add_header Alternate-Protocol  443:npn-spdy/3;
            #add_header Strict-Transport-Security "max-age=0; includeSubdomains;";
            add_header X-Frame-Options SAMEORIGIN;
            #spdy_headers_comp 5;
            ssl_buffer_size 1400;
            ssl_session_tickets on;
    
      # limit_conn limit_per_ip 16;
      # ssi  on;
    
            access_log              /var/log/nginx/localhost_ssl.access.log     main;
            error_log               /var/log/nginx/localhost_ssl.error.log      error;
    
    # ngx_pagespeed & ngx_pagespeed handler
    #include /usr/local/nginx/conf/pagespeed.conf;
    #include /usr/local/nginx/conf/pagespeedhandler.conf;
    #include /usr/local/nginx/conf/pagespeedstatslog.conf;
    
        location / {
            return 302 http://$server_name$request_uri;
        }
        
      include /usr/local/nginx/conf/phpmyadmin_https.conf;
      include /usr/local/nginx/conf/staticfiles.conf;
      #include /usr/local/nginx/conf/php.conf;
      include /usr/local/nginx/conf/drop.conf;
      include /usr/local/nginx/conf/errorpage.conf;
    }


    Code (Text):
    location ^~ /28325_mysqladmin21003/ {
            rewrite ^/(.*) https://firegrilled.food-karts.com/$1 permanent;
    }


    Thanks,
    Itworx4me
     
  7. eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    10:20 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
  8. Itworx4me

    Itworx4me Premium Member Premium Member

    339
    35
    28
    Mar 14, 2017
    Ratings:
    +65
    Local Time:
    5:20 PM
    Nginx 1.27.4
    MariaDB 10.6.21