I even didn't know this exists

We will add it for Piwigo 2.5.1

[Bugtracker] ticket 2865

Looking at some other projects, there seem to be two ways to identify sockets.

The first is to prefix the path with a colon.
The second is to look for the leading "/" in the path.

If you cannot decide, I would vote for the second option.

<<I can find any documentation on how to use mysql sockets
is the host always "localhost" ?>>

The host field is ignored.  NULL works, and is probably the cleanest solution.

I'm currently using this in piwigo

  if (substr($host, 0, 1)=='/')
  {
    $mysqli = new mysqli(null, $user, $password, null, null, $host);
  }
  else
  {
    $mysqli = new mysqli($host, $user, $password);
  }


FYI, with the PHP/PDO interface, there is actually a different connection string completely.  Use code like this

    $pdo=new PDO(
        (substr($DBHOST, 0, 1)=='/' ?
        "mysql:unix_socket={$DBHOST};dbname={$DBNAME}" :
        "mysql:host={$DBHOST};dbname={$DBNAME};port={$DBPORT}"
        ),
        ...
    );

If you don't have a suitable machine for testing (i.e. a unix server with MySQL listening on a socket), I can test this for you.

Last edited by fisharebest (2013-03-19 18:43:02)