Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Problems with any Episode beyond 2.2

Initiate Mage
Joined
Jun 25, 2012
Messages
9
Reaction score
1
Hello!

I've been trying all kinds of Ace Online Servers / Clients (I even tried to compile binaries from the EP 3.5 and 4.2 sources), but I allways struggled very much with the Pre- and Log-Server failing to connect to the DB.

For some strange reason I somehow managed to get a EP 2.2 Server running, but nothing else Every other episode allways has the same "CPreIOCP::IOCPInit_"-Error. I've triple checked settings for:

-ODBCs
-SQL Server TCP/IP
-Global.cfg
-I tried encrypted and not-encrypted logins
-SQL server has active mixed authentication

---

In some thread I found a guy with a similar problem and Future provided various possible solutions for this problem (http://forum.ragezone.com/f908/help-pre-server-wrong-db-1152897/), but none of these work for me.

What bugs me the most is, if I try to connect through the SQL Management studio, and just use the IP instead of "H2431283\SQLEXPRESS" I cannot connect. Which is strange, since the EP2.2 Pre- and Logserver work fine. I even played the first few missions of the FreeSKA just for testing. I've been trying around for over 4 days now, but It doesn't seem like I make any progress.

I tried EP 3.3, EP 3.5 and EP 4.2, all of which I could find in one way or another in these forums. Neither did work.

---

I can provide any logs if needed, but maybe someone would have had a similar problem before?

---

Example of the Preserver log for a EP 3.5 preserver (with matching .cfg's):

05-10 02:28:05|[Notify] elapsed time after turn on !! 0Day 3h:54m:34s
05-10 02:28:05|Pre Server Start
05-10 02:28:05|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 100] CommitSize[ 151552] vectorSize[1] Address Range(0x7FE80000 ~ 0x7FEA5000)
05-10 02:28:05|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[ 101] CommitSize[ 155648] vectorSize[1] Address Range(0x7FE50000 ~ 0x7FE76000)
05-10 02:28:05|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[15001] CommitSize[23281664] vectorSize[1] Address Range(0x7E810000 ~ 0x7FE44000)
05-10 02:28:05| ServerGroup: Dragon, Enable(1) MGameServerID(10061)
05-10 02:28:05| ServerGroup: Arena, Enable(0) MGameServerID(10062)
05-10 02:28:06| [Notify] CPreGlobal::OnPacketNotifyOfSPToMPWinSoc# 10000 CWinSocket::WS_CONNECTED wParam(0)
05-10 02:28:06| [Notify] CPreGlobal::InitServerSocket# Starting...
05-10 02:28:06| [Notify] CPreIOCP::IOCPInit# 10000
05-10 02:28:06| [Notify] CPreIOCP::IOCPInit# 11000 updated version files !
05-10 02:28:06| [Notify] CPreIOCP::IOCPInit# 12000 arranged version list !
05-10 02:28:23|[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! 85.214.129.61,1433 atum2_db_account atum callweb
05-10 02:28:26|[Error] PreServer IOCPInit Error
05-10 02:28:27|[ERROR] CPreGlobal::OnPacketNotifyOfSPToMPWinSoc_ InitServerSocket_ error !!05-10 02:28:28| [Notify] CPreGlobal::EndServerSocket#
05-10 02:28:28|CGlobalGameServer::EndServerSocket_1
05-10 02:28:28|######################## Server IOCPClean ########################

05-10 02:28:28|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1508] TotalCommitedObjCnts( 100) CurrentObjCnts( 100)
05-10 02:28:28|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1528] TotalCommitedObjCnts( 101) CurrentObjCnts( 101)
05-10 02:28:28|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1552] TotalCommitedObjCnts( 15001) CurrentObjCnts( 15001)
05-10 02:28:28|Pre Server End


05-10 02:28:28|CGlobalGameServer::EndServerSocket_1

I'm sorry that I have to ask for help :(
 
Initiate Mage
Joined
Feb 2, 2015
Messages
77
Reaction score
53
05-10 02:28:23|[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! 85.214.129.61,1433 atum2_db_account atum callweb

your have issue with db connect right? so try check sql server setting

1. sql server configuration / sql server network / TCP IP / IP Addresss's tab / fix it if you using wrong ip port (
85.214.129.61 / 1433) and restart sql server.
2. try login sql server management with that account atum password callweb (check permssion setting using admin or not)
3. check server config global. you put same db ip/port/user/password or not. some source using XOR password.



 
Upvote 0
[emoji848]
Legend
Joined
Dec 3, 2011
Messages
2,232
Reaction score
1,518
As you found my posts already, I can pretty much only repeat myself.

Try connecting to the SQL Server via the SQL Server Management Studio, not the game servers, using the exact same IP, User ID and Password you've set in the config files. If that doesn't connect, there is no chance your game servers will. + SSMS' error reporting is a ton better than masang's. You prolly get some useful information out of that.

Otherwise, if you know how to, you can obviously also extend the error logging on server connection attempts. ODBC API error information can be read and parsed using SQLGetDiagRec, passing the respective connection handles.
 
Upvote 0
Initiate Mage
Joined
Jun 25, 2012
Messages
9
Reaction score
1
As you found my posts already, I can pretty much only repeat myself.

Try connecting to the SQL Server via the SQL Server Management Studio, not the game servers, using the exact same IP, User ID and Password you've set in the config files. If that doesn't connect, there is no chance your game servers will. + SSMS' error reporting is a ton better than masang's. You prolly get some useful information out of that.

Otherwise, if you know how to, you can obviously also extend the error logging on server connection attempts. ODBC API error information can be read and parsed using SQLGetDiagRec, passing the respective connection handles.

After a lot of searching and grey hair, I seem to have found the issue:

In the SQL Configuration Manager, under IPAll there was a wrong (?) dynamic port (1399), for reasons I don't know. After I changed this to 1433 too, I can connect to the server through SSMS by entering the IP. I'll try around and report back - but I think I might have gotten a step further.

I still cannot quite understand how and why EP2.2 still worked for some reason.
 
Upvote 0
Back
Top