Fresh install - phpmyadmin - page not found

R0GGER · January 27, 2022, 7:18pm

Fresh install on Debian 11.2.
HestiaCP: v1.5.7

Install command:
sudo bash hst-install.sh --apache yes --phpfpm yes --multiphp yes --vsftpd yes --proftpd no --named yes --mysql yes --postgresql no --exim yes --dovecot yes --sieve no --clamav no --spamassassin no --iptables no --fail2ban no --quota no --api yes --interactive yes --with-debs no --port 8083 --hostname web.domain.tld --email [email protected] --password **** --lang en

When I go to http://web.domain.tl/phpmyadmin or https://web.domain.tl/phpmyadmin, I get Page not Found.
What did I miss?

Raphael · January 27, 2022, 7:23pm

Is web.domain.tld added as webdomain under your admin user? Does pma show up on any other domain hosted on that server?

R0GGER · January 27, 2022, 7:27pm

Yes

No

R0GGER · January 27, 2022, 7:44pm

Log: /var/log/hestia

nginx-error.log:
2022/01/27 20:37:06 [error] 492#0: *485 "/usr/local/hestia/web/phpmyadmin/index.php" is not found (2: No such file or directory), client: 192.168.1.201, server: _, request: "GET /phpmyadmin/ HTTP/1.1", host: "web.domain.tld", referrer: "https://web.domain.tld/list/db/"

Raphael · January 27, 2022, 7:46pm

pma doesnt run under port 8083 or hostname.domain.tld with a proxy pass redirect - it runs under the normal apache2/nginx system. As written, try to use a normal webdomain added to hestia.

R0GGER · January 27, 2022, 7:47pm

/usr/local/hestia/web/phpmyadmin/ does not exist.

eris · January 27, 2022, 7:48pm

Hestia runs under the normal domain

https://domain.com/phpmyadmin/

Raphael · January 27, 2022, 7:50pm

Add yourdomain.tld to a user, set the dns record to it, visit http://yourdomain.tld/phpmyadmin

It looks like you try to access https://web.yourdomain.tld:8083/phpmyadmin…

R0GGER · January 27, 2022, 7:54pm

It looks like you try to access https://web.yourdomain.tld:8083/phpmyadmin…

Nope.

eris · January 27, 2022, 7:58pm

Are you using a template that proxies traffic from https://domain.com to https://domain.com:8083

R0GGER · January 27, 2022, 8:04pm

No.

I on a proxmox server with in between a NGINX proxy for all my services.
Also I am having a other HestiaCP server on Ubuntu 18.04 which works perfectly fine, no issues with PMA.

Raphael · January 27, 2022, 8:09pm

This log shows, that you try to access it under hestia service, which runs on port 8083. A 404 not found should be logged or reported under /home/admin/web/web.domain.tld/logs/

R0GGER · January 27, 2022, 8:46pm

Logs are empty… Pfff…

Raphael · January 27, 2022, 8:49pm

Also your access log? If yes, then there is something wrong in your custom setup…

R0GGER · January 27, 2022, 9:21pm

I used your generator to install HestiaCP, no complicated other packages were installled.
Pff… It took me now about 5 hours to figure this out… Frustrated argg!! I quit. I doesn’t work and will not work.

eris · January 27, 2022, 10:07pm

1.5.6 an 1.5.7 did nothing change regarding phpmyadmin or web

1.5.6 Fixend issue with installer + Upgrade script to “fix” an issue with SSL
1.5.7 Fixed the issues apt keys

As all traffic if forwarded to /usr/local/hestia/web/ folder according your logs I suggest checking out what goes wrong…

Custom setups are impossible for us to debug. And unless you are willing to pay for the time I need to invest into it to test I am not able to do so…

eris · January 28, 2022, 9:54am

So in your Nginx proxy you already forward the traffic from http(s)://domain.com to https://domain.com:8083. If it is done with the Hestia or with any nginx proxy it doesn’t matter.

You have to modify some config to get it working how ever it falls out off scope for us…

I have templates for Nginx + Apache2

