[PHP-DB] Oracle errors not returning w 4.30
Hi all, We recently upgraded to php 4.30 and now our oracle errors are not returning.. This used to work $errmsg = ocierror($err_curs); ocirollback($err_conn); $errtext = $errmsg['message']; TIA Steve -- - Nearly all men can stand adversity, but if you want to test a man's character, give him power. -Abraham Lincoln, U.S. president (1809-1865) Support free speech; visit http://www.efa.org.au/ Heads Together Services Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle errors not returning w 4.30
Hey Thies, Weird problem.. I have just discovered that it is not working on only some machines. does it depend on certain environment variables being set either at run time or during compile? Most likely it can't find the ora_messages I would imagine. Regards Steve At 12:41 PM +0100 12/2/03, Thies C. Arntzen wrote: On Wed, Feb 12, 2003 at 07:43:48PM +1100, Steve Farmer wrote: Hi all, We recently upgraded to php 4.30 and now our oracle errors are not returning.. This used to work $errmsg = ocierror($err_curs); ocirollback($err_conn); $errtext = $errmsg['message']; works for me - could you send a _short_ selfcontained script that shows your problem? re, tc -- - Nearly all men can stand adversity, but if you want to test a man's character, give him power. -Abraham Lincoln, U.S. president (1809-1865) Support free speech; visit http://www.efa.org.au/ Heads Together Services Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP database
Hi, I would try to convince the admin that a DB like MYSql (which is actually part of the standard install under Redhat now) is much more secure than storing data in text files !! HTH Steve At 11:02 AM +0200 15/7/02, Tomator wrote: Hello I'm to have database, but server's administrator refuses to install MySQL nor PHP MySQL support :( He told me he won't install it and I should use textfiles if I want to have database. I don't want to write engine to textfiles, so... Can You point where can I find PHP code which realize basic database functions without installing any not standard functions nor modules on unix/linux server? -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle
Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php- Oracle
Hi Michael, So what you are saying is that apache/php will keep opening sessions until oracle runs out of processes or cursors or memory or hits session_per_user maximum ?? I was thinking of experimenting with the profile parameter IDLE_TIME Profile Parameter to make oracle close open sessions after a certain amount of time , have you any experience with this? I have open_cursors = 500 processes = 200 max_enabled_roles = 30 regards Steve At 8:24 AM +0200 9/7/02, Michael Bretterklieber wrote: Hi, this depends on your settings in the initinstance.ora in the directory /opt/oracle/OraHome1/admin/instance/pfile dir. Here are some settings: processes = 150 open_cursors = 300 max_enabled_roles = 30 you also have to set the sizes of the shared-memory pool. bye, Steve Farmer wrote: Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- -- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 [EMAIL PROTECTED] homepage: http://www.jawa.at - privat --- E-mail: [EMAIL PROTECTED] homepage: http://www.inode.at/mbretter -- ...the number of UNIX installations has grown to 10, with more expected... - Dennis Ritchie and Ken Thompson, June 1972 -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle IDLE_TIME Profile Parameter plogon
Hi, At 1:40 PM +0200 8/7/02, B. PERRINE wrote: We are using these ORACLE PARAMETERS, but we don't use plogon; too problems. Instead, we use one logon per request. Is any one really use plogon successfully with Oracle Database 8i and more ? I am using plogon with no problems, apache is compiled with enable-sigchild on It is only one DB that is causing me any drama ! Regards Steve Le lun 08/07/2002 à 05:45, Steve Farmer a écrit : HI all, I was wondering if anyone had experimented with the Oracle Profile parameters such as IDLE_TIME, CONNECT_TIME or SESSIONS_PER_USER in order to control the number of connections apache/php makes to the Oracle DB when using plogon? I was thinking of experimenting with this and wondered if anyone had any pointers? Regards Steve Farmer -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle IDLE_TIME Profile Parameter plogon
HI all, I was wondering if anyone had experimented with the Oracle Profile parameters such as IDLE_TIME, CONNECT_TIME or SESSIONS_PER_USER in order to control the number of connections apache/php makes to the Oracle DB when using plogon? I was thinking of experimenting with this and wondered if anyone had any pointers? Regards Steve Farmer -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sql standard
Hi, In Oracle they are all UPPERCASE !! Rgds Steve At 11:15 PM -0400 23/6/02, Gerard Samuel wrote: Hope someone can confirm this. I was moving a mysql dump to postgresql, and I had 2 tables with MiXeD upper/lower case letters, that got converted to lowercase. I found a discussion that sql column/table/database names should be lowercase. Just trying to keep in line with a standard. Thanks -- Gerard Samuel http://www.trini0.org:81/ http://dev.trini0.org:81/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] THIS IS A HOAX !!! WARNING !!Re: [PHP-DB] Virus alarm!
Folks, check anti virus sites this is a hoax and will destroy your windows system !! regards Steve At 11:25 AM +0200 16/5/02, Trond Erling Hundal wrote: Jeg fikk en mail fra en I adresseboken min om et nytt virus, som hadde slettet hele harddisken hans! Jeg fant da også ut at jeg hadde blitt infisert av samme virus, og siden du står I adresseboken min kan du også være infisert. For å sjekke om du har fått viruset, gjør dette: 1. Klikk på start - søk 3. Merk av for at du vil søke på hele harddisken. 2. Skriv: sulfnbk.exe, og trykk på søk. 4. Dersom du finner programmet, IKKE START DET. Slett det, og deretter slett det fra papirkurven. 5. Send advarsel videre til alle I adresseboken din. ENGLISH: I recently discovered a virus on my computer that none of my antivirus programs could detect. It spreads through the adressbook, and since you are in my addressbook, I am warning you. The virus deletes everything on your harddisk after 14 days! Here's how you can detect it, and delete it: 1. Go to start - search. 2. Look in all the harddrives on your computer (C:, D:, E: etc) 3. search for a file named: sulfnbk.exe 4. If you find it delete it, then delete it from your recycle bin. 5. Warn everyone who is in your adressbook! Med vennlig hilsen Trond Erling Hundal Daglig leder Epost: [EMAIL PROTECTED] Internett: www.innovationmanagement.no Telefon: 73 54 03 80 Mobil: 918 41 117 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? Sorry
Hi Jason, You need the Oracle client installed and working rgds Steve At 11:39 AM -0500 1/3/02, Jason Lehman wrote: This may be a stupid question but I am stuck. Do I have to have the Oracle Linux Client to connet to a remote Oracle Database or can I just have the php --with-oci8 turned on and that be it? And I can't seem to find any how-tos on just installing the client and I am not sure what prerequisites I need on my computer to install just the client. Any help would be appreciated. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] The Debacle
Hi, I have a similar system.. only problem is a band called The The :) we manually entered and corrected the artists http://www.musicexperts.com/ steve At 11:16 PM + 24/2/02, Peter Lovatt wrote: When you add the data //does it begin with 'The '? $name_start = substr($band_name, 0, 2) if ($name_start==The) { //remove the word 'The' and following space from the beginning of the string str_replace('The ', '', $band_name) ; //add ', The 'to the end of the name $band_name=$band_name.', The'; } You might want something more sophisticated if The with a capital is found in the middle of names, but hope this is a start Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]] Sent: 24 February 2002 18:36 To: [PHP-DB] Subject: [PHP-DB] The Debacle I'm putting together a table with bands, and I have a slight problem. Well it not really a problem as much as I'd like some input from more seasoned professionals. Certain band names begin with The but when listing them it would be of great advantge to me to remove the the. Has anyone else faced this dilemma? I was thinking that when inputting and editing band names that I could just scripot a new column with the comma in place. I suppose librarys have this difficulty as well. So what is it? Column 1 - The Distillers Column 2 - Distillers, The Or a bit of PHP programming every time I list them (seems more difficult.) Either way, does anyone have the propper PHP function I should use? Thanks much... -Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Access with PHP on Linux?
Hi Andreas, At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: At 13.11.2001 23:23, Chris Payne wrote: Hi there everyone, [snip] I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Install ODBC, that would let you interface with degenerate database formats as access et al. When you say install ODBC, I assume you mean on the Linux box. Could you give me a pointer as to the best way to achieve this ? [snip -- Andreas D Landmark / noXtension Regards Steve -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] Sorting a 2 dimension array
Hi, Why don't you sort the query to MYSQL and have the records delivered in the order you want them? HTH Steve At 5:31 PM +0930 5/10/01, John Clarke wrote: I would like to sort a 2 dimensional array based on the value of one of the keys of each element. I have an array returned from a msql query which contains 10 records/elements and each record 5 fields/keys. I would like to sort the records based on the value of a particular field in each record. Is this possible.? I have looked thru all the array functions but cannot seem to find anything that allows me to do this. I dont want to write a separate peice of code to compare all of these elements and their values and then place them into a new array in the correct order if there is a simpler way of achieving it. Any comments would be greatly appreciated. Regards, John Clarke -- PHP Database 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] -- - 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] USA Attacks
Hi, My heart goes out to all our American cousins in their time of tragedy. Steve Farmer -- --- 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] order by question
Hi Andrius, try order by date desc Steve At 9:12 PM -0700 11/9/01, Andrius Jakutis wrote: Ok, here is the question: I write to order by date Order by date. So, it output's something like this: 2001 08 01 2001 08 02 2001 08 03 What if I want to order by date, but not from the older to newest, but from newest to older ? The same is with numbers - priority I use order by priority. It lists: 1 2 3 4 But how to list like this: 4 3 2 1 Thanks -- --- 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] ora_logon receive ora-12154
Hi Miguel, try if(!($conn=ora_logon(user,pass,SERVICE))) it always works for me HTH Steve At 10:47 PM +0100 3/5/01, Miguel wrote: Hi, I'am having serious problems in put php acessing a remote oracle 8 database, i have tried several configurations but always end up with Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in /var/www/htdocs/support/teste.php on line 5 I can access this database from sqlplus and when I start apache all oracle variables are set. If I get rid of the connect string and access my local database then everything is ok. My code is something like... putenv(ORACLE_HOME=/apps/oracle/8.1.7); putenv(TNS_ADMIN=/apps/oracle/8.1.7/network/admin); // main if(!($conn=ora_logon(user@SERVICE,pass))) echo Error: Cannot connect to database\n; exit; } Using: apache: apache_1.3.19 php4: php-4.0.5 Linux: Red Hat 7.0 with latest patch's Remote Oracle DB: Oracle 8.1.6 W2K Local DB: Oracle 8.1.7 Linux php build with: --with-oci8 --with-oracle Any help would be apreciated... Thanks, Miguel -- PHP Database 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] -- --- 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] Migrating from InterBase 4.0 to 6.0
Hi all, I need to migrate a database from InterBase 4.0 to 6.0 . Question is has anybody done this and what are the snafus !! The migration docs for 6.0 only seem to mention migration from 5.0 !! I would imagine a complete export from 4.0 and import into 6.0 would be the way to go. Any suggestions would be appreciated Regards Steve -- --- 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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] date_format for Oracle
Hi Richard, try TO_DATE or TO_CHAR , depending upon what you are trying to do, there are about 2 pages of formatting options for these functions. HTH Steve At 10:12 PM + 11/4/01, Richard Crawford wrote: This isn't strictly a PHP question, I suppose... but is anyone aware of a date_format function for Oracle comparable to MySQL's date_format() function? -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] date_format for Oracle
Hi Joe, Yes, I put this in as a standard statement immediately after i connect to the orcale database, it is also possible to put it in your init.ora file i believe rgds Steve At 8:28 PM -0400 11/4/01, Joe Brown wrote: Also consider the oracle sql ALTER SESSION SET NLS_DATE_FORMAT='-MM-DD HH24:MI:SS' or whichever format you prefer. This sets the default format returned when selecting a date column. -Joe "Steve Farmer" [EMAIL PROTECTED] wrote in message news:p04320402b6fa8a7ffc70@[203.28.219.179]... Hi Richard, try TO_DATE or TO_CHAR , depending upon what you are trying to do, there are about 2 pages of formatting options for these functions. HTH Steve At 10:12 PM + 11/4/01, Richard Crawford wrote: This isn't strictly a PHP question, I suppose... but is anyone aware of a date_format function for Oracle comparable to MySQL's date_format() function? -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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 Database 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] -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] Oracle vs MS SQL vs MySQL
Hi Brian, At 7:24 PM -0500 4/4/01, Brian.J.Mauter wrote: Hey, Has anyone tried out all three of these DBMS packages and evaluated them? well not all of them :) I was wondering what everyone is having the best luck with when writing PHP scripts. On that level it doesn't make much difference to me I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P Kinda wondering what in particular is a PIA about it, apart from the knowledge level required to install, configure and tune Oracle !! While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) MySQL - best price :) , very fast when doing reads, not very good when a lot of writes are happening, lacking in some fundamental features eg foreign keys etc. Integrates well with PHP. PostGres - no experience , but V7 seem to be getting very good reviews, I am going to try it out very soon now. Oracle - the "18 wheeler" of the RDBMS world. Expensive but highly scaleable, full featured , excellent security etc. It needs a fair amount of knowledge to really get it happening though. PHP integrates well, including with stored procedures. So IMHO it's a matter of "horses for courses" i.e. choosing the right tool for the job. Thanks, Brian HTH Steve Farmer -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] PHP/Oracle/mod_ssl/Apache
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: 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] PHP4/Apache on Win95 to remote Oracle
Hi Guys, Not sure what your problem is since i haven't run apache on WIN32 but tnsping only tells you that the listeners is running, not that you can connect to the database... Use sql*plus to connect and then you can be sure your Oracle client is installed and configured correctly. If you have all you environment variables set it should work OK.. BTW i'm not sure if putenv("ORACLE_HOME=D:\PROGRA~1\ORAWIN95"); is ok, i think you should put the full path name in without any ~ or try installing oracle directly on the C: drive so you get a path with no spaces in it Otherwise it must be something to do with the way php has been compiled ... if you do a phpinfo() do all the environment variables look OK and is OCI8 support complied ? I have connected remotely from linux/apahe to a variety of oracle DB's on a variety of remote platforms HTH Steve Farmer At 4:39 PM -0600 8/2/01, Mark Farver wrote: Please help. I'm going maaddd trying to figure this out. I've pretty much read all of the online docs and spend countless hours reading through the archives.. I'm running PHP4 and Apache on my Win95 computer. I'm trying to connect to a remote Oracle database. I had the same problem last week. Every suggestion I got was about environment variables. However since a tnsping from within PHP (using passthru) works fine I know better. From examining the sqlnet files and watching the resource allocations I came to the conclusion that PHP is hardcoded to connect only to a database located on the same machine (using BEQLOCAL). Oracle never even bothers to read the tnsnames.ora file when its called from PHP. This seems to be only a problem in Windows and possibly only with the Oracle8 drivers. My postings to the dev lists went unanswered but at the time I was unsure if it was a Windows only problem. It might be worth reposting this info to the PHP-WIN list. My boss was very unhappy when I told him my code had to run on a Unix box.. I basically sold him on PHP due to is cross-paltform nature. ODBC might work instead, although it never did for me. Use ADODB or another abstraction layer.. this way you can switch back and forth easier. Let me know if you figure anything else out. Mark Farver [EMAIL PROTECTED] On Thu, 8 Feb 2001, Jorge Santos wrote: Hi all, I'm getting a "Warning: _oci_open_server: ORA-12203: TNS:unable to connect to destination ..." error message. Yet I know the environment is ok because I can tnsping the database name and I can connect using SQL Plus to the database. Here's the php code: ?php putenv("ORACLE_SID=MDC6"); putenv("ORACLE_HOME=D:\PROGRA~1\ORAWIN95"); putenv("TNS_ADMIN=D:\PROGRA~1\ORAWIN95\NET80\ADMIN"); $tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =TCP)(HOST = njnwkora15.db.pseg.com)(PORT = 1527))) (CONNECT_DATA = (SID =MDC6) ) )"; $connect=OCIPLogon("MDC","MDC",$tns) or die("It's not possible to connect"); $sql = "select * from district"; $result =OCIParse($connect,$sql); OCIExecute($result) or die("It's not possible to query"); echo("TABLE"); while(OCIFetch($result)) { $CC = OCIResult($result,1); $CCNome = OCIResult($result,2); echo('TRTD' . $CC . '/TDTD' . $CCNome . '/TD/TR'); } echo("/TABLE"); ? I shouldn't need to declase $tns above but I've tried with and without it. I'm also including the ORACLE_SID, ORACLE_HOME and TNS_ADMIN variables in the autoexec.bat so that they are declared as of machine bootup. I also added them to the httpd.conf for Apache configuration like this: SetEnv ORACLE_SID MDC6 SetEnv ORACLE_HOME D:\PROGRA~1\ORAWIN95 SetEnv TNS_ADMIN D:\PROGRA~1\ORAWIN95\NET80\ADMIN Please help Before I switch to ASP... Later, Jorge [EMAIL PROTECTED] -- "The greatest dangers to liberty lurk in insidious enroachment by mean of zeal, well-meaning but without understanding." -- Justice Louis O. Brandeis, Olmstead vs. United States -- PHP Database 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] -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] Oracle TNS problems with PHP4?
Hi Mark, I run Oracle 8i with apache and PHP 4 on about 6 different machines , all connect to a remote DB and i have no problems @ all. Regards Steve Farmer At 8:29 AM -0600 2/2/01, Mark Farver wrote: I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache and PHP4.04pl1. I'm getting consistent TNS No service errors from PHP using all three methods of accessing Oracle (oracle,oci,odbc). ODBC works fine in other apps, and the SQLPlus and tnsping work fine (even when called from a passthru(), so its not environment related). I've noticed a large number of bug reports on this.. but no answers (other than modifing the ORACLE_SID, and ORACLE_HOME environment vars, and that only works if the DB is local). I'm trying to nail down how widespread this problem is... How many of you have Oracle working with PHP4? What version of the Oracle drivers? Are you accessing a local db or a remote one? Did you have to tweak any settings to make it work? Windows or Unix? Thanks Mark -- "The greatest dangers to liberty lurk in insidious enroachment by mean of zeal, well-meaning but without understanding." -- Justice Louis O. Brandeis, Olmstead vs. United States -- PHP Database 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] -- --- "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: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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-DB] Message Boards
Hi all, Apologies if this is off-topic .. I am looking for a simple message/news board for a non-profit association(Surf Lifesaving Club in fact). I have tried Nope but cannot get it running and have had no response from posting to their install messageboard. i just want something that the club can use to post simple messages about up-coming events etc.. Can anybody point me in the right direction., i have looked around a fair bit, but most of them seem to be much to heavyweight for what I need. It is basically to replace a static news page and allow several authorised people to post news items TIA Steve Farmer -- --- "I disagree completely with what you are saying, but I will defend to the death your right to say it" - Voltaire Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database 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]