[GUIDE] Setup a server without errors [1x GameServer]

[6_lucifer_6]

Originally Posted by _HouseMusicx3

ill show ya whats wrong marked in red last spoiler

so now my problem ...

when after pressing enter at log in screen nothing happens ..it always shows me "requesting user blablabla"

privileged ip is set !

incorectly... i have same issue... idk how to fix that..

[silk0104]

help me

Tell how to fix the Cert of SR_GameServer

[_HouseMusicx3]

Originally Posted by 6_lucifer_6

incorectly... i have same issue... idk how to fix that..

i fixed it this way :S

[6_lucifer_6]

Originally Posted by _HouseMusicx3

ill show ya whats wrong marked in red last spoiler

so now my problem ...

when after pressing enter at log in screen nothing happens ..it always shows me "requesting user blablabla"

privileged ip is set !

incorectly... i have same issue... idk how to fix that.

Originally Posted by zikor1337

Privilege your ip .

kay.. im using hamachi..

and my hamachi ip is 5.72.17.48

so i put it this way

(5) (72) (250) (84) (5) (72) (50) (84)
ip1 ip2 ip3 ip4 ip5 ip6 ip7 ip8

is that wrong? cuz i cant login as gm on my own pserver.. that shud be a joke

[Striker900]

There is 1 thing I dont understand, when I write "sa" in login what will I wrote in "password"? I dont remember such thing in install.

[6_lucifer_6]

Originally Posted by Striker900

There is 1 thing I dont understand, when I write "sa" in login what will I wrote in "password"? I dont remember such thing in install.

open sql

+Security
+Logins

double click sa and set ur pw

press of +

[omegalugia]

Fixed the ini file !THANK YOU! _HouseMusicx3
Shouldnt it be able to connect now though?

 Spoiler

