Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

FWR Media

Installing your own web server with PHP and MySQL

13 posts in this topic

I have seen a number of posts here regarding installing a local pc web server. Most talk about using pre configured packages which are restrictive and often out of date.

 

How much better to just download apache, PHP, MySQL and run it on your pc.

 

The author of this guide is is an immensely capable programmer and I have used the guide myself on numerous occasions.

 

[unknown]'s Guide to Installing PHP and MySQL

 

Hope it helps others as much as its helped me.

SypePecezen likes this

Share this post


Link to post
Share on other sites
I have seen a number of posts here regarding installing a local pc web server. Most talk about using pre configured packages which are restrictive and often out of date.

 

How much better to just download apache, PHP, MySQL and run it on your pc.

 

The author of this guide is is an immensely capable programmer and I have used the guide myself on numerous occasions.

 

[unknown]'s Guide to Installing PHP and MySQL

 

Hope it helps others as much as its helped me.

 

Instructions for Apache, Perl/CGI, PHP, and MySQL on Windows

Above link is another step by step guide that I found to be very useful

 

These are how-to tutorials to give step by step instructions for installing, setting up, and configuring Apache2 web server, ActivePerl, PHP, and MySQL in Windows. A section is also included that tells you how to make your server accessible to the world, some info on firewalls, and a section on other types of servers (ftp, mail).

Share this post


Link to post
Share on other sites
Instructions for Apache, Perl/CGI, PHP, and MySQL on Windows

Above link is another step by step guide that I found to be very useful

 

These are how-to tutorials to give step by step instructions for installing, setting up, and configuring Apache2 web server, ActivePerl, PHP, and MySQL in Windows. A section is also included that tells you how to make your server accessible to the world, some info on firewalls, and a section on other types of servers (ftp, mail).

 

 

 

 

Google Xampp.. I am a complete novice at this... and found that program on another site and now am running my test OS commerce page on my PC. It contains everything needed.. I would def check them out. GL

 

-Dinny

Share this post


Link to post
Share on other sites

Packages are fine if you really can't do the real thing.

 

But it is far better (imo) to have the flexibility to update to the latest packages and the ability, for example to run MySQL4 AND MySQL5 with PHP4 AND PHP5 (not at the same time if you get my drift).

 

There are many other benefits of not being restricted to a package but I'll leave it there.

 

 

My tutorial is here ..

 

Instructions to install a local apache server with PHP and MySQL on your windows PC - including Vista - XP

 

Hope it helps someone

Share this post


Link to post
Share on other sites

As usual, you guys rock!

This all went smooth using the first set of instructions from unknownbrackets.com except:

 

Also added from http://www.ricocheting.com/server/apache.html

• When you install Apache, you'll get a prompt for "Server Information." Here is the settings I used:

Network Domain: localhost

Server Name: localhost

Admin Email: (your any email)

 

I have hit on a problem though, in the final step of configuring MySQL I'm getting the error;

 

Error 2003 can’t connect to MySQL server on localhost (10061)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections

I haven't spent all that much time searching for it, [running windows 2000 XP (service pack2), Norton, & Spy Sweeper. All firewalls off] don't know how to find or adjust port 3306.

Any help or suggestions?

Share this post


Link to post
Share on other sites
As usual, you guys rock!

This all went smooth using the first set of instructions from unknownbrackets.com except:

 

Also added from http://www.ricocheting.com/server/apache.html

• When you install Apache, you'll get a prompt for "Server Information." Here is the settings I used:

Network Domain: localhost

Server Name: localhost

Admin Email: (your any email)

 

I have hit on a problem though, in the final step of configuring MySQL I'm getting the error;

 

Error 2003 can’t connect to MySQL server on localhost (10061)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections

I haven't spent all that much time searching for it, [running windows 2000 XP (service pack2), Norton, & Spy Sweeper. All firewalls off] don't know how to find or adjust port 3306.

Any help or suggestions?

 

 

Outof curiousity: What type of internet connection are you using for your home / OSC severs, and have you had any problems with bandwidth - or lack thereof?

 

Husky

Share this post


Link to post
Share on other sites

Babygurgles,

 

Do you have installation instructions for Windows Vista where Apache is not used by either IIS or PWS ?

I have the Vista Home Premium edition and have not been able to figure out if it still comes with IIS.

 

I dont want to install Apache as I am not an expert.

 

 

Packages are fine if you really can't do the real thing.

 

But it is far better (imo) to have the flexibility to update to the latest packages and the ability, for example to run MySQL4 AND MySQL5 with PHP4 AND PHP5 (not at the same time if you get my drift).

 

There are many other benefits of not being restricted to a package but I'll leave it there.

My tutorial is here ..

 

Instructions to install a local apache server with PHP and MySQL on your windows PC - including Vista - XP

 

Hope it helps someone

Share this post


Link to post
Share on other sites

thanks, I followed all the instructions from unknownbrackets.com and have downloaded my site to the right directory. But, when I go to 'http://localhost/mysite' it tells me

 

Unable to connect to database server!

 

I havent installed phpMyAdmin or imported my shop database because I dont know how. What do I need to do to set up osCommerce on my local server?

 

Thanks,

 

Ben

Share this post


Link to post
Share on other sites

Ok, So I have extracted phpmyadmin to the correct directory and tried to login but it tells me everytime:

 

Error

 

MySQL said:

#2003 - The server is not responding

 

Could someone help? I really would like to get this set up

Share this post


Link to post
Share on other sites

A super easy way to setup a development environment is with xampp

 

http://www.apachefriends.org/en/xampp.html

 

It will setup everything you need to setup a dev environment (linux or windows mac os x or Solaris) with one short command. I use it to setup test environments at home so I can test everything 1st before moving it to the production site.

 

Its always worked great for me and free to boot!

Share this post


Link to post
Share on other sites

The best way I found to do this was using VMWare (Fusion on Mac) to run http://www.turnkeylinux.org/appliances/lamp - which is closer to what my host uses than the XAMPP instances.

 

I then use zoneedit.com to map a development site to the VM using another domain name. The development environment is available when required and can be shutdown when not. It can also have snapshots taken and be replicated very easily for other sites that I work on.

 

And while VMWare can sometimes be a bit resource heavy, apache, php, mysql is pretty lightweight - don't even notice it running.

Share this post


Link to post
Share on other sites

All of this is really great :-) but my question is how to take the test site live once you are done tweaking it on your local computer? Say to like a godaddy account? Thank you all

Share this post


Link to post
Share on other sites

Erwin,

 

Once you are done working locally, you can FTP the files to your hosting account (Godaddy) maintaining the directory structure. Then, set the two configure.php files to match your server path and database credentials.

 

 

 

 

Chris

Share this post


Link to post
Share on other sites