[PHP-DEV] PHP as ISAPI module crashes but...

2001-03-07 Thread Paco Ortiz

Hi: 

I've discovered something very interesting: 

perhaps you already know that using PHP + IIS in ISAPI mode is not recommended, 
because of the: "PHP has encountered an Access Violation at 73342C83" and so errors. 

So CGI use is recommended. But I have found that this happens whenever I make a MSSQL 
query. 

If I run a script with no queries, it works fine, and no matter how much I bash the 
server, no crashes. Now, I tried to do the same with Oracle8i. Using php_oci8 module, 
I made a query: and  it never crashes even if I bash the server with many requests!!! 
(this sadly makes scripts using MSSQL crash miserably). Now: could it be that, for 
some reason, the code of php_mssql has reentrancy problems with multiple server 
threads?

Maybe we could test some other modules (php_odbc or other DB modules) looking for the 
same problem? I find this issue important, because many people (including me) are 
expectant about using PHP as an ISAPI filter. The performance boost is very important 
to be looked upon, and this clearly prevents people from running heavily loaded 
production websites with NT+IIS. 

Greetings,
___
Francisco Javier Ortiz Torre
ComuNET,S.A.
mailto:[EMAIL PROTECTED] ComuNET, S.A
Gral. Concha 39,6
48012 Bilbao Espaa
Tel: +34 944 700 101
Fax: +34 944 700 185
http://www.comunet.es
___




Re: [PHP-DEV] PHP as ISAPI module crashes but...

2001-03-07 Thread Phil Driscoll

I'm a keen as you are for the PHP ISAPI module to work reliably, but before
we start sorting out the extension modules, we need to sort out the core
itself. For me (on my NT4/IIS4/SP6 setup), php 'straight out of the box'
falls over with server 500 errors on the simplest of scripts - even with
only a single request being made to the server (which may rule out the
problem being anything to do with thread safety?).

Perhaps we could get together a few simple and a few more complicated
scripts and try them on a range of machines and see if we can start to make
any conclusions.

My suggestions for starters are:

---
?php
echo('hello');
?
---
?php
phpinfo();
?
(which will probably start up simultaneous threads at it fetches the images)
---
?php
 /*something simple which takes a long time so that we get a chance to fire
 off multiple simultaneous requests to it*/
?
---

Any other thoughts?

Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org



-- 
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DEV] PHP as ISAPI module crashes but...

2001-03-07 Thread Paco Ortiz

Hi:


3/7/01 11:33:18 AM, "Phil Driscoll" [EMAIL PROTECTED] wrote:

I'm a keen as you are for the PHP ISAPI module to work reliably, but before
we start sorting out the extension modules, we need to sort out the core
itself. For me (on my NT4/IIS4/SP6 setup), php 'straight out of the box'
falls over with server 500 errors on the simplest of scripts - even with
only a single request being made to the server (which may rule out the
problem being anything to do with thread safety?).

are you trying with 4.0.4pl1? Try, please. I had the same problems with previous
versions, but since I installed 4.0.4pl1 in a development server (one week ago, 
not much time...) I've had no problems, (if I only care about disabling the 
directories with scripts using MSSQL .)

For example, I've tried to bash the server with the typical scripts, including the 
3 examples you point in your post, from 4 clients making several requests 
at a time. No problem at all. The same happened with queries against 
Oracle8i.


Perhaps we could get together a few simple and a few more complicated
scripts and try them on a range of machines and see if we can start to make
any conclusions.


I'm with you, heavier testing must be carried out. I have limited time, but I'll 
post more results here as they come along.

Any other thoughts?

just more testing ... if you or anybody wants me to test more scripts, just send them 
to me.

Greetings,

Paco






-- 
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DEV] PHP as ISAPI module crashes but...

2001-03-07 Thread Phil Driscoll

Paco wrote:

are you trying with 4.0.4pl1? Try, please. I had the same problems with
previous

Yes, I've been using 4.0.4pl1 since day '0', and it 'reliably' goes wrong
for me. Are you using NT4 or W2K?

Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org


-- 
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DEV] PHP as ISAPI module crashes but...

2001-03-07 Thread Paco Ortiz

Hi:

Yes, I've been using 4.0.4pl1 since day '0', and it 'reliably' goes wrong
for me. Are you using NT4 or W2K?

I'm using NT4, SP6 and IIS 4. I have the MSSQL 2000 client libraries installed
(MDAC 2.6) but I can't think they have any influence (the db API  used by 
php_mssql is backwards compatible with MDAC 2.x AFAIK).

Some more "casual" information in case it helps: with earlier versions, whenever the
IIS server crashed, both .PHP and .ASP pages stopped working . However, static 
content was served fine, as I pointed in a bug report.

Now with 4.0.4pl1, when a script using MSSQL queries crashes, the other .PHP or
.ASP scripts keep working. Other scripts using MSSQL fail. Strange, isn't it?

It's all I can say now. When I have some more tests done (other servers maybe)
I'll make you know. Ask me whatever you might find useful.

Greetings,

Paco


3/7/01 2:31:30 PM, "Phil Driscoll" [EMAIL PROTECTED] wrote:

Paco wrote:

are you trying with 4.0.4pl1? Try, please. I had the same problems with
previous

Yes, I've been using 4.0.4pl1 since day '0', and it 'reliably' goes wrong
for me. Are you using NT4 or W2K?

Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org



___
Francisco Javier Ortiz Torre
ComuNET,S.A.
mailto:[EMAIL PROTECTED]

ComuNET, S.A
Gral. Concha 39,6
48012 Bilbao Espaa
Tel: +34 944 700 101 
Fax: +34 944 700 185 
http://www.comunet.es
___



-- 
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]