Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

MySql access on Small business Server 2003

I am trying to install mysql onto my company server and am having great difficulty in doing so.  I have installed PHP and am able to get the PHP info via IE successfully.  The MySQL service has also started successfully.  However, when I try to access localhost/php via IE I get an HTTP 403 error.  I have seen various responses on this suggesting that I need to add a port exception to the firewall, however, when I do this and start the Windows Firewall and Internet connection (ICS) service it denies access to the network for my client PCs so I think my configuration must be slightly different.  I have also checked the setup in IIS and by default everyone is granted access.  Can someone help me with this - I am only a beginner with this so I can't be sure that I'm even looking in the right places!  I did manage to get everything set up and running with xampp on my laptop but my issues seem to be with SBS...
0
Susanstevenson
Asked:
Susanstevenson
  • 4
  • 3
4 Solutions
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
What type of site are you trying to put on your SBS?  Because you have to be very careful about installing another site on an SBS due to it's need to use sub-sites on the default web site of IIS.

Therefore, you cannot use port 80 for anything other than what's on the default site unless you also use host headers for your other sites.

This means that localhost will ONLY go to the IIS default web site, not your PHP site.

Jeff
TechSoEasy
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Also... it's really not a good idea to run PHP and MySQL on an SBS... especially if you are a beginner with this stuff.

You should probably put these on a separate machine.

Jeff
TechSoEasy
0
 
Olaf De CeusterCommented:
ICS should  be disabled on SBS box. Clients will not have access with that service running.
Olaf
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
SusanstevensonAuthor Commented:
It is an intranet site mainly to be used for call centre operators to data enter and record outcomes of calls.  Also, down the line, I hope to give clients access to their own reports etc so some secure external access would be needed.
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Then you should be running this on a separate machine, not your SBS.

Jeff
TechSoEasy
0
 
SusanstevensonAuthor Commented:
Please split points between olafdc and techsoeasy - I accepted olafdc: answer only and couldn't figure out how to accept both
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Okay, so now I'm curious.  Was there something else you needed to do to resolve this problem other than what we suggested?  Because you gave a grade of "B" which would indicate that my answer wasn't complete.

Perhaps because you are fairly new to EE you aren't quite familiar with the way grades are given.  Please review http://www.experts-exchange.com/help.jsp?hi=403 for more info.

Thanks.

Jeff
TechSoEasy
0
 
SusanstevensonAuthor Commented:
Only that I had done some additonal reading on the subject and felt that installing mysql on SBS was actually quite common.  We don't really have the resources to dedicate another machine.  I have gone ahead and done it on the server.  It was only for this reason that I graded a B.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now