phpmyadmin ignores port on login page

Question

I've built a docker container with the following (all on one container) :

mysql Ver 8.0.29-0ubuntu0.20.04.2 for Linux on x86_64((Ubuntu))
Apache/2.4.41 (Ubuntu)
phpmyadmin 4:4.9.5+dfsg1-2
PHP 7.4.3

On localhost/phpmyadmin, I fail to log in if I don't manually set the host directive in /etc/phpmyadmin/config.inc.php, for example:

$cfg['Servers'][$i]['host'] = "{$dbserver}:{$cfg['Servers'][$i]['port']}";
$cfg['Servers'][$i]['host'] = $dbserver.':'.$dbport
$cfg['Servers'][$i]['host'] = "{$dbserver}:3306";
$cfg['Servers'][$i]['host'] = "localhost:3306";

Essentially, dbport is ignored in the config file

If I leave $cfg['Servers'][$i]['host'] = $dbserver it fails. even though $cfg['Servers'][$i]['port'] is set.

The file config.inc.php (default one, aside from the host directive):


The file config-db.php

The file Dockerfile: (built with docker build -t test . and run with docker run -d -p 80:80 test)
FROM ubuntu:20.04
MAINTAINER Sheed
RUN apt-get update
RUN apt-get -y upgrade
RUN DEBIAN_FRONTEND=noninteractive apt -y install apache2 php libapache2-mod-php mysql-server php-mysql phpmyadmin
COPY ./config-db.php /etc/phpmyadmin/config-db.php
COPY ./config.inc.php /etc/phpmyadmin/config.inc.php
RUN cp /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
RUN a2enconf phpmyadmin
COPY ./init.sh /init.sh
COPY ./start.sh /start.sh
RUN bash /init.sh
CMD ["bash", "start.sh"]

The file init.sh:
#!/bin/bash

service mysql start
mysql -u root --password= -e "CREATE USER 'admin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'admin';"
mysql -u root --password= -e "GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';"
mysql -u root --password= -e "FLUSH PRIVILEGES;"

The file start.sh:
#!/bin/bash

service mysql start
apachectl -D FOREGROUND

By manually setting as examplified above and setting dbport, the header on PHPMyAdmin shows : localhost:3306:3306,twice the port, which is strange that it does include the port there but not for login requests

user_436560 · Answer

Fact

You have

$dbport='3306';

and

$cfg['Servers'][$i]['host'] = "{$dbserver}:{$cfg['Servers'][$i]['port']}";

So, putting the host and the port together you get the resulting duplicate port, because

"host:port" . ":" . "port" === "host:port:port"

So, the technical answer to your question is that you get duplicated ports because you have added the port to the host and left the port value for the port.

Theory

Even though the reason of your port being duplicated is clear (see the Fact section), we need to know why you need to duplicate the port.

First of all, you will need to check whether you really need to duplicate the port (changing $dbport to '' is a test, for instance) and you will also need to look into the error that you get from PHPMyAdmin. If you want to research this further, you can ask a separate question about the cause of the issue here on stackoverflow.

This is just an educated guess, but to me it seems that your Docker container uses port 3306 (the port you needed to add to the host) and, your Docker container also uses PORT 3306 to reach your database.

A simplification would be possible to make sure that you have a container that's reachable from port 80 for example and acts as a proxy to your other container that can be reached at port 3306. But this is only an opinion, the actual answer to your question can be found in the Fact section.

phpmyadmin ignores port on login page

1 Answers

Fact

Theory