Yet another Call to Undefined Function help request

Hi all,

PLEASE, don't just toss the e-mail... I think I have a unique enough situation to warrant this e-mail.

First, I have searched the mailing lists for the answer to my problem. I have also tried to find the answer through the documentation, but have been
unsuccessful. Mailing lists are always my last resort.

Here's the situation. I have an *old* Cobalt Raq appliance with Apache 1.3.20 and an older version of mysql on it. I have a customer that wants to
use a database on his website, and rather than update this old, unsupported appliance and possibly break something, or go through the hassle of moving
this customer with 100+ e-mail addresses to a different server, we have installed a new, dedicated mysql server to use system-wide for any of our
customers, and ourselves, to use as a db server. This seemed like a good idea at the time, and I think it will work well once we figure out the bugs
here.

Now, everything was going swimmingly, until we tried to access the db with php on a web page (which is where we got the call to undefined function).
It was an old version of php, so I thought I'd upgrade, not as scary as upgrading all three pieces of software. No resolution there. I compiled it
with mysql support, but still get the undefined function error. Now, on the new db server, phpinfo reports a whole section on mysql. On this older
server, there is no mysql section in phpinfo. I can log in and access the databases remotly from the Cobalt server using command line mysql; I would
like to try this at cli using php but don't know how.

I am obviously missing something and I can't find the answer anywhere, other than "reinstall apache, mysql, and php", which is kind of scary on a
server this old that is running as well as it is. Not only that, but my ego is kicking in here and I would really like to understand what the problem
is rather than just reinstalling everything... That just seems too M$ to me.

Any suggestions?

Thanks,

Alex

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Yet another Call to Undefined Function help request

OK, sounds good, what am I looking for? I don't see the module being declared in my php.ini file on either of my servers.

Alex

Fortuno, Adam wrote:
> Alex:
>
> It sounds like the MySQL extension module isn't loading. Here are some
> things to confirm:
>
> - Ensure the module is declared in your php.ini file
> - If it exists in the php.ini, confirm the module is located and named
> as stated in the php.ini file.
> - If the module is named and located in the proper place, check your
> permissions on that extension. You want to make sure whatever is running
> your sight can access the module.
>
> I hope this helps!
>
> A-
>
> -----Original Message-----
> From: Alex Moen [mailto:alexm@ndtel.com]
> Sent: Tuesday, December 09, 2008 9:54 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Yet another Call to Undefined Function help request
>
> Hi all,
>
> PLEASE, don't just toss the e-mail... I think I have a unique enough
> situation to warrant this e-mail.
>
> First, I have searched the mailing lists for the answer to my problem.
> I have also tried to find the answer through the documentation, but have
> been
> unsuccessful. Mailing lists are always my last resort.
>
> Here's the situation. I have an *old* Cobalt Raq appliance with Apache
> 1.3.20 and an older version of mysql on it. I have a customer that
> wants to
> use a database on his website, and rather than update this old,
> unsupported appliance and possibly break something, or go through the
> hassle of moving
> this customer with 100+ e-mail addresses to a different server, we have
> installed a new, dedicated mysql server to use system-wide for any of
> our
> customers, and ourselves, to use as a db server. This seemed like a
> good idea at the time, and I think it will work well once we figure out
> the bugs
> here.
>
> Now, everything was going swimmingly, until we tried to access the db
> with php on a web page (which is where we got the call to undefined
> function).
> It was an old version of php, so I thought I'd upgrade, not as scary as
> upgrading all three pieces of software. No resolution there. I
> compiled it
> with mysql support, but still get the undefined function error. Now, on
> the new db server, phpinfo reports a whole section on mysql. On this
> older
> server, there is no mysql section in phpinfo. I can log in and access
> the databases remotly from the Cobalt server using command line mysql; I
> would
> like to try this at cli using php but don't know how.
>
> I am obviously missing something and I can't find the answer anywhere,
> other than "reinstall apache, mysql, and php", which is kind of scary on
> a
> server this old that is running as well as it is. Not only that, but my
> ego is kicking in here and I would really like to understand what the
> problem
> is rather than just reinstalling everything... That just seems too M$ to
> me.
>
> Any suggestions?
>
> Thanks,
>
> Alex
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Yet another Call to Undefined Function help request

