php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #81055 $mysqli->real_connect connecting to socket exception
Submitted: 2021-05-19 18:09 UTC Modified: 2021-05-22 21:33 UTC
From: ivsucic at fesb dot hr Assigned:
Status: Open Package: MySQL related
PHP Version: 7.4Git-2021-05-19 (Git) OS: wsl2 debian
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2021-05-19 18:09 UTC] ivsucic at fesb dot hr
Description:
------------
When connecting to a mysql db with mysqli->real_connect using unix socket it gives an exception unexpected server response while doing caching_sha2 auth. The user of apache2 is changed as needed.

Test script:
---------------
$mysqli->real_connect(null, 'ivan', 'ivan', 'phpmyadmin', 0, '/var/run/mysqld/mysqld.sock');

Expected result:
----------------
Establishing a connection to db

Actual result:
--------------
Exception unexpected server response while doing caching_sha2 auth

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2021-05-21 14:00 UTC] cmb@php.net
-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb
 [2021-05-21 14:00 UTC] cmb@php.net
Are both client and server running on WSL2?
What is your Client API library version (see phpinfo)?
Can you connect via mysqli?
What's your server version?
 [2021-05-21 15:45 UTC] ivsucic at fesb dot hr
-Status: Feedback +Status: Assigned
 [2021-05-21 15:45 UTC] ivsucic at fesb dot hr
Are both client and server running on WSL2?
Yes, both are running on wsl2.
What is your Client API library version (see phpinfo)?
mysqlnd 7.4.15
Can you connect via mysqli?
Using phpmyadmin with password authentication works.
What's your server version?
Apache 2.0 Handler
 [2021-05-21 16:00 UTC] cmb@php.net
-Status: Assigned +Status: Feedback
 [2021-05-21 16:00 UTC] cmb@php.net
Thanks for the info!  With "server version" I meant the version of
MySQL (if it's even MySQL and not MariaDB or such).

Anyhow, if you can connect with phpmyadmin, the MySQL server is
probably irrelevant.  Maybe there are issues with unix sockets
under WSL2?  Can you connect via TCP/IP with mysqli?
 [2021-05-21 20:50 UTC] ivsucic at fesb dot hr
-Status: Feedback +Status: Assigned
 [2021-05-21 20:50 UTC] ivsucic at fesb dot hr
I am using mysql 8. I can connect via tcp/ip
 [2021-05-22 21:33 UTC] cmb@php.net
-Status: Assigned +Status: Open -Assigned To: cmb +Assigned To:
 [2021-05-22 21:33 UTC] cmb@php.net
Thanks for providing further info!

I'll leave this ticket for someone else more used to connecting to
a MySQL server via Unix sockets.
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Fri Aug 06 04:01:23 2021 UTC