suPHP is a tool that allows PHP scripts to be executed with the permissions of their owners. By not running PHP script using web server’s user rights, suPHP increase the server security.
First install httpd-devel and compiler tools:
|
1 |
yum install httpd-devel gcc gcc-c++ make |
I’ve been struggling for several hours to find out why PHP 5.2.5 didn’t want to connect to MS SQL Server 2005 Express Edition although extension=php_mssql.dll already enabled and phpinfo() is showing MS SQL already active.
I always got this error messages when trying to connect to MS SQL:
|
1 |
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: (local)\SQLEXPRESS in path\mssql.php on line 5 |
After doing some searching, I got an answer that PHP 5 is using old ntwdblib.dll version. The one that comes with PHP 5.2.5 distribution is version 2000.2.8.0 which seems doesn’t compatible with the new MS SQL Server 2005 Express Edition. I downloaded new dll from http://webzila.com (use the search tool) which is version 2000.80.194.0 and replaced the one on PHP folder with this version.
I use this code to test the connection and its working:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
echo("Testing MS SQL connection... "); if ($conn = mssql_connect('(local)\SQLEXPRESS', 'user', 'pass')) { echo("Connection succeed"); mssql_select_db('dbname', $conn); mssql_close($conn); } else { echo("Connection failed"); } |