Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Instant Website: Realty/Listings/Auto:
Is MySQL needed on local machine?

 
 


danw
User

Jul 1, 2009, 3:29 PM

Post #1 of 5 (2258 views)
Shortcut
Is MySQL needed on local machine? Can't Post
I'm attempting to set up IW on a webserver that was previously only running ASP sites. I installed PHP on this server and MySQL on our database server. For some reason, the PHP won't load the MySQL extension so the IW install is balking with a "This program requires the PHP 'mysql' extension." message. Is it necessary to have the MySQL installed on the web server as well as the database server? My intention was to just connect to the database server to reach the database. Thanks,

Dan


Dave
Staff / Moderator


Jul 1, 2009, 9:29 PM

Post #2 of 5 (2257 views)
Shortcut
Re: [danw] Is MySQL needed on local machine? [In reply to] Can't Post
Hi Dan,

The 'mysql extension' is just a php extension that lets PHP talk to the MySQL server. If you search through the php.ini config file for mysql you might find a commented line that will enable it. For example, on windows it looks like this:

;extension=php_mysql.dll

Just remove to ; to uncomment it and restart the web server and it should work. Let us know how it goes.

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com
 


danw
User

Jul 2, 2009, 7:22 AM

Post #3 of 5 (2255 views)
Shortcut
Re: [Dave] Is MySQL needed on local machine? [In reply to] Can't Post
Thanks for getting back to me, Dave.

Yeah, I did do that. As a matter of fact, when I loaded PHP, I didn't load any extensions. I wanted to see what I needed for IW and only load the minimum. When I tried to install IW I received two messages; one regarding mysql and one for GD. I enabled them both in php.ini but only the GD loaded. I've also looked for any errors when php loads and can't find any.


danw
User

Jul 2, 2009, 9:57 AM

Post #4 of 5 (2252 views)
Shortcut
Re: [danw] Is MySQL needed on local machine? [In reply to] Can't Post
Everything looks ok now. I had to reboot the server to get the mysql extensions to load.



Thanks.


Dave
Staff / Moderator


Jul 2, 2009, 10:01 AM

Post #5 of 5 (2251 views)
Shortcut
Re: [danw] Is MySQL needed on local machine? [In reply to] Can't Post
It may take some google'ing and experimentation. Setting up server software can be a hassle sometimes.

Here's some more things I'd check:
- Check php_mysql.dll is in C:\php\ext or your PHP extension folder
- Make sure you've restarted your web server (depending on how PHP is loaded it may only check it's config file on restart).
- Create a file called phpinfo.php with the following contents to check server settings (and search for mysql):
<?php phpinfo() ?>
- If none of that works try installing with all the extensions and working in reverse to remove ones you don't need rather than vice-versa.

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com