PHP & mySQL

Zack yellowdog-general@lists.terrasoftsolutions.com
Sun Jun 23 11:31:00 2002


>Can you locate your mysql.so file?? That locatin needs to be specified as the extension_dir... on my standard YDL 2.2 system this location is /usr/lib/php4

Nope.  Can't seem to find it - /usr/lib/php4 exists, but is an empty directory.

When I do a #whereis mysql.so it only shows me /usr/bin/mysql

Where would I obtain this file?

Thx,

-Z

Rob Schumann <robs@rs-tc.com> wrote:

>Hi Zack,
>
>Couple of quick things...
>
>On 23-06-2002 Shawn Coomey wrote in response to Zack:
> > 
> > Sounds to me like PHP wasn't compiled with MySQL support.
> >
>What installation are we talking about here. YDL 2.2 has a known problem with the php.ini file as described earlier and simply fixing the php.ini file (the one in /etc) as described and then restarting httpd should fix the problem without the need for a rebuild.
>
>If you are not running the standard "out-of-the-box" YDL 2.2 install of PHP & MySQL, then we have a whole other problem to deal with where a rebuild _might_ be in order.
>
>But I'm all for the simple solutins first :O)
>
>You can also check your php configuration by creating a page with the following script
>
><?php
>    phpinfo();
>?>
>
>This will return full php and server environment information, including at the top the configuration used to build php. Check in there for the --with-mysql flag and if present the problem lies definitely with your php.ini... assuming that mysql is installed.
> >
> > On Sunday, June 23, 2002, at 11:21 AM, Jamey Osborne wrote:
> > 
> > > At 12:40 AM 6/23/2002 -0400, you wrote:
> > >>
> > >> I added those lines to php.ini & restarted httpd, and I
> > >> still get the error:
> >
>Can you locate your mysql.so file?? That locatin needs to be specified as the extension_dir... on my standard YDL 2.2 system this location is /usr/lib/php4
> > >>
> > >> Call to undefined function: mysql_connect()
> > >>
> > >> Is there something I missed?
> > >
> > > Well, just taking a weak stab in the dark.  Without my
> > > manuals in front of me, either...
> > >
> > > As I recall, don't you have to specify the database to be
> > > used in the mysql_connect?  I didn't see that in your $Link
> > > line.  You're calling the DB before you've specified it......
> > >
>The above error says "undefined function", meaning no knowledge of that function. As far as php is concerned, it doesn't exist, so it equally has no knowledge of how many parameters, if any, should even be present, hence the () after the function name in the error message.
>
>Hope this helps
>
>Rob
>_______________________________________________
>yellowdog-general mailing list
>yellowdog-general@lists.terrasoftsolutions.com
>http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general
>


-- 
_____________________
I feel more like I do right now than I did a while ago.



__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/