ID: 37232
Updated by: [EMAIL PROTECTED]
Reported By: rriehle at gmail dot com
-Status: Assigned
+Status: Bogus
Bug Type: MSSQL related
Operating System: XP SP2
PHP Version: 5.1.2
Assigned To: fmk
New Comment:
This is due to limmitations in ntwdblib from Microsoft. This library
has not been updated since SQL server 6.5 where 30 was the max length
of passwords etc.
Use the php_dblib.dll extension. This is a dropin replacement build
with FreeTDS.
Previous Comments:
------------------------------------------------------------------------
[2006-04-28 06:03:00] rriehle at gmail dot com
Description:
------------
Using SQL Server 2005 (SP1).
Unable to connect with logins that have passwords greater than 30
characters long using mssql_connect or mssql_pconnect.
The logins work fine from the server client tools; I spent hours
troubleshooting this. sigh.
The reason the passwords I was trying to use were 32 characters is
becuase I was using MD5 hashes of plain passwords for my server logins.
Reproduce code:
---------------
$dbh = mssql_pconnect("MyHost", "testlogin",
"passwordpasswordpasswordpassword");
OR
$dbh = mssql_connect("BUILDWAY-NET", "testlogin",
"passwordpasswordpasswordpassword");
Expected result:
----------------
Expect $dbh to hold a link identifier to a mssql connection.
I expected that the statements would connect with passwords that have a
length as long as the server can accept.
Actual result:
--------------
Returns false with these messages:
Debug Warning: c:\Inetpub\wwwroot\includes\ez_sql-ms.php line 71 -
mssql_pconnect() [<a href='file:///C:\Program
Files\Zend\ZendStudioClient-5.1.0\docs\PHPmanual/function.mssql-pconnect'>function.mssql-pconnect</a>]:
message: Login failed for user 'testlogin'. (severity 14)
Debug Warning: c:\Inetpub\wwwroot\includes\ez_sql-ms.php line 71 -
mssql_pconnect() [<a href='file:///C:\Program
Files\Zend\ZendStudioClient-5.1.0\docs\PHPmanual/function.mssql-pconnect'>function.mssql-pconnect</a>]:
Unable to connect to server: BUILDWAY-NET
Errors are the same for mssql_connect (except that the p in
mssql_pconnect is left out).
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37232&edit=1
