News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[Unknown]'s Guide to Installing PHP and MySQL.

Started by [Unknown], November 16, 2003, 03:40:49 PM

Previous topic - Next topic

[Unknown]

Quote from: jrcarr on September 10, 2004, 10:25:37 PM
Now you have an apache server with php and MySQL all running.  You have uploaded and created a test website and all is working well.  How do you make a home server visible to the internet.  Or is this beyond the scope of the Tutorial?  Thanks

There's a lot more you need to do to make it internet ready.  This only makes it ready for testing purposes only.  A lot of VERY IMPORTANT security issues are completely glossed over for simplicity.  Let me say it in large letters:

PLEASE DO NOT USE THIS GUIDE TO SET UP A PRODUCTION SERVER!

Quote from: Thunderace on September 10, 2004, 04:29:28 PM
Having said that .. I haven't a clue how to create a DB in mySQL, in fact I don't even know of it's running.

The easiest way is to check services.  On NT/2000/XP, go to My Computer -> right click -> Manage -> Services and Applications -> Services.  Under there, look for MySQL.  It will tell you if it has been started or not.

To run queries, you can use the mysql.exe command line utility.  C:\Program Files\MySQL\bin\mysql.exe.  You can also install phpMyAdmin.

Username is root, password is a blank (empty) string.

-[Unknown]

jrcarr

QuoteThere's a lot more you need to do to make it internet ready.  This only makes it ready for testing purposes only.  A lot of VERY IMPORTANT security issues are completely glossed over for simplicity.  Let me say it in large letters:

PLEASE DO NOT USE THIS GUIDE TO SET UP A PRODUCTION SERVER!
This is understandable!  Do you have suggestion of good site to read to learn more about setting security and then to make a home server a production server.  Thanks

Jack
Jack Carr

[Unknown]

For one thing, my first advice is to use Apache instead of IIS.  IIS will do windows authentication, and several other things that can cause problems.

I won't pretend to be an expert on server configuration, though.  You might check webhostingtalk, though...

-[Unknown]

jrcarr

Are you referring to the Host and Hosting board here?  Thanks for your replies.

Jack
Jack Carr

[Unknown]


Thunderace

QuoteNow, this part is important only if you're using NTFS.  You probably are if you are on 2000 or XP.  Go to the folder C:\WINDOWS\Temp and right click on it, and select Properties.  If you don't see a Security tab, close it and go to Tools -> Folder Options in the menu.  Go to the View tab, and uncheck the "Use simple file sharing" checkbox at the bottom of the list.  Now go to Properties again.

These options are not available on my XP.

Only option it offers is to move Temp to shared folder

[Unknown]

You went to the Tools menu next to "Favorites" and "View" and then Folder Options?

-[Unknown]


[Unknown]

#128
Quote from: Thunderace on September 13, 2004, 02:14:05 AM
Yup that option doesn't exist on mine

Are you using Windows XP Home, or Windows XP Pro?  I'm still not certain you're looking in the right place, because the option to "move Temp to shared folder" is displayed in a completely different place.  Here, let me try to illustrate with some attachments ;).

Please note that this tab is only available when using NTFS.  If you are using FAT, you both won't have it and won't need to worry about it.  You can be sure your computer is insecure :P. (FAT means EVERYONE can write and you can't restrict that.)

-[Unknown]


[Unknown]

Right click on the file and go to properties ;).

-[Unknown]


[Unknown]



[Unknown]

Go to Start -> Run.  In the box, type cmd.  From there, type:

cacls c:\windows\temp

When I say that, my computer says:
c:\windows\Temp BUILTIN\Administrators:(OI)(CI)F
                CREATOR OWNER:(OI)(CI)(IO)F
                TBIRD1800\IUSR_TBIRD1800:(OI)(CI)C
                NT AUTHORITY\NETWORK SERVICE:(OI)(CI)(special access:)
                                                     DELETE
                                                     SYNCHRONIZE
                                                     FILE_READ_DATA

                BUILTIN\Power Users:(OI)(CI)C
                NT AUTHORITY\SYSTEM:(OI)(CI)F
                BUILTIN\Users:(CI)(special access:)
                                  SYNCHRONIZE
                                  FILE_WRITE_DATA
                                  FILE_APPEND_DATA
                                  FILE_EXECUTE


What does yours say?

-[Unknown]


[Unknown]

Hmm... try:

cacls c:\windows\temp /e /g Everyone:C

-[Unknown]


Thunderace

Seems to have done the trick [unknown]

Local board is now smooth as silk

Cookie problem that I was experiencing seems to have gone.

Nice, thanks for your time m8.


Advertisement: