Any Idea?

[nup72]

This is all i seem to get whn i run server

[Win32 Error] the System cannot Find the file specified
DB server finalized

Ta for any hlp

 

[knad]

Ahh i had that...

u need to put your maps folder in the 'envir' folder and link it to there

 

[nup72]

knad Ahh i had that...

u need to put your maps folder in the 'envir' folder and link it to there


not sure wat u mean m8

 

[knad]

copy the 'maps' foler from ur client and paste it into 'envir'

then on DBserver.exe Config, link the ap location to there

 

[zion]

for example it should look something like this:

c:\mud3\envir

well that's what mine is.

Important that you DO NOT add the trailing \

 

[nup72]

bah dont no wat to do now tbh

 

[Ripman]

goto options, configuration:

Name ktest

Game DB DSN mir3db Account DB mir3db
ID sa sa

Login Server Address 127.0.0.1
Port 5600

Game Server Binding Port 6000

Run Gate Binding Port 5100

Map File Patch C:\mud3\mir300\Envir

THIS IS IN DBSvr !!!

Maps must be in Envir Folder!!!

 

[zion]

on the dbserver exe, click on option then on configuration, at the bottom of it, it should have a little bit to do with the map directory, in there you put the location of your map folder, e.g. if your map folder is in your server files' envir folder in the box for the path you must put something like C:\mir3server\mud3\mir300\envir without a \ after the envir.

 

[nup72]

still doesnt work ><

 

[zion]

what's in your !setup.txt for your map dir?

 

[nup72]

okie whn i did it ur way i got a error map etc not found

whn its like this it loads but no 1 can connect

[Share]
BaseDir=C:\Mud3\Mir300\Share\
GuildDir=C:\Mud3\Mir300\GuildBase\Guilds\
GuildFile=C:\Mud3\Mir300\GuildBase\Guildlist.txt
VentureDir=C:\Mud3\Mir300\ShareV\
ConLogDir=C:\Mud3\Share\ConLog\
CastleDir=C:\Mud3\Mir300\Envir\Castle\
EnvirDir=C:\Mud3\Mir300\Envir\
MapDir=C:\Mud3\map\

Ta for any Hlp

 

[zion]

this bit should go into the dbserver map path bit for your server: C:\Mud3

make sure all i.p's are correct and so are all the ports and server names.

 

[nup72]

okie did tht and.. i still get

[Win32 Error] the System cannot Find the file specified
DB server finalized

and this

Read Emergency Map : [0] 459,261
Not Ready.82.38.2.151
no guild file loaded...

 

[zion]

not had a no guild file loaded prob b4, what does it say b4 read emergency map?

i've got no idea whats up with your dbserver. try running your server offline first with all the i.p.s as 127.0.0.1

edit: have you also put in your sql username and password in the places you need to?

 

[nup72]

yup and whn i try run offline i get same prob

any 1 no wat im doing wrong plz

 

[nup72]

well wats this all about :S

[Win32 Error] the System cannot Find the file specified
DB server finalized

 

[nup72]

Fixed this error can Mod Lock it ?

 

[Stonehelm]

For Future referrence:
You do not need to copy ur maps into the envir folder at all it only need to point to ur map folder because that is where ur mapinfo.txt is and nothing will work if it cannot locate that.

If you followed kaorii's guide then ur directory will be hardriveletter:\mir3server\Mud3\Mir300\Envir

 

[Tkonian]

Right my name is Tkonian and I'm working with nup72 on this. I can't be around much and he's never done MIR3 before. So please be patient with him.

Right the [Win32 Error] has been solved. For some reason MAP folder HAD to be in the Envir folder.

I had put MAP at C:\Mud3\Map - and nothing I did worked. Then upon the advice of Ripman and Zion I moved the MAP folder to the Envir. And hey presto, no more problem. Weird I granted you, but it worked.

Only problem now - I can't make Characters. I've used the AccountMaker, and I can log-on. It says I have to make a Character first, all normal, but everytime I enter a name MIR3 just says "????? ???????? ????" or s load of questions marks similar to that. And now all I get is this is DB Server when trying to make a char.


22:37:11 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHARACTER'.
22:37:24 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHANGECHR'.
22:37:24 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHARACTER'.
22:37:33 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHANGECHR'.


Please can someone help. I'm new to SQL, and don't really know what this means.

Thank You.

Tkonian

 

[Ripman]

Ok here is a complete guide (not written by me)

\\Written By Kaoii//

Minimum System Specs for an EI Server:
Windows 2000/XP/NT/2000/Server 2003
500+ MB of RAM
DSL+ Connection

Recommended System Specs for an EI Server:
Windows XP
800MB-1GB of RAM
Cable-T1 Connection


Setting up an EI server is pretty easy if you
know what your doing. A lot of people, however,
don't know what they are doing. Thats why
I wrote this guide!

