Concerning phpMyAdmin : do you install it on all web server or just one ?

thank you for you helps. but it's really hard , here.

 

rahhhhhhhhhhhhhhhhhhhh :
thinnk successful login .... BU :

ERROR 404 - Not Found!
The following error occurred:
The requested URL was not found on this server.

Please check the URL or contact the webmaster.

note : the url is like that : https://db3.domain.com/index.php

 

Weirddness ... if i click on back button of browser ... phpmyadmin appear with my user connected , what that ?

(is it nomral that we can see: information_schema database ?)

 

On each webserver, i do : (following phpmyadmin part , https://www.howtoforge.com/perfect-...g-3.1/#-install-nginx-php-phpfpm-and-fcgiwrap : perhaps this i my mistake ????)

nano /usr/share/phpmyadmin/config.inc.php
then change :
$cfg['Servers'][$i]['host'] = 'localhost';
to
$cfg['Servers'][$i]['host'] = 'dbx.domain.com';

Did need to change another thing ?

(but i need to create dbx.domain.com website for admin user, inorder to have ssl cert for https://dbx.domain.com/phpmyadmin)

 

or perhaps something wrong here ?

location /phpmyadmin {
root /usr/share/;
index index.php index.html index.htm;
location ~ ^/phpmyadmin/(.+\.php)$ {
try_files $uri =404;
root /usr/share/;
fastcgi_pass unix:/var/run/php/php7.3-fpm.sock;
fastcgi_param HTTPS on; # <-- add this line
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $request_filename;
include /etc/nginx/fastcgi_params;
fastcgi_param PATH_INFO $fastcgi_script_name;
fastcgi_buffer_size 128k;
fastcgi_buffers 256 4k;
fastcgi_busy_buffers_size 256k;
fastcgi_temp_file_write_size 256k;
fastcgi_intercept_errors on;
}
location ~* ^/phpmyadmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
root /usr/share/;
}
}
location /phpMyAdmin {
rewrite ^/* /phpmyadmin last;
}​

 

the config file is strange too :

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'dbx.domain.com';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

/**
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'phpmyadminpassword';

 

i've got phpmyadmin , web page but after sending credentials :

the link became :
https://db3.domain.com/index.php?server=2

instead of the one that work befpore sending credentials ...
https://db3.domain.com/phpmyadmin/

 

i think there is an issue in ispconfig redir ...
Because when auth success i got :
ERROR 404 - Not Found!

and if i use back button of breiwser sometimes it show me the phpmyadmin panel ...

 

if i try to put bad password i got this :
mysqli_real_connect(): (HY000/1045): Access denied for user 'c2_user1'@'web.domain.com' (using password: YES)
but no error 404

 

hello Till,
thank you for answering.
Yes but with multi server server ?

and after ERROR 404
if manually modify the url :
https://db3.domain.com/phpmyadmin/index.php?server=2
(instead of : https://db3.domain.com/index.php?server=2)
the phpmyadmin panel is showing up.

this is an issue of URL rewriting with nginx ...

 

i'm not sure you use it with one web server (web1) and a database server (db1)

 

i'm using this builtin redirection : https://[SERVERNAME]/phpmyadmin
can you give me the task in order to activate phpmyadmin in webgui of ispconfig ? (i follow your howto for install it)
and if i want let's encrypt on db1.domain.com/phpmyadmin ... i need to create a site , named db1.domain.com which is the database server name ...
i don't see how i can to another way ....

 

oups : so i must install nginx on db server too ? (if you said : install phpmyadmin on db server ...)

 

hummmmm !!

db3.domain.com is a cname of web3.domain .com !!!
(this is the same public ip BUT, in /usr/share/phpmyadmin/config.inc.php i'm using LOCAL IP address of db3.domain.com server.