Private Server Set Up Guide!

Since no one could even get close to guessing who i was on the Suba forums, i'll just post it here where i can openly answer any questions you have.

The following guide will give you enough knowledge to setup and run a Ace Online/ Air Rivals private server.

Step 1: Getting the files you need.
-Go to http://www.megaupload.com/?d=6U3JW4SJ and download it. After, download http://www.megaupload.com/?d=U4PIJKFX . These are the basics you will need. Extract the first one

to the root of your Harddrive. Extract the second to your desktop.

-If you need a flysis client, download it from here:
http://games.on.net/file/14941/Flysis_Full_Client_1.0.0.9

-Download SQL 2k5 or 2k8, it's up to you. Out of personal preference, i use 2k5.
Go to http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx 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.


Step 2: Setting up the server (AceOnline folders).
-If you didn't extract the first file to the root of your HD already, do it now. It should be around 36.3 MBs.

-Once extracted, go into the AceOnline folder. You should see 9 other folders inside (bin, config, DB_BAKS, htdocs, Lib, log, map, SCMonitor, SCVoIP) along with odbx_x86 / 64 and a README file. The README is a little Engrishy, but if you wanna read it go ahead.

-Go into the config folder and look for the file named global.cfg. Open it using Notepad.

-The top two IPs that say 127.0.0.1, 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:


-Now you're going to do a bit of copying, bare with me. It's going to sound a bit awkward reading it (Alot easier hearing how to do it), but i'll use pictures to try and help guide you through it.
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 AO Stuff, and go to 002SERVER/Server/map. Copy all of the map files from that to your server. So it should look like this:

-Now find where you installed flysis. Go into the Res-Obj folder, and copy all of those files into the Res-Obj folder in the server. Should be like this:

-Now go back a folder in your flysis folder, go to Res-Map. Now go back a folder in your server. Copy ALL of the DATs to the clients Res-Map folder, and ONLY the .DATs. Like so:


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:

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.

Make it Active if it isn't, Enable it, and change the Port to 9979. 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 MSSQL Server, 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:

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

Once you restore atum2_db_1, do the same for atum2_db_account:

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 a default account named Admin, you can add an account by typing in its:
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 your server folder, and double click on the file named odbc_x86 (or x64 for you 64 bit users out there). It'll ask if you're sure, just say yes. Now go to Control Panel -> Admin Tools -> Data Sources (ODBC). Click on the Systm DSN tab, there should be 5 entries. Only worry about the top 4. Double click the first one, you'll want to edit the Server Name part. Where it says 127.0.0.1, put in the name of your server like so:

Click finish and test it. If it passes successfully, do the same for the next 3. 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 (YOURIP)

Click on Embedded Files and Browse for your FLYSIS.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.

If done correctly....

CONGRATULATIONS, YOU'RE DONE~!

Just a side note for everyone: This is an SCO (EP2) server so the files technically aren't stolen.
Just don't claim the game as your own work, and don't use the game for profit.

So I guess Operation "Fuck ACE up even moar" is undergoing?

I guess I will jsut do it for my own gigs and stuff (GM POWAH). Still downloading the client and that SQL. Shits are big...

problem... At step 4, do you mean use a "random" name for the server, then put that exact same thing in the data source window, where you highlighted? Because on my machine, when i open up the manager studio, it says "local" for the server name. I've changed it to Tommy-PC, and then put that in the data source window where the 127.0.0.1 is.

And when I start preserver and log server, I always get errors. ANd then the game says server inactive. What's wrong?

I've tried everything, but preserver, IMserver keeps getting error messages and the game can't find the server... what's wrong?

Ummmmm.....I managed o slowly creep my way to the part where i log into the game. However every time i press Game Start the client crashes. Any ideas of wat is going on?

Sorry been away for a while and what not.

@Fortune: What's the error message say Fortune? I'd assume you're one, if not all, of the following errors:
DB connect CPreIOCPInit()
[Error] PreServer IOCPinit Error
m_pAtumLogDBManager initialize fail
LogServer IOCPinit Error

