Thread: Need help setting up Arios #498

Results 1 to 3 of 3
  1. #1 Need help setting up Arios #498 
    Registered Member
    Join Date
    Feb 2019
    Posts
    2
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    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?
    Reply With Quote  
     

  2. #2  
    Registered Member
    arch337's Avatar
    Join Date
    Sep 2008
    Posts
    2,628
    Thanks given
    165
    Thanks received
    272
    Rep Power
    497
    I recommend changing the database name and also make sure the table it is looking for is added in that database. Database name it is trying to use "arios_server" and the tables are quite a few, to name some: "shops", "duel_scoreboard".


    "A fail act is something you do regular, but a dumb act is something you can learn from"
    Spoiler for Problem?:
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Feb 2019
    Posts
    2
    Thanks given
    0
    Thanks received
    0
    Rep Power
    0
    Quote Originally Posted by arch337 View Post
    I recommend changing the database name and also make sure the table it is looking for is added in that database. Database name it is trying to use "arios_server" and the tables are quite a few, to name some: "shops", "duel_scoreboard".
    Would I change the name of the SQL files? Or is there a way to import the tables in the SQL file into the database?
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need help setting up vps
    By d1sturbed in forum Help
    Replies: 2
    Last Post: 09-23-2009, 09:24 PM
  2. Need help setting up my compiler
    By homm88 in forum Help
    Replies: 1
    Last Post: 06-23-2009, 03:17 PM
  3. need help setting up vb!
    By jmeletz92yo in forum Help
    Replies: 7
    Last Post: 05-23-2009, 11:06 PM
  4. Replies: 0
    Last Post: 05-19-2009, 11:22 PM
  5. Need help setting up Linux dedi
    By `Mahfuz in forum Hosting
    Replies: 0
    Last Post: 01-11-2009, 01:20 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •