Re: PHP/Oracle/mod_ssl/Apache

Hi Steve, if you use OciPLogon to connect to ORA, bad luck. Replace with OCiLogon and your problesm are gone. Of course, *always* remember to ocilogoff() your open connections. In my experience OCIPLogon is broken. It never closes open connections to ora, instead it waits for them to timeout, even if ocilogoff has been called, not a very smart thing... other than that, I have not encountered any problems with SSL or non-SSL connections. Yes, the number of open connections is affected by the ora control file. I think the default is 50, which should be enough for most applications. To change it, you have to restart ora (at least). Good Luck, -Stathis. Steve Farmer wrote: > > hi Brian, > > I'm curious to know whether or not you are using persistent > connections from Oracle. > > And do your problems disappear if you restart the Oracle db? > > We are having some problems with to many sessions being created with > persistent connections and we think there are a couple of parameters > .. > > 1) no of connections allowed in apache. (this could explain why SSL > id different to NON-SSL connections) > > 2) no of sessions an oracle user is allowed to create. > > 3) How many connections we provide in the oracle listener connection pool. > > Regards > Steve Farmer > > At 1:41 PM -0600 9/3/01, Brian.J.Mauter wrote: > >Hello, > > > >I am running an Apache 1.3.19 server with mod_ssl, PHP 4.0.4pl1, and > >Oracle 8.1.6. > > > >Oracle is only installed so that we could compile PHP --with-oci8. When I > >originally got everything going, it worked well. > > > >After about two weeks, PHP works fine, Apache works fine, but when I try > >to logon to the Oracle database (via TCP), I get an ORA-03106 error on the > >OCISessionBegin statement. I can write another php page logging into the > >database and everything seems to work fine. > > > >If I go to another server setup exactly the same as the first, the same > >script will work just fine. After about two weeks, the script runs great > >via https, but not plain http. It's really fast with https. > > > >You're welcome to see what I'm talking about with: > > > >FIRST: > > >>http://cbhp.ua.edu/~bmauter/oracle.php?query=select+*+from+meal > > > >SECOND: > > >>http://airwest.cba.ua.edu/~bmauter/oracle.php?query=select+*+from+meal > > > >THIRD: > > > >����8�Y[a�8:]�https://airwest.cba.ua.edu/~bmauter/oracle.php?query=select+*+from+meal > > > >If anyone has had similar problems, please let me know. I have no idea > >what is going on. > > > >Thanks in advance, > > > >Brian Mauter > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > --------------------------------------------------- > "Minds are like parachutes, they work best when open" > Support free speech; visit http://www.efa.org.au/ > > Heads Together Systems Pty Ltd http://www.hts.com.au > Email: hts@hts.com.au Tel: 612 9982 6767 Fax: 612 9981 3081 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net