If so, make sure your ODBCs are correct. Enter in the Database name (During SQL Setup, it should automatically set it as your PC Name, for example, mine as Anthony-PC, or yours as Tommy-PC.) That should be in the ODBC as the Server name in the ODBC. If it connects, but you're still getting those errors, change all the ODBC Server names to 127.0.0.1
Then go to your global.cfg, and set the IP instead of the Hamachi one as 127.0.0.1, boot up the server. If it boots, you can do it locally, if it doesn't, message me on MSN or AIM and i'll check it out. Alot easier then going back and forth on a forum lol.

Also, OS and 32/64 bit? Problem with the server is sometimes, it HATES 64 bit (Works PERFECTLY on my machine, however; on a friends it doesn't seem to work.)

How can i open the right window
or wath he means with Control Panel -> Admin Tools -> Data Sources (ODBC) ? I don´t know wich Control Panel u mean.
Can somebode tell me?
Thank you
---in the german version of win7 are some things a litle bit different ---

-----------edit------------

ok i have found it but there are not the "5 entries". there is no entry. can somebody help me? wath i have forgot?

Well if you are on a 64 bit system, you need to use c:\Windows\SysWOW64\odbcad32.exe The DSN's should be there.

I use win 7 64 bit home premium.
I delete my harddrive and made my windows new.
I made everything like u descript it and used c:\Windows\SysWOW64\odbcad32.exe but the same problem! There are no entrys.
the Firewall is out of action i had on my windows no antivir or something like that.
I don´t know why i have no entrys.
Can i make this 5 entrys or must they be there?
If i can make them manually can somebody write them to me or how to make them?

Hope sb can help me !

now it works

hola mi nombre es cristian, vivo en Argentina, follow the steps in your guide, everything is fine, but when I enter the private server, become a normal user, not administrator.

As I believe the manager? Need tools to change level, experience, stats etc?? I appreciate your response.

thank you very much

how to fix? i search in config somethink but i don't found it...
sorry for my bad english ^^

paluch979 wrote:

how to fix? i search in config somethink but i don't found it...
sorry for my bad english ^^

bad english??? hablas español????? abri el administrador de tareas despues de haber abierto los archivos que van en orden cuando fieldserver aperesca como activo provas hay, yo tuve que esperar a que todo este activado para poder ejecutar flysis private server, me salia el mismo mensaje

Wow! Awesome! This is just what I was looking for! I always wanted to know what being an AR GM is like, and this is my chance!

Probably not going to make some big ol' private server, maybe just something to enjoy with my brig mates or something.


I just have one question: do those files include the GM files? I heard GM's have a special client that is what actually gives them the power to be GM's. And since in that last screenshot the character doesn't have a grey name with GM before it like GM's usually do, I'm asking this.

Thanks for this wonderful info,
~TBURN

EDIT: As well as those questions regarding server managment after installing (like being a GM), I can't download the files too, due to Megaupload being a b***h.

EDIT to EDIT: I managed to download the first Ace Online file (the 6 MB one) with Google Chrome's awesomeness, but the second one seems to be unavailable.

got admin tools.
I can not use some items (eg binder Serapia IG).
How do I upgrade to ep3?




please, I need your help to run my server in Latin America. I have a database file and files ep3

When I open the Start.exe icon it says cannot find Launcher.atm


Help pls?

Subject: Private Server Set Up Guide! Tue Oct 05, 2010 3:40 pm
First topic message reminder :

Since no one could even get close to guessing who i was on the Suba forums, i'll just post it here where i can openly answer any questions you have.

The following guide will give you enough knowledge to setup and run a Ace Online/ Air Rivals private server.

Step 1: Getting the files you need.
-Go to megaupload.com 6U3JW4SJ and download it. After, download megaupload.com U4PIJKFX . These are the basics you will need. Extract the first one

to the root of your Harddrive. Extract the second to your desktop.

-If you need a flysis client, download it from here:
http://games.on.net/file/14941/Flysis_Full_Client_1.0.0.9

-Download SQL 2k5 or 2k8, it's up to you. Out of personal preference, i use 2k5.
Go to http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx 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.


Step 2: Setting up the server (AceOnline folders).
-If you didn't extract the first file to the root of your HD already, do it now. It should be around 36.3 MBs.

-Once extracted, go into the AceOnline folder. You should see 9 other folders inside (bin, config, DB_BAKS, htdocs, Lib, log, map, SCMonitor, SCVoIP) along with odbx_x86 / 64 and a README file. The README is a little Engrishy, but if you wanna read it go ahead.

-Go into the config folder and look for the file named global.cfg. Open it using Notepad.

-The top two IPs that say 127.0.0.1, 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:

Enlarge this image Click to see fullsize



-Now you're going to do a bit of copying, bare with me. It's going to sound a bit awkward reading it (Alot easier hearing how to do it), but i'll use pictures to try and help guide you through it.
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 AO Stuff, and go to 002SERVER/Server/map. Copy all of the map files from that to your server. So it should look like this:

Enlarge this image Click to see fullsize


-Now find where you installed flysis. Go into the Res-Obj folder, and copy all of those files into the Res-Obj folder in the server. Should be like this:

Enlarge this image Click to see fullsize


-Now go back a folder in your flysis folder, go to Res-Map. Now go back a folder in your server. Copy ALL of the DATs to the clients Res-Map folder, and ONLY the .DATs. Like so:

Enlarge this image Click to see fullsize



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:

Enlarge this image Click to see fullsize


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.

Make it Active if it isn't, Enable it, and change the Port to 9979. 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 MSSQL Server, 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:

Enlarge this image Click to see fullsize


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

Enlarge this image


Once you restore atum2_db_1, do the same for atum2_db_account:

Enlarge this image


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 a default account named Admin, you can add an account by typing in its:
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 your server folder, and double click on the file named odbc_x86 (or x64 for you 64 bit users out there). It'll ask if you're sure, just say yes. Now go to Control Panel -> Admin Tools -> Data Sources (ODBC). Click on the Systm DSN tab, there should be 5 entries. Only worry about the top 4. Double click the first one, you'll want to edit the Server Name part. Where it says 127.0.0.1, put in the name of your server like so:

Enlarge this image Click to see fullsize


Click finish and test it. If it passes successfully, do the same for the next 3. 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 (YOURIP)

Click on Embedded Files and Browse for your FLYSIS.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




i dont understand it mean.... can u tell little bit more what i most to do.... Upload a picture that would be better

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 (YOURIP)

Click on Embedded Files and Browse for your FLYSIS.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




i dont understand it mean.... can u tell little bit more what i most to do.... Upload a picture that would be better

Mine for example was:
echo off
start Launcher.atm 5.207.74.185
i dont understand what echo off and start launcher.atm is...... can u help me..

Ok, so now I've set everything up and I have no errors until I try to start the batch file I created.

When the log in screen appears, it says "Cannot connect to Pre Server".

Do you know what it might be?

i dont understand the step 5 can you make a scrreenshot
ples

[img][/img]
lookkk this i have this probleme

EPION PLEASE READ PLEASE

EPION please, need help. in my game. normal accounts (account type 0) do not work. the other accounts if, 128, 255, 260, 404 found. you know I can do for users to run normal (normal user, account type 0)?? Please.i use google to write translators. I live in Argentina.

my mail.cristian_mangiaterrahotmail.com please, helpme

look. my ip hamachy is 5.145.156.47. join in my red: cam46 pass: taringa or red: airforcerrivals pass: taringa



account type 0 (normal): test pass: test


account type 128 (admin): epion pass: admin


look the problem..... please, need rly help

[img][/img]
lookk this