Цитата:
Сообщение от Dr.Aibolit
Стоило бы вчитываться с содержимое конфигов...
|
А вот сейчас при авторизации статус сервера стоит "Загружено" и все равно не заходит и в логах ls вот что написано:
Свернуть ↑
Код:
INFO [07 ьрщ 11:45:23,005] Client connected Ip:192.168.1.12
FATAL [07 ьрщ 11:45:23,466] Failed writing: com.aionemu.loginserver.network.aion
.GameClient@db23f1 -
java.lang.NumberFormatException: For input string: "sk13"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at com.aionemu.loginserver.GameServerInfo.getPublicIPAddress(GameServerI
nfo.java:277)
at com.aionemu.loginserver.network.aion.serverpackets.SM_SERVER_LIST.wri
teImpl(SM_SERVER_LIST.java:52)
at com.aionemu.loginserver.network.aion.serverpackets.SM_SERVER_LIST.wri
teImpl(SM_SERVER_LIST.java:32)
at com.aionemu.commons.network.mmocore.SendablePacket.write(SendablePack
et.java:128)
at com.aionemu.commons.network.mmocore.ReadWriteThread.putPacketIntoWrit
eBuffer(ReadWriteThread.java:507)
at com.aionemu.commons.network.mmocore.ReadWriteThread.prepareWriteBuffe
r2(ReadWriteThread.java:470)
at com.aionemu.commons.network.mmocore.ReadWriteThread.writePacket(ReadW
riteThread.java:383)
at com.aionemu.commons.network.mmocore.ReadWriteThread.handle(ReadWriteT
hread.java:138)
at com.aionemu.commons.network.mmocore.WorkerThread.run(WorkerThread.jav
a:75)
INFO [07 ьрщ 11:45:30,506] Client logged in IP: 192.168.1.12, AccountName: skeich13
Свернуть ↑Развернуть ↓
А вот еще в таблице gameservers в столбце public_ip что должно быть написано? Я вписал sk13.dyndns.biz
Добавлено через 1 час 22 минуты
Зайти теперь получилось, изменил public_ip на 192.168.1.12, но при создании персонажа выдает ошибку такого вида "Не удалось создать персонажа из-за ошибки в базе данных игры". Но при еще одной попытки создать пишет, что "Персонаж с таким именем уже существует". Перевыбор сервера показывает, что на аккаунте есть данный персонаж, но зайти не возможно все просто висит.
Добавлено через 1 час 32 минуты
А уже при совершенно новом заходе в игру, то уже предлогают заново содать персонажа, а какого создавали персанажа - он создан, но не показывает! В чем проблема?
Добавлено через 7 часов 41 минуту
что за ошибка в gs? При выборе сервера тупо все висит и все..
Свернуть ↑
Код:
FATAL [07 ьрщ 19:28:02,718] Could not restore PlayerCommonData data for player:
1 from DB: Column 'legion_id' not found.
java.sql.SQLException: Column 'legion_id' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
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(DelegatingResultSe
t.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSe
t.java:275)
at system.database.mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5Pla
yerDAO.java:283)
at com.aionemu.gameserver.model.account.Account.loadAccount(Account.java
:133)
at com.aionemu.gameserver.model.account.Account.getAccount(Account.java:
78)
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthent
icationResponse(LoginServer.java:193)
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:95)
at com.aionemu.commons.network.netty.packet.AbstractClientPacket.run(Abs
tractClientPacket.java:63)
at com.aionemu.commons.network.netty.handler.AbstractChannelHandler.mess
ageReceived(AbstractChannelHandler.java:141)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(S
impleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultCh
annelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerC
ontext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.execution.ChannelEventRunnable.run(ChannelEve
ntRunnable.java:69)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:42)
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)
FATAL [07 ьрщ 19:28:02,786] Could not restore Equipment data for player: 1 from
DB: Unknown column 'disappearTime' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'disap
pearTime' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2113)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2275)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:96)
at system.database.mysql5.MySQL5InventoryDAO.loadEquipment(MySQL5Invento
ryDAO.java:173)
at com.aionemu.gameserver.model.account.Account.loadAccount(Account.java
:139)
at com.aionemu.gameserver.model.account.Account.getAccount(Account.java:
78)
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthent
icationResponse(LoginServer.java:193)
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:95)
at com.aionemu.commons.network.netty.packet.AbstractClientPacket.run(Abs
tractClientPacket.java:63)
at com.aionemu.commons.network.netty.handler.AbstractChannelHandler.mess
ageReceived(AbstractChannelHandler.java:141)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(S
impleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultCh
annelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerC
ontext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.execution.ChannelEventRunnable.run(ChannelEve
ntRunnable.java:69)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:42)
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)
WARN [07 ьрщ 19:28:02,793] Error executing select query java.lang.NullPointerExc
eption
java.lang.NullPointerException
at system.database.mysql5.MySQL5PlayerDAO$2.setParams(MySQL5PlayerDAO.ja
va:366)
at com.aionemu.commons.database.DB.select(DB.java:189)
at com.aionemu.commons.database.DB.select(DB.java:167)
at system.database.mysql5.MySQL5PlayerDAO.setCreationDeletionTime(MySQL5
PlayerDAO.java:361)
at com.aionemu.gameserver.model.account.Account.loadAccount(Account.java
:142)
at com.aionemu.gameserver.model.account.Account.getAccount(Account.java:
78)
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthent
icationResponse(LoginServer.java:193)
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:95)
at com.aionemu.commons.network.netty.packet.AbstractClientPacket.run(Abs
tractClientPacket.java:63)
at com.aionemu.commons.network.netty.handler.AbstractChannelHandler.mess
ageReceived(AbstractChannelHandler.java:141)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(S
impleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultCh
annelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerC
ontext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.execution.ChannelEventRunnable.run(ChannelEve
ntRunnable.java:69)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:42)
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 [07 ьрщ 19:28:02,796] Running failed for packet com.aionemu.gameserver.net
work.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE@1aba14e Revision: GS 591
, Common: 591 , DP: ${last.revision}
java.lang.NullPointerException
at com.aionemu.gameserver.model.account.Account.addPlayerAccountData(Acc
ount.java:285)
at com.aionemu.gameserver.model.account.Account.loadAccount(Account.java
:144)
at com.aionemu.gameserver.model.account.Account.getAccount(Account.java:
78)
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthent
icationResponse(LoginServer.java:193)
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AU
TH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:95)
at com.aionemu.commons.network.netty.packet.AbstractClientPacket.run(Abs
tractClientPacket.java:63)
at com.aionemu.commons.network.netty.handler.AbstractChannelHandler.mess
ageReceived(AbstractChannelHandler.java:141)
at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(S
impleChannelUpstreamHandler.java:80)
at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultCh
annelPipeline.java:545)
at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerC
ontext.sendUpstream(DefaultChannelPipeline.java:754)
at org.jboss.netty.handler.execution.ChannelEventRunnable.run(ChannelEve
ntRunnable.java:69)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWr
apper.java:61)
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrappe
r.java:42)
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)
Свернуть ↑Развернуть ↓