Re: [PHP-DB] Re: Problems w/ OCI

2001-12-06 Thread B. PERRINE

le jeu 06-12-2001 à 06:14, John Kolvereid a écrit :
 It's me again,
 I got it.  1st, disregard the Mysql concerns.  It was only slow because
 it wouldn't display until Oracle finished in the same script.  2nd, the
 reason that OCI did not work during the boot up was because APACHECTL which
 starts the web server needed $ORACLE_HOME to find something (not sure
 what).  I simply added the line
 export ORACLE_HOME=/u01/app/oracle/product/8.1.7
 and now it works on bootup.   Whew
 I would like to know if someone out there knows why APACHECTL requires
 $ORACLE_HOME, and/or what can be done to avoid putting in the extra line.  I
 think this would eliminate a lot of grief to the ORACLE community.
Thanks.
 
 John Kolvereid wrote:
 
It isn't apache, launched with apachectl, that need the environnement
variable ORACLE_HOME, but the php extension oci8. The reason why is to
locate an oracle library to use the middleware : net8. Net8 is the
feature that use php to connect itself to an oracle database.

Look at the annoted php manual, oci8 section. There is a lot of tips
about this case.

B.


--
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, PHP4, BSD

2001-11-27 Thread B. PERRINE

le jeu 08-11-2001 à 23:52, D. Witten a écrit :
 These are pretty basic questions, but I would appreciate help:
 
 I need to access Oracle (already running on a separate server) via PHP4 from
 a FreeBSD Server.
 
 1) Can this be done?
 (if so...)
I don't think so. But if the BSD can run linux prog, then you may try to
install oracle (client part) on your server via the oracle java
installer : OUI. It come with oracle.
 2) Where do I find instructions?
technet.oracle.com product : 8i, some howto exists.
 3) Where do I get php_oci8
with php
 4) Do I HAVE to install code from Oracle (the Oracle client, etc) on my
 server?
 (if so,,,)
see 1)
 5) Where do I get that client software?
 
 Thanks
 
 Dave Witten
 
 
 
 -- 
 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]




Re: [PHP-DB] Re: What software do I need in order to access Oracledatabase on an NT server from my unix machine?

2001-11-27 Thread B. PERRINE

le mar 27-11-2001 à 17:19, Philippe Saladin a écrit :
 AFAIK, you need to install the oracle 8 client for linux onto your machine.
 Unfortunately, it can't be downloaded alone. you need the entire Oracle 8
 database release for Linux, available at www.oracle.com
 
 Hope I'm not wrong. Please correct me there's an error
 Regards,
 Philippe

I confirm.
B.


--
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] Problem with Oracle connection

2001-11-27 Thread B. PERRINE

le ven 23-11-2001 à 02:18, Jonathan B. Bayer a écrit :
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 Hello php-db,
 
 We have a RedHat 7.1 server with a stock install.  I recompiled PHP from
 the source RPM in order to add oracle support.
 
 It mostly works, but we are having a problem where it apparently
 randomly loses the connection to the database.  It is an oracle database
 which is on the local network;  another system (a Sun) doesn't have this
 problem, so that rules out the database.
 
 Does anybody have any experience with this happening?
 
 
 Thanks in advance.
 
 
 JBB

I guess you are using php-4.0.6, I met this problem on a Debian with
this PHP version.
B.


--
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] executing system commands

2001-10-30 Thread B. PERRINE

Get a look at the PHP manual on www.php.net or mirror, 
annoted version, 
command : system,
there is a good example.

regards
B.

le jeu 25-10-2001 à 12:46, Ric Manalac a écrit :
 hi,
 
 i'm a newbiew php developer. i'm trying to
 execute a system command in one of my
 php scripts. what i would like to do is to
 create a directory. my code goes like this:
 
 // chunk of code starts here
 $directory = generate_sessionid();
 $command = mkdir /home/httpd/html/miroku/downloads/$directory;
 system($command, $dirsuccess);
 // chunk of code ends here
 
 generate_sessionid() is a function that
 generates a string that contains 16 random
 integers (0-9). i want to use that random string
 as the name of the directory that i'm creating.
 i checked php3.ini if safe mode is on but it is
 set to Off. thanks in advance!
 
 regards,
 
 ric
 
 --
 
 ==
 Note: The information contained in this message may be privileged
 and confidential and protected from disclosure. If the reader of
 this message is not the intended recipient,or an employee or agent
 responsible for delivering this to the intended recipient,you are
 hereby notified that any dissemination, distribution or copying of
 this communication is strictly prohibited. If you have received
 this communication in error, please notify us immediately by
 replying to the message and deleting it from your computer.
 Thank you.
 ==
 
 
 
 

 -- 
 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]




Re: [PHP-DB] Difference between OCI* functions and ORA_* functions

2001-10-04 Thread B. PERRINE

ORA are for Oracle7
OCI8 for Oracle8

Read the manual on www.php.net
B. 

le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit :
 Hi All,
 
 Does any one know the difference between OCI* functions from PHP_OCI8.DLL
 and ORA_* functions  from PHP_ORACLE.DLL?
 Which one is better in terms of speed and which one is better for future
 compatibility?.
 
 Thanks in advance
 Sridhar Moparthy.
 
 
 -- 
 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]