Help PreServer

Results 1 to 5 of 5
  1. #1
    Newbie vasyater5 is offline
    MemberRank
    Jan 2016 Join Date
    3Posts

    shout Help PreServer

    Help PreServer
    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
    Last edited by vasyater5; 18-02-17 at 03:54 PM.


  2. #2
    Account Upgraded | Title Enabled! inetpub is offline
    True MemberRank
    Oct 2012 Join Date
    223Posts

    Re: Help PreServer

    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

  3. #3
    Guss decarvk is offline
    True MemberRank
    Jul 2008 Join Date
    /home/bed/Location
    381Posts

    Re: Help PreServer

    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.

  4. #4
    Help PreServer Future is offline
    LegendRank
    Dec 2011 Join Date
    2,275Posts

    Re: Help PreServer

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

    Related code in the Pre Server:

    Code:
    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)


    Quote Originally Posted by A Wise Man
    P-Servers are NOT dead. Bugs need squishing. Quests need fixing. Unfortunately, majority of people don't know the difference between a computer and a toaster so...

  5. #5
    Guss decarvk is offline
    True MemberRank
    Jul 2008 Join Date
    /home/bed/Location
    381Posts

    Re: Help PreServer

    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.



Advertisement