Re: [PHP4BETA] OCI8 persistant connections fail after database restarted

Excellent! I'll look into these solutions. Thanks for your assistance! kevin khendrix@pennypi.com thies@digicol.de wrote: > > On Wed, May 10, 2000 at 09:29:04AM -0500, Kevin Hendrix wrote: > > Hi. > > > > We are using TCP connections. It should be possible to do this ... when PLogon > > is called, the auth credentials are passed back in, so they should not need to > > be cached between scripts. The first real oracle interaction that failed on > > the pconn (probably a parse) could trigger a single attempt at reconnect, > > failing with appropriate error condition if the reconnect fails... It'd be > > complex, but not impossible. > > what i do right now is that i close the connection and remove > it from the persistent list once a fatal error has happened! > that should take care of this situation mostly. this is done > in ociexecute (oci8.c:1188) - maybe we just need to add > 'nother error-code here to make it work for you > > -OR- > > there is some commented out code that will check the > connection *before* it's returned to the script in > ext/oci8/oci8.c line 2062. just uncomment the oci_ping stuff > and connections will be "pinged" before returned to the > script! > > tc > > > > > Just an idea... > > kevin > > khendrix@pennypi.com > > > > thies@digicol.de wrote: > > > > > > On Mon, May 08, 2000 at 12:49:42PM -0500, Kevin Hendrix wrote: > > > > The subject pretty much says it all. I've got a Redhat 6.2 box running > > > > Secure Web Server 3.2 (Apache 1.3.12) and PHP4RC1 using persistant connections > > > > to an Oracle 8i server on another box. > > > > > > > > When the 8i server is restarted, all PHP persistant connections that were > > > > pinned up before the 8i reboot continue to fail. Shouldn't there be some > > > > error recovery built in that wouldn't require an apache restart? > > > > > > that's what should happen - i'll have to dig into that. > > > > > > what connection Net8 connection are u using? beq, tcp, ipc > > > > > > > > > > > kevin > > > > khendrix@pennypi.com > > > > > > > > -- > > > > PHP 4.0 Beta Mailing List > > > > <http://www.php.net/version4/> > > > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > > > For additional commands, e-mail: php4beta-help@lists.php.net > > > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > > > > > > -- > > > > > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > > > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > > > Hammerbrookstr. 93 20097 Hamburg / Germany > > > > > > -- > > > PHP 4.0 Beta Mailing List > > > <http://www.php.net/version4/> > > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > > For additional commands, e-mail: php4beta-help@lists.php.net > > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > > -- > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > Hammerbrookstr. 93 20097 Hamburg / Germany