DB Connection Failed! -.-

01/23/2013 05:32 mayc0n#1
OMG...

My SR_ShardManager dont connect with DB :(

SR_ShardManager : DB Connection Failed!

srShard
Code:
[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
Code:
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:ftp123456@127.0.0.1/"
        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
01/23/2013 06:27 3lyka#2
DSN=SRO_VT_SHARD_INIT

check this one if u have set up right SRO_VT_SHARD_INIT DSN
01/23/2013 12:31 mayc0n#3
Quote:
Originally Posted by 3lyka View Post
DSN=SRO_VT_SHARD_INIT

check this one if u have set up right SRO_VT_SHARD_INIT DSN
its right, look:

Quote:
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
01/23/2013 12:39 3lyka#4
Quote:
Originally Posted by mayc0n View Post
its right, look:
i mean DSN connection
01/23/2013 12:46 zikor1337#5
Post a picture of your Databases: Shard, log, account . Just the names not the tables .
01/23/2013 21:31 mayc0n#6
Quote:
Originally Posted by 3lyka View Post
i mean DSN connection
Same name, "SRO_VT_SHARD_INIT"

Quote:
Originally Posted by zikor1337 View Post
Post a picture of your Databases: Shard, log, account . Just the names not the tables .
[Only registered and activated users can see links. Click Here To Register...]
01/24/2013 17:53 TurboLiKe#7
same problem for me do it works for you now??
01/24/2013 23:59 mayc0n#8
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:

[Only registered and activated users can see links. Click Here To Register...]

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
01/25/2013 13:08 Haxor#9
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
01/26/2013 01:42 mayc0n#10
Quote:
Originally Posted by ™Haxor™ View Post
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

Quote:
Originally Posted by Sir*EviL View Post
you opened agent server port?

and necessary ports?
Ports + Ip?

[Only registered and activated users can see links. Click Here To Register...]

Damn 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?