MuOnline Server Setup Guide

Requirements:
  • A computer with SQL Server 2000 installed
  • IIS installed(if you want to have a web interface for creating new users)
  • A computer for the actual MuOnline Server with OS installed
  • MuOnline Server files ofcource
  • WinRar or WinAce or Total Commander (for unzipping files)
The better OS for this job is Windows 2000 Server, because:
  • you can install there the SQL Server 2000
  • you can install there the MuOnline Server
  • you can install IIS there too
The disadvantage is that you need more memory.
I installed Windows 2000 Server into a computer with the following specs:
  • 1Gb Physical memory
  • 1,6GHz CPU Speed
  • 40Gb Hard Disk Space
The Start:

Ofcourse you can install SQL Server, MuOnline Server and IIS in different machines, but i dont recommend that because you use 3 computers when you can use 1 (if you have 3 computers then make 3 servers :).
For now on i will analyze the method i installed MuOnline Server into 1 computer.
MuOnline Server need to be installed into a D: drive, this can be a second partition, a second hard disk or a directory that points into a D: drive (this can be done if you use the SUBST command - type SUBST /? into a Command Prompt for help).

I used a second partition, anyway unzip the server files into D: drive. After unzip finish you will have something like this:

The above picture show us the directory structure after unzipping the server files.
How to Setup SQL Server:

Now it is time to setup SQL Server. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager) and browse to Databases:

Press the right mouse button and create a new database:

Name the database muonline and press OK:

It is time to restore the database files, right click on muonline database then browse to Restore Database...:

When the Restore Database dialog appear click on From Device radiobox and then click on Select Devices button:

Then from Choose Restore Devices dialog press the Add... button:

and then choose the destination of the Database Files to Restore into muonline database:

Press OK 3 times to continue. You will have something like the below image, then press the Options tab:

Make sure the Force restore over existing database checkbox is checked and the database files point below D:\MuServer\DB\ directory:

Press OK to import the tables into muonline database, if you will see this message:

everything went ok.
Create another database, name it ranking and restore the tables from Ranking database files, make sure the database files point below D:\MuServer\DB\ directory. Do the same for the exdb database (remember that database files must point below D:\MuServer\DB\ directory).
Now you have all three needed databases into SQL Server:
How to Add a User to SQL (IF YOU DONT WANT TO INSTALL IIS AND HAVE WEB REGISTRATION SKIP THIS) :
Add a user to SQL Server Logins. Click Security then right click on Logins and select New Login... option:

Follow the screens to add the user:

Find the User IUSR_MU (MU is my computer name, it will be something else to you - make sure IIS is installed to continue, else this user might not exist, the full name of the user is Internet Guest Account):

Then choose some options and click on Server Roles tab:

Choose here the below option and then click on Database Access tab:

Choose here also the below option and click ok:
How to Setup ODBC Links:
It is time to setup the ODBC logical links. Start Data Sources (ODBC) (Start -> Programs -> Administrative Tools -> Data Sources (ODBC)), browse to System DSN tab then click the Add... button:

Select the SQL Server driver (bottom) and click Finish. Choose MuOnline for Name and your SQL Server for Server, click Next two times:

Now change the default database to muonline and click Next then Finish and OK (you can also test the connection):

Create also 4 System DSN links named MuOnlineJoinDB, USELOG, Event and MuOnlineReg (MuOnlineReg will be used for web registration) that use muonline as the default database.
Create 1 System DSN named Ranking that use ranking as the default database and 1 System DSN named ExDB that use exdb as the default database.
You will have something like this, click OK to Exit ODBC Data Source Administrator:
How to Setup MuOnline Server:

Now the edit thing. First find out you ip address (you can use ipconfig /all in Command Prompt):

Mine is 192.10.10.199 , this ip is the MuOnline Server, SQL Server and IIS Server ip address. Write it down (not mine ip address ofcourse, yours!!!).
Change all the ip addresses (127.0.0.1) found in config files to the ip address you wrote down.
IP Addresses can be found in the following files:

  • D:\MuServer\CS\Connectserverlist.dat
  • D:\MuServer\CS\data\Connectserverlist.dat
  • D:\MuServer\CS\data\ServerList.dat
  • D:\MuServer\data\commonserver.cfg
  • D:\MuServer\data\IpList.dat

Then change the IP Addresses found as parameters to 5.lnk and 9.lnk files below D:\MuServer\Links folder (right click on them and select properties):

Then edit D:\MuServer\MU2003_EVENT_SERVER\DATA\svconfig.ini and change "mu2003_dsn = DEVILSQURE_RANKING" to "mu2003_dsn = Ranking" and edit also D:\MuServer\RankingServer\svconfig.ini changing "odbc_dsn=DEVILSQURE_RANKING" to "odbc_dsn=Ranking" .
How to Setup IIS:
Open Internet Services Manager. Browse to Default Web Site, right mouse button on it and choose New -> Site:

Click Next and choose a Description for the Site (whatever you like), click Next and choose the IP Address and the TCP Port to use (i choosed for IP Address 192.10.10.199 and port 8090, so if i want to connect to the site i type in ie http://192.10.10.199:8090 ), click Next and choose a path that will hold the MuOnline Web Registration files (i used D:\MuReg , after creating the folder :), click Next 2 times and Finish.
Right mouse button on your Site description (mine is mureg) and choose Properties, then browse to Documents tab, click the Add... button enter index.htm press OK and move it to the Top, then click OK to exit:
How to Setup Web Registration:
Unzip the Web Account registration files to D:\MuReg\ (or the directory you choosed) and edit conn.asp and change
connstr = "driver={sql server};server=192.168.0.2;uid=sa;pwd=pass;database=MuOnline"
to
connstr = "DSN=MuOnlineReg;"
then point to http://192.10.10.199:8090 and test the creation of accounts.
Other things:
The databases are not empy, there are some accounts and characters you should delete before starting the server. Ofcourse you can leave as is.
Starting MuOnline Server:
Browse to D:\MuServer\Links and double click 1.lnk, wait to load then double click 2.lnk, then 3.lnk and so on until 9.lnk (lnk is the extention for shorcut files).
Always wait each program to load before continue to next shorcut.
Start your client and connect to the server to test it.
Tips and Copyright:
  • Use your brain, if you dont have one then donate your organs.
  • No Idiot harmed in the process of making this guide.
  • Get memory, alot of memory you will need it. I have 30mb free physical memory dohh.
  • MuOnline is copyright of Webzen i think, anyway i dont really care.
  • My english might be bad, i know its my fault.

Copyright blurcode
Contact me at blurcoder(put_something_here)yahoo.com

have good luck and fun