[Guide] Aion Server Setup

im stuck at select server and i can't proceed what is the best thing to fix this problem?

If you guys followed his guide you shouldn't have any issue's. I would suggest read it again and again till you fully understand. what hes telling you. The problem with the server log in is it's different than your my sql password so it want launch. You should have 2 passwords by the time your done 1 that is used several times and 1 that is used once only. Make sure your passwords are set up right.

His work up works very well and i went some where got a nice updated trunk file of 2.5 and used his system and steps. Now i have version 2.5 working exstreamly well. Your ipconfig.xml in your games folder should have your ip in it if you want others to log in to your server. the default.config in your games folder should be the only one that has the second password in it once under
# LoginServer password for this GameServer
gameserver.network.login.password = (your second password you made.)

All other passwords should be same as your mysql password. If there not the same as your mysql password the clients can't connect and run you will keep getting failed to log in error. hope this clears up some issues. Remember This is my first time building my own server ever and I have no knowledge in coding what so ever but his guide was very detailed to take some one like me and have me up and running in a matter of 6 hours. Yes i read his article several times when i would get stumped so please read it a few times it's all there.

---------- Post added 30-09-11 at 12:06 AM ---------- Previous post was 29-09-11 at 11:33 PM ----------

Love the guide. I just have one problem I need some help with right now. I need you to explain what this code is pointing to. I'm trying to learn as I go. Server runs fine and all game runs but this is now twice this has happened to my admin account. and i get this error and crash when logging in to them if i make a regular account it will log in. Haven't seen if this happens on regular yet cause been to busy decking out my admin character before i make my regular account. Code is below*****

[ERROR 2011-09-29 23:15:25] mysql5.MySQL5LegionDAO:262 - Column 'legionary_permission1' not found.
java.sql.SQLException: Column 'legionary_permission1' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at mysql5.MySQL5LegionDAO.loadLegion(MySQL5LegionDAO.java from JavaSourceFromFile:246)
at org.openaion.gameserver.services.LegionService.getLegion(LegionService.java:365)
at mysql5.MySQL5LegionMemberDAO.loadLegionMember(MySQL5LegionMemberDAO.java from JavaSourceFromFile:164)
at org.openaion.gameserver.services.AccountService.loadAccount(AccountService.java:145)
at org.openaion.gameserver.services.AccountService.getAccount(AccountService.java:77)
at org.openaion.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:248)
at org.openaion.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:94)
at org.openaion.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:53)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:45)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:26)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[ERROR 2011-09-29 23:15:25] org.openaion.commons.network.Dispatcher:102 - Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException
at org.openaion.gameserver.network.aion.PlayerInfo.writePlayerInfo(PlayerInfo.java:151)
at org.openaion.gameserver.network.aion.serverpackets.SM_CHARACTER_LIST.writeImpl(SM_CHARACTER_LIST.java:61)
at org.openaion.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:81)
at org.openaion.gameserver.network.aion.AionConnection.writeData(AionConnection.java:229)
at org.openaion.commons.network.Dispatcher.write(Dispatcher.java:304)
at org.openaion.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:69)
at org.openaion.commons.network.Dispatcher.run(Dispatcher.java:94)

What Am I looking for here to tell me where to go fix this issue? If can explain your way I'll do my best to understand.The account worked fine logged in and out few times and had no issues but when i logged out and shut down the server this happen. Am I shutting down the server to soon? and information isn't getting saved and curropting the file? or is there a setting in my default config i should have turned on that i don't? Would love to understand this issue.

Anytime i try to download the portable server i get an error saying "you do not have permission to access this page" how do i fix this?

cant download the portable server, "you do not have permission to access this page". What to do now?

Quote:

---

Originally Posted by Savage

Creating an Aion Private Server

Table of Contents:

A.) Introduction
B.) Links and Downloads
C.) Server Guide
D.) Various Links and Downloads
E.) Credits

