works with 127.0.0.1, but not localhost

[johnny_canuck]

So, I moved my phpBB board from one server to anotherl. Everything works as it shoiuld, but with a quirk I'm hoping someone can help my figure out. Same OS, same flavour of mySQL, same my.cnf, same php.ini...same everything...more or less (the ip addresses for the two machines, are different, obviously).

On the original server, my config.php had

Code: Select all

<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
...

However, on the new server, the only way I can connect is to change $dbhost to '127.0.0.1'. Works fine...

My hosts file is the same between the two machines, so I can't see that being the route of the problem. And as noted, my.cnf and php.ini are the same...

I suppose I should be happy that it works, but...I'm puzzled as to why this difference has arisen? I know this is more a mySQL than phpBB thing, but given the experience base of phpBB users/admin, thought I'd try here first....

Pointers to the obvious appreciated...

Thanks...

[Wirral Talk]

What platform are they on? Mac/windows/unix

[warmweer]

...

Code: Select all

<?php
// phpBB 3.1.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
...

However, on the new server, the only way I can connect is to change $dbhost to '127.0.0.1'. Works fine...

My hosts file is the same between the two machines, so I can't see that being the route of the problem. And as noted, my.cnf and php.ini are the same...

The releases of the MySQL database differentiate between the use of the hostname localhost and the use of the addresses 127.0.0.1 and ::1.
When using localhost as the destination in a client connector interface of an application, the MySQL application programming interface connects to the database using a Unix domain socket, while a TCP connection via the loopback interface requires the direct use of the explicit address.

BTW: time to move to mysqli (and 3.2)

[johnny_canuck]

What platform are they on? Mac/windows/unix

Sorry, my mistake: GNU/Linux.

[johnny_canuck]

The releases of the MySQL database differentiate between the use of the hostname localhost and the use of the addresses 127.0.0.1 and ::1.
When using localhost as the destination in a client connector interface of an application, the MySQL application programming interface connects to the database using a Unix domain socket, while a TCP connection via the loopback interface requires the direct use of the explicit address.

Thanks -- that much I knew (more or less), but what puzzles is me is why one machine is using a socket, and the other a TCP connection, when the two machines are largely redundant. I suppose no matter -- so long as 127.0.0.1 works, I can live with the nanosecond degree to which said connections are (in theory) slower than socket connections. I was simply trying to figure out why there was a difference, since the flavour of mySQL is the same on both machines (same OS, smae php, etc...).

BTW: time to move to mysqli (and 3.2)

No doubt, but as is the case for many users, there are so many mods/tweaks/changes to the board(s) I'm running that a simple migration is anything but simple.

[mrgoldy]

https://stackoverflow.com/questions/314 ... is-working

This should give you perhaps some more insight and possibilities as to what caused the issue.

[AmigoJack]

The comments in PHP's manual to mysqli_connect also share experiences with both values and their differences on multiple platforms. Bottom line is: don't ever assume them being interchangeable.