Common {
debug_option_debugger_present{
DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
DEBUG_OPTION_ASSERT_CANCEL_EXIT
}
debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_debugger_present{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
Certification "192.168.1.8", 32000
LoginFailureTolerance 3
IBUVFailureTolerance 3
LoginFailureBlockTimeMin 0
IBUVFailureBlockTimeMin 0
AutomatedPunisher "AutomatedPunisher"
LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times"
LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times"
IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times"
IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times"
}

GatewayServer {
LastFullVersion_SR_Client 130
Certification "192.168.1.8", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

DownloadServer {
Certification "192.168.1.8", 15880
}
FarmManager {
Certification "192.168.1.8", 15880
}

AgentServer {
Certification "192.168.1.8", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "192.168.1.8", 15880
CERTIFICATION_IP_BIND "192.168.1.8"
}

SR_GameServer {
Certification "192.168.1.8", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor "250"
ShowFormulaDetail "1"

//WINTER_EVENT_2009 EVENT_ON
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM

//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
//RE FTW

DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "OFF"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"


}

SR_ShardManager {
Certification "192.168.1.8", 15882
BILLING_SERVER_URL "http://192.168.1.8:8080/"
CREST_FTP_URL "ftp://SRO_FTP:[email protected]/"
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1
//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0

BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
}

srglobalservice

 Spoiler

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=User\SQLEXPRESS;DSN=SRO_VT_ACCOUNT; UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

srnodetype

 Spoiler

[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.1.8
nip=192.168.1.8
machine_manager_node_id=699

srshard

 Spoiler

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SROLand
query=DRIVER={SQL Server};SERVER=User\SQLEXPRESS;DSN=SRO_VT_SHARD_IN IT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=User\SQLEXPRESS;DSN=Log_DB;UID=sa;P WD=123456;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

I'm gonna have to start handing out money for all this help ._.

[_HouseMusicx3]

Originally Posted by omegalugia

Fixed the ini file !THANK YOU! _HouseMusicx3
Shouldnt it be able to connect now though?

 Spoiler

Common {
debug_option_debugger_present{
DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
DEBUG_OPTION_ASSERT_CANCEL_EXIT
}
debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_debugger_present{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
Certification "192.168.1.8", 32000
LoginFailureTolerance 3
IBUVFailureTolerance 3
LoginFailureBlockTimeMin 0
IBUVFailureBlockTimeMin 0
AutomatedPunisher "AutomatedPunisher"
LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times"
LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times"
IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times"
IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times"
}

GatewayServer {
LastFullVersion_SR_Client 130
Certification "192.168.1.8", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

DownloadServer {
Certification "192.168.1.8", 15880
}
FarmManager {
Certification "192.168.1.8", 15880
}

AgentServer {
Certification "192.168.1.8", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "192.168.1.8", 15880
CERTIFICATION_IP_BIND "192.168.1.8"
}

SR_GameServer {
Certification "192.168.1.8", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor "250"
ShowFormulaDetail "1"

//WINTER_EVENT_2009 EVENT_ON
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM

//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
//RE FTW

DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "OFF"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"


}

SR_ShardManager {
Certification "192.168.1.8", 15882
BILLING_SERVER_URL "http://192.168.1.8:8080/"
CREST_FTP_URL "ftp://SRO_FTP:[email protected]/"
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1
//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0

BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
}

srglobalservice

 Spoiler

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=User\SQLEXPRESS;DSN=SRO_VT_ACCOUNT; UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

srnodetype

 Spoiler

[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.1.8
nip=192.168.1.8
machine_manager_node_id=699

srshard

 Spoiler

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SROLand
query=DRIVER={SQL Server};SERVER=User\SQLEXPRESS;DSN=SRO_VT_SHARD_IN IT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=User\SQLEXPRESS;DSN=Log_DB;UID=sa;P WD=123456;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

I'm gonna have to start handing out money for all this help ._.

is ur SQLEXPRESS name User/SQLEXPRESS ? if not change it in the ini files

[omegalugia]

Originally Posted by _HouseMusicx3

is ur SQLEXPRESS name User/SQLEXPRESS ? if not change it in the ini files

Yes, this pc name is User.

Any other ideas? :c
OH YEAH and this computer is under DMZ, so all ports are open. (temporarily of course)

[xFlyer]

Originally Posted by omegalugia

Yes, this pc name is User.

Any other ideas? :c
OH YEAH and this computer is under DMZ, so all ports are open. (temporarily of course)

Check your database names. btw nice rating.

––––––––––––––––––––

I want to ask something from guys who have working server, maybe you can make your database backup and share it with me? I have troubles with db I think or maybe not. It's a very interesting bug. After I launch my server and try to go ingame its crash, second time its works, but if I want to open an NPC it's crash, third time connect and npc works, but if I want go outside town it crash again, after re-log i can go outside town but if monster will hit me it will crash again and so on...

[Striker900]

One more thing guys I dont really understand the party with LDF and MDF thing in folder, it saids I should create a folder (Database) Then create 2 folder inside it and name those files SRO_MDF_Files and SRO_LDF_Files and do some setting in folder (Hide extention), and then what? It doesn't really say much after it, how do I get those

SRO_VT_ACCOUNT_Data.MDF
SRO_VT_SHARD_INIT_Data.MDF
Log_DB.MDF

and LDF

Thanks in advance

[_HouseMusicx3]

Originally Posted by Striker900

One more thing guys I dont really understand the party with LDF and MDF thing in folder, it saids I should create a folder (Database) Then create 2 folder inside it and name those files SRO_MDF_Files and SRO_LDF_Files and do some setting in folder (Hide extention), and then what? It doesn't really say much after it, how do I get those

SRO_VT_ACCOUNT_Data.MDF
SRO_VT_SHARD_INIT_Data.MDF
Log_DB.MDF

and LDF

Thanks in advance

create a .txt document .. rename it to
SRO_VT_ACCOUNT_Data.MDF
SRO_VT_SHARD_INIT_Data.MDF
Log_DB.MDF

and u got the files which are needed

[xFlyer]

Originally Posted by Striker900

One more thing guys I dont really understand the party with LDF and MDF thing in folder, it saids I should create a folder (Database) Then create 2 folder inside it and name those files SRO_MDF_Files and SRO_LDF_Files and do some setting in folder (Hide extention), and then what? It doesn't really say much after it, how do I get those

SRO_VT_ACCOUNT_Data.MDF
SRO_VT_SHARD_INIT_Data.MDF
Log_DB.MDF

and LDF

Thanks in advance

You have to associate your database with those files when restoring databases in SQL Manager.

[baddarkness]

frends how i can set my gm name in yellow color ? and how can i set Captain, General names?


wy i canot set itens more than +8 in gm panel?

[Striker900]

almost there guys one more thing XD

What's

Now edit DBConnect.asp like this:
Quote:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=YOURPCNAME\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=your password;"
DBConnA.Open strConnectA

%>

Where can I find DBconnect? in internet information ISS Manager?