Sounds like fallout from bug 45288. CC'ing Chad.

mitakas wrote:

I have php 5.4.22 on my server, compiled with '--with-mysql' '--with-mysqli=...' '--with-pdo-mysql=...'

I get the following errors:

DB connection error
Server: myserver:1234 , User: <user>, Password: <password>, error: :real_connect(): (HY000/2005): Unknown MySQL server host 'myserver:port' (2)
Failed to connect to database 0 at myserver:1234

when I enter $wgDBServer = 'myserver:1234';

DB connection error
Server: myserver, User: <user>, Password: <password>, error: :real_connect(): (28000/1045): Access denied for user '<user>'@'myserver' (using password: YES)
Failed to connect to database 0 at myserver

when I enter $wgDBServer = 'myserver'; $wgDBport = 1234;

Update per https://www.mediawiki.org/w/index.php?title=MediaWiki_1.22/Known_issues&oldid=847749 which seems to be the master list.

kasper.souren wrote:

It is a bit confusing that $wgDBport is only used for postgres.
So a patch that uses $wgDBport would be great.

kasper.souren wrote:

Meanwhile adding the following in LocalSettings.php can be a possible workaround on some systems, I've seen it work on one system and fail on another:
ini_set('mysqli.default_port', 3333);

• Bug 59657 has been marked as a duplicate of this bug. ***

Change 109634 had a related patch set uploaded by Mglaser:
Make MySQLi work with non-standard port (bug 58153)

https://gerrit.wikimedia.org/r/109634

It turns out that this fix is not as simple as thought. $wgDBport is set to 5432. If I make mysqli consider $wgDBport by default, all instances using mysqli on 3306 will be broken. Further, running PHP 5.6 it seems to be ok to use hostname:port.
So my attempt to fix this for now is to parse the port off the hostname. This needs to work for IPv4 and IPv6 as well. See https://gerrit.wikimedia.org/r/#/c/109634/. Please review and comment.

(In reply to comment #8)

It turns out that this fix is not as simple as thought. $wgDBport is set to

5432. If I make mysqli consider $wgDBport by default, all instances using

mysqli on 3306 will be broken.

Can't this be refactored to default to null and be overwritten in the specific database implementations should the value not be set by the user?

Further, running PHP 5.6 it seems to be ok to
use hostname:port.
So my attempt to fix this for now is to parse the port off the hostname. This
needs to work for IPv4 and IPv6 as well. See
https://gerrit.wikimedia.org/r/#/c/109634/. Please review and comment.

That won't handle the syntax for persistent connections correctly which is 'p:<host>:<port>'.

(In reply to comment #9)

That won't handle the syntax for persistent connections correctly which is
'p:<host>:<port>'.

'p:<host>' of course for earlier versions. ;)

roygrubb wrote:

I experienced what looks like a manifestation of the same bug. Running

php maintenance/update.php

from the command line with what I knew were correct credentials, I had the response

DB connection error: Unknown MySQL server host 'localhost:/tmp/mysql5.sock' (34) (localhost:/tmp/mysql5.sock)

The answer in my case was to change the DB host from

$wgDBserver = "localhost:/tmp/mysql5.sock"

to just

$wgDBserver = "localhost"

My thanks to Ciencia Al Poder who pointed me here, and my ISP support who suggested the above.

(In reply to comment #11)

DB connection error: Unknown MySQL server host 'localhost:/tmp/mysql5.sock'
(34) (localhost:/tmp/mysql5.sock)

How did you end up with "localhost:/tmp/mysql5.sock" in your LocalSettings.php? Did you modify that setting or is that what MediaWiki gave you?

roygrubb wrote:

It was what my ISP told me to use when I first set up Wikimedia a couple of years ago and couldn't get a connection. It worked then, and it worked up to the time I updated to 1.22.

Change 109634 had a related patch set uploaded by Mglaser:
Make MySQLi work with non-standard port

https://gerrit.wikimedia.org/r/109634

Change 109634 merged by jenkins-bot:
Make MySQLi work with non-standard port

https://gerrit.wikimedia.org/r/109634

Change 119735 had a related patch set uploaded by Mglaser:
Make MySQLi work with non-standard port

https://gerrit.wikimedia.org/r/119735

Change 119735 merged by jenkins-bot:
Make MySQLi work with non-standard port

https://gerrit.wikimedia.org/r/119735

now merged in master and backported to release 1.22.5

dev wrote:

(In reply to Mark A. Hershberger from comment #12)

(In reply to comment #11)

DB connection error: Unknown MySQL server host 'localhost:/tmp/mysql5.sock'
(34) (localhost:/tmp/mysql5.sock)

In 1.22.5 I have exactly the same socket problem

How did you end up with "localhost:/tmp/mysql5.sock" in your
LocalSettings.php? Did you modify that setting or is that what MediaWiki
gave you?

https://www.mediawiki.org/wiki/Manual:Config_script

This bug should be reopened.

Stefan: Is this also a setting your provider recommended (see comment 12)? Did you check that the code change in https://gerrit.wikimedia.org/r/#/c/119735/ is in place on the server, just to make sure?

dev wrote:

(In reply to Andre Klapper from comment #20)

Stefan: Is this also a setting your provider recommended (see comment 12)?

No, it was setting suggested on https://www.mediawiki.org/wiki/Manual:Config_script

Did you check that the code change in
https://gerrit.wikimedia.org/r/#/c/119735/ is in place on the server, just
to make sure?

Yes, it is.

With original settings:
$wgDBserver = "localhost:/var/lib/mysql/mysql.sock";

it doesn't work and after change in LocalSettings.php:
-#$wgDBserver = "localhost:/var/lib/mysql/mysql.sock";
+$wgDBport = "/var/lib/mysql/mysql.sock";

it works again.

(In reply to Stefan Plewako :stef from comment #21)

With original settings:
$wgDBserver = "localhost:/var/lib/mysql/mysql.sock";

it doesn't work and after change in LocalSettings.php:
-#$wgDBserver = "localhost:/var/lib/mysql/mysql.sock";
+$wgDBport = "/var/lib/mysql/mysql.sock";

it works again.

What if you don't add $wgDBport? Does it work then? I think it should since, IIRC, /var/lib/mysql/mysql.sock is the standard connection for localhost on Debian.

dev wrote:

(In reply to Mark A. Hershberger from comment #22)

What if you don't add $wgDBport? Does it work then?

Yes, it works without $wgDBport and $wgDBserver