#45849 [Com]: segmentation fault accessing mssql with pdo/odbc
ID: 45849
Comment by: dk at trick dot ca
Reported By: dk at trick dot ca
Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.2.6
New Comment:
Possibly related to 41399?
http://bugs.php.net/bug.php?id=41888
Previous Comments:
[2008-08-18 11:28:21] dk at trick dot ca
further investigation shows this error occurs when a field of type
"text" or "varchar(max)" is included in the query.
[2008-08-18 10:08:22] dk at trick dot ca
typo, first line of testpdo.pgp does have a missing quote:
$d = new PDO('odbc:MYDSN','MYDUSERID', 'MYPASSWORD');
----------------
[2008-08-18 10:06:39] dk at trick dot ca
Description:
PHP Segfaults when I query MS SQL Server 2005 via an ODBC DSN with
PDO.
The query returns fine using tsql, and there is nothing wrong in the
freetds log.
Reproduce code:
---
(names/credentials changed)
testpdo.php:
query('SELECT * from MYTABLE') as $row) {
print_r($row);
}
odbc.ini:
[MYDSN]
Driver = /usr/lib/libtdsodbc.so.0
Description = MYDSN
Trace = Yes
Servername = MYSERVER
Database = MYDATABASE
freetds.conf:
[MYSERVER]
host = MYHOST
port = 1433
tds version = 8.0
Expected result:
print results or some sort of error.
Actual result:
--
# php testpdo.php
Segmentation fault
--
Edit this bug report at http://bugs.php.net/?id=45849&edit=1
#45849 [Com]: segmentation fault accessing mssql with pdo/odbc
ID: 45849
Comment by: dk at trick dot ca
Reported By: dk at trick dot ca
Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.2.6
New Comment:
further investigation shows this error occurs when a field of type
"text" or "varchar(max)" is included in the query.
Previous Comments:
[2008-08-18 10:08:22] dk at trick dot ca
typo, first line of testpdo.pgp does have a missing quote:
$d = new PDO('odbc:MYDSN','MYDUSERID', 'MYPASSWORD');
----------------
[2008-08-18 10:06:39] dk at trick dot ca
Description:
PHP Segfaults when I query MS SQL Server 2005 via an ODBC DSN with
PDO.
The query returns fine using tsql, and there is nothing wrong in the
freetds log.
Reproduce code:
---
(names/credentials changed)
testpdo.php:
query('SELECT * from MYTABLE') as $row) {
print_r($row);
}
odbc.ini:
[MYDSN]
Driver = /usr/lib/libtdsodbc.so.0
Description = MYDSN
Trace = Yes
Servername = MYSERVER
Database = MYDATABASE
freetds.conf:
[MYSERVER]
host = MYHOST
port = 1433
tds version = 8.0
Expected result:
print results or some sort of error.
Actual result:
--
# php testpdo.php
Segmentation fault
--
Edit this bug report at http://bugs.php.net/?id=45849&edit=1
#45849 [Com]: segmentation fault accessing mssql with pdo/odbc
ID: 45849
Comment by: dk at trick dot ca
Reported By: dk at trick dot ca
Status: Open
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.2.6
New Comment:
typo, first line of testpdo.pgp does have a missing quote:
$d = new PDO('odbc:MYDSN','MYDUSERID', 'MYPASSWORD');
Previous Comments:
--------
[2008-08-18 10:06:39] dk at trick dot ca
Description:
PHP Segfaults when I query MS SQL Server 2005 via an ODBC DSN with
PDO.
The query returns fine using tsql, and there is nothing wrong in the
freetds log.
Reproduce code:
---
(names/credentials changed)
testpdo.php:
query('SELECT * from MYTABLE') as $row) {
print_r($row);
}
odbc.ini:
[MYDSN]
Driver = /usr/lib/libtdsodbc.so.0
Description = MYDSN
Trace = Yes
Servername = MYSERVER
Database = MYDATABASE
freetds.conf:
[MYSERVER]
host = MYHOST
port = 1433
tds version = 8.0
Expected result:
print results or some sort of error.
Actual result:
--
# php testpdo.php
Segmentation fault
--
Edit this bug report at http://bugs.php.net/?id=45849&edit=1
#45849 [NEW]: segmentation fault accessing mssql with pdo/odbc
From: dk at trick dot ca
Operating system: Linux
PHP version: 5.2.6
PHP Bug Type: PDO related
Bug description: segmentation fault accessing mssql with pdo/odbc
Description:
PHP Segfaults when I query MS SQL Server 2005 via an ODBC DSN with PDO.
The query returns fine using tsql, and there is nothing wrong in the
freetds log.
Reproduce code:
---
(names/credentials changed)
testpdo.php:
query('SELECT * from MYTABLE') as $row) {
print_r($row);
}
odbc.ini:
[MYDSN]
Driver = /usr/lib/libtdsodbc.so.0
Description = MYDSN
Trace = Yes
Servername = MYSERVER
Database = MYDATABASE
freetds.conf:
[MYSERVER]
host = MYHOST
port = 1433
tds version = 8.0
Expected result:
print results or some sort of error.
Actual result:
--
# php testpdo.php
Segmentation fault
--
Edit bug report at http://bugs.php.net/?id=45849&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=45849&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=45849&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=45849&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=45849&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=45849&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=45849&r=needtrace
Need Reproduce Script:http://bugs.php.net/fix.php?id=45849&r=needscript
Try newer version:http://bugs.php.net/fix.php?id=45849&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=45849&r=support
Expected behavior:http://bugs.php.net/fix.php?id=45849&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=45849&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=45849&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=45849&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45849&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=45849&r=dst
IIS Stability:http://bugs.php.net/fix.php?id=45849&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=45849&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=45849&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=45849&r=nozend
MySQL Configuration Error:http://bugs.php.net/fix.php?id=45849&r=mysqlcfg
