473,320 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

timeout with php-mssql connection with stunnel

dan
Hi,
I connect to a microsoft SQL server from php. Php is running on linux
(debian sarge) with the freetds package.
The connection is secured through stunnel (version 3.26), with stunnel
running locally on the web server and locally on the SQL server
machine.
This means php connects locally to the stunnel port, which then
establishes a secure connection to stunnel on the sql server. There
the data is then transmitted locally to the SQL server.

When the SQL server machine is not responding the connection attempt
times out with the following msg:
Warning: mssql_connect(): Sybase: Client message: Read from SQL server
failed. (severity 78) in /var/www/abc/utils.php on line 283
Warning: mssql_connect(): Sybase: Client message: Login incorrect.
(severity 78) in /var/www/abc/utils.php on line 283
Warning: mssql_connect(): Sybase: Unable to connect in
/var/www/abc/utils.php on line 283

My problem is that the timeout is very high, about three minutes. I
could not reduce this timeout with any parameter like
mssql.connect_timeout, mssql.timeout, not even max_execution_time
would reduce this timeout.
I also tried to reduce the freetds and stunnel timeout, no success.

I assume that this has something to do with stunnel being used beccause
the mssql drive recives the connection response from the local stunnel.

Do you have any idea how I can set the timeout to a value of 10 sec. ?

many thanks!

Dan

Jul 26 '05 #1
0 2180

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dario | last post by:
I've modify the php.ini the session.gc_maxlifetime to reduce the time of timeout of the session variabiles. But it not seems to go. In fact the session variabile remain also when after the timeout...
1
by: Ralph Freshour | last post by:
Can I adjust the PHP session timeout on my web site? Users are reporting timeout errors when they leave their computer for a period of time and then come back to resume using the site - is there...
3
by: Craig Storey | last post by:
I have a form where users logged in using sessions can edit articles in a WYSIWYG editor. Some of them take their time and don't like to save their work very often and occassionally the sessions...
6
by: somaboy mx | last post by:
Hello I need people to be able to complete long text blocks in my cms before their session times out. From the php documentation I gather that ini directive session.gc_maxlifetime would be the...
2
by: Lisa Pearlson | last post by:
Hi, I am wanting to write an internet 'server' program. For ease, I want to use PHP-CLI with XINET super server. XINET communicates with the 'server' program via STDIN/STDOUT. I'm not sure...
3
by: hakim | last post by:
Hi NG, I have my own apache server 2.0.54 running with php 4.3.10. I got a little logical problem here about http requests. I have written a small php script which waits for x seconds. Every...
2
by: hakim | last post by:
Hi NG, I have my own apache server 2.0.54 running with php 4.3.10. I got a little logical problem here about http requests. I have written a small php script which waits for x seconds. Every...
5
by: Dave | last post by:
Hi All, Can anyone suggest a reliable solution to php redirect?: header("Location: $redir_url"); if the above times out in $timeout seconds header("Location: $alt_redir_url"); Many thanks,
1
by: a.r.austin | last post by:
Hello, I am trying to download a few files one after another from a remote server. Problem is that I don't know how to, or if I am able at all, set a time out for download. I don't want to time...
0
by: adamalton | last post by:
I'm trying to investigate the way PHP behaves in relation to timeouts and included scripts. PHP seems to do very strange things when scripts that include other scripts timeout, or when the included...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.