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
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.
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 y
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/ora
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 tha
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 t
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_PAT
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
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/i
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
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
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
r
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
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 securel
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 MYS
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 &&
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
compa
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
"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 pl
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
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 wh
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
I have the following problem, please help me. Many thanks.
Script 1:
___
2.inc:
// This script will switch the brower to script2.php
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:
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).
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
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.
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 see
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
possibl
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
possibl
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
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
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?
> So
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 w
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 a
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
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-8
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 i
-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 disconne
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)
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 characte
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 fau
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 lo
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'
'
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 comm
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 u
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, eve
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
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
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.ne
50 matches
Mail list logo
