connection option LoginTimeout is not respected on mac driver

[aelliott1485]

Please check the FAQ (frequently-asked questions) first. If you have other questions or something to report, please address the following (skipping questions might delay our responses):

PHP version
PHP 8.1.17 (cli) (built: Mar 16 2023 13:07:08) (NTS)

PHP SQLSRV or PDO_SQLSRV version
SQLSRV

Microsoft ODBC Driver version
unixODBC 2.3.11

SQL Server version
Microsoft Azure SQL Edge Developer (RTM) - 15.0.2000.1574 (ARM64) Jan 25 2023 10:36:08 Copyright (C) 2019 Microsoft Corporation Linux (Ubuntu 18.04.6 LTS aarch64) (running in a docker container)

Client operating system
macOS Ventura 13.2.1 (22D68)

Problem description
Connection option LoginTimeout is not respected on mac driver

Expected behavior and actual behavior
LoginTimeout=15 is being passed in connection string (via laravel SqlServerConnector at vendor/laravel/framework/src/Illuminate/Database/Connectors/SqlServerConnector.php). When server is taken offline requests timeout after 60 seconds.

Repro code or steps to reproduce

• take SQL server offline or change connection string to connect to incorrect yet valid host (per https://stackoverflow.com/a/59900696/1575353)
• attempt to make a connection for a query

This same scenario appears to work in an equivalent Windows setup -

• Windows 10 Version 21H1 (OS Build 19043.1766)
• PHP 8.1.13 (cli) (built: Nov 22 2022 15:44:26) (NTS Visual C++ 2019 x64)
• Microsoft SQL Server Developer (64-bit) 15.0.4261.1 running in a docker container on Ubuntu (16.04)

[v-makouz]

Do you have a small repro script? Like a .php file that tries to connect? I want to to see exactly how he timeout value is set.

[aelliott1485]

I can attempt to create a script with the docker container used. Until then, below is the sanitized DSN, config and options used in Illuminate\Database\Connectors\SqlServerConnector in the connect() method when it calls $this->createConnection() on line 32. That method createConnection() passes the $dsn string on to its call to createPdoConnection() which instantiates a PDO object with the same value for $dsn.

`Illuminate\Database\Connectors\SqlServerConnector::getDsn($config)` returns: 

sqlsrv:Server=localhost,1433;Database=A***e;LoginTimeout=15 

$config: array (
  'driver' => 'sqlsrv',
  'host' => 'localhost',
  'port' => '1433',
  'database' => 'A***e',
  'username' => '***',
  'password' => '***',
  'charset' => 'utf8',
  'login_timeout' => 15,
  'prefix' => '',
  'pooling' => true,
  'prefix_indexes' => true,
  'foreign_key_constraints' => true,
  'options' => 
  array (
    1005 => true,  // PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE
  ),
  'name' => 'sqlsrvAdminDB',
) 

$options: array (
  8 => 0,             // PDO::ATTR_CASE => PDO::CASE_NATURAL
  3 => 2,             // PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  11 => 0,            // PDO::ATTR_ORACLE_NULLS => PDO::NULL_NATURAL
  17 => false,        // PDO::ATTR_STRINGIFY_FETCHES => false
  1005 => true,       // PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE
)  

[aelliott1485]

I created a small PHP script in an effort to recreate the issue. Sadly it was unsuccessful. I will dig into the laravel framework code to attempt diagnosing the issue. Thank you for your time!