php-install Digest 6 Dec 2001 14:17:50 -0000 Issue 589

Topics (messages 5212 through 5218):

Re: initial problem w/ OCI
        5212 by: John Kolvereid
        5213 by: John Kolvereid

test
        5214 by: ydok.21bc.com

a strange question when installing php+oracle8.1.16+apache1.3.14 (in linux)
        5215 by: ydok.21bc.com

Call to undefined function: mysql_connect()
        5216 by: Rob Round
        5217 by: Fred
        5218 by: Rob Round

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------
--- Begin Message ---
Hi,
    I forgot to mention that I am running RedHat 6.2 and Oracle 8.1.7.  I do
know of the bug to
add my oracle shared library to the /etc/ld.so.conf file, and have fixed
it.  I have also made sure that
the shared library libpthread.so.0 is known to my httpd (by rebuilding
Apache).  Still a problem.

John Kolvereid wrote:

> Hi,
>     This may be an install problem.
>     Initially, when Apache is run from boot, I am unable to use OCI:
>     'Warning: _oci_open_server: Error while trying to retrieve text for
> error ORA-12514 in ...'
> however, when I restart it, all is well.
>     Plus there seems to be ANOTHER problem/concern.  I am also using
> MySQL.  When I cannot use OCI, the MySQL screams - it's so fast.  When I
>
> can use OCI, MySQL slows to a snails pace on initial lookup.  I am
> absolutely positive this is not a cache concern, but I don't know what
> it is.
>     Please advise, and if necessary, please give me the name of the php
> install news group.  Thank you.
>
> --
>       John Kolvereid
>       http://www.odinfo.com
>       http://www.kolvereid.com
>       [EMAIL PROTECTED]
>       1.610.296.4485

--
      John Kolvereid
      http://www.odinfo.com
      http://www.kolvereid.com
      [EMAIL PROTECTED]
      1.610.296.4485


--- End Message ---
--- Begin Message ---
It's me again,
    I got it.  1st, disregard the Mysql concerns.  It was only slow because it
wouldn't display until Oracle finished in the same script.  2nd, the reason that
OCI did not work during the boot up was because APACHECTL which starts the web
server needed $ORACLE_HOME to find something (not sure what).  I simply added
the line
    export ORACLE_HOME=/u01/app/oracle/product/8.1.7
and now it works on bootup.   Whew
    I would like to know if someone out there knows why APACHECTL requires
$ORACLE_HOME, and/or what can be done to avoid putting in the extra line.  I
think this would eliminate a lot of grief to the ORACLE community.
   Thanks.

John Kolvereid wrote:

> Hi,
>     I forgot to mention that I am running RedHat 6.2 and Oracle 8.1.7.  I do
> know of the bug to
> add my oracle shared library to the /etc/ld.so.conf file, and have fixed
> it.  I have also made sure that
> the shared library libpthread.so.0 is known to my httpd (by rebuilding
> Apache).  Still a problem.
>
> John Kolvereid wrote:
>
> > Hi,
> >     This may be an install problem.
> >     Initially, when Apache is run from boot, I am unable to use OCI:
> >     'Warning: _oci_open_server: Error while trying to retrieve text for
> > error ORA-12514 in ...'
> > however, when I restart it, all is well.
> >     Plus there seems to be ANOTHER problem/concern.  I am also using
> > MySQL.  When I cannot use OCI, the MySQL screams - it's so fast.  When I
> >
> > can use OCI, MySQL slows to a snails pace on initial lookup.  I am
> > absolutely positive this is not a cache concern, but I don't know what
> > it is.
> >     Please advise, and if necessary, please give me the name of the php
> > install news group.  Thank you.
> >
> > --
> >       John Kolvereid
> >       http://www.odinfo.com
> >       http://www.kolvereid.com
> >       [EMAIL PROTECTED]
> >       1.610.296.4485
>
> --
>       John Kolvereid
>       http://www.odinfo.com
>       http://www.kolvereid.com
>       [EMAIL PROTECTED]
>       1.610.296.4485

--
      John Kolvereid
      http://www.odinfo.com
      http://www.kolvereid.com
      [EMAIL PROTECTED]
      1.610.296.4485


--- End Message ---
--- Begin Message ---

--- End Message ---
--- Begin Message ---
hi,sir;

        i am installing php4.0.2+oracle8.1.16+apache1.3.14  in redhat7.0 ,first i 
