DB Connection Failed! -.-

[mayc0n]

OMG...

My SR_ShardManager dont connect with DB

SR_ShardManager : DB Connection Failed!

srShard

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SROtest
query=DRIVER={SQL Server};SERVER=WIN-9NETQZ8ZF7F\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=WIN-9NETQZ8ZF7F\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=123456;DATABASE=Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

server.cfg

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.0.187", 32000 
	LoginFailureTolerance		3				// ÃÖ´ë ·Î±×ÀÎ Æнº¿öµå ¿À·ù Çã¿ëÄ¡
	IBUVFailureTolerance		3				// ÃÖ´ë À̹ÌÁö ÀÎÁõ ¿À·ù Çã¿ëÄ¡
	LoginFailureBlockTimeMin	0				// ºí·° ½Ã°£(ºÐ) - ·Î±×ÀÎ Æнº¿öµå ¿À·ù 
	IBUVFailureBlockTimeMin		0				// ºí·° ½Ã°£(ºÐ) - À̹ÌÁö ÀÎÁõ ¿À·ù 
	AutomatedPunisher		"AutomatedPunisher"		// ºí·° ÁÖü À̸§ (±âÁ¸ ºí·°Àº gm ¸í)
	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 1
	Certification "192.168.0.187", 15880
	IBUVQueueReserveCount		20000	// IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö		
	IBUVQueuePrepareRatio		0.10	// ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ²
	IBUVFailureIPTolerance		0	// ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö.

	// Ãß°¡µÈ ³ÑÀÌ´Ù!!!!!
	//////////////////////////////////////////////////////////
	IBUVStringSize			5 	// ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù.
	IBUVCharacterSet		"ABCDEF1234567890"
	//////////////////////////////////////////////////////////
}

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

AgentServer {
	Certification "192.168.0.187", 15882 //
	//traffic_filter_activity "service_off"
	//MaxUser 5000
	//SockTCPCount 15000
	MaxConnectionsPerServer "5000"
	MaxConnectionsPer1_OServer "5000"
}

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

SR_GameServer {
	Certification "192.168.0.187", 15882
	SockTCPCount "5000"
	ExpRatio "35000"
	ExpRatioParty "35000" 
	DropItemRatio "5000"
	DropGoldAmountCoef "15000"
	HwanGainFactor 250
	ShowFormulaDetail 1
	
        //WINTER_EVENT_2009		EVENT_ON	// 2009³â °Ü¿ï À̺¥Æ®
	//EUBUSINESS_EVENT		EVENT_ON
        //GOLDEN_PIG_FEBRUARY_EVENT	EVENT_ON
	//THANKS_GIVING_EVENT		EVENT_ON
	//LIBERATION_EVENT		EVENT_ON
	LOCALE LOCALE_VIETNAM	// for Helper mark 
       
         //#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.0.187", 15882
	BILLING_SERVER_URL "http://192.168.0.187:8080/"
	CREST_FTP_URL "http://SRO_FTP:[email protected]/"
        ChristmasEvent2007 0
	//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

Thnx for help

[3lyka]

DSN=SRO_VT_SHARD_INIT

check this one if u have set up right SRO_VT_SHARD_INIT DSN

[mayc0n]

Originally Posted by 3lyka

DSN=SRO_VT_SHARD_INIT

check this one if u have set up right SRO_VT_SHARD_INIT DSN

its right, look:

query=DRIVER={SQL Server};SERVER=WIN-9NETQZ8ZF7F\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=WIN-9NETQZ8ZF7F\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=12345 6;DATABASE=Log_DB

[3lyka]

Originally Posted by mayc0n

its right, look:

i mean DSN connection

[zikor1337]

Post a picture of your Databases: Shard, log, account . Just the names not the tables .

[mayc0n]

Originally Posted by 3lyka

i mean DSN connection

Same name, "SRO_VT_SHARD_INIT"

Originally Posted by zikor1337

Post a picture of your Databases: Shard, log, account . Just the names not the tables .

[TurboLiKe]

same problem for me do it works for you now??

[mayc0n]

I dont know why, but working fine now lol

My friend cant log on server, use edxloader, same ip, port 15779 same here, but he cant open the game, he got this error:



why?

----

Now i used IPinput, i can log normaly, but his have same error lol

IPinput i need create a new division using my ip on files and port 15779, right? i made it, and i can log normaly with laucnher on my pc (another ip)

why

Regards

[Haxor]

how you want your friend to login into server if you using 192.168 ip

go to google and write what my ip and change the ini's with that ip to make it public
or use hamachi

[mayc0n]

Originally Posted by ™Haxor™

how you want your friend to login into server if you using 192.168 ip

go to google and write what my ip and change the ini's with that ip to make it public
or use hamachi

thx but look this answer

Originally Posted by Sir*EviL

you opened agent server port?

and necessary ports?

Ports + Ip?



**** lol

I change IP for static ip on inis, i made this tut, and now my friends can log but im not, c9 for me wtf?