phpmyadmin / docker

Docker container for phpMyAdmin
https://hub.docker.com/_/phpmyadmin
GNU General Public License v3.0
665 stars 456 forks source link

Cannot login to mysql server #361

Closed sybanyt closed 2 years ago

sybanyt commented 2 years ago

After referencing multiple pages and forums I cannot login to phpmyadmin after setup. I get the error: _Cannot login to the MySQL server. mysqli::realconnect(): (HY000/2002): No such file or directory

Attached is my docker compose file: dockcomp.txt

I have created an admin user aside root with admin privileges. using this account I can docker exec into the mariadb container and login with that account.

I can also login to the mariadb container with the account specified in the docker compose file.

None of these accounts are able to login to the phpmyadmin webui and even though i have specified below in docker compose file, i do not see the server selection option on the web page. I only have username and password PMA_ARBITRARY=1

Below are the container logs for phpmyadmin:

2022-05-03T14:09:05.071163665Z AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 192.168.90.3. Set the 'ServerName' directive globally to suppress this message
2022-05-03T14:09:05.090031394Z AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 192.168.90.3. Set the 'ServerName' directive globally to suppress this message
2022-05-03T14:09:05.099857260Z [Tue May 03 14:09:05.099740 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.52 (Debian) PHP/8.0.15 configured -- resuming normal operations
2022-05-03T14:09:05.099876361Z [Tue May 03 14:09:05.099804 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
2022-05-03T14:09:10.568488015Z 192.168.7.6 - - [03/May/2022:14:09:10 +0000] "GET /index.php?route=/ HTTP/1.1" 200 6176 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36"
2022-05-03T14:09:24.683705343Z 192.168.7.6 - - [03/May/2022:14:09:24 +0000] "GET /index.php?route=/ HTTP/1.1" 200 6082 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36"
2022-05-03T14:10:11.378485202Z 192.168.7.6 - - [03/May/2022:14:10:11 +0000] "-" 408 0 "-" "-"
2022-05-03T14:33:52.732824697Z AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 192.168.90.3. Set the 'ServerName' directive globally to suppress this message
2022-05-03T14:33:52.747010494Z AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 192.168.90.3. Set the 'ServerName' directive globally to suppress this message
2022-05-03T14:33:52.760303484Z [Tue May 03 14:33:52.760202 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.52 (Debian) PHP/8.0.15 configured -- resuming normal operations
2022-05-03T14:33:52.760316584Z [Tue May 03 14:33:52.760260 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
2022-05-03T14:37:18.080353062Z 192.168.7.6 - - [03/May/2022:14:37:17 +0000] "GET /index.php?route=/ HTTP/1.1" 200 6083 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36"
2022-05-03T14:37:18.126972978Z 192.168.7.6 - - [03/May/2022:14:37:18 +0000] "GET /js/messages.php?l=en&v=5.1.3 HTTP/1.1" 200 8259 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36"
2022-05-03T14:37:36.002794434Z 192.168.7.6 - - [03/May/2022:14:37:35 +0000] "POST /index.php?route=/ HTTP/1.1" 200 6266 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.41 Safari/537.36"
istoph commented 2 years ago

I can confirm the problem after updating the version from 5.1.4 to 5.2.0.

istoph commented 2 years ago

The difference with docker version was that no /var/www/html/config.inc.php exists anymore. I copied the config.sample.inc.php and created it by hand, so I could fix the problem:

      volumes:
      - ./phpmyadmin/config.inc.php:/var/www/html/config.inc.php
williamdes commented 2 years ago

Same as #365

ibennetch commented 2 years ago

A fix for this has been submitted to the official Docker repository.

Our own 'phpmyadmin/phpmyadmin' repository has already been updated, but as I mention in #363 I hope to deprecate that repository in the future.