Debian Bug report logs -
#790841
php5-odbc: Missing option to set timeout on login for odbc_pconnect/connect
Reported by: Boris Shtrasman <borissh1983+bugs@gmail.com>
Date: Thu, 2 Jul 2015 09:12:02 UTC
Severity: minor
Tags: upstream
Found in version php5/5.6.9+dfsg-1
Fixed in version 5.6.26+dfsg-1+rm
Done: Debian FTP Masters <ftpmaster@ftp-master.debian.org>
Bug is archived. No further changes may be made.
Toggle useless messages
Report forwarded
to debian-bugs-dist@lists.debian.org, borissh1983+bugs@gmail.com, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>:
Bug#790841; Package php5-odbc.
(Thu, 02 Jul 2015 09:12:06 GMT) (full text, mbox, link).
Acknowledgement sent
to Boris Shtrasman <borissh1983+bugs@gmail.com>:
New Bug report received and forwarded. Copy sent to borissh1983+bugs@gmail.com, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>.
(Thu, 02 Jul 2015 09:12:06 GMT) (full text, mbox, link).
Message #5 received at submit@bugs.debian.org (full text, mbox, reply):
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
Reply sent
to Debian FTP Masters <ftpmaster@ftp-master.debian.org>:
You have taken responsibility.
(Fri, 13 Jan 2017 13:07:13 GMT) (full text, mbox, link).
Notification sent
to Boris Shtrasman <borissh1983+bugs@gmail.com>:
Bug acknowledged by developer.
(Fri, 13 Jan 2017 13:07:13 GMT) (full text, mbox, link).
Message #10 received at 790841-done@bugs.debian.org (full text, mbox, reply):
Version: 5.6.26+dfsg-1+rm
Dear submitter,
as the package php5 has just been removed from the Debian archive
unstable we hereby close the associated bug reports. We are sorry
that we couldn't deal with your issue properly.
For details on the removal, please see https://bugs.debian.org/841781
The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.
This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
ftpmaster@ftp-master.debian.org.
Debian distribution maintenance software
pp.
Scott Kitterman (the ftpmaster behind the curtain)
Bug archived.
Request was from Debbugs Internal Request <owner@bugs.debian.org>
to internal_control@bugs.debian.org.
(Sat, 11 Feb 2017 07:30:51 GMT) (full text, mbox, link).
Send a report that this bug log contains spam.
Debian bug tracking system administrator <owner@bugs.debian.org>.
Last modified:
Sun Jul 2 02:22:54 2023;
Machine Name:
buxtehude
Debian Bug tracking system
Debbugs is free software and licensed under the terms of the GNU
Public License version 2. The current version can be obtained
from https://bugs.debian.org/debbugs-source/.
Copyright © 1999 Darren O. Benham,
1997,2003 nCipher Corporation Ltd,
1994-97 Ian Jackson,
2005-2017 Don Armstrong, and many other contributors.