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.

 

[Supremesis]

Im trying to create an account but nothing is popping up when i have entered details etc like a pane which says "your account is now created...." so any help here?

 

[OldDirty]

iv never taken so much time on 1 thing in my whole life. iv been doing this for nrly 2days lol, iv d/l all the sqls - im d/l last 1 2005 sp2, x84 because it says its the only 1 compatible with my comp. windows vista 2008 premium...takes piss - is it same setup as the 2000 sql????

 

[mStation]

Hello,

i wanted to set up a 2.3 server using this guide but i'm getting some errors.. ovviously im not soo noob so i hope just to have the correct attention..

i read that the "mir2(restorethis)" was made of ms sql 2005 and not the mssql2000 which im using but i tried anyway to restore it and i got this error:



so i thought to go with the backup "mir2sql2000backup" which was supposed to work and i get this error instead:



as far as i can say, with the first file u cant even change the tab that the errors pops up and as u can see from the screenshot it doesnt see lom2_chardb_Data nor lom2_chardb_Log which instead are seen using the "mir2sql2000backup".. but anyway even after forcing the backup to be added it gives that error.. i also tried not to force it but i get the same error.. whats wrong?

ovviously the sql service is running correctly or i wont be able to add the mir2 database.. and as far as i can see i didnt get nothing wrong..

if i did please say where else give me some suggestions please..

also maybe another database to restore would be nice..

thanks!
mStation

 

[mStation]

Problem solved.. if anyone has this problem u can solve it doing this:

my pc has and italian windows xp and program files doesnt exist but programmi does.. the error occured because in the Option Tab of Restore Database it tried to memorize lom2_chardb_Data and lom2_chardb_Log in
C:\Program Files\Microsoft SQL Server\MSSQL\data\lom2_chardb_Data.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\data\lom2_chardb_Log.LDF

so u simply need to change the location to have it fixed..

 

[mStation]

Quick fix to the guide.. where it says:

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)

U must also set:
SQLCharDatabase=mir2

might fix your problems with creating chars and login in..

thanks for the server files.. they work perfectly..also fix the mapquest.txt error the m2server.exe gave..

 

[Meltus]

gettin this weird error in M2Server.exe

Loaded client version information and server table...
Loading StdItem.DB...
[29/09/2008 23:42:07] StartTimer exception: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

reinstalled SQL a few times, followed everything to the word (i think) no idea whats wrong.
had a mir server up and running before, but i have no idea why this isn't working.

if anyone could shed some light on this, it would be very helpful ^^

 

[james19]

um have u made sure passwords are all correct and u got sql running in icon tray

 

[mStation]

hi there.. try following this guide so u can also see the videos on how to do it.. u can't make errors here: Server Guide

 

[TravisW]

gettin this weird error in M2Server.exe

Loaded client version information and server table...
Loading StdItem.DB...
[29/09/2008 23:42:07] StartTimer exception: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

reinstalled SQL a few times, followed everything to the word (i think) no idea whats wrong.
had a mir server up and running before, but i have no idea why this isn't working.

if anyone could shed some light on this, it would be very helpful ^^

Service manager is not running/wrong passwords in !dsbrc and !setup texts.

 

[Meltus]

Service manager is not running/wrong passwords in !dsbrc and !setup texts.

/edit
nvm got it working.
dodgy version of SQL it seems.
thanks for your help

 

[Painkiller]

lo all got abit of a prob i got it all set up and everything made an account ect wen i try make a char i enter char name press OK but nothing happens any ideas? ty

/Brandon

am not pwnage btw lol we shareing this account coz i can't make 1 of my own for sum reason

 

[Mezoko]

Says the following in my M2server when I run it;

Loaded client version information and server table...
Loading StdItem.DB...
[22/12/2008 21:38:16] StartTimer exception: Unspecified error
[22/12/2008 21:39:16] -- --> Error Keeping Query Alive!
[22/12/2008 21:39:53] -- --> Error Keeping QueryCommand Alive!
[22/12/2008 21:40:26] -- --> Error Keeping charQuery Alive!
[22/12/2008 21:41:03] -- --> Error Keeping charQueryCommand Alive!

And in my DBserver, all it says is:

Gate connected
Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected

etc...

Can anyone help me out on this?

 

[mStation]

use this server files on this guide and re-follow it from the start.. i bet it will work okay:

http://www.lomcn.co.uk/forum/showthread.php?t=57431&highlight=idiot

 

[Mezoko]

Ok i'll go do it now
Thanks for the quick reply.

Edit: Just looked at the heading of the guide; it only works for XP
I'm using Vista =\

 

[mStation]

ill try to get some free hours this afternoon to install vista so that i can help all vista users out..

 

[Mezoko]

That would be great.
I think i just fail when it comes to setting up SQL, although this time i'm 99% certain that i set it up correctly.

 

[Dazz]

If your on Vista you tend to need -

- Microsoft SQL 2005 Edition - something like this.

- And something else can't remember what.

/Daz

 

[Mezoko]

Yeah i was using MSSQL2005, but then after giving up on that managed to make SQL2000 work on my pc, but the exact same errors occured.

 

[mStation]

i just installed vista now.. i'm going out in a moment so the guide will be done later but after i download the sql2005 and the drivers i will start working on it!

 

[Dazz]

Nice one mate, a thanks from me - will be a big help to them users on Vista, including myself when im on Laptop :P

/Daz