2.3 server setup guide

[koni]

i did not make this guide or the files, so full credit to the maker of the guide.


Step 1: Getting the Server Files

visit this thread and download the files:TD'S FILES ALL IN ONE - Legend of Mir 2.3 Server Files. (fully updated by jasper and elvin) full credit to them for the release

Step 2: Setting Up Your Server

Extract your files to C:/mirserver folder. This is the place where the server is set to run. This can be edited later on by hexing the server files but do this for now.

Now then go to your Legend of Mir Game Folder > Maps and copy all the maps to your C:/mirserver/m2server/maps folder. This way the map info is directly taken from the client and need not be download along with the server itself. And this will also reduce client incompatibility problems.

Now setting up the IP's of your server. You need to set them to 127.0.0.1 (Local) if you want it to work offline or 192.168.XXX.XXX (WAN or LAN IP) to either run it on LAN or over the net. The correct server name would be Diamond.

Go to C:/mirserver/DBServer/addrtable.txt and set all your IP's to the required one.
Do the same in the following files too.

C:/mirserver/DBServer/serverinfo.txt
C:/mirserver/DBServer/dbsrc.ini
C:/mirserver/LoginGate/config.ini
C:/mirserver/LoginSrv/addrtable.txt
C:/mirserver/LoginSrv/serveraddr.txt
C:/mirserver/LoginSrv/UserLimit.txt
C:/mirserver/LoginSrv/Logsrv.ini
C:/mirserver/LogServer/LogData.ini
C:/mirserver/M2Server/runaddr.txt
C:/mirserver/M2Server/servertable.txt
C:/mirserver/M2Server/Setup.txt
C:/mirserver/RunGate/Config.ini
C:/mirserver/SelGate/Config.ini

Congratulations for setting up your server!

Step 3: Setting Up SQL Server 2000

DOWNLOAD SQL SERVER 2000 HERE - You can download SQL Server 2000 Evaluation Edition from here.
SQL 2000 MIRROR DOWNLOAD or from this link provided by koni

Once downloaded, install SQL Server 2000 by setting the system to "local" and the authentication mode to "mixed" and set a "sa" password.

After the installation, start Service Manager and let it run.

Congratulations! You have installed SQL Server 2000.

Step 4: Restoring the Databases

Now go to Enterprise Manager>Local>Databases
Here you will find that there are already a few default databases. Right click and create a new database called "mir2"

Then right click on this new database and go to All Tasks>Restore Database
Here select the option of "From Device" and then select the location of the database which in this case is /DBServer/lom2restorethis In this case the DB provided is already in the *.bak format and hence need not be force restored. If it aint, then go to the second tab and tick the option - force restore and then click OK.

Congratulations! You have successfully restored your databases.

Extra Note: To add yourself as a GM, go to the mir2 database and look for the table called "admin" and return all rows on it and then enter your ID and other details there. That particular ID will from now be the GM ID. Account must be created in the account table.

Step 5: Configuring Your Server Part 2

Go to the folder /DBServer/dbsrc.ini and edit the following.

SQLType = mssql
SQLHost = localhost
SQLPort = 3306
SQLDatabase = mir2
SQLUsername = sa
SQLPassword = (Enter the password you entered while setting up SQL Server 2000).

Then Go to the folder /M2Server/Setup.txt and edit the following.

UseSQL = True
SQLHost = 127.0.0.1 (which is nothing but your localhost)
SQLUsername = sa
SQLPassword = (Enter the password you entered while setting up SQL Server 2000)
SQLDatabase = mir2
SQLType = mssql (if you are working with MySQL2005 change this to mysql)

Congratulations! You have successfully configured your server.

Step 6: Running the Server

Run them in the following order.

1. m2server/m2server.exe
2. gamegate/gamegate.exe
3. DBServer/dbserver.exe
4. logingate/logingate.exe
5. loginsrv/loginsrv.exe
6. logserver/LogDataServer.exe
7. Selgate/Selgate.exe

Note: It would be advisable to run DBServer.exe before all the other servers though.

Congratulations! Your Server Is up and running.

Step 7: Setting Up The Client

Go to the server folder /m2server and copy and paste the mir2.exe in your game folder. Then go to the game folder and open mir.ini and save all the IP's (3 of them) to either your local IP 127.0.0.1 or your LAN or WAN IP which ever you entered in your server files and save this file as mir2.ini

Create an account as mentioned earlier and then run mir2.exe.

Congratulations! You are in the game. Have fun now.

 

[Mezoko]

Ooo i've got 1 step further with SQL2000. It loads everything correctly in the M2server, however the DBserver still spams
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected

Thus, the M2server spams:
[23/12/2008 13:27:51] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:27:54] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:27:57] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:00] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:03] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:06] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:09] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:12] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:15] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:18] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:21] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:24] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:27] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:30] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:33] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:36] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:39] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:42] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:45] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:48] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:51] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:54] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:28:57] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:00] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:03] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:06] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:09] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:12] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:16] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:19] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:22] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:25] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:28] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:31] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:34] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:37] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:40] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:43] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:46] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:49] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:52] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:55] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:29:58] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:30:01] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:30:04] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:30:07] DBServer Connected(127.0.0.1:6000)
[23/12/2008 13:30:10] DBServer Connected(127.0.0.1:6000)

