Need help setting up Arios #498
I've successfully managed to get a MySQL local server running and the source connects to it successfully, but I'm getting this error.
Code:
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
[2019-08-14 19:07:02][Arios]: Prompting Arios Game World...
[2019-08-14 19:07:02][Arios]: Initializing cache...
[2019-08-14 19:07:03][Arios]: Parsed 33 Arios scripts...
java.sql.SQLSyntaxErrorException: Table 'arios_server.duel_scoreboard' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at plugin.activity.duel.DuelArenaActivity.parseScoreboard(DuelArenaActivity.java:176)
at plugin.activity.duel.DuelArenaActivity.configure(DuelArenaActivity.java:144)
at org.arios.game.content.activity.ActivityManager.register(ActivityManager.java:37)
at org.arios.plugin.PluginManager.definePlugin(PluginManager.java:137)
at org.arios.plugin.PluginManager.loadLocal(PluginManager.java:95)
at org.arios.plugin.PluginManager.loadLocal(PluginManager.java:66)
at org.arios.plugin.PluginManager.loadLocal(PluginManager.java:66)
at org.arios.plugin.PluginManager.init(PluginManager.java:40)
at org.arios.game.world.GameWorld.prompt(GameWorld.java:163)
at org.arios.game.world.GameWorld.prompt(GameWorld.java:146)
at org.arios.Main.main(Main.java:47)
java.sql.SQLSyntaxErrorException: Table 'arios_server.worlds' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at org.arios.game.node.entity.player.info.login.LoginConfiguration.readWeeklyMessage(LoginConfiguration.java:74)
at org.arios.game.node.entity.player.info.login.LoginConfiguration.<clinit>(LoginConfiguration.java:395)
at org.arios.plugin.PluginManager.definePlugin(PluginManager.java:139)
at org.arios.plugin.PluginManager.loadLocal(PluginManager.java:95)
at org.arios.plugin.PluginManager.loadLocal(PluginManager.java:66)
at org.arios.plugin.PluginManager.loadLocal(PluginManager.java:66)
at org.arios.plugin.PluginManager.init(PluginManager.java:40)
at org.arios.game.world.GameWorld.prompt(GameWorld.java:163)
at org.arios.game.world.GameWorld.prompt(GameWorld.java:146)
at org.arios.Main.main(Main.java:47)
[2019-08-14 19:07:25][Arios]: Initialized 1408 plugins...
java.sql.SQLSyntaxErrorException: Table 'arios_server.shops' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at org.arios.game.system.mysql.impl.ShopSQLHandler.parse(ShopSQLHandler.java:62)
at org.arios.game.system.mysql.SQLManager.postPlugin(SQLManager.java:69)
at org.arios.game.world.GameWorld.prompt(GameWorld.java:168)
at org.arios.game.world.GameWorld.prompt(GameWorld.java:146)
at org.arios.Main.main(Main.java:47)
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
java.sql.SQLSyntaxErrorException: Table 'arios_server.settings' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at org.arios.game.system.SystemConfig.reload(SystemConfig.java:68)
at org.arios.game.system.mysql.SQLManager.init(SQLManager.java:61)
at org.arios.Main.main(Main.java:48)
[2019-08-14 19:07:25][Arios]: Starting NIO reactor...
[2019-08-14 19:07:25][Arios]: Attempting to connect to management server...
[2019-08-14 19:07:26][Arios]: Arios flags GameSettings [name=Arios, beta=false, devMode=true, gui=false, type=ECONOMY, worldId=2]
[2019-08-14 19:07:26][Arios]: Arios started in 24225 milliseconds.
java.net.ConnectException: Connection refused: no further information
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source)
at org.arios.net.amsc.MSEventHandler.connect(MSEventHandler.java:29)
at org.arios.net.NioReactor.run(NioReactor.java:123)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Failed connecting to Management Server!
[2019-08-14 19:07:27][Arios]: Management server status: NOT_AVAILABLE.
java.nio.channels.CancelledKeyException
at sun.nio.ch.SelectionKeyImpl.ensureValid(Unknown Source)
at sun.nio.ch.SelectionKeyImpl.readyOps(Unknown Source)
at java.nio.channels.SelectionKey.isAcceptable(Unknown Source)
at org.arios.net.NioReactor.run(NioReactor.java:125)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.sql.SQLSyntaxErrorException: Table 'arios_server.members' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at org.arios.game.node.entity.player.info.portal.PlayerSQLManager.getCredentialResponse(PlayerSQLManager.java:222)
at org.arios.net.event.LoginReadEvent$1.run(LoginReadEvent.java:106)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I understand that it needs a database, but I'm unsure how to go about doing it since I keep gettings errors when I try to create a new one (I've been googling how to do it). I've also found the SQL files that have tables, but I'm not sure how to get them to work? I've placed them in the server's folder, but it doesn't read from them. Anyone want to help a noob?