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