A- Getting the Server Files
B- Setting Up The Server Files
C- Setting Up The SQL Server
D- Setting Up Your ODBC Database
E- Adding/Editing Items, Monsters, and Magic
F- Running The Server
G- iamdeath's Router Tutorial
H- The Fun Stuffs
I- Boring Stuffs

////////////////////////////////////
A: Getting the Server Files
////////////////////////////////////

The MSRF 2.9b EI server files can be found on my
site here:

http://www.flaresoft.net/MSRF2.9b.exe

This link will _ALWAYS_ work and is _NEVER_
down.

Extract your server files into a directory
called C:\mir3server\

////////////////////////////////////
B: Setting Up The Server Files
////////////////////////////////////

The first step in setting up your server files
is that once they are extracted, we have to
make sure all the text documents and ini files
and pointing to where we want them to point.

Go to C:\mir3server\mud3\LogDataSrv\

------------------------------------------------
Once your in that folder find your LogData.ini
file.

Make it look like this:

[setup]
basedir=C:\mir3server\Mud3\LogDataSrv\Logbase\
------------------------------------------------

Now go to C:\mir3server\mud3\Logsrv\

------------------------------------------------
Once your in that folder find your Logsrv.ini
file.

Make it look like this:

[server]
DBServer=127.0.0.1
DBSPort=16300
FeePort=16301
LogPort=16302
ReadyServers=0
EnableMakingID=TRUE
EnableTrial=FALSE

CountLogDir=C:\mir3server\mud3\Logsrv\CountLog
WebLogDir=C:\mir3server\mud3\Share\GameWFolder\
FeedIDList=C:\mir3server\mud3\Share\Feed\FeedIDList.txt
FeedIPList=C:\mir3server\mud3\Share\Feed\FeedIPList.txt
[DB]
IdDir='.\IDDB\'

--------------------------------------------------

Now go to C:\mir3server\mud3\Mir300\

--------------------------------------------------
Once your in that folder find your !setup.txt
file.

Make it look like this:

[Server]
ServerIndex=0
ServerName=ktest
ServerNumber=0
VentureServer=FALSE
TestServer=TRUE
TestLevel=0
TestGold=0
TestServerUserLimit=500
ServiceMode=FALSE
NonPKServer=FALSE

DBAddr=127.0.0.1
DBPort=6000
IDSAddr=127.0.0.1
IDSPort=5600
MsgSrvAddr=127.0.0.1
MsgSrvPort=4900

HumLimit=30
MonLimit=30
ZenLimit=30
NpcLimit=5
SocLimit=30
DecLimit=10
UserFull=500
ZenFastStep=300
SendBlock=1000
CheckBlock=8000
AvailableBlock=250
GateLoad=0
LogServerAddr=127.0.0.1
LogServerPort=10000
ViewHackMessage=FALSE
ViewAdmissionFailure=FALSE
CommonDBLoc=
CommonDBID=sa
CommonDBPassword=sapass
CommonDBDSN=mir3db

[Share]
BaseDir=C:\mir3server\mud3\Mir300\Share\
GuildDir=C:\mir3server\mud3\Mir300\GuildBase\Guilds\
GuildFile=C:\mir3server\mud3\Mir300\GuildBase\Guildlist.txt
VentureDir=C:\mir3server\mud3\Mir300\ShareV\
ConLogDir=C:\mir3server\mud3\Share\ConLog\
CastleDir=C:\mir3server\mud3\Mir300\Envir\Castle\
EnvirDir=C:\mir3server\mud3\Mir300\Envir\
MapDir=C:\Directory where your maps are\

[Setup]
ItemNumber=12460214
ClientFile1=Mir4.dat
ClientFile2=
ClientFile3=

HomeMap0=01
HomeX0=459
HomeY0=261
HomeMap1=02
HomeX1=265
HomeY1=207
HomeMap2=1
HomeX2=400
HomeY2=121
EmergencyMap=0
EmergencyX=200
EmergencyY=200

[Names]
ClothsMan='BaseDress(M)'
ClothsWoman='BaseDress(F)'
WoodenSword='WoodenSword'
Candle='Candle'
BasicDrug='(HP)DrugSmall'

GoldStone='GoldOre'
SilverStone='SilverOre'
SteelStone='IronOre'
CopperStone='CopperOre'
BlackStone='BlackIronOre'

Zuma1='ZumaGaurdian'
Zuma2='ZumaStatue'
Zuma3='ZumaArcher'
Zuma4='WedgeMoth'

Bee='BugBat'
Spider='Larva'

WomaHorn='WoomaHorn'
ZumaPiece='ZumaRelic'

;Replace the Mapdir with the directory where your
;maps are.