------=_Part_56849_31675681.1228837950919
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tue, Dec 9, 2008 at 10:33 AM, Alex Moen wrote:

> OK, sounds good, what am I looking for? I don't see the module being
> declared in my php.ini file on either of my servers.
>
> Alex
>
> Fortuno, Adam wrote:
>
>> Alex:
>>
>> It sounds like the MySQL extension module isn't loading. Here are some
>> things to confirm:
>>
>> - Ensure the module is declared in your php.ini file
>> - If it exists in the php.ini, confirm the module is located and named
>> as stated in the php.ini file.
>> - If the module is named and located in the proper place, check your
>> permissions on that extension. You want to make sure whatever is running
>> your sight can access the module.
>>
>> I hope this helps!
>>
>> A-
>>
>>
>> -----Original Message-----
>> From: Alex Moen [mailto:alexm@ndtel.com] Sent: Tuesday, December 09, 2008
>> 9:54 AM
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] Yet another Call to Undefined Function help request
>>
>> Hi all,
>>
>> PLEASE, don't just toss the e-mail... I think I have a unique enough
>> situation to warrant this e-mail.
>>
>> First, I have searched the mailing lists for the answer to my problem.
>> I have also tried to find the answer through the documentation, but have
>> been unsuccessful. Mailing lists are always my last resort.
>>
>> Here's the situation. I have an *old* Cobalt Raq appliance with Apache
>> 1.3.20 and an older version of mysql on it. I have a customer that
>> wants to use a database on his website, and rather than update this old,
>> unsupported appliance and possibly break something, or go through the
>> hassle of moving this customer with 100+ e-mail addresses to a different
>> server, we have
>> installed a new, dedicated mysql server to use system-wide for any of
>> our customers, and ourselves, to use as a db server. This seemed like a
>> good idea at the time, and I think it will work well once we figure out
>> the bugs here.
>>
>> Now, everything was going swimmingly, until we tried to access the db
>> with php on a web page (which is where we got the call to undefined
>> function). It was an old version of php, so I thought I'd upgrade, not as
>> scary as
>> upgrading all three pieces of software. No resolution there. I
>> compiled it with mysql support, but still get the undefined function
>> error. Now, on
>> the new db server, phpinfo reports a whole section on mysql. On this
>> older server, there is no mysql section in phpinfo. I can log in and
>> access
>> the databases remotly from the Cobalt server using command line mysql; I
>> would like to try this at cli using php but don't know how.
>>
>> I am obviously missing something and I can't find the answer anywhere,
>> other than "reinstall apache, mysql, and php", which is kind of scary on
>> a server this old that is running as well as it is. Not only that, but my
>> ego is kicking in here and I would really like to understand what the
>> problem is rather than just reinstalling everything... That just seems too
>> M$ to
>> me.
>>
>> Any suggestions?
>>
>> Thanks,
>>
>> Alex
>>
>>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
In the new version of php, mysql is not enabled by default. Check the ini
file for the modules section and ensure that the mysql is uncommented.


--

Bastien

Cat, the other other white meat

------=_Part_56849_31675681.1228837950919--

Re: Yet another Call to Undefined Function help request

GOT IT!!!

Adam, thanks for the answer. It got me where I needed to be, and I now understand how this stuff works a little better.


Here's the solution for future reference:

The new server has a separate directory (/etc/php.d) that was referenced in the php.ini. (This server is running Fedora 9, btw.) In /etc/php.d was a
file called mysql.ini, which had the line:

extension=mysql.so

I searched for "extension" in my php.ini file on the cobalt server, found, among other things:

extension_dir = /usr/lib/apache/php ; directory in which the loadable extensions (modules) reside

and

;UNIX Extensions
;extension=interbase.so
;extension=pgsql.so

