Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot login to mysql server #361

Closed
sybanyt opened this issue May 3, 2022 · 4 comments
Closed

Cannot login to mysql server #361

sybanyt opened this issue May 3, 2022 · 4 comments
Assignees

Comments

@sybanyt
Copy link

sybanyt commented May 3, 2022

After referencing multiple pages and forums I cannot login to phpmyadmin after setup.
I get the error:
Cannot login to the MySQL server.
mysqli::real_connect(): (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
Copy link

istoph commented May 11, 2022

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

@istoph
Copy link

istoph commented May 11, 2022

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
Copy link
Member

Same as #365

@ibennetch
Copy link
Member

ibennetch commented May 12, 2022

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants