Thanks already found it.Originally Posted by micropanther
Thanks already found it.
Nice work but, what program use for modify database?? I need put mi char in admin. Thx
# Examples : NA : 4.7.5.1 / EU : 4.7.5.15 / KOR : 4.5.0.1 / OTHER : 4.0.0.2
# Default: 5.0.0.0
Server Version
The 5.1 not 5.8..
Help me.My personal server can play but inventory and equipment data cannot to be saved.Game server console mentioned any error.Can anyone solve it?02:33:21.227 ERROR[PacketProcessor:3]: - Failed to execute insert batchjava.sql.BatchUpdateException: Unknown column 'isEnhance' in 'field list' at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1168) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5InventoryDAO.insertItems(MySQL5InventoryDAO.java]:439) [na:na] at mysql5.MySQL5InventoryDAO.store(MySQL5InventoryDAO.java]:361) [na:na] at mysql5.MySQL5InventoryDAO.store(MySQL5InventoryDAO.java]:311) [na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [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.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isEnhance' in 'field list' at sun.reflect.GeneratedConstructorAccessor494.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756) ~[mysql-connector-java-5.1.46.jar:5.1.46] ... 13 common frames omitted02:34:18.142 ERROR[PacketProcessor:3]: - Error saving new player: 321182 Duancom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '321182' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_80] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_80] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:269) ~[na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [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.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]02:38:08.846 ERROR[InstantPool-9]: - Could not restore Equipment data for player: 321182 from DB: Unknown column 'isEnhance' in 'field list'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isEnhance' in 'field list' at sun.reflect.GeneratedConstructorAccessor494.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5InventoryDAO.loadEquipment(MySQL5InventoryDAO.java]:206) ~[na:na] at com.aionemu.gameserver.services.AccountService.loadAccount(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.services.AccountService.getAccount(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.loginserver.LsClientPacket.run(Unknown Source) [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]
Help me.My personal server can play but inventory and equipment data cannot to be saved.Game server console mentioned any error.Can anyone solve it?02:33:21.227 ERROR[PacketProcessor:3]: - Failed to execute insert batchjava.sql.BatchUpdateException: Unknown column 'isEnhance' in 'field list' at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1168) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5InventoryDAO.insertItems(MySQL5InventoryDAO.java]:439) [na:na] at mysql5.MySQL5InventoryDAO.store(MySQL5InventoryDAO.java]:361) [na:na] at mysql5.MySQL5InventoryDAO.store(MySQL5InventoryDAO.java]:311) [na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [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.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isEnhance' in 'field list' at sun.reflect.GeneratedConstructorAccessor494.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756) ~[mysql-connector-java-5.1.46.jar:5.1.46] ... 13 common frames omitted02:34:18.142 ERROR[PacketProcessor:3]: - Error saving new player: 321182 Duancom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '321182' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_80] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_80] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:269) ~[na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [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.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]02:38:08.846 ERROR[InstantPool-9]: - Could not restore Equipment data for player: 321182 from DB: Unknown column 'isEnhance' in 'field list'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isEnhance' in 'field list' at sun.reflect.GeneratedConstructorAccessor494.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966) ~[mysql-connector-java-5.1.46.jar:5.1.46] at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5InventoryDAO.loadEquipment(MySQL5InventoryDAO.java]:206) ~[na:na] at com.aionemu.gameserver.services.AccountService.loadAccount(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.services.AccountService.getAccount(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.loginserver.LsClientPacket.run(Unknown Source) [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]
work local ip only?
i do not use this client/server files. but i do use another. this can work on LOCAL and external connections through hamachi or Portforwarding.
@yokohiro
port forwarding does not work. i've tried every combination of that to no avail. I know my firewall is fine because my 4.7 connects external users just fine using the same ports.
however, testing out hamachi.. so COOL
hamachi work fine here.
i actually had this issue with my current server files. port forwarding worked to no avail, but suddenly, out of the blue. it started working with NO changes. whether it was my router/modem, or my ISP. not sure. it was not my PC nor my firewalls. i sat for 5 days trying to figure it out. did not work, until suddenly... all by itself. works now.
- - - Updated - - -
yeah it worked fine with my hamachi, but of course this is quite a way... not sure anyone would install hamachi unless you had close friends for it.
Hello, first of all very Thanks for it, I play very well but, don't know how to get admin. I think modify the mysql (using navicat..etc..) but, this like a portable. Can you help me about this? Thank you.
change privileges to you account table.
I got this working on localhost and then on my localgame server where I can connect with EU 5.8 client. I've tried to go into database and set the gameserver for external people to connect. The system see's their IP and creates them an account in the database but then dis connects them. The dispacher says failed to connect to gameserver. The funny thing is that I can connect from my side of the network. Any Idea what I'm missing. I have port forwarding setup. And I can connect fine. But for what ever reason the server kicks external users off. If anyone could point me in the right direction I'd be happy. Trying to get this working for a friends birthday tomorrow and its been doing my head in.
- - - Updated - - -
For navicat change your test connection to 127.0.0.1 (vs) locahost then add your root / 123456 once you have connected to your database via navicat.
Note: Make sure your single player db is running.
From there goto your al_server_sl database, goto account_data goto ID:2 or where ever you see you account name, change the access level to 10 in your account_data table. Save the table, reload your login server. You'll have admin (server owner) status. When you login.
yes you can make it public yes i tested it with 5 players. Some of the quests are missing but nothing that effects progression for class change. some missing quest for sanctum are missing for aka getting your pets and a few other quest are missing but can pick up main quest in next area. i have only tested it up to lvl 25 so far so good
Last edited by goober100; 04-10-18 at 12:47 AM.
what did you add to gameserver table or do I need to change something in the ipconfig.xml .. again I've got it working fine with in my LAN but not sure why it won't accept external connections outside of my network. She and I both have the EU 5.8 Gameforge client. The launcher I gave her has my servers IP. or is there a setting in the config files that needs to be turned on?
Reply With Quote