So, I added

extension=mysql.so

to the list.

Then, I did a search for the mysql.so file, which turned out to be in the build/modules directory all by itself just waiting to be used, copied it to
/usr/lib/apache/php/, restarted httpd, and voila, I now have a working implementation of php pulling data from a remote server.

Thanks for the help!!! It is greatly appreciated!

Alex


Alex Moen wrote:
> OK, sounds good, what am I looking for? I don't see the module being
> declared in my php.ini file on either of my servers.
>
> Alex
>
> Fortuno, Adam wrote:
>> Alex:
>>
>> It sounds like the MySQL extension module isn't loading. Here are some
>> things to confirm:
>>
>> - Ensure the module is declared in your php.ini file
>> - If it exists in the php.ini, confirm the module is located and named
>> as stated in the php.ini file.
>> - If the module is named and located in the proper place, check your
>> permissions on that extension. You want to make sure whatever is running
>> your sight can access the module.
>>
>> I hope this helps!
>>
>> A-
>>
>> -----Original Message-----
>> From: Alex Moen [mailto:alexm@ndtel.com] Sent: Tuesday, December 09,
>> 2008 9:54 AM
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] Yet another Call to Undefined Function help request
>>
>> Hi all,
>>
>> PLEASE, don't just toss the e-mail... I think I have a unique enough
>> situation to warrant this e-mail.
>>
>> First, I have searched the mailing lists for the answer to my problem.
>> I have also tried to find the answer through the documentation, but have
>> been unsuccessful. Mailing lists are always my last resort.
>>
>> Here's the situation. I have an *old* Cobalt Raq appliance with Apache
>> 1.3.20 and an older version of mysql on it. I have a customer that
>> wants to use a database on his website, and rather than update this old,
>> unsupported appliance and possibly break something, or go through the
>> hassle of moving this customer with 100+ e-mail addresses to a
>> different server, we have
>> installed a new, dedicated mysql server to use system-wide for any of
>> our customers, and ourselves, to use as a db server. This seemed like a
>> good idea at the time, and I think it will work well once we figure out
>> the bugs here.
>>
>> Now, everything was going swimmingly, until we tried to access the db
>> with php on a web page (which is where we got the call to undefined
>> function). It was an old version of php, so I thought I'd upgrade, not
>> as scary as
>> upgrading all three pieces of software. No resolution there. I
>> compiled it with mysql support, but still get the undefined function
>> error. Now, on
>> the new db server, phpinfo reports a whole section on mysql. On this
>> older server, there is no mysql section in phpinfo. I can log in and
>> access
>> the databases remotly from the Cobalt server using command line mysql; I
>> would like to try this at cli using php but don't know how.
>>
>> I am obviously missing something and I can't find the answer anywhere,
>> other than "reinstall apache, mysql, and php", which is kind of scary on
>> a server this old that is running as well as it is. Not only that,
>> but my
>> ego is kicking in here and I would really like to understand what the
>> problem is rather than just reinstalling everything... That just seems
>> too M$ to
>> me.
>>
>> Any suggestions?
>>
>> Thanks,
>>
>> Alex
>>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Yet another Call to Undefined Function help request

> Then, I did a search for the mysql.so file, which turned out to be in
> the build/modules directory all by itself just waiting to be used,
> copied it to /usr/lib/apache/php/, restarted httpd, and voila, I now
> have a working implementation of php pulling data from a remote server.

Did you run 'make install'? because that step is supposed to do that for
you.

--
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: Yet another Call to Undefined Function help request

Yes, I did run make install... I was kind of surprised that it didn't put that file somewhere.

Alex


Chris wrote:
>
>> Then, I did a search for the mysql.so file, which turned out to be in
>> the build/modules directory all by itself just waiting to be used,
>> copied it to /usr/lib/apache/php/, restarted httpd, and voila, I now
>> have a working implementation of php pulling data from a remote server.
>
> Did you run 'make install'? because that step is supposed to do that for
> you.
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php