Help PreServer

[vasyater5]

Error Preserver . I configuration server for game.

17:41:24|[Notify] elapsed time after turn on !! 13Day 3h:50m:24s
02-18 17:41:24|Pre Server Start
02-18 17:41:24|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 100] CommitSize[ 151552] vectorSize[1] Address Range(0x7EF80000 ~ 0x7EFA5000)
02-18 17:41:24|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[ 101] CommitSize[ 155648] vectorSize[1] Address Range(0x7EF50000 ~ 0x7EF76000)
02-18 17:41:24|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1556] PoolCnt[15001] CommitSize[23343104] vectorSize[1] Address Range(0x7D900000 ~ 0x7EF43000)
02-18 17:41:24| ServerGroup: ACE_WAR, Enable(1) MGameServerID(10061)
02-18 17:41:24| ServerGroup: Arena, Enable(0) MGameServerID(10071)
02-18 17:41:25| [Notify] CPreGlobal::OnPacketNotifyOfSPToMPWinSoc# 10000 CWinSocket::WS_CONNECTED wParam(0)
02-18 17:41:25| [Notify] CPreGlobal::InitServerSocket# Starting...
02-18 17:41:25| [Notify] CPreIOCP::IOCPInit# 10000
02-18 17:41:25| [Notify] CPreIOCP::IOCPInit# 11000 updated version files !
02-18 17:41:25| [Notify] CPreIOCP::IOCPInit# 12000 arranged version list !
02-18 17:41:42|[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! 127.0.0.1,1433 atum2_db_account : Wrong DB Password


Screenshot by Lightshot


my global config
https://drive.google.com/open?id=0By...llJNnpjQ2laakk

[MentaL]

[inetpub]

02-18 17:41:42|[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! 127.0.0.1,1433 atum2_db_account : Wrong DB Password

Well thats maybe some tip

[decarvk]

Wrong DB Password come from 2 way, the way on that is what is say, and the second way is you sqlSever don't accept mixed authentification mode and only accept windows authentication. you can correct this directly on studio management tools provided with sqlserver if got the full bundle.

[Future]

That error is actually logged each time the connection fails for whatever reason that is.

Related code in the Pre Server:

BOOL bRet = odbcStmt.Init(g_pGlobalGameServer->GetDBServerIP(), g_pGlobalGameServer->GetDBServerPort(), g_pGlobalGameServer->GetDBServerDatabaseName(), (char*)g_pGlobalGameServer->GetODBCUID(), (char*)g_pGlobalGameServer->GetODBCPASSWORD(), g_pGlobalGameServer->GetMainWndHandle());
if (!bRet)
{
	// 2008-09-05 by cmkwon, DBServer ¿¬°á ½ÇÆÐ ½Ã½ºÅÛ ·Î±× ³²±â±â - 
	g_pGlobal->WriteSystemLogEX(TRUE, "[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! %s,%d %s : Wrong DB Password \r\n"		// 2012-09-24 by jhseol, ¼Ò½ºÁ¤¸® - ÁÖ¼® Á¤¸® ID / PW ¹ÌÃâ·Â
		, g_pGlobalGameServer->GetDBServerIP(), g_pGlobalGameServer->GetDBServerPort(), g_pGlobalGameServer->GetDBServerDatabaseName());	// 2012-09-24 by jhseol, ¼Ò½ºÁ¤¸® - ÁÖ¼® Á¤¸® ID / PW ¹ÌÃâ·Â

	MessageBox(NULL, "DB connect CPreIOCP::IOCPInit()", "ERROR - SpaceCowboy PreServer", NULL);
	return FALSE;
}

Their logging is as usual not of any help unless you really wrote a wrong password.

Try to connect to your SQL serv with the Management Studio using the credentials that you put in the global.cfg and see what error the Management Studio gives you.

Common reasons for this are:

• TCP is not configured correctly for the SQL server (check in the Configuration Manager)
• The server does not allow SQL authentication
• The username is wrong
• The password is wrong
• You did or did not XOR the credentials in the global.cfg (depends on the bins)

[decarvk]

and a missing case if you use bin where you haven't to xor login and password for db, avoid to use special character like ";" I have seen that all server don't like it (and haven't take look at source to patch this.