I can still reproduce this problem as of 2007-06-13.

I've tried with PHP 5.2.1 and 5.2.3, And FreeTDS is at 0.64
on a FreeBSD 6.1 install.

This code always waits the 20 seconds and tells me that everything went according to plan

$dbLink = mssql_connect('sqldmz','sosuser','123456');
ini_set('mssql.timeout','1');
$query = "WAITFOR DELAY '000:00:20' SELECT TOP 1 * FROM tbl_serviceorder";
$res = mssql_query($query,$dbLink);
		
if(!$res) {
   echo 'No, error, warning, timeout!!!!!!!!!';
}
else {
   $row = mssql_fetch_assoc($res);
   echo 'Everything is OK: '.$row['OrderNumber'];
}

/hps

The two time out parameters is used during request startup and it will not have any effect to change the value at runtime.

I'll look at a way to move these to the connect/query functions, but until then you should specify these in your php.ini file.

I'm sorry, but setting the timeouts in php.ini doesn't help either. phpinfo() confirms that the limit is set to 1 second, but it waits an infinite amount of time for the query to finish!

Deliberatly making a self-join-query will lock up one php-thread forever, after all threads are locked up, the webserver won't answer any further requests.

/hps

I also have this problem with PHP 5.2.0.

mssql.timeout is set to Local Value 60 and Master Value 60. Php doesn't time out. I have a query which run over 60 seconds.

This is still occurring in 5.2.6.  It sits there timing out:

write(1, "Running query...\n", 17Running query...
)      = 17
gettimeofday({1240263244, 234960}, NULL) = 0
gettimeofday({1240263244, 234963}, NULL) = 0
select(4, NULL, [3], NULL, {5, 0})      = 1 (out [3], left {5, 0})
gettimeofday({1240263244, 235613}, NULL) = 0
sendto(3, "\1\1\10@\0\0\1\0S\0E\0L\0E\0C\0T\0 \0[\0d\0a\0t\0e\0"..., 2112, MSG_NOSIGNAL, NULL, 0) = 2112
gettimeofday({1240263244, 235962}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263249, 235390}, NULL) = 0
gettimeofday({1240263249, 235490}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263254, 235491}, NULL) = 0
gettimeofday({1240263254, 235591}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263259, 235422}, NULL) = 0
gettimeofday({1240263259, 235523}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263264, 235536}, NULL) = 0
gettimeofday({1240263264, 235637}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263269, 235253}, NULL) = 0
gettimeofday({1240263269, 235354}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263274, 235997}, NULL) = 0
gettimeofday({1240263274, 236097}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263279, 236311}, NULL) = 0
gettimeofday({1240263279, 236413}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263284, 236515}, NULL) = 0
gettimeofday({1240263284, 236615}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)
gettimeofday({1240263289, 236319}, NULL) = 0
gettimeofday({1240263289, 236419}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0})      = 0 (Timeout)

I think i am seeing the same issue on php 5.2.6 on Mac

Im setting timeout 60 in php.ini and 8 at runtime. Im runnig nc -l -p 4000 on localmachine and pointing mssql connection to it.

I can see its connecting and then hangs forever.

If i point mssql connect to non existing ip it fails after connection_timeout as it should.

Is there any chance for this setting to be fixed? or any way around it? 

Thanks

We are experiencing the same behaviour.

PHP Version 5.2.11
freetds-0.64
CentOS 5.4

If our database queries get queued, the connections will never timeout and as a result all apache processes lock up. Has anyone found a workaround?

The only way to it work is setting it to a huge number.
It will ignore -1 and 0.
Edit php.ini and set mssql.timeout = 854358349583 and it will work fine.

From what i can tell it's not a bug in php, but in the under lying freetds library. 

For those people on Freebsd or anyone else using freetds .64 and having problems with the timeout. 

Try upgrading your freetds to the latest build.

On Freebsd (until i can get the ports updated):
uninstall php5-mssql and freetds (and/or freetds-msdblib)

then install freetds-devel, and then php5-mssql.

That should get you freetds-devel which in the ports tree is version 0.82 and the mssql.timeout functionality should start working.