Running Apache & mySQL as services on XP Home

[(Shovel)]

Right, this is both WebDev and Operating Systems, so it's going in the parent forum - I don't do double posting.

Havign just got Apache 1.3 and mySQL 3.23 up and running on their own as services (I was just as amazed as you are...) I need to sort out one sticking point.

Firstly, I only use them for local testing of websites before they go online. Apache is set up only to monitor localhost, can I assume that mySQL needs a similar setting set to keep it local? If so, where is it?

And no to the subject:
The Apache documentation mentions that running the Apache server as a "Local Service" user as it is by defualt is an uber bad idea (security I assume?) and that a separate user account should be used.
So I create a new limited user account (This is XP Home, remember) and assign it to start the service. It throws up access denied errors I don't know why, it doesn't want to tell me much.

So, is there a way to get this working right? I've got some user editing command line tools lying around that might be useful for customising the user privilages, but I'm not 100% sure.

So, can anyone help? I want to set up a secure user account to run the Apache service (and probably mySQL as well if it needs it) and I can't get it working.

Thanks

 

[Testin da Cable]

egads Ben! run them on a proper os


(not helping, I know )

 

[Will]

I was going to say that too, but I resisted...

Proper OS.

 

[(Shovel)]

I knoooooooooooooooooow

However, there is a need to preview websites on the fly, and I've not got round to reinstalling *nix yet after my extravegant reformatting last week.

I think I've got it working acceptably, so I shant be worrying about it any more.

And yes.. I will install *nix of some description at some point too...

... I have CygWin running, if that counts for anything?

 

[wyrd_fish]

get an old hammered PC and wack Mandrake linux on it...

i think they caom with apachie and MySQl already to go... thats what i did...

 

[Jonty]

If it is a security issue then, as we were talking about yesterday, I think you're safe with the setup being purely for local testing

Personally, and I'm a newbie when it comes to this [as (Shovel) now knows], but PHP and Apache were very easy to setup on Windows XP, all things considered. Quite what the fixation with Linux is I just don't know teeheehee

Kind Regards

 

[(Shovel)]

Originally posted by wyrd_fish
get an old hammered PC and wack Mandrake linux on it...

i think they caom with apachie and MySQl already to go... thats what i did...

Not that easy as a Student - lugging extra PCs around to uni every few months isn't really an option

I'll be running a firewall back home so *maybe* I'll set something up on there (I think it will already have something running come to think of it, for the web based admin), so we'll see

 

[wyrd_fish]

a hammered old laptop is also a good option

 

[(Shovel)]

Again, don't have one. I don't even have a shiny new laptop to one day be hammered. Sadly

Anyway, it's working, it runs using my user account (rather than Local System), which gives it admin rights, but is probably safer. It's only set up for internal access anyway, and on top of that the firewall will keep out outsiders

It's working, I'm happy

 

[mookie]

Have you tried phpdev ben?
its a handy little pre-configured win32 apache/php/mySQL and perl setup, its obviosuly not for heavy heavy stuff but it does the job very well for previewing server side stuff, and iirc theres several different versions with various configurations and apache versions, its well worth having a look at imo.

 

[(Shovel)]

Yeah, I used to use that a lot. However, my general finickityness (Sp?) means that I want them installed somewhere not in C:\ - I know, I'm bloody difficult.

It does appear to be working now. I runs the server as my administrator account, and it doesn't start up automagically, so it's probably safe enough.

Thanks for all the suggestions though

 

[Jonty]

teeheehee, just for reference ...

Dictionary
finick·i·ness n. Insisting capriciously on getting just what one wants; difficult to please; fastidious: a finicky eater

I wrote myself a Dictionary.com plugin so I can search automatically via Firebird's search toolbar

Kind Regards