installed apache at /opt/apache ,it run well.
then i installed oracle at /opt/oracle and /opt/oraclient,as you see,i installed oci 
at /opt/oraclient.now oracle works well,too.
at last,i try to install php as a dso in apache like this :
shell> ./configure --with-apxs=/opt/apache/bin/apxs --with-oracle=/opt/oracle 
--with-oci8=/opt/oraclient --enable-track-vars ;make;make install
shell> cp php.ini-dist /usr/local/lib

it didn't show any error messages.then i start apache :
[root@linux bin]# ./apachectl restart
./apachectl restart: httpd not running, trying to start
./apachectl restart: httpd started

it looks like that apache is running.but ......i can't see 'httpd' when running 'ps 
-e' in console,and when
i visit in ie5 ,i found apache didn't work.i changed httpd.conf ,change the line
'LoadModule php4_module     libexec/libphp4.so'
to 
'#LoadModule php4_module     libexec/libphp4.so'
and start apache again,this time it works well.i feel so stange,why?

 
 
i installed apache like this 
shell>./configure --with-prefix=/opt/apache --enable-module=most --enable-shared=max
 
 
so apache should support dso.in fact,i had installed php with mysql as dso,it works 
well.i think i made some mistake when configure php with oracle and oci8,who can give 
me some help? 


--- End Message ---
--- Begin Message ---
Hello,

I have a standard RedHat7.2 install.  In the installation I specified every
mysql, PHP and apache module available.  PHP works, mysql works and so does
Apache.  Unfortunately, I get this error when trying to make a mysql
connection through a PHP page "Call to undefined function: mysql_connect()".
I'm assuming that PHP is missing some compile switches that weren't
available at install time.  Is it possible to add this functionality
afterwards or do I have to recompile PHP from scratch?  If there is a way
around not reinstalling from scratch that would be great as this is a
production machine.

I have looked through the archives and haven't really found what I needed. I
also did a test install on a second machine and installed every package
available to see if the PHP/mysql support was included... it wasn't.

Thanks in advance.

--- End Message ---
--- Begin Message ---
Write this script and execute it:
<? phpinfo() ?>
It will provide you with a lengthy list of configuration information.  Copy
the "configuration command" and any mysql info to an email so that we can
better understand your situation.

Fred

Rob Round <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> I have a standard RedHat7.2 install.  In the installation I specified
every
> mysql, PHP and apache module available.  PHP works, mysql works and so
does
> Apache.  Unfortunately, I get this error when trying to make a mysql
> connection through a PHP page "Call to undefined function:
mysql_connect()".
> I'm assuming that PHP is missing some compile switches that weren't
> available at install time.  Is it possible to add this functionality
> afterwards or do I have to recompile PHP from scratch?  If there is a way
> around not reinstalling from scratch that would be great as this is a
> production machine.
>
> I have looked through the archives and haven't really found what I needed.
I
> also did a test install on a second machine and installed every package
> available to see if the PHP/mysql support was included... it wasn't.
>
> Thanks in advance.
>


--- End Message ---
--- Begin Message ---
Here is the configuration command (PHP Version 4.0.4pl1).  I guess I should
have added this in my original email.  I did see that it
says --without-mysql which was a clue to my problem.  Whay I don't
understand is why, on two installs, if I pick "install everything" it
doesn't install this.  Can I add it after the fact or do I need to reinstall
PHP from scratch?

Thanks again.

Rob.

'./configure' '--prefix=/usr' '--with-config-file-path=/etc'
'--disable-debug' '--enable-pic' '--enable-shared'
'--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs'
'--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext'
'--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2'
'--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes'
'--enable-safe-mode' '--enable-sockets' '--enable-sysvsem'
'--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp'
'--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8'
'--with-xml'


-----Original Message-----
From: Fred [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 3:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-INST] Re: Call to undefined function: mysql_connect()


Write this script and execute it:
<? phpinfo() ?>
It will provide you with a lengthy list of configuration information.  Copy
the "configuration command" and any mysql info to an email so that we can
better understand your situation.

Fred

Rob Round <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> I have a standard RedHat7.2 install.  In the installation I specified
every
> mysql, PHP and apache module available.  PHP works, mysql works and so
does
> Apache.  Unfortunately, I get this error when trying to make a mysql
> connection through a PHP page "Call to undefined function:
mysql_connect()".
> I'm assuming that PHP is missing some compile switches that weren't
> available at install time.  Is it possible to add this functionality
> afterwards or do I have to recompile PHP from scratch?  If there is a way
> around not reinstalling from scratch that would be great as this is a
> production machine.
>
> I have looked through the archives and haven't really found what I needed.
I
> also did a test install on a second machine and installed every package
> available to see if the PHP/mysql support was included... it wasn't.
>
> Thanks in advance.
>



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


--- End Message ---

Reply via email to