[Guide] for ep 3.3

5 Attachment(s)

[Guide] for ep 3.3

Step 1: Getting the files you need.
http://www.mediafire.com/?ot2i3b2mz03goqq
^This is a working link^

Password is x-rivals
On a side note:
-As I promised, the new files with the new monsters, items, maps, but for making the pets to work you need to fix some things in databases. Here is it:
New ep 3.5 with some features of episode 4

Also, if you need some files for client, go on www.war0nline.net at the Download section.
-If you need a client, download it from here:
http://dr-files.net/clients/current/...3.6.5).sfx.exe
http://installer.subagames.com/ace/ACEonline(3511).exe
Deposit Files
http://airrivals.net/main/download/client

-Download SQL 2k5 or 2k8, it's up to you. Out of personal preference, i use 2k5.
Go to Database Management | Data Mining & Warehousing | Microsoft SQL Server to get the trial version of SQL 2k8. Try to avoid getting Express if possible (It has a limitation on DB restores.

-Download Hamachi. It will give you a Virtual IP which will be used to connect to the server. You can download it from https://secure.logmein.com/products/hamachi2/ . Install it and run through the set up. Once running, click the power button. You'll have to create a Hamachi ID, it doesn't really matter what it is. Then, It'll ask you whether you want to Create a network or Join an existing one. Choose to create a new one, name it, give it a password. You're done with Hamachi for now.
[[[[This is in case that you want to use Hamachi instead of External IP]]]]

Step 2: Setting up the server.
-If you didn't extract the first file to the root of your HD already, do it now.

-Once extracted, go into the server folder. You should see 9 other folders inside (bin, config, DB_BAKS, htdocs, Lib, log, map, SCMonitor, SCVoIP)

-Go into the config folder and change the file named global.cfg with the one ATTACHED here, so odbc will work. After changing it, open it using Notepad.

-The top two IPs, change it to say your Hamachi IP (It'll start with a 5). This isn't completely necessary, you can just set it up as a 127.0.0.1 (Which for those of you who don't know, that means local host) However, this guide is made for people who want others to connect to your server (Say, a friend comes over and wants to play too, or some Ventrilo friends, take your pick). So for the sake of the guide, do the Hamachi IP.
If done right, it should look as follows:

[...]
$LOCAL_IP_ADDR = 5.175.254.21 -(for hamachi) or u can put here ur local ip (ex: 192.168.25.10)
$LOCAL_PUBLIC_IP_ADDR = 73.128.265.001 -(here you put your external IP in case u want to run it globally. Or just $LOCAL_IP_ADDR for hamachi.
$ARENA_IP_ADDR = $LOCAL_PUBLIC_IP_ADDR -Arena to work, globally, I puted here the external IP.
$WEBSRV_IP_ADDR = $LOCAL_IP_ADDR
$FTPSRV_IP_ADDR = $LOCAL_IP_ADDR
$IS_ARENA_SERVER = FALSE
$SERVER_GROUP_NAME = YourServerGroupName
$LANGUAGE_TYPE = 1
[...]

-Now you're going to do a bit of copying.
What you're going to want to do is open up the server folder, go to the map folder. Now you're going to open up "server" that you dearchivated it, and go to "Server/map".
Open also your client go to /Res-Map/ and copy the .dat files in to the /server/map/

Go back in /server/ and open the /server/Res-Obj/
Go back in the /client/ and go to /client/Res-Obj/. Copy the objs to the folder /server/Res-Obj/

Go back in /server/map in /server/map/Res-Exe.
Go to your client and copy the Aceonline.atm in the /server/map/Res-Exe.

Go back in /server/map in /server/map/Res-Tex.
Go in to ur client in /client/Res-Tex. Copy the interface.tex, omi.tex and quest.tex in to the /server/map/Res-Tex.

Now you should be set with the files that you needed to copy over to both the client and the server. Now on to SQL Side of things!

Step 3: Setting up the server (SQL Side of things).
-Moving right on to SQL side of things, the installation is fairly simple, so i'm not going to walk you through it. You're a big kid, running your own server and stuff, i think you can figure it out. (When it asks what you want to install, select all. USe NT/System Authority, and Add current user for anything after that. Install it and you should be on your way. Figured i'd just give an overview

-Open the SQL Server Configuration Manager, click on SQL Server Network Configuration, and click on Protocols for MSSQLSERVER. Right click TCP/IP Settings. It should look like the following:

The images are attached as Step3 Step3.1 and so on.

If it doesn't make it look like that.
Now go over to the IP Addresses tab, and since you have Hamachi installed, the IP should already be there.
Or if you don't use the hamachi ip You just put ur local one.

Make it Active if it isn't, Enable it, and change the Port to 9979 or leave it as 1433. When you click okay, it will say that the service will have to be restarted for the changes to be applied.

Go to Start, type in services.msc, and scroll down until you find MSSQLSERVER, Restart it and you should be good.

-Now open up the Microsoft SQL Server Management Studio. Right click on Databases, and chose the restore option. if done successfully, you'll get to this screen:

Step3.3 photo.

All you have to do now is restore the databases. Do as follows:

Step3.4

Once you restore atum2_db_1, do the same for atum2_db_account:

Step3.5

Now you're set for that side of things. To make an account, go to Databases, atum2_db_account, Tables, and right click on dbo.td_Account, select "Edit top 200 rows"
You'll see 20 accounts as normal. You can leave them there or just take them out.
To create an account:
AccountName
Password
AccountType (0= Normal user, 128= GM, 256= Helper)

Now you're almost done, all you have to do now is add the odbc's and compile a batch file.

Step 4: Setting up the ODBC's

-What you have to do now is go to "Start", and Type odbc.
add User Data Sources as:
db_1
db_account
db_arena

Click finish and test it. If it passes successfully, do the same for the next 2 . Once all are done and successfully tested, congratulations. Only one more step to go.

Step 5: Getting the Batch file
If you don't know how to make a batch file, just use the following program and method:
Quote:

Quick BFC: http://www.abyssmedia.com/downloads/quickbfc.exe

Install and start the Program.
Now Type in:

echo off
start Launcher.atm (YOUR IP)

Click on Embedded Files and Browse for your client.ico (in your game folder).

Now click -> Project -> Compile.

Save it in your Game Folder as .exe

Now you can try to start your own compiled Start.exe

Mine for example was:
echo off
start Launcher.atm 5.207.74.185

You're going to use that Start.Exe to get the client to connect to your server. Now you're pretty much done. All you have to do is bring the server online. To do that, all you gotta do is go to the bin folder in your server, and open up, in this order, Preserver, IM Server, LogServer, Field Server, and then NPC Server. First three take next to nothing to boot, Field takes a little long and so does NPC. If you open task manager, and it says not responding, don't freak out. That means the server is actually booting up. Once Field server comes online you can launch into the game.

-----------------------------------------------
The thing is, its a GUIDE nearly the same as this one but for episode 2.
I tryed to make for 3.3 if some1 have a better idea or waisting his time other way, please come with better guides.

Thank you.

[Credits for most of the work to FallenProphett]

Re: [Guide] for ep 3.3

Hello I wanted to thank you for the guide, but I'm also here to ask me why these errors.
ALogServer-
LogServer-
-Preserver

I placed an image of the errors, can someone tell me how to solve?

http://img829.imageshack.us/img829/4493/errorhx.png

Uploaded with ImageShack.us

Re: [Guide] for ep 3.3

ahhhaha lol obdc probleme

Re: [Guide] for ep 3.3

those errors means that in config files u got some errors.
Did u made in SQL Server Configuration Manager the TCP/IP on as ur hamachi or local ip? then after u restarted the service MSSQLSERVER from Start> type "services" ?

And try ur SQL Server to log in with ur IP id and pw.
in ODBC at db_1 u must put as default database the atum2_db_1
at db_account put as default database the atum2_db_account
at db_arena put as default database the atum2_db_arena

Check the global.cfg something u made wrong. Upload it here so i can take a look.

Re: [Guide] for ep 3.3

Thank you to provide
Please ask what password is?

Re: [Guide] for ep 3.3

Quote:

Originally Posted by jison

ahhhaha lol obdc probleme

btw those errors means that has errors in config files ;) not necessary ODBC

Quote:

Originally Posted by xbl106525250

Thank you to provide
Please ask what password is?

x-rivals is the pw

Re: [Guide] for ep 3.3

Thank you

Re: [Guide] for ep 3.3

or assigned to the various odbc db and are just as you say darmandos

if someone can entarre TeamViewer from me in just to check and see that everything is ok please send me pm

Re: [Guide] for ep 3.3

Send me pm with ur yahoo or msn or add me rusufoxxzy@yahoo.com

Re: [Guide] for ep 3.3

I'm installing msn m1ster_b1t@hotmail.it

Re: [Guide] for ep 3.3

EP 3+ Doesn't need an odbc. But yeah only retards can't understand that.

Re: [Guide] for ep 3.3

Hi, we only need to run 5 files: Preserver, IM Server, LogServer, Field Server, and NPCServer or we must run all of them? 'coz when running AIMServer I got an IOCPInit Error on AIMServer :(

http://img403.imageshack.us/img403/7681/aimserver1.png http://img854.imageshack.us/img854/7245/aimserver2.png

Re: [Guide] for ep 3.3

Your configs are not ok. IOCPInit means that its an error in ur config.
Upload here the logs of the servers that are giving errors and also the global.cfg

Re: [Guide] for ep 3.3

Everything is OK, only that AIMServer got that error, I still can login to game, I was thing those file with an "A" prefix (like AIMServer, ALogServer, ANPCServer and ArenaSever) is needed for an Arena server so Im not runing them. At the Launcher, I can see that Arena Server is offline if Im not running 'em.

Re: [Guide] for ep 3.3

AIM Server and all the arena servers got problem because the atum2_db_arena database is not complete. Somewhere in the forum i uploaded a working atum2_db_arena. Find it change it with the one that u got it in SQL Server and ull be ok.

Re: [Guide] for ep 3.3

Hello I hope someone so much that some of you know the solution to my problem,
Then either the server UP (online) when I try to connect with the client proceeds to insert the data as a login to the game, does not make you as if you enntrare crascha and writes
(connection to the server will be terminated lost.Client has-been. (FieldWinSocket ws_CLOSED) and this error since the game ends.

Or looked at the error message that gave the preserver, and write them below fieldserv

preserver:

11-16 22:03:00| SendErrorMsg to ClientIndex[ 7] 5.53.52.237(56455) ==> ERR_NO_SEARCH_CHARACTER(0x4018) AT T_PC_CONNECT_LOGIN Param1(0) Param2(0) Msg(m1st3rb1t)
11-16 22:03:20| SendErrorMsg to ClientIndex[ 7] 5.53.52.237(56455) ==> ERR_NO_SEARCH_CHARACTER(0x4018) AT T_PC_CONNECT_LOGIN Param1(0) Param2(0) Msg(m1st3rb1t)
11-16 22:03:23|Socket Closed SocketIndex[ 7] SocketType[7] PeerIP[ 5.53.52.237] Port[56455] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
11-16 22:03:55|Socket Connect SocketIndex[ 8] PeerIP[ 5.53.52.237] Port[56460]
11-16 22:04:01| SendErrorMsg to ClientIndex[ 8] 5.53.52.237(56460) ==> ERR_NO_SEARCH_CHARACTER(0x4018) AT T_PC_CONNECT_LOGIN Param1(0) Param2(0) Msg(m1st3rb1t)
11-16 22:04:04|Socket Closed SocketIndex[ 8] SocketType[7] PeerIP[ 5.53.52.237] Port[56460] MaxWriteBufCounts[ 2] ==> reason 6[0X000006]
11-16 22:04:21|Socket Connect SocketIndex[ 9] PeerIP[ 5.53.52.237] Port[56462]
11-16 22:04:36|Socket Closed SocketIndex[ 9] SocketType[7] PeerIP[ 5.53.52.237] Port[56462] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
11-16 22:05:43|Socket Closed SocketIndex[ 4] SocketType[8] PeerIP[ 127.0.0.1] Port[56406] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
11-16 22:07:00|Socket Closed SocketIndex[ 6] SocketType[8] PeerIP[ 127.0.0.1] Port[56436] MaxWriteBufCounts[ 1] ==> reason 5[0X000005]
11-16 22:11:22|Socket Connect SocketIndex[ 10] PeerIP[ 5.53.52.237] Port[56504]
11-16 22:11:32|Socket Closed SocketIndex[ 10] SocketType[7] PeerIP[ 5.53.52.237] Port[56504] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]

FieldServer:

11-16 22:04:48|Socket Connect SocketIndex[172] PeerIP[ 5.53.52.237] Port[56463]
11-16 22:04:49| SendErrorMsg to [A(m1st3rb1t:8) C(:0) CI(0)] 5.53.52.237 ==> ERR_PROTOCOL_INVALID_PROTOCOL_TYPE(0x2400) AT T_FIELD_IOCP Param1(0) Param2(0) Msg((null))
11-16 22:04:49|[Error] CFieldIOCPSocket::OnRecvdPacketFieldServer2 invalid protocol type, RecvType[NO SUCH MESSAGE TYPE(0000)], PrevType[T_FC_CONNECT_LOGIN(0X3104)], [A(m1st3rb1t:8) C(:0) CI(0)]
11-16 22:04:49|[Error] CIOCPSocket::OnReceive Error! Closing Connection!, SocketIndex[172]
11-16 22:04:49|Socket Closed Client( 5.53.52.237:56463) SocketType(7) |SockIdx( 172)| MaxWriteBufCounts[ 1] ==> reason 65537[0X010001], deletedPacketCount(0)
11-16 22:07:00|Socket Closed Client( 5.53.52.237:56439) SocketType(8) |SockIdx( 170)| MaxWriteBufCounts[ 1] ==> reason 5[0X000005], deletedPacketCount(0)
11-16 22:11:35|Socket Connect SocketIndex[173] PeerIP[ 5.53.52.237] Port[56505]
11-16 22:11:35| SendErrorMsg to [A(m1st3rb1t:0) C(:0) CI(0)] 5.53.52.237 ==> ERR_PROTOCOL_INVALID_PROTOCOL_TYPE(0x2400) AT T_FIELD_IOCP Param1(0) Param2(0) Msg((null))
11-16 22:11:35|[Error] CFieldIOCPSocket::OnRecvdPacketFieldServer2 invalid protocol type, RecvType[NO SUCH MESSAGE TYPE(0000)], PrevType[T_FC_CONNECT_LOGIN(0X3104)], [A(m1st3rb1t:0) C(:0) CI(0)]
11-16 22:11:35|[Error] CIOCPSocket::OnReceive Error! Closing Connection!, SocketIndex[173]
11-16 22:11:35|Socket Closed Client( 5.53.52.237:56505) SocketType(7) |SockIdx( 173)| MaxWriteBufCounts[ 1] ==> reason 65537[0X010001], deletedPacketCount(0)

how can I do to resolve, any idea where or what to do to correct?

Re: [Guide] for ep 3.3

Hmm to to your atum2_db_1 > Tables > ti_Character delete all the characters Then enter.

Re: [Guide] for ep 3.3

Login -> OK
Character Create -> OK
Play -> The game disapear

I use Subagame 3.5.1.1 like introduction. Anyone can tell me how to play ?

Re: [Guide] for ep 3.3

Play -> The game disapear its because the files are not the same between Server files and Client.

Try to copy from ur client from "Res-Map" the .dat and .tex files in "server/map".
After copy the res-obj from client to the server files.
Then put ur ACEonline.atm from the client in to Res-Exe With copy replace.
And the last thing u must Copy from client Are the interface.tex omi.tex and quest.tex.

You can see the errors in "server/log/SystemLog. (In FieldSystem_xxxxxX)

Re: [Guide] for ep 3.3

Hello darkmandos, or done as you have written or deleted records in td_Carachter in atum2_db_1.
but it still does not make me log gives me the same error message

preserver:

:31:47|Socket Closed SocketIndex[ 4] SocketType[7] PeerIP[ 5.53.52.237] Port[50927] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
11-17 14:32:08|ServerGroup(AcEFiGHTeR) FieldServer(5.53.52.237, 15103), PeerIPPort[5.53.52.237:50618] registeration done...
11-17 14:32:08|ServerGroup(ARENA) FieldServer(5.53.52.237, 15107), PeerIPPort[5.53.52.237:50765] registeration done...
11-17 14:38:55|Socket Connect SocketIndex[ 5] PeerIP[ 5.53.52.237] Port[50958]
11-17 14:39:12|Socket Closed SocketIndex[ 5] SocketType[7] PeerIP[ 5.53.52.237] Port[50958] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]

fielserver:

11-17 14:39:19|Socket Connect SocketIndex[171] PeerIP[ 5.53.52.237] Port[50959]
11-17 14:39:19| SendErrorMsg to [A(m1st3rb1t:1) C(:0) CI(0)] 5.53.52.237 ==> ERR_PROTOCOL_INVALID_PROTOCOL_TYPE(0x2400) AT T_FIELD_IOCP Param1(0) Param2(0) Msg((null))
11-17 14:39:19|[Error] CFieldIOCPSocket::OnRecvdPacketFieldServer2 invalid protocol type, RecvType[NO SUCH MESSAGE TYPE(0000)], PrevType[T_FC_CONNECT_LOGIN(0X3104)], [A(m1st3rb1t:1) C(:0) CI(0)]
11-17 14:39:19|[Error] CIOCPSocket::OnReceive Error! Closing Connection!, SocketIndex[171]
11-17 14:39:19|Socket Closed Client( 5.53.52.237:50959) SocketType(7) |SockIdx( 171)| MaxWriteBufCounts[ 1] ==> reason 65537[0X010001], deletedPacketCount(0)

Re: [Guide] for ep 3.3

[Error] CIOCPSocket::OnReceive Error! Closing Connection!, SocketInd

Errors in connections. Configs, the pass between the config thru the database...

Add me on yahoo or MSN.

foxxzy@yahoo.com

Re: [Guide] for ep 3.3

Thank you. My Bad ^^!...

Re: [Guide] for ep 3.3

you can make a video tutorial is not. I can not run the server for errors as you misterbit. or you can teach more in step config db, global.cfg and odbc.thanks

Re: [Guide] for ep 3.3

Why others can understand the guide and u can't?

Oh i know why u don't understand... it's because its ur 1st post in this entire forum from ragezone. And u didn't even searched for the problems.
When u entered here, u saw this guide and u humped exactly here. But u need some experience to fix a server.
At least u could try to understand what i wrote there. Unless use google translate and try to translate it on ur language.

^^

Re: [Guide] for ep 3.3

darkmandos to six time you call me on MSN? m1ster_b1t@hotmail.it

Re: [Guide] for ep 3.3

Quote:

Originally Posted by darkmandos

[Error] CIOCPSocket::OnReceive Error! Closing Connection!, SocketInd

Errors in connections. Configs, the pass between the config thru the database...

Add me on yahoo or MSN.

foxxzy@yahoo.com

foxxzy@yahoo.com

Re: [Guide] for ep 3.3

Quote:

Originally Posted by darkmandos

Why others can understand the guide and u can't?

Oh i know why u don't understand... it's because its ur 1st post in this entire forum from ragezone. And u didn't even searched for the problems.
When u entered here, u saw this guide and u humped exactly here. But u need some experience to fix a server.
At least u could try to understand what i wrote there. Unless use google translate and try to translate it on ur language.

^^

:D:I've run the sever.

Re: [Guide] for ep 3.3

Quote:

Originally Posted by auditiontcn1

:D:I've run the sever.

Nice. Looks like some1 understand what i wrote in the guide. ^^

Re: [Guide] for ep 3.3

i dont understand at "step4"

please describe in detail. :)

Re: [Guide] for ep 3.3

This is exactly a clone of... not in the right section either wait i dont even....

What..?

Re: [Guide] for ep 3.3

Quote:

Originally Posted by gigabyte

This is exactly a clone of... not in the right section either wait i dont even....

What..?

=))=))=)) Ur so cool :)) sometimes :P

