Problem setting up new server

[Garu]

Havnt set up a server in a few months and last one was on sql 2000. After reading through some guides i got the sql 2005 one set up and database seems fine but when loading m2server up i get this.

[07/07/2009 00:58:08] Guilds: 1
[07/07/2009 00:58:08] Total Castles: 1
[07/07/2009 00:58:08] Windows socket error: The requested address is not valid in its context (10049), on API 'bind'
[07/07/2009 00:58:09] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 00:58:09] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 00:58:09] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 00:58:09] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 00:58:09] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 00:58:09] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 00:58:13] Windows socket error: The requested address is not valid in its context (10049), on API 'bind'


Any ideas please?

 

[noisound]

im sure thats an ip error not something to do with SQL

 

[Garu]

Thanks i was missing a ip in setup, thought i had changed it lol. But i am now getting connection closes when trying to run mir2. Everything is saying it is connected etc but i get connection closed when logging in. m2server looks like this.

[07/07/2009 07:42:35] Guilds: 1
[07/07/2009 07:42:35] Total Castles: 1
[07/07/2009 07:42:36] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 07:42:36] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 07:42:36] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 07:42:36] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 07:42:36] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 07:42:36] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 07:42:55] INFO: Item database has been reloaded...
[07/07/2009 07:43:03] Gate[0](127.0.0.1:49603) Opened...
[07/07/2009 07:43:10] DBServer Connected(127.0.0.1:6000)
[07/07/2009 07:43:33] -- SQL KeepAlive
[07/07/2009 07:43:35] LoginServer Connected(127.0.0.1:5600)

 

[akacary2]

Have a check through the attachment in this thread and make sure all of ur ip's are correct as it sounds like 1 is wrong and not allowing it to connect (think its logingate but not totally sure)

http://soren.co.uk/~lomcn/forum/showthread.php?t=61866

 

[Garu]

I have checked all the ips and i am still getting connection closed. I checked your link thank you mate, i downloaded the document and made sure its all the same and they were. My M2SERVER looks like this.

[07/07/2009 15:32:39] Guilds: 1
[07/07/2009 15:32:39] Total Castles: 1
[07/07/2009 15:32:39] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 15:32:39] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 15:32:39] Script file not found: .\Envir\Market_Def\1AME-GA2.txt
[07/07/2009 15:32:39] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 15:32:39] Script file not found: .\Envir\Market_Def\1BME-GA1.txt
[07/07/2009 15:32:39] Script file not found: .\Envir\Market_Def\1BME-GA1.txt

And after connecting everything else i just get conn closed.

Hope someone can help.

 

[Garu]

Here is a link of my desktop with everything open. I have corrected the npc error message but still getting Conn closed. Not sure if its because the mir2.ini in the game folder i am using is different than the guide i have could someone post me what this ini should look like please? Screeny below.

 

[akacary2]

Check ur Sql info in !Setup.ini, make sure that is the same as the info u entered into SQL:

[SQL]
UseSQL=TRUE
SQLHost=******-PC\SQLEXPRESS
SQLUsername=sa
SQLPassword=sa
SQLDatabase=mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=mir2

 

[Garu]

Just checked it and mines the same as that. Which is the same info for my sql.

 

[IceMan]

u useing windows xp?

also look in the ini for db server.exe and sql info is rite

 

[Garu]

Checked both of them aswell and seems to match.

I am running vista

 

[Garu]

After looking around on these forums i tried changing a few things and now get no errors except for connection closed.

I have changed the mir.ini to mir.ini and it looks like this.

[setup]
patched=0
Param1=127.0.0.1
Param2=
Param3=
Param4=
Param5=
[Option]
SkillSetting=0
Sound=1
ShowAllItem=0
EffectSetting=1
ShowSkillBar=0

i have added server.ini which looks like this.

[Server1]
ServerName=Diamond
ServerAddr=127.0.0.1
ServerPort=7000
SelectServerAddr=127.0.0.1
SelectServerPort=7100
GameServerAddr=127.0.0.1
GameServerPort=7200

and i deleted the ftp.ini etc that was in the folder.

Any ideas? As i am still getting conn closed.


EDIT- Just read on a few posts that this is different if your running off a router? do i need to do something different than setting the ips to the offline ip 127(etc) if i am just using it offline?

 

[Gezza]

are you trying to run these offline or online so others can connect? if you want it working offline it dont matter if you on router or not.

 

[Garu]

Yeah wanting to run it offline. Dont get why its not working.

 

[Garu]

Any ideas please. I cant see what the problem would be?

 

[noisound]

are u keeping SQL open when u run the server? lol either keep it open on desktop or the icon that appears in the right bottom icon bar

 

[Grinch]

Ur server look to work just fine, the problem is in the .ini file near to exe in ur client . U must 2 setup this ini with ip 127.0.0.1, and dont make changes with [setup] because exe read this header....