#27077 [NEW]: Changing 'mssql.textsize' in php.ini causes connections to stop working
From: jason at burfield dot com
Operating system: Linux ( Suse 9 )
PHP version: 4.3.4
PHP Bug Type: MSSQL related
Bug description: Changing 'mssql.textsize' in php.ini causes connections to stop working
Description:
------------
PHP, configured as such:
'./configure' '--with-mssql=/usr/local' '--with-apxs=/usr/sbin/apxs'
'--with-mcrypt=/usr/local' '--enable-trans-id'
Use Suse 9.0
Using Apache 1.3.28
Using FreeTDS.
I encountered a problem with the 'textsize' and 'textlimit' values in the
PHP.INI file when using SQL Server.
If left to their default values (commented out) everything is fine,
however, when I change the value to a larger size, in this case up to
10000, Apache starts and all seems fine, however, connecting to the SQL
Server database machine stops working.
If I change the limit back to default the connections start working
again.
I also attempted changing the settings in freetds.conf, however, that had
no effect at all.
Reproduce code:
---------------
/* simple connection */
$host = 'server:1433';
$user = 'username';
$pass = 'password';
$dblink = mssql_connect($host, $user, $pass);
This fails when the 'textsize' or 'textlimit' values are changed from
defaults.
Expected result:
----------------
Expect a connection to the database server to be made.
Actual result:
--------------
Connection to database server fails.
--
Edit bug report at http://bugs.php.net/?id=27077&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27077&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27077&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=27077&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=27077&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=27077&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=27077&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=27077&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=27077&r=support
Expected behavior: http://bugs.php.net/fix.php?id=27077&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=27077&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=27077&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=27077&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27077&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=27077&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=27077&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=27077&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=27077&r=float
Thread (4 messages)
- jason at burfield dot com