Re: [Guide] for ep 3.3

darkmandos do you know why restoring atum2_db_1 doesnt get past 93% and just hangs there?
The other account and arena were restored successfully but not this.
I really need a working one ^^
Posted via Mobile Device

Re: [Guide] for ep 3.3

For everyone it worked. Maybe you don't have enought memory. But try to restart your computer and then try again. ^^

Re: [Guide] for ep 3.3

.......
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3007), SummonTime(2012-11-19 23:50:00) SPStepMin(208980) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3009), SummonTime(2012-11-19 23:50:00) SPStepMin(209790) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(4006), SummonTime(2012-11-19 23:50:00) SPStepMin(210600) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3014), SummonTime(2012-11-19 23:50:00) SPStepMin(211410) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(4010), SummonTime(2012-11-19 23:50:00) SPStepMin(212220) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3031), SummonTime(2012-11-19 23:50:00) SPStepMin(213030) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3028), SummonTime(2012-11-19 23:50:00) SPStepMin(213840) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3015), SummonTime(2012-11-19 23:50:00) SPStepMin(214650) SPPMin( 810)
11-19 23:50:00| [Notify]: AllStrategypoint Summon Info, MapIndex(3025), SummonTime(2012-11-19 23:50:00) SPStepMin(215460) SPPMin( 810)
11-19 23:50:00| [Notify] CAtumFieldDBManager::QP_LoadStrategyPointSummonInfo# 19000
11-19 23:50:48|[Error] FieldServer IOCPInit Error

