[php-maint] Bug#790841: php5-odbc: Missing option to set timeout on login for odbc_pconnect/connect

[Boris Shtrasman]

Package: php5-odbc
Version: 5.6.9+dfsg-1
Severity: minor
Tags: upstream

Dear Maintainer,

I was getting timeout on login for odbc_connect when connecting to SQL Server 2000 + 2005,
usually to fix such an issue I set the login timeout during connect.

I was expecting to find something that could allow me to set login
timeout in php.ini,
or a timeout value in odbc.c like:
  SQLSetConnectOption(
    conn->hdbc,
    SQL_ATTR_LOGIN_TIMEOUT,//or maybe SQL_ATTR_CONNECTION_TIMEOUT
    xxxx);

but I failed to find an option or a refernce on how I can modify the login
timeout.

the suggested solution on MSDN for such an error is to drop
odbc_connect/pconnect and switch to sqlsrv_connect[1].

As I understand odbc_setoption should be called after the login had been done,
otherwise I don't see how I can access the connection handle, before doing odbc_connect.


[1] -https://social.msdn.microsoft.com/forums/sqlserver/en-US/d24045a2-6a3d-42f8-8005-6c4a49c17ac4/timeout-expired

-- Package-specific info:
==== Additional PHP 5 information ====

++++ PHP 5 SAPI (php5query -S): ++++

++++ PHP 5 Extensions (php5query -M -v): ++++

++++ Configuration files: ++++
**** /etc/php5/mods-available/odbc.ini ****
extension=odbc.so

**** /etc/php5/mods-available/pdo_odbc.ini ****
extension=pdo_odbc.so


-- System Information:
Debian Release: 8.0
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.9-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages php5-odbc depends on:
ii  libc6                          2.19-13
ii  libodbc1                       2.3.1-3
ii  php5-common [phpapi-20131226]  5.6.9+dfsg-1
ii  ucf                            3.0030

php5-odbc recommends no packages.

php5-odbc suggests no packages.

Versions of packages php5-common depends on:
ii  libc6   2.19-13
ii  lsof    4.86+dfsg-1
ii  psmisc  22.21-2
ii  sed     4.2.2-4+b1
ii  ucf     3.0030

Versions of packages php5-common suggests:
pn  php5-user-cache  <none>

-- no debconf information