Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
DB Connection Failed! -.- DB Connection Failed! -.-
You last visited: Today at 22:18

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

DB Connection Failed! -.-

Discussion on DB Connection Failed! -.- within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
mayc0n's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2007
Posts: 165
Received Thanks: 4
DB Connection Failed! -.-

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:[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
mayc0n is offline  
Old 01/23/2013, 06:27   #2
 
3lyka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
DSN=SRO_VT_SHARD_INIT

check this one if u have set up right SRO_VT_SHARD_INIT DSN
3lyka is offline  
Thanks
1 User
Old 01/23/2013, 12:31   #3
 
mayc0n's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2007
Posts: 165
Received Thanks: 4
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
mayc0n is offline  
Old 01/23/2013, 12:39   #4
 
3lyka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Quote:
Originally Posted by mayc0n View Post
its right, look:
i mean DSN connection
3lyka is offline  
Old 01/23/2013, 12:46   #5
 
zikor1337's Avatar
 
elite*gold: 0
The Black Market: 10/0/0
Join Date: Mar 2010
Posts: 2,667
Received Thanks: 1,886
Post a picture of your Databases: Shard, log, account . Just the names not the tables .
zikor1337 is offline  
Old 01/23/2013, 21:31   #6
 
mayc0n's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2007
Posts: 165
Received Thanks: 4
Exclamation

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 .
mayc0n is offline  
Old 01/24/2013, 17:53   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2010
Posts: 96
Received Thanks: 5
same problem for me do it works for you now??
TurboLiKe is offline  
Old 01/24/2013, 23:59   #8
 
mayc0n's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2007
Posts: 165
Received Thanks: 4
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
mayc0n is offline  
Old 01/25/2013, 13:08   #9

 
Haxor's Avatar
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
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
Haxor is offline  
Old 01/26/2013, 01:42   #10
 
mayc0n's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2007
Posts: 165
Received Thanks: 4
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?



**** 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?
mayc0n is offline  
Reply

« Alchemy stone | Pet2 fixed everything except one »

Similar Threads Similar Threads
DB Connection failed
09/04/2012 - SRO Private Server - 2 Replies
Well, I am trying to run my own server but when I open Sr_gameserver it says: DB Connection failed and it does not work. I think that everything is fine and right, I can not find out the problem. Does somebody knows how to fix it? Thank you guys!:)
DB Connection failed! need help.
08/15/2012 - SRO Private Server - 12 Replies
DB Connection failed! any1 can help me? http://img46.imageshack.us/img46/1876/96793744.pn g
DB Connection Failed!
09/23/2011 - SRO Private Server - 4 Replies
1. server, everything is obvious , 2. server agentserver , machinaserver, sr_gameserver open but 2. server Sr_gameserver "DB Connection Failed!" writes http://i54.tinypic.com/qygxvc.png SMC;
ERROR: Connection failed. Host 'Mcncc.com' is blocked because of many connection erro
04/10/2010 - Metin2 Private Server - 8 Replies
Hab ein Problem mit meinem DynDns Server nach einiger Zeit kommt bei der DB und Regi immer olgendes "ERROR: Connection failed. Host 'Mcncc.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" kann mir jemand sagen woran das liegt?



All times are GMT +1. The time now is 22:18.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.