/////////////////////////////////////////////////
C: Setting Up The SQL Server
/////////////////////////////////////////////////

Firstly, if you havn't already, you need to
download the Microsoft SQL Server Trial Edition.
If you have the real version, hey thats cool.

I dunno if this link still works but it did for
me:

http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe

If it doesnt work you can find it on Microsoft.com

To set up the SQL Server, first extract the exe file
to some directory. Go into that directory and run
setup.bat

This batch file opens the Microsoft SQL Server 2000
InstallShield program.

Window One:
Select Local Computer
<Click Next>

Window Two:
Name: Bob (or whatever your name is)
Company: ServerName (or whatever)
<Click Next>

Window Three:
Terms of agreement that no one really cares about..
<Click Yes>

Window Four:
( ) Client Tools
(*) Server and Client Tools (bubbled in)
( ) Connectivity Only
<Click Next>

Some users might get another window.. it might be
just me though because im going through a reinstall
procedure.

Window Five:
I recommend a typical install because thats what ill
be going through.
<Click Next>

Window Six:
(*) Use the same account for each service (bubbled in)
( ) Customize the settings for each service
_Service Settings_
(*) Use the Local System account (bubbled in)
( ) Use a Domain User account
<Click Next>

Window Seven:
( ) Windows Authentication Mode
(*) Mixed Mode (Windows Authentication and SQL Server Authentication) [bubbled in]

Add Password for the sa login:
Enter password: <sapassword>
Confirm password: <sapassword>
<Click Next>

Window Eight:
Click Next

/////////////////////////////////////////////////
D: Setting Up The ODBC Database
/////////////////////////////////////////////////

Go to your control panel first. Next, click
Administrative Tools. Now click on
Data Sources (ODBC).

Now click Add. Now scroll down and click on
SQL Server. Then click finish.

Now enter this:
Name: mir3db
Description: whatever goes here
Server: (local)

Now on the next page, click the second bubble
on the top. Now enter:
Login ID: sa
Password: ur password

Now at the top of the next page, put a checkmark
by "Change the default database to:" and put it
on mir3db

On the next page leave everything as it is and
click Finish. Then click OK.

/////////////////////////////////////////////////
E: Running the Server
/////////////////////////////////////////////////

To run the server, simply use the ServerControl
program (if your not on a router), make sure
all of the directories are right, and click
start.

Once your server is running open the DBServer.exe
window and click the Blue run button.

Be sure everything on your DB configuration is
right too if you already havnt.

/////////////////////////////////////////////////
G: iamdeath's Router Tutorial
/////////////////////////////////////////////////

I did not write this. All credit goes to iamdeath.

******DO NOT RUN THE SERVER WITH THE CONTROL PROG******
If you put a new server name in mud2\logsrv\!addrtable.txt and mir200\!setup.txt in mud2\DBSrv200\dbsrc.ini you now have your own server name and not ktest

/////////////////////////////////////////////////
H: The Fun Stuffs
/////////////////////////////////////////////////

- In your Mir300/Envir folder there is
AdminList.txt where you can change all the GMs
on your server.

- TheApprentice's tool works on EI Market NPCs

/////////////////////////////////////////////////
I: Boring Stuffs
/////////////////////////////////////////////////

Guide written by Kaoii from RageZone and CriticalServ

Contact:
E-Mail = [email protected]

Credits:
- Me, Kaoii, for writing this faq
- iamdeath for the router tutorial
- some other misc peeps who helped me get this
good at this stuff.
--------------------------------------------------------------

22:37:11 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHARACTER'.
22:37:24 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHANGECHR'.
22:37:24 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHARACTER'.
22:37:33 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_CHANGECHR'.


If you have this mir3db2.9.mdb then do like is writed bellow.

1. Goto the ClientSetup file and follow instructions (complete version)
2. Start > All Programs > Microsoft SQL Server > Enterprise Manager
3. Console Root > Microsoft SQL Servers > SQL Server Group > You P.C.
4. Right Click Databases > New Database
5. Name = mir3db > Click OK
6. Right Click mir3db > All Tasks > Import Data
7. Click Next > Data Source = Microsoft Access
File Name = C:\Mud3\mir3db2.9.mdb
8. Click Next > Data should be entered, Click Next
9. Click Next (Top option should be selected)
10. Click Select All > Click Next
11. Click Next > Click Finnish > Click OK > Click Done
12. Exit SQL Server Enterprise Manager

If you have a sql database backup do this:

delete ur old mir3db data base and make a new one .. then right click on it --> all taskes -> and restore database. Then u go at --> from device -->Select Devices -> Add... (here u select your data base) then ok .. ok @ restore database menu you go on Options and check on "Force Restore over existing database" --> ok ... now this should restore ur databse ... try now to see if all works ..

here is the msfr mdb data base file that worked for me: