Aion Unity 5.8 Land of Battle Release

[daezugun]

works perfectly, already connect the client, thank you very much. Now what I have is a doubt, as I put it so that it starts from the initial zone and without gifts because we want to play it from the beginning to see everything while we move up, if someone has a database of the server that is in that form , please tell me where you are so I would like to start from scratch. Thank you.

What version of jdk 7 and 8 you use? because for me when jdk 7 are only installed on my system the game server will run perfectly however when i install jdk 8 and run login and chat it gives me an error.

==============update=================
I figured it out and now working both jdk 7 and 8 in my machine.

[Chuwi]

Hello,

Thank you for great sharing, I try to install private server to localhost. I think I have done everything in right way, but something is missing, I am adding screen shot.

Could you please help if you know anything about that ?

Thank you in advance

[DamSF]

Hello,

Thank you for great sharing, I try to install private server to localhost. I think I have done everything in right way, but something is missing, I am adding screen shot.

Could you please help if you know anything about that ?

Thank you in advance

Are you sure everything is correctly configurated?
This error is normally associated with bad connection configuration (wrong IPs, ports or MySQL connection).

[Chuwi]

Hi DamSF,

thank you for reply, yes I have been working on it for 2 days :/, configurations are corrects, I use 127.0.0.1 for all ip requests, I dont know if I have to use my real ip in somewhere, if I have to, I would like to be informed..

and another note : when I build game from github emulator files, I get can not connect authorization error, but when I use SPP - aion installer I get server is down or no gameserver is available errors..

[daezugun]

Thanks for the files, i can connect and play in game for the first time and when i logout and log back in i encounter an error on GS and cannot connect in game.

11:04:32.452 INFO [main]: - [GameServer] Actual Factions Ratio : Elyos 50.0 % - Asmodians 50.0 %
11:04:32.954 INFO [ReadWrite-0 Dispatcher]: - [BannedMacManager] Loaded 0 banned mac addresses
11:10:00.001 INFO [InstantPool-3]: - Creating new Mount Race Map id:181
11:10:51.319 INFO [Accept Dispatcher]: - connection from: 127.0.0.1
11:10:51.330 INFO [ReadWrite-0 Dispatcher]: - Authentication with Client Version 5.8
11:10:51.443 INFO [PacketProcessor:3]: - 0 IPv4: {}
11:10:51.443 INFO [PacketProcessor:3]: - Mac: xx-xx-xx-xx-xx-xx
11:10:51.445 INFO [PacketProcessor:3]: - HDD SERIAL: 12345678
11:10:51.454 INFO [PacketProcessor:3]: - Local IP: {192.168.0.50}
11:10:51.455 INFO [PacketProcessor:3]: - Connect IP: 127.0.0.1
11:10:51.461 ERROR[ReadWrite-0 Dispatcher]: - Missing H for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
11:10:51.461 ERROR[ReadWrite-0 Dispatcher]: - Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
11:10:51.467 ERROR[ReadWrite-0 Dispatcher]: - Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
11:10:51.516 ERROR[InstantPool-4]: - Could not restore PlayerCommonData data for player: 326976 from DB: Column 'is_newbie_guide' not found.
java.sql.SQLException: Column 'is_newbie_guide' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) ~[mysql-connector-java-5.1.33.jar:5.1.33]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) ~[mysql-connector-java-5.1.33.jar:5.1.33]
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) ~[mysql-connector-java-5.1.33.jar:5.1.33]
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1064) ~[mysql-connector-java-5.1.33.jar:5.1.33]
        at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2566) ~[mysql-connector-java-5.1.33.jar:5.1.33]
        at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5PlayerDAO.java]:368) ~[na:na]
        at com.aionemu.gameserver.services.AccountService.loadAccount(AccountService.java:145) [AL-Game.jar:na]
        at com.aionemu.gameserver.services.AccountService.getAccount(AccountService.java:80) [AL-Game.jar:na]
        at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:227) [AL-Game.jar:na]
        at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:113) [AL-Game.jar:na]
        at com.aionemu.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:50) [AL-Game.jar:na]
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
        at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_80]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80]
        at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]

and when i check the db files there is no 'is_newbie_guide' column included.


===============Update Solved===================


Problem: Missing DB Column on DB Player must add is_newbie_guide if you encounter this error

Thanks to Onyen542 for helping mo to solved and for the teamview bro big thanks

