Running a remote website

[john_d]

Problem: Website and Mu server cant run in the same place or is too much for the computer to handle. or something like that

Solution: making your website run on a different computer/machine.

Overview: Computer A which would be your Mu server must be able to accept incomming connection to the mssql database, to make it more secure mssql must be on mix mode authentication ( windows and sql ). Using an Sql Username and password the Computer B (remote webhost Computer) will use a variaty of ways to connection to Computer A, but Computer B must be able to have some certain components in order for it to be able to send a secure direct connection to Computer A. These Components vary from what type of connections will be used.

Computer A: ( things to check and do )
MU server Computer and the Database server computer

1. Enable Mix mode authentication.
2. Check and Enable Certain Mssql Network Protocols
3. Create a MSsql Username Password
4. Give the newly Created username password access and powers over the MuOnline and Rankings database

Computer B: ( things to check and do )
The remote Web host

Preparation for Connection:

1. Checking for available connection
2. testing the connection type

Types of connection available

1. Connecting Via ODBC
   1. Checking if Odbc is installed
   2. Creating and testing an ODBC system dsn link to the Computer A
   3. Creating a test website that will connect to the ODBC
2. Connecting Via Php's MSsql extention
   1. Checking if Php's Mssql Extention is enabled
   2. Creating a test website that will connect to Computer A via the mssql extention
3. Connecting Via TCP
   1. same as above.. lolz

.. lolz.. im late for school be back later to finish explaining wat i started. ill sticky this for now.. so i wont forget.

[MentaL]

[Josh]

wow very nice!

[rodryggow]

good, won't that facilitate for the hackers?

[john_d]

lolz i completely forgot about this one.

what is there to hack. ok lets say u successfully have a remote website.

the hole would be .. that u opened ur mssql port ... if u follow any instruction. u should have a password on ur sa account and a new account that is being used in the web.

so unless they magically found a way to see ur username/password. i dont see how they can gain access the database.

i need to finish this.

[Josh]

How about an extreme noob edition. From like downloading it, configuring it to ur pc number etc?=P

[thejaguar1]

This is great. Thanks john_d. Your really one of the best.
Btw, i'm noobz to this. Can you give me a more detailed tuturial or let's say an "step by step tutorial". I'm so much eager to have a web site for my server.

God Bless and More Power!

[nico1993mu]

You Can Host Your Page In A Private Server(you Have To Pay)and No More Hakers That Pages Are 100% Anti Hakers And Only Cost 5 Us

[stuk]

when u going to continue the guide?
like explaining how to do every step...

[zell_11]

yeah please do man as i still don't get how to do this 100%

[Josh]

lol <>_<>

What was the point of this?
And yes, when are you going to finish the guide, john_d?

[darranthegreat]

jd..can u post a super noob version of this?

[djinan]

thnx for the guide john_d...
appreciate it..

im pinoy too..
im using your mutoolz, and in a remote webserver too.. =D

anyway.. thanx a lot..

[darko6]

gonna finish this guide anytime soon? X_X

[Oculus]

I had the same problem with my muserver, but i found an better solution like opening ports from odbc or the mysql server. I made a php script which executes the query and return the answer. So the Server had only to work on one script addional, so its not much work to do. So only the Http port is free and so nobody can connect directly to the MSSQL server.

If any interesst I can release the script and make a guide how to use.

PS: Sry for my english I am from germany

[an2ny_18]

how about Conputer A = Windows Computer B = Linux?