Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:17309 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 35654 invoked by uid 1010); 18 Jul 2005 08:15:28 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 35638 invoked from network); 18 Jul 2005 08:15:28 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 18 Jul 2005 08:15:28 -0000 Received: from ([127.0.0.1:11166]) by pb1.pair.com (ecelerity 2.0 beta r(6227M)) with ECSTREAM id 7A/B7-61486-F156BD24 for ; Mon, 18 Jul 2005 04:15:28 -0400 X-Host-Fingerprint: 212.157.39.84 smtpa3.tf1.fr Windows 2000 SP4, XP SP1 Received: from ([212.157.39.84:2700] helo=tfmelsw2.tf1.groupetf1.fr) by pb1.pair.com (ecelerity 2.0 beta r(6227M)) with SMTP id F8/97-61486-F636BD24 for ; Mon, 18 Jul 2005 04:08:16 -0400 Received: from MSGEXS1.tf1.groupetf1.fr ([10.210.35.61]) by TFEXFSW1.tf1.groupetf1.fr with Microsoft SMTPSVC(6.0.3790.211); Mon, 18 Jul 2005 10:08:11 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Mon, 18 Jul 2005 10:08:10 +0200 Message-ID: <0CEAE485BEBFFB488D93F1800C067F53DBA5C5@MSGEXS1.tf1.groupetf1.fr> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [OCI8] Patch for bug #29779 Thread-Index: AcWLb0j1VutYmCrwRCOQa4eE9P1YPA== To: "internals" X-OriginalArrivalTime: 18 Jul 2005 08:08:11.0295 (UTC) FILETIME=[D6E5EAF0:01C58B6F] Subject: [OCI8] Patch for bug #29779 From: JFBUSTARRET@tf1.fr ("BUSTARRET, Jean-Francois") I created a patch for http://bugs.php.net/bug.php?id=3D29779 (which can be= considered as a feature request more than a bug). =0D Rather than pinging existing connection each time, which would slow down= things too much for high traffic sites, the patch pings connections only= every x seconds. Considering this problem occurs when a firewall drops= idle connections after let's say one hour of inactivity, I think this is a= fine solution. I added a php.ini variable : oci8.ping_freq (if not set, oci8 works like= before). The code adds a last_ping timestamp to the server struct, and= pings when ping_freq > 0 && (time(NULL) - last_ping) > ping_freq. It= otherwise uses the commented oci_ping call. The patch (against CVS/5.0 branch) can be found at : http://www.jeuxdecartes.net/static/oci8.ping_freq.patch Hope you'll find this patch ok, and will include it in future releases of= 5.0. Jean-Fran=E7ois Bustarret eTF1 - http://www.tf1.fr ------------------------------------- Le present message (y compris tous les elements attaches) est confidentiel= et est destine a ses seuls destinataires. Si vous l'avez recu par erreur, merci de l'indiquer a son expediteur par retour et= de proceder a sa destruction dans vos systemes.=0D Toute utilisation ou diffusion non autorisee de son contenu, en totalite ou= en partie, est strictement interdite. Les idees et=0D opinions presentees dans ce message sont celles de son auteur, et ne= representent pas necessairement celles de TF1 (et/ou des=0D entites membres du Groupe TF1). This message (including any attachments) is confidential and may be= privileged. If you have received it by mistake please notify=0D the sender by return email and delete this message from your system. Any= unauthorised use or dissemination of this message in=0D whole or in part is strictly prohibited. Any views or opinions presented= are solely those of its author and do not necessarily=0D represent those of TF1 (and/or its group companies).