guest
|
| Posted: 08/16/2002, 4:08 AM |
|
Hi,
I have tried selecting both the Oracle, and Oracle OCI as the PHP Database
Library, and after publishing I get my login web page fine. I then get :
Fatal error: Call to undefined function: ocilogon() in
/var/www/html/db_oci8.php on line 59.
I get an ora_logon or ora_plogon similar message when using Oracle as the
PHP Database Library (Non-persistant and persitant).
I have compiled PHP 4.2.4 and on the configure step I used
../configure --with-oci8 --with-oracle
After installing and typing :
php -m
I get :
Running PHP 4.2.2
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
[PHP Modules]
xml
standard
session
posix
pcre
oracle
oci8
mysql
ctype
[Zend Modules]
I have been searching for answers, the only other thing I found was a
reference that says check the php.ini file to make sure that the extension
is defined. The only reference I find in the php.ini, looks like the
extensions you speify if it was for a windows environment, ie...
;extension=php_oracle.dll
I took the semi-colon off, tried it with that, and also removed the .dll,
but I still get the same result.
The only other strange thing about my environment was that the old php was
in /usr/bin, and the new version was put in /usr/local/bin. I removed the
version in /usr/bin (as it was first in the path). Perhaps when it is
looking for the oracle extension it is somehow looking in the old place ?
I am pretty sure there is a simple explanation to this.
As a second question, how would you bypass the login screen and go directly
into the application (I am trying out portal) ? I want the user to go
straight into the portal as a guest so that they can have the choice to
browse the guest portal, or login as registered user after ?
Best Regards
Martin...
|
|
|
 |
