[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Jesús Martínez Novo (Ciencia Al Poder) martinezn...@gmail.com changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=65998 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #23 from Stefan Plewako :stef d...@splewako.com --- (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 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #21 from Stefan Plewako :stef d...@splewako.com --- (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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #22 from Mark A. Hershberger m...@everybody.org --- (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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #20 from Andre Klapper aklap...@wikimedia.org --- 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? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Stefan Plewako :stef d...@splewako.com changed: What|Removed |Added CC||d...@splewako.com --- Comment #19 from Stefan Plewako :stef d...@splewako.com --- (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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added Status|PATCH_TO_REVIEW |RESOLVED CC||umherirrender_de...@web.de Resolution|--- |FIXED Flags||Backport_to_Stable+ --- Comment #18 from Umherirrender umherirrender_de...@web.de --- now merged in master and backported to release 1.22.5 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #17 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 119735 merged by jenkins-bot: Make MySQLi work with non-standard port https://gerrit.wikimedia.org/r/119735 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #16 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 119735 had a related patch set uploaded by Mglaser: Make MySQLi work with non-standard port https://gerrit.wikimedia.org/r/119735 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #15 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 109634 merged by jenkins-bot: Make MySQLi work with non-standard port https://gerrit.wikimedia.org/r/109634 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #14 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 109634 had a related patch set uploaded by Mglaser: Make MySQLi work with non-standard port https://gerrit.wikimedia.org/r/109634 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Roy Grubb roygr...@gandanet.com.hk changed: What|Removed |Added CC||roygr...@gandanet.com.hk --- Comment #11 from Roy Grubb roygr...@gandanet.com.hk --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Mark A. Hershberger m...@everybody.org changed: What|Removed |Added CC||m...@everybody.org --- Comment #12 from Mark A. Hershberger m...@everybody.org --- (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? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #13 from Roy Grubb roygr...@gandanet.com.hk --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Gerrit Notification Bot gerritad...@wikimedia.org changed: What|Removed |Added Status|NEW |PATCH_TO_REVIEW -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #7 from Gerrit Notification Bot gerritad...@wikimedia.org --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #8 from Markus Glaser gla...@hallowelt.biz --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #9 from Alex Legler a...@gentoo.org --- (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'. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #10 from Alex Legler a...@gentoo.org --- (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. ;) -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Kevin Israel (PleaseStand) pleasest...@live.com changed: What|Removed |Added CC||tobias.mucke@mbda-systems.d ||e --- Comment #6 from Kevin Israel (PleaseStand) pleasest...@live.com --- *** Bug 59657 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #5 from Kasper Souren kasper.sou...@gmail.com --- 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', ); -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Nemo federicol...@tiscali.it changed: What|Removed |Added CC||gla...@hallowelt.biz Target Milestone|--- |1.22.x release --- Comment #3 from Nemo federicol...@tiscali.it --- Update per https://www.mediawiki.org/w/index.php?title=MediaWiki_1.22/Known_issuesoldid=847749 which seems to be the master list. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Kasper Souren kasper.sou...@gmail.com changed: What|Removed |Added CC||kasper.sou...@gmail.com --- Comment #4 from Kasper Souren kasper.sou...@gmail.com --- It is a bit confusing that $wgDBport is only used for postgres. So a patch that uses $wgDBport would be great. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 --- Comment #2 from Dimitar Dimitrov mita...@gmail.com --- 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; -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 58153] mysqli: Non-standard port handling broken (explicit parameter int $port expected)
https://bugzilla.wikimedia.org/show_bug.cgi?id=58153 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||code-update-regression Priority|Unprioritized |High CC||hexm...@gmail.com, ||innocentkil...@gmail.com Depends on||45288 Summary|mysqli: Non-standard port |mysqli: Non-standard port |handling broken |handling broken (explicit ||parameter int $port ||expected) Severity|normal |major --- Comment #1 from Andre Klapper aklap...@wikimedia.org --- Sounds like fallout from bug 45288. CC'ing Chad. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l