[DamSF]

Hi DamSF,

thank you for reply, yes I have been working on it for 2 days :/, configurations are corrects, I use 127.0.0.1 for all ip requests, I dont know if I have to use my real ip in somewhere, if I have to, I would like to be informed..

and another note : when I build game from github emulator files, I get can not connect authorization error, but when I use SPP - aion installer I get server is down or no gameserver is available errors..

And the databases, have you configured the IPs there too?

[eldrey]

so that you do not give yourself more errors, take and copy the contents of the LIBS folder of AL-Game in AL-Login and AL-Chat and they open you perfect, or at least it worked for me that way

- - - Updated - - -

so that you do not give yourself more errors, take and copy the contents of the LIBS folder of AL-Game in AL-Login and AL-Chat and they open you perfect, or at least it worked for me that way

I need help because I want to start from the beginning and without gifts. How do I configure it in that way where I have to do all the missions, including Daevas? help me please

[Myster Dev]

database for this please?

[eldrey]

how i can clean the database of server to start from level 1???? someone please help me

[Chuwi]

Hello again,
Thank you for sharing,
Finally, I managed to connect Emulator, but my problem is character creation.

thank you in advance for help.



- - - Updated - - -

[DamSF]

Hello again,
Thank you for sharing,
Finally, I managed to connect Emulator, but my problem is character creation.

thank you in advance for help.



- - - Updated - - -


open mysql shell and type \c and press enter..

Can you share the logs from your Game Server?

[Chuwi]

Can you share the logs from your Game Server?

DamSF,

here is database file:

# Database Config's:# ----------------------------# This class represents database driver class that will be used while connecting to databasedatabase.driver = com.mysql.jdbc.Driver# This is database url.database.url = jdbc:mysql://localhost:3306/al_server_gs?useUnicode=true&characterEncoding=UTF-8# Database userdatabase.user = root# Database password# NOTE: Change this! Root password is not safe!database.password = 266321# Number of partitions created by bonecpdatabase.bonecp.partition.count = 2# Minimal amount of connections kept in bonecp partitiondatabase.bonecp.partition.connections.min = 2# Maximal amount of connections kept in bonecp partitiondatabase.bonecp.partition.connections.max = 5# Script context that will be loaded by database factory, it should implement DAO instancesdatabase.scriptcontext.descriptor = ./data/scripts/system/database.xml 

and here ipconfig.xml

--><ipconfig default="127.0.0.1">  I used also my local ip here, but it doesnt work as well.<!--    <iprange min="10.0.0.0" max="10.255.255.255" address="10.0.0.0"/>    <iprange min="172.16.0.0" max="172.31.255.255" address="172.16.0.0"/>    <iprange min="192.168.0.0" max="192.168.255.255" address="192.168.0.0"/>    <iprange min="127.0.0.1" max="127.0.255.255" address="127.0.0.1"/> --></ipconfig> 

and network :

# Network Config's:# ----------------------------# Port that will be used to listen for client connectionsgameserver.network.client.port = 7777# Host that will be used to listen for client connectionsgameserver.network.client.host = 127.0.0.1# Maximum online players on the servergameserver.network.client.maxplayers = 1000# Address of login servergameserver.network.login.address = localhost:9014# Id of this game servergameserver.network.login.gsid = 1  I have also created this id in navicat with 127.0.0.1 ip# Password of this game servergameserver.network.login.password = 266321# Address of chat server# Ip and port of chat server should be accessible from# 1) game server# 2) all connected clientsgameserver.network.chat.address = 127.0.0.1:9021# Password of this game server for chat servergameserver.network.chat.password = 266321# Number of extra threads dedicated only to read/write network data.# Value < 1 means that acceptor thread will also handle read & write.# Value > 0 means there will be x dedicated read/write threads + 1 acceptor.gameserver.network.nio.threads = 1# Number of threads (min) that will be used to execute client packetsgameserver.network.packet.processor.threads.min = 4# Number of threads (max) that will be used to execute client packetsgameserver.network.packet.processor.threads.max = 4# Threshold used to decide when packet processor thread should be killed# It have effect only if min threads != max threadsgameserver.network.packet.processor.threshold.kill = 3# Threshold used to decide when extra packet processor thread should be spawned# It have effect only if min threads != max threadsgameserver.network.packet.processor.threshold.spawn = 50# This will enable or disable the messages for unknown packetsgameserver.network.display.unknownpackets = true# Enable flood protectorgameserver.network.flood.connections = false# Flood ms in tickgameserver.network.flood.tick = 1000# Short periodgameserver.network.flood.short.warn = 10gameserver.network.flood.short.reject = 20gameserver.network.flood.short.tick = 10# Long periodgameserver.network.flood.long.warn = 30gameserver.network.flood.long.reject = 60gameserver.network.flood.long.tick = 60 