Marty
|
| Posted: 08/16/2002, 4:28 AM |
|
I meant "I have compiled PHP 4.2.2"
<martintrv@yahoo.com> wrote in message
news:ajimg9$47c$1@news.codecharge.com...
> Hi,
>
> I have tried selecting both the Oracle, and Oracle OCI as the PHP Database
> Library, and after publishing I get my login web page fine. I then get :
> Fatal error: Call to undefined function: ocilogon() in
> /var/www/html/db_oci8.php on line 59.
>
> I get an ora_logon or ora_plogon similar message when using Oracle as the
> PHP Database Library (Non-persistant and persitant).
>
> I have compiled PHP 4.2.4 and on the configure step I used
> ./configure --with-oci8 --with-oracle
> After installing and typing :
> php -m
> I get :
> Running PHP 4.2.2
> Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
> [PHP Modules]
> xml
> standard
> session
> posix
> pcre
> oracle
> oci8
> mysql
> ctype
> [Zend Modules]
>
> I have been searching for answers, the only other thing I found was a
> reference that says check the php.ini file to make sure that the extension
> is defined. The only reference I find in the php.ini, looks like the
> extensions you speify if it was for a windows environment, ie...
>
> ;extension=php_oracle.dll
>
> I took the semi-colon off, tried it with that, and also removed the .dll,
> but I still get the same result.
> The only other strange thing about my environment was that the old php was
> in /usr/bin, and the new version was put in /usr/local/bin. I removed the
> version in /usr/bin (as it was first in the path). Perhaps when it is
> looking for the oracle extension it is somehow looking in the old place ?
>
> I am pretty sure there is a simple explanation to this.
>
> As a second question, how would you bypass the login screen and go
directly
> into the application (I am trying out portal) ? I want the user to go
> straight into the portal as a guest so that they can have the choice to
> browse the guest portal, or login as registered user after ?
>
> Best Regards
>
> Martin...
>
>
|
|
|
|
RonB
|
| Posted: 08/16/2002, 8:08 AM |
|
Oracle is a tricky thing to get working:
- Make sure you have the oracle client stuf installed on the web server.
- use the net8 configuration assistent to set your tnsnames.ora file
- move the oci8 dll in php/extensions to system or system32 directory
depending on the flavour of windows
- make sure apache nows where to find the oracle stuff by putting something
like this:
SetEnv ORACLE_HOME c:/oracle/ora81
SetEnv ORACLE_SID <your_sid>
SetEnv LD_LIBRARY_PATH c:/oracle/ora81/lib
SetEnv TNS_ADMIN C:\oracle\ora81\network\admin\tnsnames.ora
SetEnv TWO_TASK C:\oracle\ora81\network\admin\tnsnames.ora
SetEnv NLS_LANG English_America.WE8ISO8859P1
in your apache httpd.conf file
- make sure ORACLE_HOME is known to windows by putting it in the enviroment
variable in (windows2000)configuration->system->enviroment variables
- now pray 
RonB
"Marty" <martintrv@yahoo.com> schreef in bericht
news:ajinks$67c$1@news.codecharge.com...
> I meant "I have compiled PHP 4.2.2"
> <martintrv@yahoo.com> wrote in message
>news:ajimg9$47c$1@news.codecharge.com...
> > Hi,
> >
> > I have tried selecting both the Oracle, and Oracle OCI as the PHP
Database
> > Library, and after publishing I get my login web page fine. I then get
:
> > Fatal error: Call to undefined function: ocilogon() in
> > /var/www/html/db_oci8.php on line 59.
> >
> > I get an ora_logon or ora_plogon similar message when using Oracle as
the
> > PHP Database Library (Non-persistant and persitant).
> >
> > I have compiled PHP 4.2.4 and on the configure step I used
> > ./configure --with-oci8 --with-oracle
> > After installing and typing :
> > php -m
> > I get :
> > Running PHP 4.2.2
> > Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
> > [PHP Modules]
> > xml
> > standard
> > session
> > posix
> > pcre
> > oracle
> > oci8
> > mysql
> > ctype
> > [Zend Modules]
> >
> > I have been searching for answers, the only other thing I found was a
> > reference that says check the php.ini file to make sure that the
extension
> > is defined. The only reference I find in the php.ini, looks like the
> > extensions you speify if it was for a windows environment, ie...
> >
> > ;extension=php_oracle.dll
> >
> > I took the semi-colon off, tried it with that, and also removed the
..dll,
> > but I still get the same result.
> > The only other strange thing about my environment was that the old php
was
> > in /usr/bin, and the new version was put in /usr/local/bin. I removed
the
> > version in /usr/bin (as it was first in the path). Perhaps when it is
> > looking for the oracle extension it is somehow looking in the old place
?
> >
> > I am pretty sure there is a simple explanation to this.
> >
> > As a second question, how would you bypass the login screen and go
> directly
> > into the application (I am trying out portal) ? I want the user to go
> > straight into the portal as a guest so that they can have the choice to
> > browse the guest portal, or login as registered user after ?
> >
> > Best Regards
> >
> > Martin...
> >
> >
>
>
|
|
|
|
Marty
|
| Posted: 08/16/2002, 1:04 PM |
|
Hi Ron,
The problem is not with Oracle, that is working fine. The problem is with
PHP comunicating with Oracle. I use an Oracle client on my CodeCharge
machine to communicate with the Oracle database on a Linux machine. When
the files are transferred and the application is executed on the Linux
machine, the db_oci8.php that CCS creates calls a routine called ocilogon()
.. This is what it does not find. From what I can understand, compiling php
with --with-oracle --with-oci8, should staticly compile the oracle stuff in
php. The, php -m, shows that it is there.
"RonB" <r.borkent@123chello.nl> wrote in message
news:ajj4gg$tpd$1@news.codecharge.com...
> Oracle is a tricky thing to get working:
>
> - Make sure you have the oracle client stuf installed on the web server.
> - use the net8 configuration assistent to set your tnsnames.ora file
> - move the oci8 dll in php/extensions to system or system32 directory
> depending on the flavour of windows
> - make sure apache nows where to find the oracle stuff by putting
something
> like this:
> SetEnv ORACLE_HOME c:/oracle/ora81
> SetEnv ORACLE_SID <your_sid>
> SetEnv LD_LIBRARY_PATH c:/oracle/ora81/lib
> SetEnv TNS_ADMIN C:\oracle\ora81\network\admin\tnsnames.ora
> SetEnv TWO_TASK C:\oracle\ora81\network\admin\tnsnames.ora
> SetEnv NLS_LANG English_America.WE8ISO8859P1
>
> in your apache httpd.conf file
> - make sure ORACLE_HOME is known to windows by putting it in the
enviroment
> variable in (windows2000)configuration->system->enviroment variables
>
> - now pray
>
> RonB
>
>
>
> "Marty" <martintrv@yahoo.com> schreef in bericht
>news:ajinks$67c$1@news.codecharge.com...
> > I meant "I have compiled PHP 4.2.2"
> > <martintrv@yahoo.com> wrote in message
> >news:ajimg9$47c$1@news.codecharge.com...
> > > Hi,
> > >
> > > I have tried selecting both the Oracle, and Oracle OCI as the PHP
> Database
> > > Library, and after publishing I get my login web page fine. I then
get
> :
> > > Fatal error: Call to undefined function: ocilogon() in
> > > /var/www/html/db_oci8.php on line 59.
> > >
> > > I get an ora_logon or ora_plogon similar message when using Oracle as
> the
> > > PHP Database Library (Non-persistant and persitant).
> > >
> > > I have compiled PHP 4.2.4 and on the configure step I used
> > > ./configure --with-oci8 --with-oracle
> > > After installing and typing :
> > > php -m
> > > I get :
> > > Running PHP 4.2.2
> > > Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
> > > [PHP Modules]
> > > xml
> > > standard
> > > session
> > > posix
> > > pcre
> > > oracle
> > > oci8
> > > mysql
> > > ctype
> > > [Zend Modules]
> > >
> > > I have been searching for answers, the only other thing I found was a
> > > reference that says check the php.ini file to make sure that the
> extension
> > > is defined. The only reference I find in the php.ini, looks like the
> > > extensions you speify if it was for a windows environment, ie...
> > >
> > > ;extension=php_oracle.dll
> > >
> > > I took the semi-colon off, tried it with that, and also removed the
> .dll,
> > > but I still get the same result.
> > > The only other strange thing about my environment was that the old php
> was
> > > in /usr/bin, and the new version was put in /usr/local/bin. I removed
> the
> > > version in /usr/bin (as it was first in the path). Perhaps when it is
> > > looking for the oracle extension it is somehow looking in the old
place
> ?
> > >
> > > I am pretty sure there is a simple explanation to this.
> > >
> > > As a second question, how would you bypass the login screen and go
> > directly
> > > into the application (I am trying out portal) ? I want the user to go
> > > straight into the portal as a guest so that they can have the choice
to
> > > browse the guest portal, or login as registered user after ?
> > >
> > > Best Regards
> > >
> > > Martin...
> > >
> > >
> >
> >
>
>
|
|
|
|
RonB
|
| Posted: 08/16/2002, 1:46 PM |
|
Did you define the enviroment in apache? From other news groups I gather
this is often the problem. Maybe the pointers on www.php.net will help just
search for ocilogon in the function list and look at the user notes. I've
only worked with php and oracle in a windows2000 enviroment so cant help you
on the linux stuf.
Ron
"Marty" <martintrv@yahoo.com> schreef in bericht
news:ajjlsj$sed$1@news.codecharge.com...
> Hi Ron,
>
> The problem is not with Oracle, that is working fine. The problem is with
> PHP comunicating with Oracle. I use an Oracle client on my CodeCharge
> machine to communicate with the Oracle database on a Linux machine. When
> the files are transferred and the application is executed on the Linux
> machine, the db_oci8.php that CCS creates calls a routine called
ocilogon()
> . This is what it does not find. From what I can understand, compiling
php
> with --with-oracle --with-oci8, should staticly compile the oracle stuff
in
> php. The, php -m, shows that it is there.
>
> "RonB" <r.borkent@123chello.nl> wrote in message
>news:ajj4gg$tpd$1@news.codecharge.com...
> > Oracle is a tricky thing to get working:
> >
> > - Make sure you have the oracle client stuf installed on the web server.
> > - use the net8 configuration assistent to set your tnsnames.ora file
> > - move the oci8 dll in php/extensions to system or system32 directory
> > depending on the flavour of windows
> > - make sure apache nows where to find the oracle stuff by putting
> something
> > like this:
> > SetEnv ORACLE_HOME c:/oracle/ora81
> > SetEnv ORACLE_SID <your_sid>
> > SetEnv LD_LIBRARY_PATH c:/oracle/ora81/lib
> > SetEnv TNS_ADMIN C:\oracle\ora81\network\admin\tnsnames.ora
> > SetEnv TWO_TASK C:\oracle\ora81\network\admin\tnsnames.ora
> > SetEnv NLS_LANG English_America.WE8ISO8859P1
> >
> > in your apache httpd.conf file
> > - make sure ORACLE_HOME is known to windows by putting it in the
> enviroment
> > variable in (windows2000)configuration->system->enviroment variables
> >
> > - now pray
> >
> > RonB
> >
> >
> >
> > "Marty" <martintrv@yahoo.com> schreef in bericht
> >news:ajinks$67c$1@news.codecharge.com...
> > > I meant "I have compiled PHP 4.2.2"
> > > <martintrv@yahoo.com> wrote in message
> > >news:ajimg9$47c$1@news.codecharge.com...
> > > > Hi,
> > > >
> > > > I have tried selecting both the Oracle, and Oracle OCI as the PHP
> > Database
> > > > Library, and after publishing I get my login web page fine. I then
> get
> > :
> > > > Fatal error: Call to undefined function: ocilogon() in
> > > > /var/www/html/db_oci8.php on line 59.
> > > >
> > > > I get an ora_logon or ora_plogon similar message when using Oracle
as
> > the
> > > > PHP Database Library (Non-persistant and persitant).
> > > >
> > > > I have compiled PHP 4.2.4 and on the configure step I used
> > > > ./configure --with-oci8 --with-oracle
> > > > After installing and typing :
> > > > php -m
> > > > I get :
> > > > Running PHP 4.2.2
> > > > Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
> > > > [PHP Modules]
> > > > xml
> > > > standard
> > > > session
> > > > posix
> > > > pcre
> > > > oracle
> > > > oci8
> > > > mysql
> > > > ctype
> > > > [Zend Modules]
> > > >
> > > > I have been searching for answers, the only other thing I found was
a
> > > > reference that says check the php.ini file to make sure that the
> > extension
> > > > is defined. The only reference I find in the php.ini, looks like
the
> > > > extensions you speify if it was for a windows environment, ie...
> > > >
> > > > ;extension=php_oracle.dll
> > > >
> > > > I took the semi-colon off, tried it with that, and also removed the
> > .dll,
> > > > but I still get the same result.
> > > > The only other strange thing about my environment was that the old
php
> > was
> > > > in /usr/bin, and the new version was put in /usr/local/bin. I
removed
> > the
> > > > version in /usr/bin (as it was first in the path). Perhaps when it
is
> > > > looking for the oracle extension it is somehow looking in the old
> place
> > ?
> > > >
> > > > I am pretty sure there is a simple explanation to this.
> > > >
> > > > As a second question, how would you bypass the login screen and go
> > > directly
> > > > into the application (I am trying out portal) ? I want the user to
go
> > > > straight into the portal as a guest so that they can have the choice
> to
> > > > browse the guest portal, or login as registered user after ?
> > > >
> > > > Best Regards
> > > >
> > > > Martin...
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