what is my problem? (

Quote:

Originally Posted by Glower

darkmandos do you know why restoring atum2_db_1 doesnt get past 93% and just hangs there?
The other account and arena were restored successfully but not this.
I really need a working one ^^
Posted via Mobile Device

I, too, so it was, waited 10 minutes and restore databases

Re: [Guide] for ep 3.3

Quote:

11-19 23:50:48|[Error] FieldServer IOCPInit Error

Errors in connections. Configs, the pass between the config thru the database...

Your config it's messed up.

make sure You give to "atum" sysadmin in SQL Server, after take ur Local ip address from global.cfg and log in to SQL Server in Server name : the ip with id : atum and pw: ur pw. when u are loged in,
In SQL Server Configuration Manager make sure at MSSQLSERVER you have the "Named Pipes" ENABLED and in TCP/IP you got the local ip address from global.cfg as enabled with the correct port.
After you have to restart the MSSQLSERVER from "services.msc"
When you done that, make sure also in global.cfg the odbc settings to arena and the other fields, are db_arena, db_1, db_account. when u done that open the ODBC. Create if you don't have db_arena db_1 and db_account and delete the other ones that are there.

db_arena = atum2_db_arena
db_1 = atum2_db_1
db_account = atum2_db_account

Name: db_1
Description: u leave it blank
Server: put the local ip address from global.cfg

click next

Move to "With SQL Server authentification......"
Click on "Client Configuration"
"Dynamically determine port if is enabled take it off
If the port is 9979 and u run on 1433 change it.
Or vice versa.

Click Ok
Login ID: atum
Password: ur password that u are also loging in to the SQL Server.

Click next.

remember db_1 = atum2_db_1

If is not at "Change the default database to:" as atum2_db_1
change to it.

Click Next
Then Finish
After Test.

If done correct press ok.

Do the same for db_account and db_arena.

Remember again

db_account = atum2_db_account
db_arena = atum2_db_arena
db_1 = atum2_db_1

After that, open again the server.

Tell me if you got the same problem.

If you still got, foxxzy@yahoo.com and ask me.

2 Attachment(s)

Re: [Guide] for ep 3.3

Quote:

Originally Posted by darkmandos

Errors in connections. Configs, the pass between the config thru the database...

Your config it's messed up.

make sure You give to "atum" sysadmin in SQL Server, after take ur Local ip address from global.cfg and log in to SQL Server in Server name : the ip with id : atum and pw: ur pw. when u are loged in,
In SQL Server Configuration Manager make sure at MSSQLSERVER you have the "Named Pipes" ENABLED and in TCP/IP you got the local ip address from global.cfg as enabled with the correct port.
After you have to restart the MSSQLSERVER from "services.msc"
When you done that, make sure also in global.cfg the odbc settings to arena and the other fields, are db_arena, db_1, db_account. when u done that open the ODBC. Create if you don't have db_arena db_1 and db_account and delete the other ones that are there.

db_arena = atum2_db_arena
db_1 = atum2_db_1
db_account = atum2_db_account

Name: db_1
Description: u leave it blank
Server: put the local ip address from global.cfg

click next

Move to "With SQL Server authentification......"
Click on "Client Configuration"
"Dynamically determine port if is enabled take it off
If the port is 9979 and u run on 1433 change it.
Or vice versa.

Click Ok
Login ID: atum
Password: ur password that u are also loging in to the SQL Server.

Click next.

remember db_1 = atum2_db_1

If is not at "Change the default database to:" as atum2_db_1
change to it.

Click Next
Then Finish
After Test.

If done correct press ok.

Do the same for db_account and db_arena.

Remember again

db_account = atum2_db_account
db_arena = atum2_db_arena
db_1 = atum2_db_1

After that, open again the server.

Tell me if you got the same problem.

If you still got, foxxzy@yahoo.com and ask me.

Reconfigured all over again, everything runs without errors but fieldserver

Re: [Guide] for ep 3.3

How to create ODBC WIN7 (64)?
C:\Windows\SysWOW64\odbcad32.exe or C:\Windows\System32\odbcad32.exe? User DNS or System DNS?

Re: [Guide] for ep 3.3

doesnt matter where u put the db_1 db_account and db_arena

But put them in to System DNS.
Doesn't matter what kind of odbc. Just ODBC To be.

Re: [Guide] for ep 3.3

It matters,
as far as i know it has to be in the SysWOW64 one

4 Attachment(s)

Re: [Guide] for ep 3.3

Quote:

Originally Posted by darkmandos

doesnt matter where u put the db_1 db_account and db_arena

But put them in to System DNS.
Doesn't matter what kind of odbc. Just ODBC To be.

What's the problem? (

http://forum.ragezone.com/attachment...1&d=1321792802
http://forum.ragezone.com/attachment...1&d=1321792802
http://forum.ragezone.com/attachment...1&d=1321792802

Attachment 94045

Re: [Guide] for ep 3.3

Would someone explain to me how to set up the OBDC's...
Because it doesn't let me use atum or any other possibility so I can't press next, only works with NT authentication
Also I can't login to SQL with atum and callweb

1 Attachment(s)

Re: [Guide] for ep 3.3

Also is my global.cfg correct?

Re: [Guide] for ep 3.3

Hi Dark!
After follow your guides I make my server running smoothly, but I got some problem, after setting the day and time for Strategy Point in Admin Tool, they still dun wanna come out, I swear I was not treat they badly :(

Please help me some clue to fix this bug.

Thank you!

Re: [Guide] for ep 3.3

[...]
$LOCAL_IP_ADDR = put here ur local ip (ex: 192.168.25.10)
$LOCAL_PUBLIC_IP_ADDR = 73.128.265.001 -(here you put your external IP in case u want to run it globally. Or just the hamachi.
$ARENA_IP_ADDR = $LOCAL_PUBLIC_IP_ADDR -Arena to work, globally, I puted here the external IP.
$WEBSRV_IP_ADDR = $LOCAL_IP_ADDR
$FTPSRV_IP_ADDR = $LOCAL_IP_ADDR
$IS_ARENA_SERVER = FALSE
$SERVER_GROUP_NAME = YourServerGroupName
$LANGUAGE_TYPE = 1
[...]

And try to take out from configs the infos :| that i puted them there ffs.
-(for hamachi) or u can put here ur local ip (ex: 192.168.25.10)

-(here you put your external IP in case u want to run it globally. Or just $LOCAL_IP_ADDR for hamachi.

-Arena to work, globally, I puted here the external IP.

Quote:

Originally Posted by somine

Hi Dark!
After follow your guides I make my server running smoothly, but I got some problem, after setting the day and time for Strategy Point in Admin Tool, they still dun wanna come out, I swear I was not treat they badly :(

Please help me some clue to fix this bug.

Thank you!

If the guide helped you, means that your server is running as you said, smoothly.
This guide it's only for making a server to run.
Not to fix bugs. Only errors before starting the server.

Are other threads that are helping to fix the bugs, only thing you have to do is to search.

Re: [Guide] for ep 3.3

Quote:

Originally Posted by ac777

Reconfigured all over again, everything runs without errors but fieldserver

this field server error is the date was expired on your declationwar table
go on declation war table and put the date for futur:thumbup:

1 Attachment(s)

Re: [Guide] for ep 3.3

changed all the local ip (192.168.1.3) ip in this database comes from the normal port 1433, but FieldServer an error ((
Here are my logs, may in another problem?

Re: [Guide] for ep 3.3

11-20 23:46:57|ServerGroupName(YourServerGroupName) IMServer(10.102.248.158), PeerIPPort[192.168.1.3:57348] registeration done...

Why you don't delete the all unnecessary infos from the config files? which means global.cfg?
And not only these from down. For example the 11-20 23:46:57|ServerGroupName(YourServerGroupName)

And try to take out from configs the infos :| that i puted them there ffs.
-(for hamachi) or u can put here ur local ip (ex: 192.168.25.10)

-(here you put your external IP in case u want to run it globally. Or just $LOCAL_IP_ADDR for hamachi.

-Arena to work, globally, I puted here the external IP.

add me on yahoo. foxxzy@yahoo.com

Re: [Guide] for ep 3.3

Quote:

Originally Posted by jison

this field server error is the date was expired on your declationwar table
go on declation war table and put the date for futur:thumbup:

This helped the server is running!
Thank you very much:)

Re: [Guide] for ep 3.3

darkmandos hello if you have time, I'm still waiting for your help to install SQL, you remember you told me you? I know you always have to do to help many people but you can just call me in msn? Tantop my contact there lai m1ster_b1t@hotmail.it

Re: [Guide] for ep 3.3

can i need a obdc arena for that ?

Re: [Guide] for ep 3.3

well if u replace the atum_dns_odbc and all the shits from inside the global.cfg + from inside the odbc, in to db_1, db_account and db_arena, yes you will need in odbc :P

Re: [Guide] for ep 3.3

So erm... Idk.
Ran up on a few errors. Looked over everything and found no fix. Skype/msn messenger would fix this all faster but i've got time so doesnt matter to me.

ps; Dont tell me to search. I have looked over everything, and tried everything more than once... -,-
PreServer.exe

Code:

11-27 18:28:54|[Notify] elapsed time after turn on !! 1Day 8h:36m:32s 11-27 18:28:54|Pre Server Start 11-27 18:28:54|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 100] CommitSize[ 151552] vectorSize[1] Address Range(0x7EF80000 ~ 0x7EFA5000) 11-27 18:28:54|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[ 101] CommitSize[ 155648] vectorSize[1] Address Range(0x7EF50000 ~ 0x7EF76000) 11-27 18:28:54|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[15001] CommitSize[23281664] vectorSize[1] Address Range(0x7D910000 ~ 0x7EF44000) 11-27 18:28:54| ServerGroup: PANDEA, Enable(1) MGameServerID(10061) 11-27 18:28:55| [Notify] CPreGlobal::OnPacketNotifyOfSPToMPWinSoc# 10000 CWinSocket::WS_CONNECTED wParam(0) 11-27 18:28:55| [Notify] CPreGlobal::InitServerSocket# Starting... 11-27 18:28:55| [Notify] CPreIOCP::IOCPInit# 10000 11-27 18:28:55| [Notify] CPreIOCP::IOCPInit# 11000 updated version files ! 11-27 18:28:55| [Notify] CPreIOCP::IOCPInit# 12000 arranged version list ! 11-27 18:29:12|[DB Error] fail to connect DBServer(CPreIOCP::IOCPInit_) !! 5.60.137.114,9979 atum2_db_account 11-27 18:29:15|[Error] PreServer IOCPInit Error 11-27 18:29:16|[ERROR] CPreGlobal::OnPacketNotifyOfSPToMPWinSoc_ InitServerSocket_ error !!11-27 18:29:17| [Notify] CPreGlobal::EndServerSocket# 11-27 18:29:17|CGlobalGameServer::EndServerSocket_1 11-27 18:29:17|######################## Server IOCPClean ######################## 11-27 18:29:17|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1508] TotalCommitedObjCnts( 100) CurrentObjCnts( 100) 11-27 18:29:17|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1528] TotalCommitedObjCnts( 101) CurrentObjCnts( 101) 11-27 18:29:17|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1552] TotalCommitedObjCnts( 15001) CurrentObjCnts( 15001) 11-27 18:29:17|Pre Server End 11-27 18:29:17|CGlobalGameServer::EndServerSocket_1

global.cfg

Code:

################################################################################ # # $LOCAL_IP_ADDR : local computer IP(All server edit) # $SERVER_GROUP_NAME : set ServerGruop(IM, Field server edit), Max 19Bytes # $LANGUAGE_TYPE : set language load Text field of DB # # #define LANGUAGE_TYPE_UNKNOWN -1 # #define LANGUAGE_TYPE_KOREAN 0 # #define LANGUAGE_TYPE_ENGLISH 1 # #define LANGUAGE_TYPE_JAPANESE 2 # #define LANGUAGE_TYPE_CHINESE 3 # #define LANGUAGE_TYPE_VIETNAMESE 4 # ################################################################################ $LOCAL_IP_ADDR = 5.60.137.114 $LOCAL_PUBLIC_IP_ADDR = $LOCAL_IP_ADDR $ALLOWED_TOOL_IP = $LOCAL_IP_ADDR $SERVER_GROUP_NAME = PANDEA $LANGUAGE_TYPE = 1 ################################################################################ # ServerGroupList ################################################################################ $SERVER_GROUP_NAME_1 = PANDEA $SERVER_GROUP_NAME_2 = 1 $SERVER_GROUP_NAME_3 = 2 $SERVER_GROUP_NAME_4 = 3 $SERVER_GROUP_NAME_5 = 4 $SERVER_GROUP_NAME_6 = 5 $SERVER_GROUP_NAME_7 = 6 $SERVER_GROUP_NAME_8 = 7 $SERVER_GROUP_NAME_9 = 8 $SERVER_GROUP_NAME_10 = 9 $SERVER_GROUP_NAME_11 = 11 $SERVER_GROUP_NAME_12 = 12 $SERVER_GROUP_NAME_13 = 13 $SERVER_GROUP_NAME_14 = 14 $SERVER_GROUP_NAME_15 = 15 $SERVER_GROUP_NAME_16 = 16 $SERVER_GROUP_NAME_17 = 17 $SERVER_GROUP_NAME_18 = 18 $SERVER_GROUP_NAME_19 = 19 $SERVER_GROUP_NAME_20 = 21 $MGAME_SERVER_ID_1 = 10061 $MGAME_SERVER_ID_2 = 10062 $MGAME_SERVER_ID_3 = 10063 $MGAME_SERVER_ID_4 = 10064 $MGAME_SERVER_ID_5 = 10065 $MGAME_SERVER_ID_6 = 10066 $MGAME_SERVER_ID_7 = 10067 $MGAME_SERVER_ID_8 = 10068 $MGAME_SERVER_ID_9 = 10069 $MGAME_SERVER_ID_10 = 10070 $MGAME_SERVER_ID_11 = 10071 $MGAME_SERVER_ID_12 = 10072 $MGAME_SERVER_ID_13 = 10073 $MGAME_SERVER_ID_14 = 10074 $MGAME_SERVER_ID_15 = 10075 $MGAME_SERVER_ID_16 = 10076 $MGAME_SERVER_ID_17 = 10077 $MGAME_SERVER_ID_18 = 10078 $MGAME_SERVER_ID_19 = 10079 $MGAME_SERVER_ID_20 = 10080 ################################################################################ # PreServer Group List # [ServerGroupName] [ServerGroupIP] [OrderIndex] ################################################################################ $$GAME_SERVER_GROUP_NAME1 = MainServer $LOCAL_IP_ADDR 1 $$GAME_SERVER_GROUP_NAME2 = $$GAME_SERVER_GROUP_NAME3 = $$GAME_SERVER_GROUP_NAME4 = $$GAME_SERVER_GROUP_NAME5 = ################################################################################ # 2010-12-12 by PanKJ # ServerGroupInfos # [ServerName] [ServerID] [Enabled] ################################################################################ $$SERVER_GROUP_INFO1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE $$SERVER_GROUP_INFO2 = $$SERVER_GROUP_INFO3 = $$SERVER_GROUP_INFO4 = $$SERVER_GROUP_INFO5 = ################################################################################ # Each Server's IP ################################################################################ $PRE_SERVER_IP = $LOCAL_IP_ADDR $IM_SERVER_IP = $LOCAL_IP_ADDR $LOG_SERVER_IP = $LOCAL_IP_ADDR $FIELD_SERVER_IP = $LOCAL_IP_ADDR $NPC_SERVER_IP = $LOCAL_IP_ADDR $VD_SERVER_IP = $LOCAL_IP_ADDR $VC_SERVER_IP = $LOCAL_IP_ADDR ################################################################################ # Default Listening Ports ################################################################################ $PRE_SERVER_PORT = 15100 $IM_SERVER_PORT = 15101 $LOG_SERVER_PORT = 15102 $FIELD_SERVER_PORT = 15103 $NPC_SERVER_PORT = 15104 $VD_SERVER_PORT = 15150 $VC_SERVER_PORT = 15151 ################################################################################ # VoIP Server Settings(PCCallAgent) ################################################################################ $VOIP_1to1_SERVER_IP = $LOCAL_IP_ADDR $VOIP_1to1_SERVER_PORT = 15152 $VOIP_NtoN_SERVER_IP = $LOCAL_IP_ADDR $VOIP_NtoN_SERVER_PORT = 15150 ################################################################################ # client update ignore Flag, Warning: certainly set FALSE when real service!!! ################################################################################ $INGNORE_CLIENT_VERSION_UPDATE = TRUE ################################################################################ # Log server connect flag, Warning: certainly set TRUE when real service!!! ################################################################################ $CHECK_LOG_SERVER = TRUE ################################################################################ # Test Server Flag ################################################################################ $IS_TEST_SERVER = FALSE $MAIN_OR_TEST_SERVER_NAME = MainServer $GAME_PUBLISHER = GameForge4d ################################################################################ # Jamboree Server Flag ################################################################################ $IS_JAMBOREE_SERVER = FALSE ################################################################################ # Only Choice Server Flag ################################################################################ $IS_ONLY_CHOICE_SERVER = FALSE ################################################################################ # Server Group Limite User Count ################################################################################ $SERVER_GROUP_LIMITE_USER_COUNT = 10 ################################################################################ # Cash Shop Service Flag ################################################################################ $CASH_SHOP_SERVICE_FLAG = TRUE ################################################################################ # Use SecondaryPassword System Flag ################################################################################ $USE_SECONDARYPASSWORD_SYSTEM_FLAG = FALSE ################################################################################ # Arena Server Flag ################################################################################ ################################################################################ # Auto Update Settings # FTP or HTTP ############################################################################ $AUTO_UPDATE_SERVER_TYPE = HTTP $UPLOAD_FTP_SERVER_IP = 72.219.28.30 $UPLOAD_FTP_SERVER_PORT = 21 $UPLOAD_FTP_SERVER_ACCOUNT = atum $UPLOAD_FTP_SERVER_PASSWORD = callweb $DOWNLOAD_FTP_SERVER_IP1 = 72.219.28.30 $DOWNLOAD_FTP_SERVER_IP2 = 72.219.28.30 $DOWNLOAD_FTP_SERVER_PORT = 21 $DOWNLOAD_FTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_FTP_SERVER_PASSWORD = $CLIENT_FTP_UPDATE_UPLOAD_DIR = //aceonliine/flysis $LAUNCHER_FILE_UPLOAD_PATH = //aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_UPLOAD_PATH = //aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_UPLOAD_PATH = //aceonliine/notice/notice.txt $VERSION_LIST_FILE_UPLOAD_PATH = //aceonliine/flysis/versionlist.ver $CLIENT_FTP_UPDATE_DOWNLOAD_DIR = //aceonliine/flysis $LAUNCHER_FILE_DOWNLOAD_PATH = //aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_PATH = //aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_PATH = //aceonliine/notice/notice.txt $DOWNLOAD_HTTP_SERVER_IP1 = 127.0.0.1 $DOWNLOAD_HTTP_SERVER_IP2 = 127.0.0.1 $DOWNLOAD_HTTP_SERVER_PORT = 80 $DOWNLOAD_HTTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_HTTP_SERVER_PASSWORD = $CLIENT_UPDATE_DOWNLOAD_HTTP_DIR = aceonliine/ $LAUNCHER_FILE_DOWNLOAD_HTTP_PATH = aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_HTTP_PATH = aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_HTTP_PATH = aceonliine/notice/notice.txt $VERSION_LIST_FILE_DOWNLOAD_HTTP_PATH = aceonliine/versionlist.ver ################################################################################ # ReInstall Version:(previous version of new download version), Default = 1.0.0.0 ################################################################################ $CLIENT_REINSTALL_VERSION = 0.0.0.0 ################################################################################ # Default Map ################################################################################ $SERVER_GROUP_DEFAULT_MAP = 2001 ################################################################################ # Database Settings 1 - PreServer ################################################################################ $PRE_ODBC_DSN = $PRE_ODBC_UID = $PRE_ODBC_PASSWD = $PRE_DB_SERVER_DATABASE_NAME = atum2_db_account $PRE_DB_SERVER_IP = 5.60.137.114 $PRE_DB_SERVER_PORT = 9979 ################################################################################ # Database Settings 2 - ServerGroup(IMServer, FieldServer, LogServer, NPCServer) ################################################################################ $SERVER_GROUP_ODBC_DSN = $SERVER_GROUP_ODBC_UID = $SERVER_GROUP_ODBC_PASSWD = $SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $SERVER_GROUP_DB_SERVER_IP = 5.60.137.114 $SERVER_GROUP_DB_SERVER_PORT = 9979 ################################################################################ # Database Settings 3 - Log DB Server(LogServer) ################################################################################ $LOG_SERVER_GROUP_ODBC_DSN = $LOG_SERVER_GROUP_ODBC_UID = $LOG_SERVER_GROUP_ODBC_PASSWD = $LOG_SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $LOG_SERVER_GROUP_DB_SERVER_IP = 5.60.137.114 $LOG_SERVER_GROUP_DB_SERVER_PORT = 9979 ################################################################################ # Database Settings 3 - External Authentication ################################################################################ $IS_EXTERNAL_AUTHENTICATION = FALSE $EXT_AUTH_ODBC_DSN = $EXT_AUTH_ODBC_UID = $EXT_AUTH_ODBC_PASSWD = $EXT_AUTH_DB_SERVER_DATABASE_NAME = $EXT_AUTH_DB_SERVER_IP = $EXT_AUTH_DB_SERVER_PORT = ################################################################################ # Database Settings 4 - Billing Database ################################################################################ # $BILLING_DB_SERVER_USER_ID = # $BILLING_DB_SERVER_PASSWORD = # $BILLING_DB_SERVER_DATABASE_NAME = atum2_db_1 # $BILLING_DB_SERVER_IP = 5.60.137.114 # $BILLING_DB_SERVER_PASSWORD = 9979

1 Attachment(s)

Re: [Guide] for ep 3.3

I u don`t see atum in your odbc usee this.. 2 files use the proper one.

for PCCallAgent u have to edit the reg file and set path to your server PCCallAgent eg: d:Server/ace/... etc

Re: [Guide] for ep 3.3

the global.cfg from where did u got it? It seems it's not the 3.3 one :-??

Where is the config of Arena?

And some things u made wrong... read again the steps of odbc and what u have to put and change.

$SERVER_GROUP_LIMITE_USER_COUNT = 10 <---- change it in to lets say 1000 peoples.

Re: [Guide] for ep 3.3

the global.cfg i got from PanJK somewhere around here that has been modified several times by people to make it work better?
I think it was in the developement section.
But!
http://forum.ragezone.com/f614/guide...logins-717947/
I followed that and it made me realize that maybe a problem comes from my password starting with a $ sign and then some letters and numbers.
Because in the global Config that redirects to another point when something has $ signs in it right?

Either way; Im not woried about the limit user count. At most it'd be 3-5 people just messing around. Arena isn't in it; neither is the database in my sql server. Im thinking of a full restart of it all because i've changed so many things-so many times; not sure if any of its even fixable anymore from this point...

--EDIT--
So It turned out to be a few slightly stupid errors resulting from not having the right log in-information to not being able to pass through that port = so i changed it back to 1433 and had success.
Preserver.exe = working
IMserver.exe = working
LogServer.exe = not working
FieldServer.exe = --not tried--
NPCServer.exe = --not tried--

LogServer.exe;

Code:

11-28 20:10:50|[Notify] elapsed time after turn on !! 0Day 0h:59m:30s 11-28 20:10:50|Log Server Start 11-28 20:10:50|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[10002] CommitSize[15523840] vectorSize[1] Address Range(0x7E0E0000 ~ 0x7EFAE000) 11-28 20:10:50| [Notify] CLogGlobal::InitServerSocket# Starting... 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1912, 0x778) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1976, 0x7B8) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2700, 0xA8C) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2368, 0x940) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1076, 0x434) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1804, 0x70C) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1980, 0x7BC) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1104, 0x450) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1140, 0x474) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2000, 0x7D0) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2984, 0xBA8) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2300, 0x8FC) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2732, 0xAAC) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2940, 0xB7C) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1320, 0x528) 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:08|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:08|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:08|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:08|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:22|[Error] CAtumDBManager::Init IsReadyAtumDBManager() Error 11-28 20:11:23|[Error] LogServer IOCPInit Error 11-28 20:11:24|[ERROR] LogServer call InitServerSocket() error !! 11-28 20:12:03| [Notify] CLogGlobal::EndServerSocket# 11-28 20:12:03|CGlobalGameServer::EndServerSocket_1 11-28 20:12:03|######################## Server IOCPClean ######################## 11-28 20:12:03|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1552] TotalCommitedObjCnts( 10002) CurrentObjCnts( 10002) 11-28 20:12:03|Log Server End 11-28 20:12:03| [Notify] CLogGlobal::EndServerSocket# 11-28 20:12:03|CGlobalGameServer::EndServerSocket_1 11-28 20:12:03|CGlobalGameServer::EndServerSocket_1

Global.cfg

Code:

################################################################################ # # $LOCAL_IP_ADDR : local computer IP(All server edit) # $SERVER_GROUP_NAME : set ServerGruop(IM, Field server edit), Max 19Bytes # $LANGUAGE_TYPE : set language load Text field of DB # # #define LANGUAGE_TYPE_UNKNOWN -1 # #define LANGUAGE_TYPE_KOREAN 0 # #define LANGUAGE_TYPE_ENGLISH 1 # #define LANGUAGE_TYPE_JAPANESE 2 # #define LANGUAGE_TYPE_CHINESE 3 # #define LANGUAGE_TYPE_VIETNAMESE 4 # ################################################################################ $LOCAL_IP_ADDR = 5.60.137.114 $LOCAL_PUBLIC_IP_ADDR = $LOCAL_IP_ADDR $ALLOWED_TOOL_IP = $LOCAL_IP_ADDR $SERVER_GROUP_NAME = PANDEA $LANGUAGE_TYPE = 1 ################################################################################ # ServerGroupList ################################################################################ $SERVER_GROUP_NAME_1 = PANDEA $SERVER_GROUP_NAME_2 = 1 $SERVER_GROUP_NAME_3 = 2 $SERVER_GROUP_NAME_4 = 3 $SERVER_GROUP_NAME_5 = 4 $SERVER_GROUP_NAME_6 = 5 $SERVER_GROUP_NAME_7 = 6 $SERVER_GROUP_NAME_8 = 7 $SERVER_GROUP_NAME_9 = 8 $SERVER_GROUP_NAME_10 = 9 $SERVER_GROUP_NAME_11 = 11 $SERVER_GROUP_NAME_12 = 12 $SERVER_GROUP_NAME_13 = 13 $SERVER_GROUP_NAME_14 = 14 $SERVER_GROUP_NAME_15 = 15 $SERVER_GROUP_NAME_16 = 16 $SERVER_GROUP_NAME_17 = 17 $SERVER_GROUP_NAME_18 = 18 $SERVER_GROUP_NAME_19 = 19 $SERVER_GROUP_NAME_20 = 21 $MGAME_SERVER_ID_1 = 10061 $MGAME_SERVER_ID_2 = 10062 $MGAME_SERVER_ID_3 = 10063 $MGAME_SERVER_ID_4 = 10064 $MGAME_SERVER_ID_5 = 10065 $MGAME_SERVER_ID_6 = 10066 $MGAME_SERVER_ID_7 = 10067 $MGAME_SERVER_ID_8 = 10068 $MGAME_SERVER_ID_9 = 10069 $MGAME_SERVER_ID_10 = 10070 $MGAME_SERVER_ID_11 = 10071 $MGAME_SERVER_ID_12 = 10072 $MGAME_SERVER_ID_13 = 10073 $MGAME_SERVER_ID_14 = 10074 $MGAME_SERVER_ID_15 = 10075 $MGAME_SERVER_ID_16 = 10076 $MGAME_SERVER_ID_17 = 10077 $MGAME_SERVER_ID_18 = 10078 $MGAME_SERVER_ID_19 = 10079 $MGAME_SERVER_ID_20 = 10080 ################################################################################ # PreServer Group List # [ServerGroupName] [ServerGroupIP] [OrderIndex] ################################################################################ $$GAME_SERVER_GROUP_NAME1 = MainServer $LOCAL_IP_ADDR 1 $$GAME_SERVER_GROUP_NAME2 = $$GAME_SERVER_GROUP_NAME3 = $$GAME_SERVER_GROUP_NAME4 = $$GAME_SERVER_GROUP_NAME5 = ################################################################################ # 2010-12-12 by PanKJ # ServerGroupInfos # [ServerName] [ServerID] [Enabled] ################################################################################ $$SERVER_GROUP_INFO1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE $$SERVER_GROUP_INFO2 = $$SERVER_GROUP_INFO3 = $$SERVER_GROUP_INFO4 = $$SERVER_GROUP_INFO5 = ################################################################################ # Each Server's IP ################################################################################ $PRE_SERVER_IP = $LOCAL_IP_ADDR $IM_SERVER_IP = $LOCAL_IP_ADDR $LOG_SERVER_IP = $LOCAL_IP_ADDR $FIELD_SERVER_IP = $LOCAL_IP_ADDR $NPC_SERVER_IP = $LOCAL_IP_ADDR $VD_SERVER_IP = $LOCAL_IP_ADDR $VC_SERVER_IP = $LOCAL_IP_ADDR ################################################################################ # Default Listening Ports ################################################################################ $PRE_SERVER_PORT = 15100 $IM_SERVER_PORT = 15101 $LOG_SERVER_PORT = 15102 $FIELD_SERVER_PORT = 15103 $NPC_SERVER_PORT = 15104 $VD_SERVER_PORT = 15150 $VC_SERVER_PORT = 15151 ################################################################################ # VoIP Server Settings(PCCallAgent) ################################################################################ $VOIP_1to1_SERVER_IP = $LOCAL_IP_ADDR $VOIP_1to1_SERVER_PORT = 15152 $VOIP_NtoN_SERVER_IP = $LOCAL_IP_ADDR $VOIP_NtoN_SERVER_PORT = 15150 ################################################################################ # client update ignore Flag, Warning: certainly set FALSE when real service!!! ################################################################################ $INGNORE_CLIENT_VERSION_UPDATE = TRUE ################################################################################ # Log server connect flag, Warning: certainly set TRUE when real service!!! ################################################################################ $CHECK_LOG_SERVER = TRUE ################################################################################ # Test Server Flag ################################################################################ $IS_TEST_SERVER = FALSE $MAIN_OR_TEST_SERVER_NAME = MainServer $GAME_PUBLISHER = GameForge4d ################################################################################ # Jamboree Server Flag ################################################################################ $IS_JAMBOREE_SERVER = FALSE ################################################################################ # Only Choice Server Flag ################################################################################ $IS_ONLY_CHOICE_SERVER = FALSE ################################################################################ # Server Group Limite User Count ################################################################################ $SERVER_GROUP_LIMITE_USER_COUNT = 1000 ################################################################################ # Cash Shop Service Flag ################################################################################ $CASH_SHOP_SERVICE_FLAG = TRUE ################################################################################ # Use SecondaryPassword System Flag ################################################################################ $USE_SECONDARYPASSWORD_SYSTEM_FLAG = FALSE ################################################################################ # Arena Server Flag ################################################################################ ################################################################################ # Auto Update Settings # FTP or HTTP ############################################################################ $AUTO_UPDATE_SERVER_TYPE = HTTP $UPLOAD_FTP_SERVER_IP = 72.219.28.30 $UPLOAD_FTP_SERVER_PORT = 21 $UPLOAD_FTP_SERVER_ACCOUNT = atum $UPLOAD_FTP_SERVER_PASSWORD = callweb $DOWNLOAD_FTP_SERVER_IP1 = 72.219.28.30 $DOWNLOAD_FTP_SERVER_IP2 = 72.219.28.30 $DOWNLOAD_FTP_SERVER_PORT = 21 $DOWNLOAD_FTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_FTP_SERVER_PASSWORD = $CLIENT_FTP_UPDATE_UPLOAD_DIR = //aceonliine/flysis $LAUNCHER_FILE_UPLOAD_PATH = //aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_UPLOAD_PATH = //aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_UPLOAD_PATH = //aceonliine/notice/notice.txt $VERSION_LIST_FILE_UPLOAD_PATH = //aceonliine/flysis/versionlist.ver $CLIENT_FTP_UPDATE_DOWNLOAD_DIR = //aceonliine/flysis $LAUNCHER_FILE_DOWNLOAD_PATH = //aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_PATH = //aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_PATH = //aceonliine/notice/notice.txt $DOWNLOAD_HTTP_SERVER_IP1 = 127.0.0.1 $DOWNLOAD_HTTP_SERVER_IP2 = 127.0.0.1 $DOWNLOAD_HTTP_SERVER_PORT = 80 $DOWNLOAD_HTTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_HTTP_SERVER_PASSWORD = $CLIENT_UPDATE_DOWNLOAD_HTTP_DIR = aceonliine/ $LAUNCHER_FILE_DOWNLOAD_HTTP_PATH = aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_HTTP_PATH = aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_HTTP_PATH = aceonliine/notice/notice.txt $VERSION_LIST_FILE_DOWNLOAD_HTTP_PATH = aceonliine/versionlist.ver ################################################################################ # ReInstall Version:(previous version of new download version), Default = 1.0.0.0 ################################################################################ $CLIENT_REINSTALL_VERSION = 0.0.0.0 ################################################################################ # Default Map ################################################################################ $SERVER_GROUP_DEFAULT_MAP = 2001 ################################################################################ # Database Settings 1 - PreServer ################################################################################ $PRE_ODBC_DSN = atum2_db_account $PRE_ODBC_UID = atum $PRE_ODBC_PASSWD = ADMINISTRATOR123lolz $PRE_DB_SERVER_DATABASE_NAME = atum2_db_account $PRE_DB_SERVER_IP = 5.60.137.114 $PRE_DB_SERVER_PORT = 1433 ################################################################################ # Database Settings 2 - ServerGroup(IMServer, FieldServer, LogServer, NPCServer) ################################################################################ $SERVER_GROUP_ODBC_DSN = atum2_db_1 $SERVER_GROUP_ODBC_UID = atum $SERVER_GROUP_ODBC_PASSWD = ADMINISTRATOR123lolz $SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $SERVER_GROUP_DB_SERVER_IP = 5.60.137.114 $SERVER_GROUP_DB_SERVER_PORT = 1433 ################################################################################ # Database Settings 3 - Log DB Server(LogServer) ################################################################################ $LOG_SERVER_GROUP_ODBC_DSN = atum2_db_1 $LOG_SERVER_GROUP_ODBC_UID = atum $LOG_SERVER_GROUP_ODBC_PASSWD = ADMINISTRATOR123lolz $LOG_SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $LOG_SERVER_GROUP_DB_SERVER_IP = 5.60.137.114 $LOG_SERVER_GROUP_DB_SERVER_PORT = 1433 ################################################################################ # Database Settings 3 - External Authentication ################################################################################ $IS_EXTERNAL_AUTHENTICATION = FALSE $EXT_AUTH_ODBC_DSN = $EXT_AUTH_ODBC_UID = $EXT_AUTH_ODBC_PASSWD = $EXT_AUTH_DB_SERVER_DATABASE_NAME = $EXT_AUTH_DB_SERVER_IP = $EXT_AUTH_DB_SERVER_PORT = ################################################################################ # Database Settings 4 - Billing Database ################################################################################ # $BILLING_DB_SERVER_USER_ID = atum # $BILLING_DB_SERVER_PASSWORD = ADMINISTRATOR123lolz # $BILLING_DB_SERVER_DATABASE_NAME = atum2_db_1 # $BILLING_DB_SERVER_IP = 5.60.137.114 # $BILLING_DB_SERVER_PASSWORD = 1433

PS; I have no Arena. Appearently its not necassary...?

1 Attachment(s)

Re: [Guide] for ep 3.3

AirRivalsEN client generates this error when starting
http://forum.ragezone.com/attachment...1&d=1322587515
:(:

Re: [Guide] for ep 3.3

What i can say is u dont need odbc for make server run, just use same way for pankj files remake golbal for make it work wt odbc, check all bc some file use xored id and pass or not, check server flag code, server name num. etc, give all privile to arena db, change port to 9979, same for server group info "the number".

Re: [Guide] for ep 3.3

It seems that some peoples understand what they have to make from this guide so a ep 3.3 to work ok. Some other not.

freebook21.. you make that guy to change the entire configs which means, he won't succed.

2 Attachment(s)

Re: [Guide] for ep 3.3

darkmandos..
i got this error after i follow all the guide u post and i already figure out for about few days to make it work but seems like i cant make it at all...
when im start all the server application i got this error..

http://www.postimg.com/image/54000/photo-53385.jpg http://www.postimg.com/thumbs/54000/photo-53385.jpg

here my cofig.cfg and my log files.
can u help me to get rid with this error?
i know i got a problem with the config but im had no idea where the error.. :?:

Re: [Guide] for ep 3.3

Quote:

Originally Posted by DarkSk8er

darkmandos..
i got this error after i follow all the guide u post and i already figure out for about few days to make it work but seems like i cant make it at all...
when im start all the server application i got this error..
-------
here my cofig.cfg and my log files.
can u help me to get rid with this error?
i know i got a problem with the config but im had no idea where the error.. :?:

1.BAD

ServerGroupInfo List
# Syntax = [ServerName] [ServerId] [Enable]
#############################################################################
$$SERVER_GROUP_INFO_1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE
$$SERVER_GROUP_INFO_2 = $SERVER_GROUP_NAME_2 $MGAME_SERVER_ID_2 FALSE
$$SERVER_GROUP_INFO_3 = $SERVER_GROUP_NAME_3 $MGAME_SERVER_ID_3 FALSE
$$SERVER_GROUP_INFO_4 = $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 FALSE

//preserver log
bad
11-30 03:48:10|[Error] CPreIOCP::LoadAllServers# error !! ServerGroupInfo $$SERVER_GROUP_INFO_2

2 --change

ServerGroupInfo List
# Syntax = [ServerName] [ServerId] [Enable]
#############################################################################
$$SERVER_GROUP_INFO_1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE
$$SERVER_GROUP_INFO_2 = $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 TRUE

Remember
step by step run processes.
run - preserwer check log
run -log serwer check log
run - im serwer check log
run - FieldServer check loog .
wait for the server start !!!!!-------"eliminates peoblem / arena -
[Error] CMapWorkspace::LoadAllProject_3 Can't InitMapProject, ProjectName[2001]
| [Error] CMapWorkspace::LoadAllProject_3 Can't InitMapProject, ProjectName[2002]

next run npc or

aimserwer - check log
alogservr - check log
arenaserver - check log
waith
run anpcserver
*run npcserver
sory bad english

Re: [Guide] for ep 3.3

Quote:

1.BAD

ServerGroupInfo List
# Syntax = [ServerName] [ServerId] [Enable]
#############################################################################
$$SERVER_GROUP_INFO_1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE
$$SERVER_GROUP_INFO_2 = $SERVER_GROUP_NAME_2 $MGAME_SERVER_ID_2 FALSE This 2 YOU GOT TAKE THEM OUT that are with red
$$SERVER_GROUP_INFO_3 = $SERVER_GROUP_NAME_3 $MGAME_SERVER_ID_3 FALSE
$$SERVER_GROUP_INFO_4 = $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 FALSE

//preserver log
bad
11-30 03:48:10|[Error] CPreIOCP::LoadAllServers# error !! ServerGroupInfo $$SERVER_GROUP_INFO_2

2 --change

ServerGroupInfo List
# Syntax = [ServerName] [ServerId] [Enable]
#############################################################################
$$SERVER_GROUP_INFO_1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE
$$SERVER_GROUP_INFO_4 = $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 TRUE

and also $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 this put in on $$SERVER_GROUP_INFO_2

Re: [Guide] for ep 3.3

my mistake
. corrected my post
thx darkmandos

Re: [Guide] for ep 3.3

Quote:

Originally Posted by gozo333

my mistake
. corrected my post
thx darkmandos

You welcome.

Re: [Guide] for ep 3.3

Quote:

Originally Posted by TKTAB911

the global.cfg i got from PanJK somewhere around here that has been modified several times by people to make it work better?
I think it was in the developement section.
But!
http://forum.ragezone.com/f614/guide...logins-717947/
I followed that and it made me realize that maybe a problem comes from my password starting with a $ sign and then some letters and numbers.
Because in the global Config that redirects to another point when something has $ signs in it right?

Either way; Im not woried about the limit user count. At most it'd be 3-5 people just messing around. Arena isn't in it; neither is the database in my sql server. Im thinking of a full restart of it all because i've changed so many things-so many times; not sure if any of its even fixable anymore from this point...

--EDIT--
So It turned out to be a few slightly stupid errors resulting from not having the right log in-information to not being able to pass through that port = so i changed it back to 1433 and had success.
Preserver.exe = working
IMserver.exe = working
LogServer.exe = not working
FieldServer.exe = --not tried--
NPCServer.exe = --not tried--

LogServer.exe;

Code:

11-28 20:10:50|[Notify] elapsed time after turn on !! 0Day 0h:59m:30s 11-28 20:10:50|Log Server Start 11-28 20:10:50|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[10002] CommitSize[15523840] vectorSize[1] Address Range(0x7E0E0000 ~ 0x7EFAE000) 11-28 20:10:50| [Notify] CLogGlobal::InitServerSocket# Starting... 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1912, 0x778) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1976, 0x7B8) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2700, 0xA8C) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2368, 0x940) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1076, 0x434) 11-28 20:10:50|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1804, 0x70C) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1980, 0x7BC) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1104, 0x450) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1140, 0x474) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2000, 0x7D0) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2984, 0xBA8) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2300, 0x8FC) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2732, 0xAAC) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 2940, 0xB7C) 11-28 20:10:51|CAtumDBManager::AtumDBWorker_ DWWorkerThread, ThreadID( 1320, 0x528) 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:06|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:06|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:07|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:07|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:08|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:08|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:08|[DB Error] fail to connect DBServer(CAtumDBManager::Connect2DBServer_) !! ,0 11-28 20:11:08|[Error] CAtumDBManager::Worker Connect2DBServer_1 Error 11-28 20:11:22|[Error] CAtumDBManager::Init IsReadyAtumDBManager() Error 11-28 20:11:23|[Error] LogServer IOCPInit Error 11-28 20:11:24|[ERROR] LogServer call InitServerSocket() error !! 11-28 20:12:03| [Notify] CLogGlobal::EndServerSocket# 11-28 20:12:03|CGlobalGameServer::EndServerSocket_1 11-28 20:12:03|######################## Server IOCPClean ######################## 11-28 20:12:03|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1552] TotalCommitedObjCnts( 10002) CurrentObjCnts( 10002) 11-28 20:12:03|Log Server End 11-28 20:12:03| [Notify] CLogGlobal::EndServerSocket# 11-28 20:12:03|CGlobalGameServer::EndServerSocket_1 11-28 20:12:03|CGlobalGameServer::EndServerSocket_1

Global.cfg

Code:

################################################################################ # # $LOCAL_IP_ADDR : local computer IP(All server edit) # $SERVER_GROUP_NAME : set ServerGruop(IM, Field server edit), Max 19Bytes # $LANGUAGE_TYPE : set language load Text field of DB # # #define LANGUAGE_TYPE_UNKNOWN -1 # #define LANGUAGE_TYPE_KOREAN 0 # #define LANGUAGE_TYPE_ENGLISH 1 # #define LANGUAGE_TYPE_JAPANESE 2 # #define LANGUAGE_TYPE_CHINESE 3 # #define LANGUAGE_TYPE_VIETNAMESE 4 # ################################################################################ $LOCAL_IP_ADDR = 5.60.137.114 $LOCAL_PUBLIC_IP_ADDR = $LOCAL_IP_ADDR $ALLOWED_TOOL_IP = $LOCAL_IP_ADDR $SERVER_GROUP_NAME = PANDEA $LANGUAGE_TYPE = 1 ################################################################################ # ServerGroupList ################################################################################ $SERVER_GROUP_NAME_1 = PANDEA $SERVER_GROUP_NAME_2 = 1 $SERVER_GROUP_NAME_3 = 2 $SERVER_GROUP_NAME_4 = 3 $SERVER_GROUP_NAME_5 = 4 $SERVER_GROUP_NAME_6 = 5 $SERVER_GROUP_NAME_7 = 6 $SERVER_GROUP_NAME_8 = 7 $SERVER_GROUP_NAME_9 = 8 $SERVER_GROUP_NAME_10 = 9 $SERVER_GROUP_NAME_11 = 11 $SERVER_GROUP_NAME_12 = 12 $SERVER_GROUP_NAME_13 = 13 $SERVER_GROUP_NAME_14 = 14 $SERVER_GROUP_NAME_15 = 15 $SERVER_GROUP_NAME_16 = 16 $SERVER_GROUP_NAME_17 = 17 $SERVER_GROUP_NAME_18 = 18 $SERVER_GROUP_NAME_19 = 19 $SERVER_GROUP_NAME_20 = 21 $MGAME_SERVER_ID_1 = 10061 $MGAME_SERVER_ID_2 = 10062 $MGAME_SERVER_ID_3 = 10063 $MGAME_SERVER_ID_4 = 10064 $MGAME_SERVER_ID_5 = 10065 $MGAME_SERVER_ID_6 = 10066 $MGAME_SERVER_ID_7 = 10067 $MGAME_SERVER_ID_8 = 10068 $MGAME_SERVER_ID_9 = 10069 $MGAME_SERVER_ID_10 = 10070 $MGAME_SERVER_ID_11 = 10071 $MGAME_SERVER_ID_12 = 10072 $MGAME_SERVER_ID_13 = 10073 $MGAME_SERVER_ID_14 = 10074 $MGAME_SERVER_ID_15 = 10075 $MGAME_SERVER_ID_16 = 10076 $MGAME_SERVER_ID_17 = 10077 $MGAME_SERVER_ID_18 = 10078 $MGAME_SERVER_ID_19 = 10079 $MGAME_SERVER_ID_20 = 10080 ################################################################################ # PreServer Group List # [ServerGroupName] [ServerGroupIP] [OrderIndex] ################################################################################ $$GAME_SERVER_GROUP_NAME1 = MainServer $LOCAL_IP_ADDR 1 $$GAME_SERVER_GROUP_NAME2 = $$GAME_SERVER_GROUP_NAME3 = $$GAME_SERVER_GROUP_NAME4 = $$GAME_SERVER_GROUP_NAME5 = ################################################################################ # 2010-12-12 by PanKJ # ServerGroupInfos # [ServerName] [ServerID] [Enabled] ################################################################################ $$SERVER_GROUP_INFO1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE $$SERVER_GROUP_INFO2 = $$SERVER_GROUP_INFO3 = $$SERVER_GROUP_INFO4 = $$SERVER_GROUP_INFO5 = ################################################################################ # Each Server's IP ################################################################################ $PRE_SERVER_IP = $LOCAL_IP_ADDR $IM_SERVER_IP = $LOCAL_IP_ADDR $LOG_SERVER_IP = $LOCAL_IP_ADDR $FIELD_SERVER_IP = $LOCAL_IP_ADDR $NPC_SERVER_IP = $LOCAL_IP_ADDR $VD_SERVER_IP = $LOCAL_IP_ADDR $VC_SERVER_IP = $LOCAL_IP_ADDR ################################################################################ # Default Listening Ports ################################################################################ $PRE_SERVER_PORT = 15100 $IM_SERVER_PORT = 15101 $LOG_SERVER_PORT = 15102 $FIELD_SERVER_PORT = 15103 $NPC_SERVER_PORT = 15104 $VD_SERVER_PORT = 15150 $VC_SERVER_PORT = 15151 ################################################################################ # VoIP Server Settings(PCCallAgent) ################################################################################ $VOIP_1to1_SERVER_IP = $LOCAL_IP_ADDR $VOIP_1to1_SERVER_PORT = 15152 $VOIP_NtoN_SERVER_IP = $LOCAL_IP_ADDR $VOIP_NtoN_SERVER_PORT = 15150 ################################################################################ # client update ignore Flag, Warning: certainly set FALSE when real service!!! ################################################################################ $INGNORE_CLIENT_VERSION_UPDATE = TRUE ################################################################################ # Log server connect flag, Warning: certainly set TRUE when real service!!! ################################################################################ $CHECK_LOG_SERVER = TRUE ################################################################################ # Test Server Flag ################################################################################ $IS_TEST_SERVER = FALSE $MAIN_OR_TEST_SERVER_NAME = MainServer $GAME_PUBLISHER = GameForge4d ################################################################################ # Jamboree Server Flag ################################################################################ $IS_JAMBOREE_SERVER = FALSE ################################################################################ # Only Choice Server Flag ################################################################################ $IS_ONLY_CHOICE_SERVER = FALSE ################################################################################ # Server Group Limite User Count ################################################################################ $SERVER_GROUP_LIMITE_USER_COUNT = 1000 ################################################################################ # Cash Shop Service Flag ################################################################################ $CASH_SHOP_SERVICE_FLAG = TRUE ################################################################################ # Use SecondaryPassword System Flag ################################################################################ $USE_SECONDARYPASSWORD_SYSTEM_FLAG = FALSE ################################################################################ # Arena Server Flag ################################################################################ ################################################################################ # Auto Update Settings # FTP or HTTP ############################################################################ $AUTO_UPDATE_SERVER_TYPE = HTTP $UPLOAD_FTP_SERVER_IP = 72.219.28.30 $UPLOAD_FTP_SERVER_PORT = 21 $UPLOAD_FTP_SERVER_ACCOUNT = atum $UPLOAD_FTP_SERVER_PASSWORD = callweb $DOWNLOAD_FTP_SERVER_IP1 = 72.219.28.30 $DOWNLOAD_FTP_SERVER_IP2 = 72.219.28.30 $DOWNLOAD_FTP_SERVER_PORT = 21 $DOWNLOAD_FTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_FTP_SERVER_PASSWORD = $CLIENT_FTP_UPDATE_UPLOAD_DIR = //aceonliine/flysis $LAUNCHER_FILE_UPLOAD_PATH = //aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_UPLOAD_PATH = //aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_UPLOAD_PATH = //aceonliine/notice/notice.txt $VERSION_LIST_FILE_UPLOAD_PATH = //aceonliine/flysis/versionlist.ver $CLIENT_FTP_UPDATE_DOWNLOAD_DIR = //aceonliine/flysis $LAUNCHER_FILE_DOWNLOAD_PATH = //aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_PATH = //aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_PATH = //aceonliine/notice/notice.txt $DOWNLOAD_HTTP_SERVER_IP1 = 127.0.0.1 $DOWNLOAD_HTTP_SERVER_IP2 = 127.0.0.1 $DOWNLOAD_HTTP_SERVER_PORT = 80 $DOWNLOAD_HTTP_SERVER_ACCOUNT = anonymous $DOWNLOAD_HTTP_SERVER_PASSWORD = $CLIENT_UPDATE_DOWNLOAD_HTTP_DIR = aceonliine/ $LAUNCHER_FILE_DOWNLOAD_HTTP_PATH = aceonliine/launcher/Launcher.atm $DELETE_FILE_LIST_DOWNLOAD_HTTP_PATH = aceonliine/deletefilelist/deletefilelist.txt $NOTICE_FILE_DOWNLOAD_HTTP_PATH = aceonliine/notice/notice.txt $VERSION_LIST_FILE_DOWNLOAD_HTTP_PATH = aceonliine/versionlist.ver ################################################################################ # ReInstall Version:(previous version of new download version), Default = 1.0.0.0 ################################################################################ $CLIENT_REINSTALL_VERSION = 0.0.0.0 ################################################################################ # Default Map ################################################################################ $SERVER_GROUP_DEFAULT_MAP = 2001 ################################################################################ # Database Settings 1 - PreServer ################################################################################ $PRE_ODBC_DSN = atum2_db_account $PRE_ODBC_UID = atum $PRE_ODBC_PASSWD = ADMINISTRATOR123lolz $PRE_DB_SERVER_DATABASE_NAME = atum2_db_account $PRE_DB_SERVER_IP = 5.60.137.114 $PRE_DB_SERVER_PORT = 1433 ################################################################################ # Database Settings 2 - ServerGroup(IMServer, FieldServer, LogServer, NPCServer) ################################################################################ $SERVER_GROUP_ODBC_DSN = atum2_db_1 $SERVER_GROUP_ODBC_UID = atum $SERVER_GROUP_ODBC_PASSWD = ADMINISTRATOR123lolz $SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $SERVER_GROUP_DB_SERVER_IP = 5.60.137.114 $SERVER_GROUP_DB_SERVER_PORT = 1433 ################################################################################ # Database Settings 3 - Log DB Server(LogServer) ################################################################################ $LOG_SERVER_GROUP_ODBC_DSN = atum2_db_1 $LOG_SERVER_GROUP_ODBC_UID = atum $LOG_SERVER_GROUP_ODBC_PASSWD = ADMINISTRATOR123lolz $LOG_SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $LOG_SERVER_GROUP_DB_SERVER_IP = 5.60.137.114 $LOG_SERVER_GROUP_DB_SERVER_PORT = 1433 ################################################################################ # Database Settings 3 - External Authentication ################################################################################ $IS_EXTERNAL_AUTHENTICATION = FALSE $EXT_AUTH_ODBC_DSN = $EXT_AUTH_ODBC_UID = $EXT_AUTH_ODBC_PASSWD = $EXT_AUTH_DB_SERVER_DATABASE_NAME = $EXT_AUTH_DB_SERVER_IP = $EXT_AUTH_DB_SERVER_PORT = ################################################################################ # Database Settings 4 - Billing Database ################################################################################ # $BILLING_DB_SERVER_USER_ID = atum # $BILLING_DB_SERVER_PASSWORD = ADMINISTRATOR123lolz # $BILLING_DB_SERVER_DATABASE_NAME = atum2_db_1 # $BILLING_DB_SERVER_IP = 5.60.137.114 # $BILLING_DB_SERVER_PASSWORD = 1433

PS; I have no Arena. Appearently its not necassary...?

If you don't have arena servers it means IT'S NOT 3.3.

I help peoples that try to make 3.3

Re: [Guide] for ep 3.3

You know what 3.3 doesent need the ODBC entries?

Re: [Guide] for ep 3.3

Well I know that, but this guide is made for ep 3.3 working on ODBC. As you can see.

Am I right? You could make an guide 3.3 without ODBC.
I think you released the 3.3 ^^

Re: [Guide] for ep 3.3

Hay guy, i did everthing you wrote but one thing i didnt find
Also you wrote
Go back in /server/map in /server/map/Res-Exe.
Go to your client and copy the Aceonline.atm in the /server/map/Res-Exe.
I cant find that folder
Without that i did everything but if i wanna start PreSerrver
There comes a fail (LoadConfigurationError)
But i downloaded ur Global.zip and changed it to mine
But it doesnt work mhm<
And in ODBC all tests are successfully

Re: [Guide] for ep 3.3

Quote:

Originally Posted by Silenzium

Hay guy, i did everthing you wrote but one thing i didnt find
Also you wrote
Go back in /server/map in /server/map/Res-Exe.
Go to your client and copy the Aceonline.atm in the /server/map/Res-Exe.
I cant find that folder
Without that i did everything but if i wanna start PreSerrver
There comes a fail (LoadConfigurationError)
But i downloaded ur Global.zip and changed it to mine
But it doesnt work mhm<
And in ODBC all tests are successfully

Go back in /server/map in /server/map/Res-Exe.
Go to your client and copy the Aceonline.atm in the /server/map/Res-Exe.
I cant find that folder

this means to go to your client folder and copy the ACEonline.atm in to /server/map/Res-Exe.

Quote:

But i downloaded ur Global.zip and changed it to mine
But it doesnt work mhm<

here as I specified in this thread, you have to take out the informations that I wrote there.

Re: [Guide] for ep 3.3

Quote:

Originally Posted by darkmandos

Well I know that, but this guide is made for ep 3.3 working on ODBC. As you can see.

Am I right? You could make an guide 3.3 without ODBC.
I think you released the 3.3 ^^

Why i should do that?
For many more noob questions here in the forum? No thanks.

Its fucking easy to get this work without the odbc. But i've think you're the king here and know everything?!

Re: [Guide] for ep 3.3

Quote:

Its fucking easy to get this work without the odbc. But i've think you're the king here and know everything?!

I am not the king;) And yes I am agree with what you mentioned up there

Quote:

Why i should do that?
For many more noob questions here in the forum? No thanks.

Re: [Guide] for ep 3.3

soo i did it and i delete ur informations but there comes "LoadConfigurationErro"

Re: [Guide] for ep 3.3

Just Upload here the global.cfg i will make it for you, and also id and pw that you want to use.

Re: [Guide] for ep 3.3

global.cfg
and
ID Take123
Pw Daniel123

Re: [Guide] for ep 3.3

1ST OF ALL You didn't made a step.
Or more then 1 step..i will check right now the rests.

This is the 1st wrong THING:

$$SERVER_GROUP_INFO_1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE
$$SERVER_GROUP_INFO_2 = $SERVER_GROUP_NAME_2 $MGAME_SERVER_ID_2 FALSE
$$SERVER_GROUP_INFO_3 = $SERVER_GROUP_NAME_3 $MGAME_SERVER_ID_3 FALSE
$$SERVER_GROUP_INFO_4 = $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 FALSE

and Should look like this:

$$SERVER_GROUP_INFO_1 = $SERVER_GROUP_NAME_1 $MGAME_SERVER_ID_1 TRUE
$$SERVER_GROUP_INFO_2 = $SERVER_GROUP_NAME_11 $MGAME_SERVER_ID_11 TRUE
$$SERVER_GROUP_INFO_3 =
$$SERVER_GROUP_INFO_4 =

Dude This is not the global.cfg that I SAID you have to replace it with the one that you have.

Take a look:

$ARENA_SERVER_NAME = $MGAME_SERVER_ID_11
$ARENA_SERVER_ID = $SERVER_GROUP_NAME_11
$Arena_DB_SERVER_NAME_IM = atum2_db_arena
$Arena_SERVER_GROUP_ODBC_DSN = atum_group1_server_dsn

atum_group1_server_dsn should be this db_arena

Read again the GUIDE 3.3 and READ IT CAREFULLY.
Other peoples from the 1st attempt they success.

Re: [Guide] for ep 3.3

hum... now i have another problem xD...
If i wanna start the LogServer there comes (Already running) but it doesnt...

and db problems wtf...

Re: [Guide] for ep 3.3

Quote:

Originally Posted by Silenzium

hum... now i have another problem xD...
If i wanna start the LogServer there comes (Already running) but it doesnt...

and db problems wtf...

Using Task manager to shut it down b4 running it again :D

Re: [Guide] for ep 3.3

Quote:

Originally Posted by alo123ma

Using Task manager to shut it down b4 running it again :D

True.

Re: [Guide] for ep 3.3

mhm dont know why... but i did everything again... the same like u wrote
i delete the dbo.characters but if i wanna start the server there comes dbconnect fail bla bla bla...
and if i want to start it failed to connect the server

Now the LogServer works... but the Field server fails xD

1 Attachment(s)

Re: [Guide] for ep 3.3

This is the problem

Re: [Guide] for ep 3.3

can´t you even read, wtf? the error tells you what you have to edit!

Re: [Guide] for ep 3.3

The problem is i dont know where and how...

anyone can help me to set the Field server right?

Re: [Guide] for ep 3.3

none can help me?

Re: [Guide] for ep 3.3

if you can´t even solve this problem no one can help you...

Re: [Guide] for ep 3.3

mhm i told ya i dont know how...
and the only thing that u write is read it... and u dont know how to solve that problem too...

Re: [Guide] for ep 3.3

i know it and my server is running fine. and if you can´t even follow simple steps you shouldn´t create your own server

Re: [Guide] for ep 3.3

can anyone explain or give me a hint on how to solve the "server under examination" error pls, any info will help, i have ran out of ideas on what to do, changed odbc several times, changed ip's and ports to sql, changed clients, messed arnd in config, changed client version, i dnt knw what to do nw. Any help help or info will be most appreciated. Thank you

Re: [Guide] for ep 3.3

lol i can follow all steps but this not... so u mean all steps are easy?
And the 6 sides of problems are full of players with 0 knowledge?

Re: [Guide] for ep 3.3

Its a problem in ur GLOBAL.CFG

LOGDB_ODBCUID(HERE IS EMPTY BECAUSE IN UR GLOBAL.CFG YOU DIDN'T SPECIFIED YOUR Login name from SQL Server)
LOGDB_ODBCPASSWORD(HERE IS EMPTY BECAUSE IN UR GLOBAL.CFG YOU DIDN'T SPECIFIED YOUR Password from SQL Server)

I hope those infos helped.

Re: [Guide] for ep 3.3

same problem... if this is empty

Re: [Guide] for ep 3.3

It means your config and the rout that you made so your databases to be connected thru ODBC with the server files are fucked up.

Re: [Guide] for ep 3.3

yeah... i cant connect to database...

Re: [Guide] for ep 3.3

I bet that you are not connecting in SQL with ur id and password that are in global.cfg and also you are using the windows authentification in stead of ur ip that is in the global.cfg.

And that "atum" or what name u choose to log in, i bet that you didn't gaved to him sysadmin and that u didn't logged in to sql server with it.

Sorry this is for SQL Server 2008 R2 standard developed and registered. I mean with licence. As I have.

So it will be for you , DBO which means db_owner.

Re: [Guide] for ep 3.3

damn i can connect to my database... but if i start the Field server there stands "Cant connect to Database

Re: [Guide] for ep 3.3

Quote:

Originally Posted by Silenzium

damn i can connect to my database... but if i start the Field server there stands "Cant connect to Database

Because ur config it's fucked up. if is cannot connect to database, ur path is not correctly configured between databases ~ SQL Config Manager ~ ODBC ~ Server files.

Re: [Guide] for ep 3.3

then you obviously can´t connect to your db ...

Re: [Guide] for ep 3.3

yes i know... but none of u tell me how do i solve this problem^^

Re: [Guide] for ep 3.3

The guide Does. If you ur brain capacity it's so small we can do nothing.

As I said and I will repeat. Are others that followed this guide and from the 1st attempt they succeed.

So read again and again and find the posts where other peoples and they are so plenty of them, and where we helped and we fixed them issues.

We won't explain every time when a newbie comes and so on, for milion times. If we do that, in one day our dreams will be only with servers, and other peoples issues with 'em servers.

Re: [Guide] for ep 3.3

Dark, I have an off-topic question: How to adjustment the default rate for server (exp, spi, etc), not happy hour event one?
I was looking in the whole database but no luck about that :(

Thanks!

Re: [Guide] for ep 3.3

then you didn´t look in the whole database ...

Re: [Guide] for ep 3.3

Dark, would please guide me through Team Viewer?I set up but get error on second time running sever.