github.com

jaapmarcus/web-templates/blob/master/templates/nginx/cp.stpl

#=======================================================================#
# Default Web Domain Template                                           #
# DO NOT MODIFY THIS FILE! CHANGES WILL BE LOST WHEN REBUILDING DOMAINS #
#=======================================================================#

server {
    listen      %ip%:%proxy_ssl_port% ssl http2;
    server_name %domain_idn% %alias_idn%;
    index       index.php index.html index.htm;
    ssl_certificate      %ssl_pem%;
    ssl_certificate_key  %ssl_key%;
    ssl_stapling on;
    ssl_stapling_verify on;
    error_log  /var/log/%web_system%/domains/%domain%.error.log error;

    include %home%/%user%/conf/web/%domain%/nginx.hsts.conf*;

    location / {
        proxy_pass      https://%ip%:8083;
    }

This file has been truncated. show original

github.com

jaapmarcus/web-templates/blob/master/templates/nginx/cp.tpl

#=======================================================================#
# Default Web Domain Template                                           #
# DO NOT MODIFY THIS FILE! CHANGES WILL BE LOST WHEN REBUILDING DOMAINS #
#=======================================================================#

server {
    listen      %ip%:%proxy_port%;
    server_name %domain_idn% %alias_idn%;
    index       index.php index.html index.htm;
        
    include %home%/%user%/conf/web/%domain%/nginx.forcessl.conf*;

    location / {
    return 301 https://%domain_idn%/;
    }

    location /error/ {
        alias   %home%/%user%/web/%domain%/document_errors/;
    }

This file has been truncated. show original

Or Nginx

github.com

jaapmarcus/web-templates/blob/master/templates/nginx/php-fpm/cp.stpl

#=======================================================================#
# Default Web Domain Template                                           #
# DO NOT MODIFY THIS FILE! CHANGES WILL BE LOST WHEN REBUILDING DOMAINS #
#=======================================================================#

server {
    listen      %ip%:%web_ssl_port% ssl http2;
    server_name %domain_idn% %alias_idn%;
    index       index.php index.html index.htm;
    ssl_certificate      %ssl_pem%;
    ssl_certificate_key  %ssl_key%;
    ssl_stapling on;
    ssl_stapling_verify on;
    error_log  /var/log/%web_system%/domains/%domain%.error.log error;

    include %home%/%user%/conf/web/%domain%/nginx.hsts.conf*;

    location / {
        proxy_pass      https://%ip%:8083;
    }

This file has been truncated. show original

github.com

jaapmarcus/web-templates/blob/master/templates/nginx/php-fpm/cp.tpl

#=======================================================================#
# Default Web Domain Template                                           #
# DO NOT MODIFY THIS FILE! CHANGES WILL BE LOST WHEN REBUILDING DOMAINS #
#=======================================================================#

server {
    listen      %ip%:%web_port%;
    server_name %domain_idn% %alias_idn%;
    index       index.php index.html index.htm;
        
    include %home%/%user%/conf/web/%domain%/nginx.forcessl.conf*;

    location / {
    return 301 https://%domain_idn%/;
    }

    location /error/ {
        alias   %home%/%user%/web/%domain%/document_errors/;
    }

This file has been truncated. show original

Those templates are adjusted to allow phpmyadmin to severed on https://domain.com/phpmyadmin even with proxy

R0GGER · January 28, 2022, 10:44am

Why I can’t use http://ip/phpmyadmin/

For security reasons we have decided to disable this option.
Getting Started | Hestia Control Panel

Aha… I defined a new location in my proxy to /phpmyadmin.
Solved.

location /phpmyadmin {
…
proxy_pass http://192.168.1.210:80;

R0GGER · January 28, 2022, 10:50am

Thanks for your help! And sorry for my frustration…

jlguerrero · January 28, 2022, 4:38pm

If you have modified the default template remember that it will be overwritten.

Fresh install - phpmyadmin - page not found

Why I can’t use http://ip/phpmyadmin/

Why I can’t use `http://ip/phpmyadmin/`