Etc. Then randomly the M2server writes:
[23/12/2008 13:16:05] -- --> Error Keeping charQuery Alive!
[23/12/2008 13:16:05] -- --> Error Keeping charQueryCommand Alive!

Any ideas on this?

 

[Dazz]

Check your dbsrc.ini for Ips and the SQL Pass/ID

/Daz

 

[Mezoko]

Here is my ini file for the db server:

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=127.0.0.1
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=mirserver
[Setup]
ServerName=Diamond
ServerAddr=127.0.0.1
ServerPor=6000
MapFile=C:\mirserver\Mir200\Envir\MapInfo.txt
ViewHackMsg=1
GateAddr=127.0.0.1
GatePort=5100
DynamicIPMode=0
BackupClearData=0
ShowItemName=1
DBName=HeroDB
[Server]
IDSAddr=127.0.0.1
IDSPort=5600
[DBClear]
Interval=1000
Level1=1
Level2=7
Level3=14
Day1=7
Day2=62
Day3=124
Month1=0
Month2=0
Month3=0
[DB]
Dir=C:\mirserver\DBServer\FDB\
IdDir=C:\mirserver\DBServer\FDB\
HumDir=C:\mirserver\DBServer\FDB\
FeeDir=C:\mirserver\DBServer\FDB\
BackupDir=C:\mirserver\DBServer\Backup\
ConnectDir=C:\mirserver\DBServer\Connection\
LogDir=C:\mirserver\DBServer\Log\
[Backup]
AutoBackup=1
BackupTime=18000000

Edit:
Now it doesn't display the "[23/12/2008 13:16:05] -- --> Error Keeping charQuery Alive!",
But still spams the DBserver connecting and disconnecting every 3 seconds(I don't know why it's every 3 seconds, but..)
I can create an account, i can log in to my account, but i cannot create characters.

Edit2:
Also, the DBserver only says

TFrmDBSrv.starttimer

And is 'Not Ready !!'

Everything else is working fine, but i am stumped now.

 

[Dazz]

When you set up did you set your password to "sa"?

Did you follow the guide and set that password?

/Daz

 

[Mezoko]

Username is 'sa', password is mirserver, as it says above 0_0

 

[Dazz]

SOunds like an ip Error somewhere in your Dbserver

 

[Mezoko]

!Addrtable:
127.0.0.1
127.0.0.1

!serverinfo:
127.0.0.1 127.0.0.1 7200

 

[Dazz]

I can't think mate, just that it either isn't reading the SQL or you've got a wrong IP. Double check your ips and SQL details - u sure you entered the password mirserver not sa when setting SQL up?

Are you on vista or XP?

/Daz

 

[Mezoko]

I was on Vista then, but i got annoyed and installed XP instead :P
Gonna hopefully get it working now.

 

[Dazz]

Lol well played - Vista tends to need MSSQL 2005 or something MYSQL2005.

XP Alot easier, try that again and I can guarentee it will be fine You may get a few errors probably just missed IPs.

/Daz

 

[Mezoko]

I'm gonna have a little play around with a 1.9 first, if this doesn't work then i know i'm just dodgy when it comes to changing ips :P

 

[Dazz]

Ok mate up to you, I found 2.3 easier to set up

/Daz

 

[Mezoko]

Really?
I think DB Commander is Pro :P
It's much easier to use, and is much easier to configure than SQL.

 

[Dazz]

Yeh, I got literally LOST with 1.9 - I was a noob irl when trying it though could probably set it up now, but overall prefare setting up a 2.3 can do it in minutes

/Daz

 

[Mezoko]

For me, it's either the other way round to what you're saying, or i just can't set any up :P

I tried a year or two ago and failed, but now i think i can get a server online

Edit: Right now i'm inspecting my 1.9 and it's looking good, but i am currently downloading the 1.9 client so i wont know if it works until then.

 

[mStation]

sorry.. i am late but i just wanted to say that i got my server running under vista.. going to post a tutorial together with my idiot proof for xp for tonight..

image

 

[Dazz]

nice one will read when u type it up - cant get it working on Vista I love XP :P

probs could if i tried using 2005, cba to try only tried with 2000

/Daz

 

[mStation]

here is the Vista Guide for all of you peeps!!!

2.3 Server Guide - Idiot Proof 4 VISTA

 

[Mezoko]

Lol i installed XP before you made that guide :P

I got the server working (i think, doesn't say any errors), but when i try to use an exe in the TD files, about 100+ error messages pop up simultaneously and it doesn't run -,-

 

[mStation]

which exe is it? the mir2.exe?

is your problem this?

here is another person with your problem i guess

anyhow this is a sound driver problem.. this means that the computer u are using is without the sound drivers installed.. u need to install them in order to play mir.. to install them u need to know your motherboard brand and model.. this details can be read usually on the motherboard so u need to open the cabinet of your pc (unless u know what motherboard you have or unless you are using a notebook).. if u are using a notebook just go on the official website of the brand of the notebook in the support area and download the sound drivers of your model.. if you know the motherboard do the same if you dont know nothing open the cabinet and look on the motherboard.. usually between the pci sockets there is the brand and model written like in this image:

here u can see near the ram it says ASUS which is the brand
and near the pci ex socket (blu one) it says P5KR which is the model