Cater for unix domain socket mysql connections

diff --git a/config.php.sample b/config.php.sample
index 0fac91c79ac14eb433d0839df3bfe65c432e71c3..6726eb846ed634231fd05ca03336ca027851f8e9 100644 (file)
--- a/config.php.sample
+++ b/config.php.sample
@@ -69,6 +69,11 @@ define(
 
  /**
   * SQL IP address or hostname
+  * You may specify a unix domain socket directory address
+  * E.g:
+  *     define('SQL_IP', "/path/to/unix/domain/socket");
+  *
+  * Path to unix socket MUST start with a slash "/"
   */
 define('SQL_IP', "127.0.0.1");
 

diff --git a/plugins/sql_auth/SQL/sql.php b/plugins/sql_auth/SQL/sql.php
index 6de0d6cfc1bdfe4b713df7137ab88bf091bd7fa5..a9b0a556cf5ec490b67fc348618eaa6b51e025e5 100644 (file)
--- a/plugins/sql_auth/SQL/sql.php
+++ b/plugins/sql_auth/SQL/sql.php
@@ -8,7 +8,11 @@ function sqlnew()
        $db = SQL_DATABASE;
        $charset = 'utf8mb4';
 
-       $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
+       if ($host[0] == "/")
+               $host_type = "unix_socket";
+       else
+               $host_type = "host";
+       $dsn = "mysql:$host_type=$host;dbname=$db;charset=$charset";
        $options = [
                PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,