Thanks..

[DamSF]

DamSF,

here is database file:

# Database Config's:# ----------------------------# This class represents database driver class that will be used while connecting to databasedatabase.driver = com.mysql.jdbc.Driver# This is database url.database.url = jdbc:mysql://localhost:3306/al_server_gs?useUnicode=true&characterEncoding=UTF-8# Database userdatabase.user = root# Database password# NOTE: Change this! Root password is not safe!database.password = 266321# Number of partitions created by bonecpdatabase.bonecp.partition.count = 2# Minimal amount of connections kept in bonecp partitiondatabase.bonecp.partition.connections.min = 2# Maximal amount of connections kept in bonecp partitiondatabase.bonecp.partition.connections.max = 5# Script context that will be loaded by database factory, it should implement DAO instancesdatabase.scriptcontext.descriptor = ./data/scripts/system/database.xml 

and here ipconfig.xml

--><ipconfig default="127.0.0.1">  I used also my local ip here, but it doesnt work as well.<!--    <iprange min="10.0.0.0" max="10.255.255.255" address="10.0.0.0"/>    <iprange min="172.16.0.0" max="172.31.255.255" address="172.16.0.0"/>    <iprange min="192.168.0.0" max="192.168.255.255" address="192.168.0.0"/>    <iprange min="127.0.0.1" max="127.0.255.255" address="127.0.0.1"/> --></ipconfig> 

and network :

# Network Config's:# ----------------------------# Port that will be used to listen for client connectionsgameserver.network.client.port = 7777# Host that will be used to listen for client connectionsgameserver.network.client.host = 127.0.0.1# Maximum online players on the servergameserver.network.client.maxplayers = 1000# Address of login servergameserver.network.login.address = localhost:9014# Id of this game servergameserver.network.login.gsid = 1  I have also created this id in navicat with 127.0.0.1 ip# Password of this game servergameserver.network.login.password = 266321# Address of chat server# Ip and port of chat server should be accessible from# 1) game server# 2) all connected clientsgameserver.network.chat.address = 127.0.0.1:9021# Password of this game server for chat servergameserver.network.chat.password = 266321# Number of extra threads dedicated only to read/write network data.# Value < 1 means that acceptor thread will also handle read & write.# Value > 0 means there will be x dedicated read/write threads + 1 acceptor.gameserver.network.nio.threads = 1# Number of threads (min) that will be used to execute client packetsgameserver.network.packet.processor.threads.min = 4# Number of threads (max) that will be used to execute client packetsgameserver.network.packet.processor.threads.max = 4# Threshold used to decide when packet processor thread should be killed# It have effect only if min threads != max threadsgameserver.network.packet.processor.threshold.kill = 3# Threshold used to decide when extra packet processor thread should be spawned# It have effect only if min threads != max threadsgameserver.network.packet.processor.threshold.spawn = 50# This will enable or disable the messages for unknown packetsgameserver.network.display.unknownpackets = true# Enable flood protectorgameserver.network.flood.connections = false# Flood ms in tickgameserver.network.flood.tick = 1000# Short periodgameserver.network.flood.short.warn = 10gameserver.network.flood.short.reject = 20gameserver.network.flood.short.tick = 10# Long periodgameserver.network.flood.long.warn = 30gameserver.network.flood.long.reject = 60gameserver.network.flood.long.tick = 60 

Thanks..

These are the Game Server configs. What I meant was the Game Server log file, which is generated every time you run the server.
It'll show what's causing the World DB error.

[Chuwi]

These are the Game Server configs. What I meant was the Game Server log file, which is generated every time you run the server.
It'll show what's causing the World DB error.

where is it stored ? :/

[Onyen542]

Hello again,
Thank you for sharing,
Finally, I managed to connect Emulator, but my problem is character creation.

thank you in advance for help.



- - - Updated - - -


open mysql shell and type \c and press enter..

I think your database error because missing some colum, need check on console error