1.) Navicat Configuration
2.) Execute SQL Files
3.) LoginServer Database Configuration
4.) Database Properties Configuration
5.) Server Rates Configuration
6.) Game Client Installation

A.) Introduction

Hello everyone, I've decided to delve into the world of Aion and create a guide on how to set up your very own private server. I will be creating this guide using the resources provided in this section. Please let me know if you find any flaws in this guide. I am new to Aion private server development, and I would be glad to fix the mistakes I've made. Links and downloads necessary for server set up will be provided below. Here are some other threads you might want to check out:

http://forum.ragezone.com/f588/video...server-619458/
http://forum.ragezone.com/f588/confi...router-649689/
http://forum.ragezone.com/f588/tutor...on-emu-649179/

B.) Links and Downloads

First off, let's start off with the links and downloads you may need for this process. The links will be provided below.

Downloads:
- Navicat
- MySQL
- Video Guide (gujda1)
- GM Commands
- Java
- Client
- Portable Server

Note: Refer to the bottom of this tutorial for C.) Various Links and Downloads for the game client if you want to install this now and not have to wait later; and other downloads that might come in handy. Provided by dannybest.

C.)Server Guide

1.) First off, once you have everything downloaded, you might want to organize everything in a new folder so you can keep track of everything.

Next, we can configure the Aion connection in Navicat. Open your Navicat, and click "New Connection" in the upper right hand corner. Fill in the blanks as follows:

Code:

---

Connection Name: AION
Host Name/IP Address: localhost
Port: 3306
User Name: root
Password: your desired password goes here. MUST MATCH YOUR MYSQL PASSWORD.

---

You will notice the connection name has been setup. Don't worry about any of the options under your connection. Right click on your connection name and click "New Database" and enter two new databases:

Code:

---

ae_server_gs
ae_server_ls

---

ae_server_gs will be your game server database and ae_server_ls will be your login server database.

2.) After you have done that, right click on ae_server_gs and click "Execute SQL File" and locate the .sql files in the SQL folder. For ae_server_gs, you will need to execute all the .sql files in the 'gameserver' folder. Do the same for the loginserver. You will notice that the .sql files have been executed and you will see tables such as: "blocks," "droplists," "friends," and etc.

3.) Navigate into your ae_server_ls database and double-click on the table "gameservers." Edit the fields as follows:

Code:

---

ID: 1
Mask: 127.0.0.1
Password: 123

---

That concludes the Navicat configuration for this setup guide. Aion is designed for auto-registration; your accounts will be saved to your databases.

4.) Now go into your Aion server files folder and open the 'gameserver' folder. Open your 'config' folder, and then open the database.txt - here you will edit your database information. The password may be set to "123" so you will need to change it to your assigned MySQL password. Repeat this step for the loginserver file.

5.) To edit the server rates, locate the gameserver.properties file and scroll to the bottom - "Rate's configs." Here you can edit the experience rate and drop rate. You can also configure your IP settings here too. You can edit various information in the loginserver.properties file also.

6.) Next you will need to install the necessary clients and version of the game if you haven't done so already. The below list of downloads was taken from dannybest's thread: http://forum.ragezone.com/f587/aion-...server-646761/

You should be ready to go! Launch your loginserver and gameserver .bats. Navigate to your Aion game folder and launch your play.bat, and have fun!

D.) Various Links and Downloads



Here is Arecelor's "releases index" to assist you further in your private server:
http://forum.ragezone.com/f588/guide...-index-649316/

E.) Credits

- gujda1
- dannybest
- Arcelor
- minikevin12


Note: You might want to dump the playfileforaion.bat into the actual Aion game folder. Some experience problems if they don't.

Note: If you want to connect to a WAN connection, just replace 127.0.0.1 in the .bat file with an existing IP.

---

nice...

thank you, this helped me and my friends alot.

Updated tutorial and links:
http://forum.ragezone.com/f588/video...-setup-752184/