php-windows Digest 10 Dec 2001 09:36:42 -0000 Issue 893
Topics (messages 10814 through 10815):
Re: PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon Windows 2000 Server
10814 by: Ignatius Teo
Plug-in detection.
10815 by: Mark Hope
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Actually, we run Apache/Oracle 8.1.6/mod PHP4 on Unix boxes here and we also
have problems with Oracle maintaining persistent connections. PHP does not
maintain a persistent connection to Oracle no matter what. It will insist on
creating a new resource id for each discrete call to OCI8 - the obvous
result is that you will have many open connections until Oracle carks and u
get a "TNS cannot resolve service name error".
The one thing I haven't tried yet, but theoretically should work is to
maintain the db resource as a session variable across the application. But
that's kludging a "persistent" connection really....
Really, is this a tuning problem in Apache, or Oracle, or something in PHP?
Ignatius
----- Original Message -----
From: "Robin Bolton" <[EMAIL PROTECTED]>
To: "'Asendorf, John'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 6:55 PM
Subject: RE: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon
Windows 2000 Server
> <reply all - grin>
>
> John, might I suggest that if you are converting a database from oracle
> you may want to consider a database that may more closely matches your
> previous system.
>
> You may be familiar with a Borland InterBase, well they have an open
> source descendant named 'Firebird'.
>
> You can check it out at: http://firebird.sourceforge.net/
>
> And all of the PR material can be found at http://www.interbase.com,
> anything that InterBase has, Firebird has (and more).
>
> I'd suggest you give it a quick run through, it's very easy to set up,
> and there are several free, quite good gui interfaces.
>
> And, to top it all off... PHP 4 has full support of InterBase 6.0:
> http://www.php.net/manual/en/ref.ibase.php
>
>
> > -----Original Message-----
> > From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> > Sent: December 6, 2001 10:42
> > To: Jozsef Szilagyi; [EMAIL PROTECTED]
> > Subject: RE: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon
> > Windows 2000 Server
> >
> > The main reason is because you're probably NOT getting a persistent
> > connection with IIS. I've been fighting with this problem of Oracle
> for
> > so
> > long that I finally gave up on it. I started on IIS4 but couldn't
> keep
> > the
> > server from breaking down after a couple of hours after the first
> login
> > while using the ISAPI module. There are no persistent connections as
> CGI
> > (obviously)... then I switched to Apache and had the same problem
> you're
> > describing. The only way I was able to "fix" it was to increase the
> > timeout
> > on the Oracle side. But, it still doesn't keep the persistent
> connection
> > open very well.
> >
> > SO, I've ported the entire thing over to MySQL (luckily the databases
> > aren't
> > too big (5 tables, 3 tiny ones and 2 big ones (40,000 and 120,000
> records
> > each).... and will be making the transfer the first of the year.
> >
> > I tried a million different things. What I would mostly suggest is to
> use
> > the latest php 4.0.8-dev from www.php4win.com and see if some of the
> > changes
> > Thies has been working on make a difference... he has made a number
> of
> > changes trying to combat the Oracle on Windows nightmare but I don't
> think
> > they are included in the 4.0.6 release, and whether or not they'll
> work I
> > don't know.
> >
> > Good luck, please let me know if you have any,
> >
> > John
> >
> > ---------------------
> > John Asendorf - [EMAIL PROTECTED]
> > Web Applications Developer
> > http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> > Licking County, Ohio, USA
> > 740-349-3631
> > Nullum magnum ingenium sine mixtura dementiae fuit
> >
> >
> > > -----Original Message-----
> > > From: Jozsef Szilagyi [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, December 06, 2001 12:18 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-WIN] PHP 4.0.6 Apache 1.3.12 Oracle 8.1.5 OCIPlogon
> > > Windows 2000 Server
> > >
> > >
> > > Hello !
> > >
> > > I have a strange problem, with the combination of configuration on
> the
> > > subject.
> > > When want to use permanent connection to Oracle (OCIPlogon) the
> > > oracle sessions never end, and quiclky raise the 50 limit of Oracle
> > > procesess.
> > >
> > > BUT when I use on the same machine, with the same PHP, Oracle,
> > > and the same php scripts, only i change the webserver from Apache to
> > > IIS 5.0, the problem dissapeared. The IIS only open a very
> > > low number of
> > > connection
> > > and the connection time (for the second request) is much much
> > > small than
> > > the same thing under Apache.
> > >
> > > Now my question is, where is the problem ?
> > > Why with IIS is ok, and with Apache not ?
> > >
> > > SzJ.
> > >
> > >
> > >
> > >
> > > --
> > > PHP Windows 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]
> > >
> >
> > --
> > PHP Windows 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]
>
>
>
> --
> PHP Windows 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]
>
--- End Message ---
--- Begin Message ---
I'm looking for a way to detect the flash plug-in, writing a suitable
include file for those that have the plug-in, and another include for
those that don't.
Can anybody point me in the right direction.
Mark Hope
--- End Message ---
