Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Grant Croker wrote: > DYLD_LIBRARY_PATH=/opt/oracle/instanceclient > LD_LIBRARY_PATH=/opt/oracle/instanceclient > ORACLE_BASE=/opt/oracle/instanceclient > ORACLE_HOME=/opt/oracle/instanceclient > export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME > > (note: As Chris Jones mentioned LD_LIBRARY_PATH is not used on OS X, > however there is no harm in having it set) Thanks for your help getting this resolved. FWIW, I just merged a change to the originally reported "Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed." message. On Mac OS X this now mentions DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH: http://cvs.php.net/viewvc.cgi/pecl/oci8/oci8.c?r1=1.269.2.16.2.38.2.31&r2=1.269.2.16.2.38.2.32 This fix is incorporated into OCI8 1.3.5 downloadable from http://pecl.php.net/package/oci8 It will be available with PHP 5.3 (whenever that comes out). Users of older versions of PHP including PHP 5.2 are encouraged to upgrade OCI8 using PECL. Chris -- Email: christopher.jo...@oracle.com Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/UGPOM -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
On/El 16/03/09 13:03, Mark Halling-Brown wrote/escribió: Grant, thank you very much. You are a life saver. This worked perfectly. Thanks again Mark No problem, g -- Grant Croker - Ingres PHP and Ruby maintainer http://blogs.planetingres.org/grant It was so much easier to blame it on Them. It was bleakly depressing to think that They were Us. If it was Them, then nothing was anyone's fault. If it was us, what did that make Me? After all, I'm one of Us. I must be. I've certainly never thought of myself as one of Them. No one ever thinks of themselves as one of Them. We're always one of Us. It's Them that do the bad things. -- Terry Pratchett, Jingo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Grant, thank you very much. You are a life saver. This worked perfectly. Thanks again Mark On 16 Mar 2009, at 11:53 AM, Grant Croker wrote: Hi Mark, you are right /System/Library/LaunchDaemons/org.apache.httpd.plist will not work in your case, it's for the Mac OS X supplied Apache. In your case you can edit /usr/local/apache2/bin/apachectl adding the following: DYLD_LIBRARY_PATH=/opt/oracle/instanceclient LD_LIBRARY_PATH=/opt/oracle/instanceclient ORACLE_BASE=/opt/oracle/instanceclient ORACLE_HOME=/opt/oracle/instanceclient export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME (note: As Chris Jones mentioned LD_LIBRARY_PATH is not used on OS X, however there is no harm in having it set) Place the above some where near the top of apachectl, I cannot tell you exactly since fink will not install and MacPorts does not build SQLite3. Restart apache and you should see the correct values in getenv() or phpinfo(). regards grant On/El 16/03/09 12:13, Mark Halling-Brown wrote/escribió: Hi Grant, Thanks to your instructions, I am making a bit of progress. I have entered the PassEnv commands into the https.conf.: SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient PassEnv DYLD_LIBRARY_PATH PassEnv LD_LIBRARY_PATH It now seems that this variable is passed through correctly, but it is not as I set it. Instead it states: DYLD_LIBRARY_PATH: /usr/local/apache2/lib: I restart apache as root user (sudo /usr/local/apache2/bin/ apachectl restart) and it complains that: [Mon Mar 16 11:08:53 2009] [warn] PassEnv variable LD_LIBRARY_PATH was undefined So I am guessing that root has not picked up any of the environment variables that I have set in various places around my system. I have put DYLD_LIBRARY_PATH in /etc/bashrc ~/.bash_profileetc, but I still seems root doesn't know about them. Have you any idea where I need to set these variables (Is there a root home directory I can edit a bash_profile or something?) I did edit the /System/Library/LaunchDaemons/org.apache.httpd.plist file, but the apache I am using was compiled from source, so I fear it wont work list that plist? Thanks for all your help Mark -- Grant Croker - Ingres PHP and Ruby maintainer http://blogs.planetingres.org/grant It was so much easier to blame it on Them. It was bleakly depressing to think that They were Us. If it was Them, then nothing was anyone's fault. If it was us, what did that make Me? After all, I'm one of Us. I must be. I've certainly never thought of myself as one of Them. No one ever thinks of themselves as one of Them. We're always one of Us. It's Them that do the bad things. -- Terry Pratchett, Jingo _ Mark Halling-Brown Higher Scientific Officer, Computational Biology & Chemogenomics, Cancer Therapeutics, The Institute of Cancer Research 15 Cotswold Road Belmont, Surrey SM2 5NG, UK Tel: (+44)-20-8722-4300 (ext: 4659) Email: mhallingbr...@icr.ac.uk Web: http://www.markyhb.co.uk "A cynic is what an idealist calls a realist" The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer and network. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Hi Mark, you are right /System/Library/LaunchDaemons/org.apache.httpd.plist will not work in your case, it's for the Mac OS X supplied Apache. In your case you can edit /usr/local/apache2/bin/apachectl adding the following: DYLD_LIBRARY_PATH=/opt/oracle/instanceclient LD_LIBRARY_PATH=/opt/oracle/instanceclient ORACLE_BASE=/opt/oracle/instanceclient ORACLE_HOME=/opt/oracle/instanceclient export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME (note: As Chris Jones mentioned LD_LIBRARY_PATH is not used on OS X, however there is no harm in having it set) Place the above some where near the top of apachectl, I cannot tell you exactly since fink will not install and MacPorts does not build SQLite3. Restart apache and you should see the correct values in getenv() or phpinfo(). regards grant On/El 16/03/09 12:13, Mark Halling-Brown wrote/escribió: Hi Grant, Thanks to your instructions, I am making a bit of progress. I have entered the PassEnv commands into the https.conf.: SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient PassEnv DYLD_LIBRARY_PATH PassEnv LD_LIBRARY_PATH It now seems that this variable is passed through correctly, but it is not as I set it. Instead it states: DYLD_LIBRARY_PATH: /usr/local/apache2/lib: I restart apache as root user (sudo /usr/local/apache2/bin/apachectl restart) and it complains that: [Mon Mar 16 11:08:53 2009] [warn] PassEnv variable LD_LIBRARY_PATH was undefined So I am guessing that root has not picked up any of the environment variables that I have set in various places around my system. I have put DYLD_LIBRARY_PATH in /etc/bashrc ~/.bash_profileetc, but I still seems root doesn't know about them. Have you any idea where I need to set these variables (Is there a root home directory I can edit a bash_profile or something?) I did edit the /System/Library/LaunchDaemons/org.apache.httpd.plist file, but the apache I am using was compiled from source, so I fear it wont work list that plist? Thanks for all your help Mark -- Grant Croker - Ingres PHP and Ruby maintainer http://blogs.planetingres.org/grant It was so much easier to blame it on Them. It was bleakly depressing to think that They were Us. If it was Them, then nothing was anyone's fault. If it was us, what did that make Me? After all, I'm one of Us. I must be. I've certainly never thought of myself as one of Them. No one ever thinks of themselves as one of Them. We're always one of Us. It's Them that do the bad things. -- Terry Pratchett, Jingo
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Hi Grant, Thanks to your instructions, I am making a bit of progress. I have entered the PassEnv commands into the https.conf.: SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient PassEnv DYLD_LIBRARY_PATH PassEnv LD_LIBRARY_PATH It now seems that this variable is passed through correctly, but it is not as I set it. Instead it states: DYLD_LIBRARY_PATH: /usr/local/apache2/lib: I restart apache as root user (sudo /usr/local/apache2/bin/apachectl restart) and it complains that: [Mon Mar 16 11:08:53 2009] [warn] PassEnv variable LD_LIBRARY_PATH was undefined So I am guessing that root has not picked up any of the environment variables that I have set in various places around my system. I have put DYLD_LIBRARY_PATH in /etc/bashrc ~/.bash_profileetc, but I still seems root doesn't know about them. Have you any idea where I need to set these variables (Is there a root home directory I can edit a .bash_profile or something?) I did edit the /System/Library/LaunchDaemons/org.apache.httpd.plist file, but the apache I am using was compiled from source, so I fear it wont work list that plist? Thanks for all your help Mark On 16 Mar 2009, at 10:27 AM, Grant Croker wrote: On/El 16/03/09 09:23, chris smith wrote/escribió: On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown wrote: Thanks for your replies. In my desperation, I declared those environment variables in as many places as I could think of. The script (Although I know I shouldnt), php.ini and also the apache httpd.conf file: SetEnv ORACLE_HOME /opt/oracle/instanceclient SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv ORACLE_BASE /opt/oracle/instanceclient But given that it works on the command line, but not through the browser, I think that the environment variables must be set correctly. Did you restart apache after doing this? The env variables are set correctly for your user, but not apache's (which is the problem). Does the mac have an /etc/environment file? That should cover all users. Unfortunately not although with the stock/supplied Apache web server there is a plist file you can edit to add environment settings. Edit |/System/Library/LaunchDaemons/org.apache.httpd.plist, adding the relevant environment variable key/value information:| http://www.apple.com/DTDs/PropertyList-1.0.dtd "> EnvironmentVariables DYLD_LIBRARY_PATH path goes here ORACLE_HOME path goes here ORACLE_BASE path goes here Label org.apache.httpd . . . Then you use PassEnv in Apache to pass these values through to PHP. The SetEnv directive in Apache is not the same as "setenv" or "export" in csh/bash/etc. Apache maintains its own symbol table for environment variables. Unless the OCI8 extension calls apache_getenv those declarations will have no effect. regards grant -- Grant Croker - Ingres PHP and Ruby maintainer http://blogs.planetingres.org/grant Generally, old media don't die. They just have to grow old gracefully. Guess what, we still have stone masons. They haven't been the primary purveyors of the written word for a while now of course, but they still have a role because you wouldn't want a TV screen on your headstone. _ Mark Halling-Brown Higher Scientific Officer, Computational Biology & Chemogenomics, Cancer Therapeutics, The Institute of Cancer Research 15 Cotswold Road Belmont, Surrey SM2 5NG, UK Tel: (+44)-20-8722-4300 (ext: 4659) Email: mhallingbr...@icr.ac.uk Web: http://www.markyhb.co.uk "A cynic is what an idealist calls a realist" The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP. This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer and network.
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
On/El 16/03/09 09:23, chris smith wrote/escribió: On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown wrote: Thanks for your replies. In my desperation, I declared those environment variables in as many places as I could think of. The script (Although I know I shouldnt), php.ini and also the apache httpd.conf file: SetEnv ORACLE_HOME /opt/oracle/instanceclient SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv ORACLE_BASE /opt/oracle/instanceclient But given that it works on the command line, but not through the browser, I think that the environment variables must be set correctly. Did you restart apache after doing this? The env variables are set correctly for your user, but not apache's (which is the problem). Does the mac have an /etc/environment file? That should cover all users. Unfortunately not although with the stock/supplied Apache web server there is a plist file you can edit to add environment settings. Edit |/System/Library/LaunchDaemons/org.apache.httpd.plist, adding the relevant environment variable key/value information:| "http://www.apple.com/DTDs/PropertyList-1.0.dtd";> EnvironmentVariables DYLD_LIBRARY_PATH path goes here ORACLE_HOME path goes here ORACLE_BASE path goes here Label org.apache.httpd . . . Then you use PassEnv in Apache to pass these values through to PHP. The SetEnv directive in Apache is not the same as "setenv" or "export" in csh/bash/etc. Apache maintains its own symbol table for environment variables. Unless the OCI8 extension calls apache_getenv those declarations will have no effect. regards grant -- Grant Croker - Ingres PHP and Ruby maintainer http://blogs.planetingres.org/grant Generally, old media don't die. They just have to grow old gracefully. Guess what, we still have stone masons. They haven't been the primary purveyors of the written word for a while now of course, but they still have a role because you wouldn't want a TV screen on your headstone. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Did you restart apache after doing this?
Yes, many times
The env variables are set correctly for your user, but not apache's
(which is the problem).
Indeed, I have removed the putenv declarations in the php script and
inserted this:
echo("Using LD_LIBRARY_PATH: ". getenv("LD_LIBRARY_PATH"));
echo ", ORACLE_HOME=".getenv("ORACLE_HOME");
echo(", DYLD_LIBRARY_PATH: ". getenv("DYLD_LIBRARY_PATH"));
And it prints to the screen (browser) correctly:
Using LD_LIBRARY_PATH: /opt/oracle/instanceclient, ORACLE_HOME=/opt/
oracle/instanceclient, DYLD_LIBRARY_PATH: /opt/oracle/instanceclient
For completeness, I have also put the variables is /etc/profile, /etc/
bash_profile etc
So it seems that the variables are set up for sure (unless this is
just for php, but I do have these variables in the apache httpd.conf)
This is a puzzler
Cheers
Mark
Does the mac have an /etc/environment file? That should cover all
users.
--
Postgresql & php tutorials
http://www.designmagick.com/
_
Mark Halling-Brown
Higher Scientific Officer,
Computational Biology & Chemogenomics, Cancer Therapeutics,
The Institute of Cancer Research
15 Cotswold Road
Belmont, Surrey SM2 5NG, UK
Tel: (+44)-20-8722-4300 (ext: 4659)
Email: mhallingbr...@icr.ac.uk
Web: http://www.markyhb.co.uk
"A cynic is what an idealist calls a realist"
The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company
Limited by Guarantee, Registered in England under Company No. 534147 with its
Registered Office at 123 Old Brompton Road, London SW7 3RP.
This e-mail message is confidential and for use by the addressee only. If the
message is received by anyone other than the addressee, please return the
message to the sender by replying to it and then delete the message from your
computer and network.
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown wrote: > Thanks for your replies. > In my desperation, I declared those environment variables in as many places > as I could think of. The script (Although I know I shouldnt), php.ini and > also the apache httpd.conf file: > > SetEnv ORACLE_HOME /opt/oracle/instanceclient > SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient > SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient > SetEnv ORACLE_BASE /opt/oracle/instanceclient > > But given that it works on the command line, but not through the browser, I > think that the environment variables must be set correctly. Did you restart apache after doing this? The env variables are set correctly for your user, but not apache's (which is the problem). Does the mac have an /etc/environment file? That should cover all users. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Thanks for your replies.
In my desperation, I declared those environment variables in as many
places as I could think of. The script (Although I know I shouldnt),
php.ini and also the apache httpd.conf file:
SetEnv ORACLE_HOME /opt/oracle/instanceclient
SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient
SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
SetEnv ORACLE_BASE /opt/oracle/instanceclient
But given that it works on the command line, but not through the
browser, I think that the environment variables must be set correctly.
Cheers
Mark
On 16 Mar 2009, at 1:26 AM, Christopher Jones wrote:
Chris wrote:
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate()
failed. There is something wrong with your system - please check
that LD_LIBRARY_PATH includes the directory with Oracle
Instant Client libraries in/Library/WebServer/Documents/oracle.php
on line 25 Oracle Connect Error
putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");
I'd guess you probably need this in apache's start up script, not
in php (where that is on a mac setup I have no idea).
You could also try it in your virtual host:
http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv
SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
I agree that using putenv() for Environment variables in scripts is
bad.
On Mac, I think you need DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH.
See http://www.oracle.com/technology/pub/articles/bibbs-php-leopard.html
Chris
--
Email: christopher.jo...@oracle.com Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/UGPOM
_
Mark Halling-Brown
Higher Scientific Officer,
Computational Biology & Chemogenomics, Cancer Therapeutics,
The Institute of Cancer Research
15 Cotswold Road
Belmont, Surrey SM2 5NG, UK
Tel: (+44)-20-8722-4300 (ext: 4659)
Email: mhallingbr...@icr.ac.uk
Web: http://www.markyhb.co.uk
"A cynic is what an idealist calls a realist"
The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company
Limited by Guarantee, Registered in England under Company No. 534147 with its
Registered Office at 123 Old Brompton Road, London SW7 3RP.
This e-mail message is confidential and for use by the addressee only. If the
message is received by anyone other than the addressee, please return the
message to the sender by replying to it and then delete the message from your
computer and network.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Chris wrote:
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
There is something wrong with your system - please check that
LD_LIBRARY_PATH includes the directory with Oracle Instant Client
libraries in/Library/WebServer/Documents/oracle.php on line 25
Oracle Connect Error
putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");
I'd guess you probably need this in apache's start up script, not in php
(where that is on a mac setup I have no idea).
You could also try it in your virtual host:
http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv
SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
I agree that using putenv() for Environment variables in scripts is bad.
On Mac, I think you need DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH.
See http://www.oracle.com/technology/pub/articles/bibbs-php-leopard.html
Chris
--
Email: christopher.jo...@oracle.com Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/UGPOM
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
There is something wrong with your system - please check that
LD_LIBRARY_PATH includes the directory with Oracle Instant Client
libraries in/Library/WebServer/Documents/oracle.php on line 25
Oracle Connect Error
putenv("LD_LIBRARY_PATH=/opt/oracle/instanceclient");
I'd guess you probably need this in apache's start up script, not in php
(where that is on a mac setup I have no idea).
You could also try it in your virtual host:
http://httpd.apache.org/docs/2.2/mod/mod_env.html#setenv
SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Php, Oracle on Mac, with strange behaviour
Dear List,
I have a puzzler, which I can't seem to fix.
To summarise, I have installed PHP, apache from source and the oracle
client (details below). I then construct a simple PHP script to
connect to my oracle database.
When I run the script from the command line, it works perfectly, and
returns rows from the database.
bash$ php oracle.php
Using : /opt/oracle/instanceclient, ORACLE_HOME=/opt/oracle/
instanceclient
Successfully connected to Oracle.
7171421.4983td>421.4983C23 H27 N5 O3C23 H27 N5 O3
Bt, when I try to view this through a browser, it returns this
error:
Using : /opt/oracle/instanceclient, ORACLE_HOME=/opt/oracle/
instanceclient
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
There is something wrong with your system - please check that
LD_LIBRARY_PATH includes the directory with Oracle Instant Client
libraries in/Library/WebServer/Documents/oracle.php on line 25
Oracle Connect Error
Here are the details of my installation and a few things I have tried:
Apache:
Installed apache (httpd-2.2.11) with the following configuration: --
prefix=/usr/local/apache --enable-module=so
No Errors
PHP
Installed PHP (php-5.2.9) with the following configuration:
--with-apxs2 -enable-cli --with-mysql=/usr/local/mysql/ --exec-
prefix=/usr --localstatedir=/var --libexecdir=/System/Library/Apache
/Modules --enable-shared=max --with-gd=/usr/local --with-zlib --
with-oci8=instantclient,/opt/oracle/instanceclient -enable-layout
=Darwin -enable-mods-shared=all --with-apxs2=/usr/local/apache2/bin/
apxs --with-config-file-path=/usr/local/apache2/conf --enable-si
gchild
No errors
Oracle Client
Installed Basic + all others in /opt/oracle/instanceclient
No errors
Oracle (Version 11g) is installed on a different server
I will paste the PHP script I am using at the bottom of the mail.
Now, as I said, it is working fine through the command line, so
everything is setup fine, so I figure it must be a permissions problem.
Hence, I chmod -R 755 $ORACLE_HOME and have tried running apache as
lots of different users, but to no avail
Thanks in advance
Mark
# PHP SCRIPT #
(HOST=)(PORT=1521) ### I have hidden this for
security
)
(CONNECT_DATA=(SERVER=DEDICATED)(SID=orcl)
(SERVICE_NAME=orcl))
)";
if ($c = OCILogon($username,$passwd,$db)) {
echo "Successfully connected to Oracle.n";
$s = OCIParse($c, "select * from COMPOUNDS WHERE rownum=1");
OCIExecute($s, OCI_DEFAULT);
print '';
while ($row = oci_fetch_array($s, OCI_RETURN_NULLS)) {
print '';
foreach ($row as $item) {
print ''.($item?
htmlentities($item):' ').'';
}
print '';
}
OCILogoff($c);
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text]. "".
$err[message];
}
echo("\n");
# END #
_
Mark Halling-Brown
Higher Scientific Officer,
Computational Biology & Chemogenomics, Cancer Therapeutics,
The Institute of Cancer Research
15 Cotswold Road
Belmont, Surrey SM2 5NG, UK
Tel: (+44)-20-8722-4300 (ext: 4659)
Email: mhallingbr...@icr.ac.uk
Web: http://www.markyhb.co.uk
"A cynic is what an idealist calls a realist"
The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company
Limited by Guarantee, Registered in England under Company No. 534147 with its
Registered Office at 123 Old Brompton Road, London SW7 3RP.
This e-mail message is confidential and for use by the addressee only. If the
message is received by anyone other than the addressee, please return the
message to the sender by replying to it and then delete the message from your
computer and network.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP ORACLE SSL ?
Thanks all for your replies. So to secure the connection between oracle server and PHP oci8 client, we have to modify the sqlnet.ora shipped with oracle product ,as suggested by christopher in his reply, and no API or interface is avaialble to do the same via PHP . In the same manual suggested by Chris, I found a link to secure oracle connection using SSL . ( http://download.oracle.com/docs/cd/B14117_01/network.101/b10772/asossl.htm#1006120). Christopher Jones wrote: > > > Narasimha Gangaiah wrote: > > Greetings, > > > > I am writing a web application using PHP. I want to use PEAR::DB to > connect > > to user database. > > I want the connection to be secured using SSL. > > > > Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle > Server > > ? > > > > I know we can securely connect to MYSQL server using PEAR::DB && SSL. > > Is it possible to estable secure connection to oracle server using PHP > ? > > > > Best Regards > > Simha > > > > The network protocols used by Oracle can encrypt and/or checksum data > transfers between Oracle library calls in PHP's oci8 extension and the > database server. > > See > http://download.oracle.com/docs/cd/B12037_01/network.101/b10772/asoconfg.htm#1006342 > The useful bits are at the bottom of that page where the sample > sqlnet.ora files are given (just above tables 3-2 and 3-3). In effect > all you need to do is add a couple of configuration lines and restart > the network listener to get encrypted traffic. Check your license too: > the Advanced Security Option (ASO) is probably a separately licensble > product. > > Chris > > -- > Christopher Jones, Oracle > Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 > Blog: http://blogs.oracle.com/opal/ Free PHP Book: > http://tinyurl.com/f8jad > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- View this message in context: http://www.nabble.com/PHP-ORACLE-SSL---tf4208442.html#a11991531 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP ORACLE SSL ?
Narasimha Gangaiah wrote: > Greetings, > > I am writing a web application using PHP. I want to use PEAR::DB to connect > to user database. > I want the connection to be secured using SSL. > > Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server > ? > > I know we can securely connect to MYSQL server using PEAR::DB && SSL. > Is it possible to estable secure connection to oracle server using PHP ? > > Best Regards > Simha > The network protocols used by Oracle can encrypt and/or checksum data transfers between Oracle library calls in PHP's oci8 extension and the database server. See http://download.oracle.com/docs/cd/B12037_01/network.101/b10772/asoconfg.htm#1006342 The useful bits are at the bottom of that page where the sample sqlnet.ora files are given (just above tables 3-2 and 3-3). In effect all you need to do is add a couple of configuration lines and restart the network listener to get encrypted traffic. Check your license too: the Advanced Security Option (ASO) is probably a separately licensble product. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP ORACLE SSL ?
Narasimha Gangaiah wrote: Greetings, I am writing a web application using PHP. I want to use PEAR::DB to connect to user database. I want the connection to be secured using SSL. Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server ? I know we can securely connect to MYSQL server using PEAR::DB && SSL. Is it possible to estable secure connection to oracle server using PHP ? If you're using pear, the pear guys would be able to help a lot more: http://pear.php.net/support/lists.php -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP ORACLE SSL ?
Greetings, I am writing a web application using PHP. I want to use PEAR::DB to connect to user database. I want the connection to be secured using SSL. Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server ? I know we can securely connect to MYSQL server using PEAR::DB && SSL. Is it possible to estable secure connection to oracle server using PHP ? Best Regards Simha -- View this message in context: http://www.nabble.com/PHP-ORACLE-SSL---tf4208442.html#a11971724 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP+Oracle or PL/SQL Web Application - which one is efficient?
Hi friends, I need an advice about PHP+Oracle or PL/SQL Web Application. We are using at the moment PL/SQL Web Application for our all pages. But some of my friends says that php+oracle more effiecient than pl/sql. Does anybody have exprience or statistical data about this. Or how can we compare them? Thanks alot. Rasim ÞEN [EMAIL PROTECTED] http://www.sahibinden.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP Oracle Authentication using UNIX user account
Hi Roy, - Yes the web server is on a different machine - I think remote OS auth is allowed as when I login to the DB from another host using / it works fine. (obviously logged in as userA still) My DBA suggested I might have to use SSH in some way but I have not found any docs in setting up the authentication in this way... I would not want to prompt the user for a username/password each time the DB needs updating either.. It seems making the config file read only (by userA, the apache runtime user) or encrypting the DB password within the config file is the best option so far. But as the problem has already been solved by Oracle and UNIX I was hoping the solution would be at the O/S level (or at most exporting a few ORA vars so the apache runtime picks it up), rather than at the application software level. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 04 October 2004 15:48 To: Ben Gill Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP Oracle Authentication using UNIX user account A couple notes / assumptions .. (1) The web server is on a different machine then database (2) The DB is not allowing remote OS authentication and only local OS authentication If these are not true then some of my comments will be invalid (1) The above config will not work as the web-to-db conn is not authenticated locally (2) If remote OS auth is allow that is more of a security risk .. (can be mitigated) (3) If the php files are secured on the server that mitigates risk (4) Network traffic can be encrypted to prevent passwords being sent in plain text But if network is compromised all non-secure traffic is compromised (ftp/telnet/etc) My solution (1) No remote OS Auth (2) Trust network (3) I am only person that has access to web server (Web/DB/OS admin) (4) Use a 'generic' account for general web access that only has the following privs - CREATE SESSION - SELECT on tables needed (via ROLE or direct as required) (5) If a user needs to modify data allow a method for them to be prompted for username/password for database connection == If the web server & db server are the same box then local OS auth would be fine. I have not done this before since I like to separate my resources for High Avail reasons. I am now intrigued and will research it. Roy A. Jones _ US Pharma Database Administration GlaxoSmithKline Inc. US Pharma IT, Shared Services _ Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> _ "Ben Gill" <[EMAIL PROTECTED]> 04-Oct-2004 10:30 To [EMAIL PROTECTED] cc Subject [PHP-DB] PHP Oracle Authentication using UNIX user account Hi, My DBA's preferred authentication method is to set up a UNIX user account (i.e. userA) and let them login without using plaintext password authentication, ie. The user has to be logged in, they can then run (for example) sqlplus / and that will log them into the correct database. This is to prevent having to specify a username / password in a PHP script (or a config file that gets loaded). If the username / password is visible in the script, then someone can login and start making manual edits to the data using sql commands. To implement this, I have ensured my apache instance is running as 'userA' and I have tried all sorts of combinations of things username = "" password = "", username = "/" password = "", username="/" password ="/" etc.. to get this working (It works fine from the command line) but the OCILogon function requires a username and a password, so is not happy. One solution to this is that the DBA opens up the DB to plaintext authentication, I store the username / password in a config file with read only permissions (only for the owner, userA), and then only someone who knows userA's password can login and view this config file. But that does not fit in with the way my DBA wants me to authenticate. Has anyone got a solution for this? Regards
Re: [PHP-DB] PHP Oracle Authentication using UNIX user account
A couple notes / assumptions .. (1) The web server is on a different machine then database (2) The DB is not allowing remote OS authentication and only local OS authentication If these are not true then some of my comments will be invalid (1) The above config will not work as the web-to-db conn is not authenticated locally (2) If remote OS auth is allow that is more of a security risk .. (can be mitigated) (3) If the php files are secured on the server that mitigates risk (4) Network traffic can be encrypted to prevent passwords being sent in plain text But if network is compromised all non-secure traffic is compromised (ftp/telnet/etc) My solution (1) No remote OS Auth (2) Trust network (3) I am only person that has access to web server (Web/DB/OS admin) (4) Use a 'generic' account for general web access that only has the following privs - CREATE SESSION - SELECT on tables needed (via ROLE or direct as required) (5) If a user needs to modify data allow a method for them to be prompted for username/password for database connection == If the web server & db server are the same box then local OS auth would be fine. I have not done this before since I like to separate my resources for High Avail reasons. I am now intrigued and will research it. Roy A. Jones US Pharma Database Administration GlaxoSmithKline Inc. US Pharma IT, Shared Services Email: [EMAIL PROTECTED] "Ben Gill" <[EMAIL PROTECTED]> 04-Oct-2004 10:30 To [EMAIL PROTECTED] cc Subject [PHP-DB] PHP Oracle Authentication using UNIX user account Hi, My DBA's preferred authentication method is to set up a UNIX user account (i.e. userA) and let them login without using plaintext password authentication, ie. The user has to be logged in, they can then run (for example) sqlplus / and that will log them into the correct database. This is to prevent having to specify a username / password in a PHP script (or a config file that gets loaded). If the username / password is visible in the script, then someone can login and start making manual edits to the data using sql commands. To implement this, I have ensured my apache instance is running as 'userA' and I have tried all sorts of combinations of things username = "" password = "", username = "/" password = "", username="/" password ="/" etc.. to get this working (It works fine from the command line) but the OCILogon function requires a username and a password, so is not happy. One solution to this is that the DBA opens up the DB to plaintext authentication, I store the username / password in a config file with read only permissions (only for the owner, userA), and then only someone who knows userA's password can login and view this config file. But that does not fit in with the way my DBA wants me to authenticate. Has anyone got a solution for this? Regards
[PHP-DB] PHP Oracle Authentication using UNIX user account
Hi, My DBA's preferred authentication method is to set up a UNIX user account (i.e. userA) and let them login without using plaintext password authentication, ie. The user has to be logged in, they can then run (for example) sqlplus / and that will log them into the correct database. This is to prevent having to specify a username / password in a PHP script (or a config file that gets loaded). If the username / password is visible in the script, then someone can login and start making manual edits to the data using sql commands. To implement this, I have ensured my apache instance is running as 'userA' and I have tried all sorts of combinations of things username = "" password = "", username = "/" password = "", username="/" password ="/" etc.. to get this working (It works fine from the command line) but the OCILogon function requires a username and a password, so is not happy. One solution to this is that the DBA opens up the DB to plaintext authentication, I store the username / password in a config file with read only permissions (only for the owner, userA), and then only someone who knows userA's password can login and view this config file. But that does not fit in with the way my DBA wants me to authenticate. Has anyone got a solution for this? Regards
Re: [PHP-DB] PHP & oracle 9.2
Delfins wrote: i have successfully installed Oracle 9.2 on Slackware 9.0 database works fine & also any other applications runs ok. but when i compiled PHP5 with OCI8 (path i was specified as ORACLE_HOME) but running some scrip, i have this error : Warning: ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12154 There is some information in: http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#envvars The error you are getting is mentioned part way down in that section. A google search especially in recent google groups postings may pick up other causes, problem investigation tips, and solutions. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP & oracle 9.2
Hello php.db! i have successfully installed Oracle 9.2 on Slackware 9.0 database works fine & also any other applications runs ok. but when i compiled PHP5 with OCI8 (path i was specified as ORACLE_HOME) but running some scrip, i have this error : Warning: ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12154 i have 2 problems : i.) something wrong with ora error messages ii.) something wrong with compiled PHP ORA-12154 is TNS could not be resolved. but i __know__, what with this configuration (i have used) string i have success connection for other applications (net manager, etc) how to fix ? is it bug or my hands did something wrong ? :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP Oracle connection across page.
I have the following problem, please help me. Many thanks. Script 1: ___ 2.inc: // This script will switch the brower to script2.php script2.php: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php, oracle, OCIExecute()
Welcome I need Yours help about this project: I have installed on Sun Solaris (2.6) Oracle Database (8.0.5), and apache on the other linux server with PHP and Oracle Client for 9i. I making a connection to database from Linux to Sun and all is O.K. For example: ### "; } OCILogoff ($conn); ?> # When drawn out from bases column is of type int (number) all is ok. Data are presented on page, but when I drawing out of given type Varchar (eg. name) then it doesn't work ! On presented page I see following warnings: ### Warning: OCIStmtExecute: Error while trying to retrieve text for error ORA-03120 in /var/www/html/oracle/index.php on line 62 Warning: OCIFetch: Error while trying to retrieve text for error ORA-24374 in /var/www/html/oracle/index.php on line 74 ### What is wrong ? bad interpretation data by OCIs function ? ENVIRONMENT: webserver: RedHat Linux 8.0 Apache 2.0.44 + mod_php 4.3.1 Oracle Client 9i databaseserwer: SunOS Oracle 8.0.5 Thanks for any help ! Kindly Regards -- Marcin Wylot::m.wylot[at]klub[dot]chip[dot]pl "Linux is like wigwam - no windows, no gates and apache inside." "Software is like sex, it's better when it's free." -- Marcin Wylot::m.wylot[at]klub[dot]chip[dot]pl "Linux is like wigwam - no windows, no gates and apache inside." "Software is like sex, it's better when it's free." -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP - Oracle 7.3.4 - ORA-12154
add the failover directive in tnsnames.ora. Find how to on the web (not sure right now) -- Maxim Maletsky [EMAIL PROTECTED] On Fri, 07 Feb 2003 02:15:43 + Maron Kristófersson <[EMAIL PROTECTED]> wrote: > Hello! > > I set up PHP on a Sun Solaris box a week ago (see phpinfo output below). >It has oracle 7.3.4 and php 4.0.4pl1 so I'm using the --with-oracle > configure option. Due to a special module we're using we're stuck with > using that php version (4.0.4pl1). > > At first I was getting the ORA-12154 TNS:could not resolve service name > error almost every time. I then followed the instructions to set the > ORACLE_HOME and TNS_ADMIN environment variables in apaches http.conf. > I've also tried using the putenv function to set the variables. > > This really improved the situation but when I found it was still not > working I wrote a small java program that calls the php page every 15 > seconds. About 10% of the time I get the TNS (ORA-12154) error but the > other 90% it works perfect. This applies both to selecting and > inserting data. > > -- partial output from phpinfo() -- > System SunOS red 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-250 > Build Date Jan 29 2003 > Configure Command './configure' '--with-apxs=/opt/apache/bin/apxs' > '--with-mysql=no' '--with-oracle=/opt/app/oracle/product/7.3.4/' > > oracle > Oracle Support enabled > Oracle Version 7.3 > Compile-time ORACLE_HOME /opt/app/oracle/product/7.3.4/ > Libraries Used > > I really need to get this working so all ideas would be appreciated. > > Best regards, > > Maron Kristófersson > Reykjavík > Iceland > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP - Oracle 7.3.4 - ORA-12154
Hello! I set up PHP on a Sun Solaris box a week ago (see phpinfo output below). It has oracle 7.3.4 and php 4.0.4pl1 so I'm using the --with-oracle configure option. Due to a special module we're using we're stuck with using that php version (4.0.4pl1). At first I was getting the ORA-12154 TNS:could not resolve service name error almost every time. I then followed the instructions to set the ORACLE_HOME and TNS_ADMIN environment variables in apaches http.conf. I've also tried using the putenv function to set the variables. This really improved the situation but when I found it was still not working I wrote a small java program that calls the php page every 15 seconds. About 10% of the time I get the TNS (ORA-12154) error but the other 90% it works perfect. This applies both to selecting and inserting data. -- partial output from phpinfo() -- System SunOS red 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-250 Build Date Jan 29 2003 Configure Command './configure' '--with-apxs=/opt/apache/bin/apxs' '--with-mysql=no' '--with-oracle=/opt/app/oracle/product/7.3.4/' oracle Oracle Support enabled Oracle Version 7.3 Compile-time ORACLE_HOME /opt/app/oracle/product/7.3.4/ Libraries Used I really need to get this working so all ideas would be appreciated. Best regards, Maron Kristófersson Reykjavík Iceland -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php Oracle remote connect
Hi, I'm looking to config remote Oracle connectivity with php on rehdat. Can anyone point me in the right direction for how to? Or perhaps more to the point, looks like I need basic Oracle installed on the php server as a pre-requisite even for remote Oracle connect ability... true or false. Many Thanks, -- John Lewis php programmer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP/Oracle Install questions...
I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for connectivity to both a MySQL and a remote Oracle server. I am not having much luck with this right now. Currently I am getting a couple of different errors that are of concern for me. First of all, in the Apache error log I am seeing the following entry every time I start the Apache server: [Tue Dec 17 09:42:39 2002] [warn] module php4_module is already loaded, skipping I am not sure as to why I am receiving this error. I know that PHP is only compiled as a module, because it does not show up in a httpd -l. I am wondering if this is a result of some kind of syntax error in my httpd.conf file. The big problem though is getting PHP to compile completely again. I know that on HP there is an issue with the extension on the php library. It has something to do with .sl as opposed to .so, but I cannot remember exactly what it is and for some reason I can't seem to find the documentation on it this time around. Any help in the right direction here would be most appreciated. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php+oracle+win2000
Hi for all. I have php+apache+win2000+client oracle in my machine. I configured my php.ini with: extension_dir and uncomment extensions in php_oci8.dll But, when I restart my apache, I receive the following error: Unable to load dynamic library "c:\php\extensions/php_oci8.dll". It was not possible to find the specified procedure. Can anyone help me with the configuration of php+oracle? -- Mauricio +55 - (041) - 219-5246 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php+oracle
Hi for all. I have php+apache+win2000+client oracle in my machine. I configured my php.ini with: extension_dir and uncomment extensions in php_oci8.dll But, when I restart my apache, I receive the following error: Unable to load dynamic library "c:\php\extensions/php_oci8.dll". It was not possible to find the specified procedure. Can anyone help me with the configuration of php+oracle? -- Mauricio +55 - (041) - 219-5246 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP + Oracle problem
When i have uncommented the php_oci8.dll extension in the php.in(i use the recommended) i get the following error. "kodPHP Warning: Unable to load dynamic library 'c:/php/php_oci8.dll' - The specified module could not be found. in Unknown on line 0 " All paths are correct and it works fine with the mssql dll. Worth mentioning is that i run php 4.2.0 on IIS/win2k machine. Someone has a clue? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP&ORACLE ora_fetch()
Hi All! Can anybody here give me a hint on the following situation? Let's say we have a result set (cursor) got from SELECT statement having too many records to display on a single page. How to split records among several pages executing the single query? It's easy to scroll cursor forward using ora_fetch(), but how to scroll a cursor backward? Best regards, Maxim Bubnov, Software Engineer, Stelt Telecom NN [EMAIL PROTECTED] -- 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
Jason, Or you can use ODBC, as per the HOWTO at www.iodbc.org, which eliminates the ned to install the Oracle client and enables you to develop applications independent of database. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server > -Original Message- > From: Steve Farmer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 03, 2002 7:16 PM > To: Jason Lehman; [EMAIL PROTECTED] > Subject: 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 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP, Oracle and multipage transactions
Hello, is there a way to store an Oracle session in a PHP session so the transaction would carry over from one page to another? Initially I thought that using OCIPlogin and storing the connection variable into a PHP session would solve it, but it wasn't the way I had hoped it to be.. Seems that when the current page (.php) has finished executing the Oracle transaction/session is ended. If there is no way to do that in the current version of PHP, maybe someone has modified the PHP source code to do exactly that ?) And oh, the environment: Oracle9i Database with PHP 4.1.1 on a WinNT server. -- 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
[PHP-DB] PHP + Oracle + Redhat Linux Stupid Question Maybe? Sorry
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
RE: [PHP-DB] PHP, Oracle and iso-8859-1 characters
try setting NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252 or ENGLISH.UNITED KINGDOM.WE8MSWIN1252 in php. That should work. -Original Message- From: michele campeotto [mailto:[EMAIL PROTECTED]] Sent: 26 February 2002 15:53 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP, Oracle and iso-8859-1 characters Hello, I have a database that contains text with accented vowels (àèéìòù). They are displayed just fine when accessing the database from Java/JSP pages on the same machine and DB, but from PHP I get the vowels without the accent (à => a, è => e). The database uses UTF-8 encoding. Platform infos: Red Hat Linux Apache 1.3.20 PHP 4.1.1 (accepting ISO-8859-15 and UTF-8) Oracle 8.1.7 (using UTF-8 encoding, accessed using the OCI API) I'd be really happy to have even the slighties hint about the issue Thanks in advance Michele P.S. I'm not on the list, please CC: me, thanks again -- Michele Campeotto Wireless Team E-TREE S.p.A. __ Via Fonderia 45 - 31100 Treviso - Italy- ph.+39.0422.3107 fax.+39.0422.310888 www.e-tree.com www.webanana.com ___ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP, Oracle and iso-8859-1 characters
Hello, I have a database that contains text with accented vowels (àèéìòù). They are displayed just fine when accessing the database from Java/JSP pages on the same machine and DB, but from PHP I get the vowels without the accent (à => a, è => e). The database uses UTF-8 encoding. Platform infos: Red Hat Linux Apache 1.3.20 PHP 4.1.1 (accepting ISO-8859-15 and UTF-8) Oracle 8.1.7 (using UTF-8 encoding, accessed using the OCI API) I'd be really happy to have even the slighties hint about the issue Thanks in advance Michele P.S. I'm not on the list, please CC: me, thanks again -- Michele Campeotto Wireless Team E-TREE S.p.A. __ Via Fonderia 45 - 31100 Treviso - Italy- ph.+39.0422.3107 fax.+39.0422.310888 www.e-tree.com www.webanana.com ___ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP & Oracle (oci8)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello php-db, We have a RedHat Linux 7.1 system running PHP 4.0.4. It connects to an oracle database which is sitting behind a firewall. When a persistent connection is opened from apache, it apparently times out over the firewall and gets disconnected. For various reasons the firewall can't be changed to eliminate this timeout. For some reason there is a problem in that PHP doesn't recognize that the connection is down and merrily continues working until it gets a database error. Restarting apache solves the problem temporarily, but it always reappears. I also tried php 4.0.6 with no difference in the result. Does anybody have any ideas? On an related note, in the changelog for 4.1 it mentions about a fix for a differnet database problem. Has anybody back-ported this fix, and if so, where would I find it? Thanks in advance. JBB Jonathan B. Bayer mailto:[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (MingW32) Comment: For info see http://www.gnupg.org iEYEARECAAYFAjwEJfoACgkQxQhxe/20cF4laQCgzsTgodmvs4Dc2CmHsg9ADKRs U0kAnAuPl041oWQ4SgwleCXQEtbBBo3t =nksA -END PGP SIGNATURE- -- 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] php-oracle
Hi, I am working with PHP and Oracle, with the functions of library OCI, and I need to handle the transaccionalidad in PHP, not at level of Stored procedures. Somebody knows if exists the equivalence (or the form to make this equivalence), of the function ora_commitoff($conn)? (in OCI) The idea is to occupy this equivalence (or function), to execute a Stored procedure and to be able to make a Rollback at PHP level if it is that it is necessary. Thank you very much for your help :o) -- Saludos, Lilian mailto:[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]
[PHP-DB] php, oracle and ascii characters
We are creating a content management system for a web site. In this app,I am filling the contents of an html text area with the contents of a field in an oracle database. This is our dynamic content for the site.The text area allows the user to update its contents. For the time being, any characters oracle considers illegal were to be entered by the client manually in their ascii form. For instance, ' will be '. We thought this would be a short term solution allowing the browser to see the characters correctly, and the database to not error on the update. The content can be saved to the database correctly, but when it is retrieved there seems to be a conversion going on. I am seeing the character interpreted as \' causing the next update on this field to fail. It is strange because when I view the source, the html correctly keeps the ', but when I use it in a php string and send it to the database, it seems to be making a switch. I need to keep this consistantly in its ascii representation, except when it is viewed in a browser. Thanks, I'm desparate! Dan -- 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] php + oracle + apache on Compaq systems
Hello, has anybody already succeeded in installing Apache-1.3.20 with php-4.0.6 and Oracle-8.1.7 on Compaq systems with OSF V. 5.1? First I tried to use DSO for php (--with-apxs, --with-oci8). the compilation went through, but the apache server cannot be started and breaks with segmentation fault und core dump. This problem has been described by Compaq, but it is said to be working with the new version OSF V 5.1 . (LD_LIBRARY_PATH was set correctly.) Then I tried to compile php statically into apache (--with-apache --with-oci8) However, same fault and core dump. At last I tried to compile php statically with the old version --with-oracle. And now I succeeded in starting the apache server. The problem is, my users want to use the OCI-calls and don't want to go back to ORA-calls. Any ideas, how I can --with-oci8 with Compaq systems? I use the Compaq CC Compiler, the Oracle client is mounted via NFS. Sabine -- 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] a lot of errors!!!
Can you show us your OCIConnect statement? It returns a handle to a variable that you should use as your connection resource... > From: "Matteo" <[EMAIL PROTECTED]> > Date: Fri, 24 Aug 2001 10:03:46 +0200 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] [PHP-ORACLE] a lot of errors!!! > > I have a server with Linux 6.2 kernel 2.2.19 with apache 1.3.20 > > i configure php in this mode > > './configure' '--with-apache=/home/apache/apache_1.3.20' '--with-mysql' > '--with-gd' '--enable-track-vars' '--enable-force-cgi-redirect' > '--enable-discard-path' '--enable-safe-mode' '--enable-calendar' > '--with-gdbm' '--enable-ftp' '--with-regex=php' '--with-gnu-ld' > '--with-oci8' '--with-imap' '--with-kerberos' > '--with-openssl=/usr/local/ssl' > > i have installed Oracle 8.1.7. server and client and i configure correctly > listener.ora e tnsnames.ora. It works > > But when i try an SQL test, it displays this messages: > > > Warning: _oci_open_server: Error while trying to retrieve text for error > ORA-12154 in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 180 > > Warning: Supplied argument is not a valid OCI8-Connection resource in > /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 181 > > Warning: Supplied argument is not a valid OCI8-Statement resource in > /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 183 > Error: Oracle Error: --- > > Fatal error: Call to undefined function: blu_log() in > /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 187 > > > What is the problem? > > Thankx very much for answers. > > Matteo > ITALY > > > > > -- > 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]
[PHP-DB] [PHP-ORACLE] a lot of errors!!!
I have a server with Linux 6.2 kernel 2.2.19 with apache 1.3.20 i configure php in this mode './configure' '--with-apache=/home/apache/apache_1.3.20' '--with-mysql' '--with-gd' '--enable-track-vars' '--enable-force-cgi-redirect' '--enable-discard-path' '--enable-safe-mode' '--enable-calendar' '--with-gdbm' '--enable-ftp' '--with-regex=php' '--with-gnu-ld' '--with-oci8' '--with-imap' '--with-kerberos' '--with-openssl=/usr/local/ssl' i have installed Oracle 8.1.7. server and client and i configure correctly listener.ora e tnsnames.ora. It works But when i try an SQL test, it displays this messages: Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 180 Warning: Supplied argument is not a valid OCI8-Connection resource in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 181 Warning: Supplied argument is not a valid OCI8-Statement resource in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 183 Error: Oracle Error: --- Fatal error: Call to undefined function: blu_log() in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 187 What is the problem? Thankx very much for answers. Matteo ITALY -- 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] PHP & Oracle Stored Functions
Hi, Anyone have information on calling a stored function? Is it similar to a stored procedure? How to you access a return, thorugh OCIBindByName? Regards, Laurence Veale ext 6172 -- 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] PHP + Oracle 8i
Hi. Oracle 8/7 and PHP are supported! Only we have to use the OCI8 to make one conection to the Database. It´s possible connect PHP+APACHE and Oracle 8i or Oracle 9i, using Oracle Call Interface on this two versions Any Idea??? -- 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 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: > >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] -- 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]
[PHP-DB] PHP/Oracle/mod_ssl/Apache
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]
[PHP-DB] PHP+Oracle+Sessions
Hi.
Is there any way to store an OCI8 connection resource $conn =
ociplogon("",""); in a session like session_register('conn') and then use
this connection by accessing the var in the other pages? I've tried this but
it doesn't work...
Thanks
--
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]
