Log in to phpmyadmin via the admin panel in 1 click

glonin.kz · March 13, 2022, 7:10am

Good afternoon developers, I remember this item was in trouble that year, well, it was postponed for release and due to difficulties in implementation, will this feature appear in future updates or should it not be expected?. I would also like to know if there will be php compositor support from the panel

Felix · March 13, 2022, 7:43am

If you are talking about phpMyAdmin Single Sign On, then it works fine for me. I have enabled it at Hestia UI Settings > Databases and made sure I followed the docs here PhpMyAdmin Single Sign On — Hestia Control Panel documentation

glonin.kz · March 13, 2022, 8:37am

I meant when you click on the database, it immediately enters it as authorized

glonin.kz · March 13, 2022, 8:45am

Judging by the instructions, I select the API, specify the IP address of my server, and I get Page Not Found when I click on the database entry

eris · March 13, 2022, 8:59am

Make sure you access Hestia via hostname.domain.com and not over ip

glonin.kz · March 13, 2022, 9:02am

Page Not Found

Tried to disable and display ip, tried to exit via ip+port

glonin.kz · March 13, 2022, 9:05am

Or do you need to enter a password here?

Raphael · March 13, 2022, 9:08am

you’ve a proxy redirect to 8083 there, this can’t work because you cant reach phpmyadmin on port 8083. Also do not post hostnames or even full links with one click login creds into the wild…

eris · March 13, 2022, 9:26am

In that case

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

and

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:

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

and

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

The have the correct rules to allow for phpmyadmin to remain accessble

glonin.kz · March 13, 2022, 12:15pm

According to the configs, everything goes as above, where else can you dig to solve the problem?

eris · March 13, 2022, 3:15pm

Check your error logs of the domain

glonin.kz · March 14, 2022, 6:28pm

http://joxi.ru/KAgVW7qU5a5382
176.124.134.234 - - [14/Mar/2022:22:22:51 +0500] “GET /phpmyadmin//hestia-sso.php?database=admin&user=admin&exp=164754184&hestia_token=$2y$10$/.td8fwbKnWYXZun5IlrckQt8PQytjMiccFau HTTP/2.0” 404 1430 “cp.glonin.kz - login - Панель управления Hestia” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36”

the strange thing is that when you click on the link https://my.domain.kz/phpmyadmin/hestia-sso.php we get 404
although there is a physical file

https://my.domain.kz/phpmyadmin/index.php is served from this directory normally