Thread: Removing MySQL

Results 1 to 8 of 8
  1. #1 Removing MySQL 
    Registered Member

    Join Date
    Feb 2011
    Posts
    1,143
    Thanks given
    545
    Thanks received
    110
    Rep Power
    87
    So I located where I needed to change it, but I'm confused as to how I would change MySql to local.. Or remove it altogether; I understand it may not be this simple, but I will take whatever works.


    Code:
    public boolean connect() {
    		try {
    	
    			MySQLDatabaseConfiguration configuration = (MySQLDatabaseConfiguration) this.configuration;
    			connection = DriverManager.getConnection("jdbc:mysql://"
    					+ configuration.getHost() + ":" + configuration.getPort()
    					+ "/" + configuration.getDatabase(),
    					configuration.getUsername(), configuration.getPassword());
    			return true;
    		} catch (SQLException e) {
    			System.out.println("MYSQL connection not working");
    			e.printStackTrace();
    		}
    		return false;
    	}

    Reply With Quote  
     

  2. #2  
    Registered Member

    Join Date
    Feb 2013
    Posts
    4,409
    Thanks given
    59
    Thanks received
    478
    Rep Power
    138
    Change it to localhost in MySQLDatabaseConfiguration?

    Or just delete everything?
    Reply With Quote  
     

  3. #3  
    Registered Member

    Join Date
    Feb 2011
    Posts
    1,143
    Thanks given
    545
    Thanks received
    110
    Rep Power
    87
    Quote Originally Posted by Mayne View Post
    Change it to localhost in MySQLDatabaseConfiguration?

    Or just delete everything?
    Here's what I tried...

    It's connecting to 127.0.0.1, like I can almost get into the lobby, but it can't connect to the mySQL connection.. I'll post the error.

    Code:
    Oct 24, 2014 12:43:55 PM com.sevador.network.KeyMap initialize
    INFO: Binding packet handlers...
    Oct 24, 2014 12:43:55 PM com.sevador.network.KeyMap initialize
    INFO: Bound 43 packet handlers
    Oct 24, 2014 12:43:56 PM net.burtleburtle.cache.Cache init
    INFO: Loaded cache!
    Oct 24, 2014 12:43:56 PM com.sevador.game.world.World loadConfiguration
    INFO: Connected to 198.57.151.250:3306 in 0 ms.
    Oct 24, 2014 12:43:56 PM com.sevador.content.friendChat.FriendChatManager <init>
    
    INFO: Read 2 friend chat xml tables.
    Loading item definitions...
    Oct 24, 2014 12:43:57 PM com.sevador.game.dialogue.DialogueHandler init
    INFO: Loaded 22 dialogues successfully.
    Oct 24, 2014 12:43:57 PM com.sevador.content.grandExchange.GrandExchange init
    INFO: Loaded 0 grand exchange item offers!
    Loading areas...
    Loaded 25 areas.
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.npc.DropLoader load
    INFO: Loaded 2651 drops
    Oct 24, 2014 12:43:58 PM com.sevador.game.world.World initialize
    INFO: World loaded.
    Loaded 22308 item definitions.
    Server port bound to - 43594Constants.w2PORT
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loading node types...
    Oct 24, 2014 12:43:58 PM com.sevador.Main main
    INFO: Server took (3015 ms) to Run.
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loaded 41 object node types & 1 NPC node types.
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loading range weapon info...
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loaded 184 range weapon definitions.
    Oct 24, 2014 12:43:59 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loading range ammunition info...
    Oct 24, 2014 12:43:59 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loaded 219 ammunition definitions.
    Oct 24, 2014 12:43:59 PM com.sevador.game.misc.ShopManager load
    INFO: Loaded 11 game shops.
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading customized NPC classes...
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 19 customized NPCs.
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading NPC spawns...
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 2331 NPC spawns.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 38 button events.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 35 magic spell events.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 75 special attack events.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 182 npc action events.
    Oct 24, 2014 12:44:01 PM com.sevador.game.event.EventManager init
    INFO: Loaded 1793 object action events.
    Oct 24, 2014 12:44:01 PM com.sevador.game.event.EventManager init
    INFO: Loaded 224 item action events.
    Oct 24, 2014 12:44:20 PM com.sevador.content.quest.QuestListener <clinit>
    INFO: Loaded 1, there are now 1 quest points you can achieve.
    MYSQL connection not working
    java.sql.SQLException: Access denied for user 'tinyrsps_ipuser'@'23.31.139.44' (
    using password: YES)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
            at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
            at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
    370)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
            at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
            at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
            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:411)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :305)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at com.sevador.database.mysql.MySQLDatabaseConnection.connect(MySQLDatab
    aseConnection.java:45)
            at com.sevador.database.ConnectionPool.nextFree(ConnectionPool.java:81)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1034)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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.lang.RuntimeException: Connection was unable to connect!
            at com.sevador.database.ConnectionPool.nextFree(ConnectionPool.java:82)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1034)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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)
    Registered player [name=dfdsf, lobby=true, index=1, online=1]
    Channel disconnected; removing player Dfdsf from node worker.
    Unregistered player [name=dfdsf, lobby=true, online=0]


    EDIT:

    I changed
    Code:
    public boolean connect() {
    		
    			Constants.getSavePath();
    			
    	return true;
    }
    Code:
    Oct 24, 2014 12:48:49 PM com.sevador.network.KeyMap initialize
    INFO: Binding packet handlers...
    Oct 24, 2014 12:48:49 PM com.sevador.network.KeyMap initialize
    INFO: Bound 43 packet handlers
    Oct 24, 2014 12:48:49 PM net.burtleburtle.cache.Cache init
    INFO: Loaded cache!
    Oct 24, 2014 12:48:49 PM com.sevador.game.world.World loadConfiguration
    INFO: Connected to 198.57.151.250:3306 in 1 ms.
    Oct 24, 2014 12:48:49 PM com.sevador.content.friendChat.FriendChatManager <init>
    
    INFO: Read 2 friend chat xml tables.
    Loading item definitions...
    Oct 24, 2014 12:48:50 PM com.sevador.game.dialogue.DialogueHandler init
    INFO: Loaded 22 dialogues successfully.
    Oct 24, 2014 12:48:50 PM com.sevador.content.grandExchange.GrandExchange init
    INFO: Loaded 0 grand exchange item offers!
    Loading areas...
    Loaded 25 areas.
    Oct 24, 2014 12:48:50 PM com.sevador.game.node.npc.DropLoader load
    INFO: Loaded 2651 drops
    Oct 24, 2014 12:48:50 PM com.sevador.game.world.World initialize
    INFO: World loaded.
    Server port bound to - 43594Constants.w2PORT
    Oct 24, 2014 12:48:50 PM com.sevador.Main main
    INFO: Server took (1628 ms) to Run.
    Loaded 22308 item definitions.
    Oct 24, 2014 12:48:50 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loading node types...
    Oct 24, 2014 12:48:50 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loaded 41 object node types & 1 NPC node types.
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loading range weapon info...
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loaded 184 range weapon definitions.
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loading range ammunition info...
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loaded 219 ammunition definitions.
    Oct 24, 2014 12:48:51 PM com.sevador.game.misc.ShopManager load
    INFO: Loaded 11 game shops.
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading customized NPC classes...
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 19 customized NPCs.
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading NPC spawns...
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 2331 NPC spawns.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 38 button events.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 35 magic spell events.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 75 special attack events.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 182 npc action events.
    Oct 24, 2014 12:48:52 PM com.sevador.game.event.EventManager init
    INFO: Loaded 1793 object action events.
    Oct 24, 2014 12:48:52 PM com.sevador.game.event.EventManager init
    INFO: Loaded 224 item action events.
    Oct 24, 2014 12:48:56 PM com.sevador.content.quest.QuestListener <clinit>
    INFO: Loaded 1, there are now 1 quest points you can achieve.
    java.sql.SQLException: Database not connected yet!
            at com.sevador.database.DatabaseConnection.createStatement(DatabaseConne
    ction.java:102)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1037)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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.lang.NullPointerException
            at com.sevador.database.DatabaseConnection.isClosed(DatabaseConnection.j
    ava:140)
            at com.sevador.database.DatabaseConnection.isFresh(DatabaseConnection.ja
    va:153)
            at com.sevador.database.ConnectionPool.nextFree(ConnectionPool.java:68)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1034)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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)
    Registered player [name=fdsdf, lobby=true, index=1, online=1]
    Channel disconnected; removing player Fdsdf from node worker.
    Unregistered player [name=fdsdf, lobby=true, online=0]
    ^ that brings me to this

    Code:
    public Statement createStatement() throws SQLException {
    		if (connection == null) {
    			throw new SQLException("Database not connected yet!");
    		}
    		if (connection.isClosed()) {
    			throw new SQLException("Connection closed!");
    		}
    		return connection.createStatement();
    	}
    what should I do to it?

    Reply With Quote  
     

  4. #4  
    Registered Member

    Join Date
    Feb 2013
    Posts
    4,409
    Thanks given
    59
    Thanks received
    478
    Rep Power
    138
    Quote Originally Posted by Falconpunch View Post
    Here's what I tried...

    It's connecting to 127.0.0.1, like I can almost get into the lobby, but it can't connect to the mySQL connection.. I'll post the error.

    Code:
    Oct 24, 2014 12:43:55 PM com.sevador.network.KeyMap initialize
    INFO: Binding packet handlers...
    Oct 24, 2014 12:43:55 PM com.sevador.network.KeyMap initialize
    INFO: Bound 43 packet handlers
    Oct 24, 2014 12:43:56 PM net.burtleburtle.cache.Cache init
    INFO: Loaded cache!
    Oct 24, 2014 12:43:56 PM com.sevador.game.world.World loadConfiguration
    INFO: Connected to 198.57.151.250:3306 in 0 ms.
    Oct 24, 2014 12:43:56 PM com.sevador.content.friendChat.FriendChatManager <init>
    
    INFO: Read 2 friend chat xml tables.
    Loading item definitions...
    Oct 24, 2014 12:43:57 PM com.sevador.game.dialogue.DialogueHandler init
    INFO: Loaded 22 dialogues successfully.
    Oct 24, 2014 12:43:57 PM com.sevador.content.grandExchange.GrandExchange init
    INFO: Loaded 0 grand exchange item offers!
    Loading areas...
    Loaded 25 areas.
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.npc.DropLoader load
    INFO: Loaded 2651 drops
    Oct 24, 2014 12:43:58 PM com.sevador.game.world.World initialize
    INFO: World loaded.
    Loaded 22308 item definitions.
    Server port bound to - 43594Constants.w2PORT
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loading node types...
    Oct 24, 2014 12:43:58 PM com.sevador.Main main
    INFO: Server took (3015 ms) to Run.
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loaded 41 object node types & 1 NPC node types.
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loading range weapon info...
    Oct 24, 2014 12:43:58 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loaded 184 range weapon definitions.
    Oct 24, 2014 12:43:59 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loading range ammunition info...
    Oct 24, 2014 12:43:59 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loaded 219 ammunition definitions.
    Oct 24, 2014 12:43:59 PM com.sevador.game.misc.ShopManager load
    INFO: Loaded 11 game shops.
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading customized NPC classes...
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 19 customized NPCs.
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading NPC spawns...
    Oct 24, 2014 12:43:59 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 2331 NPC spawns.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 38 button events.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 35 magic spell events.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 75 special attack events.
    Oct 24, 2014 12:44:00 PM com.sevador.game.event.EventManager init
    INFO: Loaded 182 npc action events.
    Oct 24, 2014 12:44:01 PM com.sevador.game.event.EventManager init
    INFO: Loaded 1793 object action events.
    Oct 24, 2014 12:44:01 PM com.sevador.game.event.EventManager init
    INFO: Loaded 224 item action events.
    Oct 24, 2014 12:44:20 PM com.sevador.content.quest.QuestListener <clinit>
    INFO: Loaded 1, there are now 1 quest points you can achieve.
    MYSQL connection not working
    java.sql.SQLException: Access denied for user 'tinyrsps_ipuser'@'23.31.139.44' (
    using password: YES)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:935)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)
            at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)
            at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
    370)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
            at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
            at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
            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:411)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
    :305)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at com.sevador.database.mysql.MySQLDatabaseConnection.connect(MySQLDatab
    aseConnection.java:45)
            at com.sevador.database.ConnectionPool.nextFree(ConnectionPool.java:81)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1034)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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.lang.RuntimeException: Connection was unable to connect!
            at com.sevador.database.ConnectionPool.nextFree(ConnectionPool.java:82)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1034)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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)
    Registered player [name=dfdsf, lobby=true, index=1, online=1]
    Channel disconnected; removing player Dfdsf from node worker.
    Unregistered player [name=dfdsf, lobby=true, online=0]


    EDIT:

    I changed
    Code:
    public boolean connect() {
    		
    			Constants.getSavePath();
    			
    	return true;
    }
    Code:
    Oct 24, 2014 12:48:49 PM com.sevador.network.KeyMap initialize
    INFO: Binding packet handlers...
    Oct 24, 2014 12:48:49 PM com.sevador.network.KeyMap initialize
    INFO: Bound 43 packet handlers
    Oct 24, 2014 12:48:49 PM net.burtleburtle.cache.Cache init
    INFO: Loaded cache!
    Oct 24, 2014 12:48:49 PM com.sevador.game.world.World loadConfiguration
    INFO: Connected to 198.57.151.250:3306 in 1 ms.
    Oct 24, 2014 12:48:49 PM com.sevador.content.friendChat.FriendChatManager <init>
    
    INFO: Read 2 friend chat xml tables.
    Loading item definitions...
    Oct 24, 2014 12:48:50 PM com.sevador.game.dialogue.DialogueHandler init
    INFO: Loaded 22 dialogues successfully.
    Oct 24, 2014 12:48:50 PM com.sevador.content.grandExchange.GrandExchange init
    INFO: Loaded 0 grand exchange item offers!
    Loading areas...
    Loaded 25 areas.
    Oct 24, 2014 12:48:50 PM com.sevador.game.node.npc.DropLoader load
    INFO: Loaded 2651 drops
    Oct 24, 2014 12:48:50 PM com.sevador.game.world.World initialize
    INFO: World loaded.
    Server port bound to - 43594Constants.w2PORT
    Oct 24, 2014 12:48:50 PM com.sevador.Main main
    INFO: Server took (1628 ms) to Run.
    Loaded 22308 item definitions.
    Oct 24, 2014 12:48:50 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loading node types...
    Oct 24, 2014 12:48:50 PM com.sevador.game.node.NodeTypeRepositary init
    INFO: Loaded 41 object node types & 1 NPC node types.
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loading range weapon info...
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.RangeWeapon ini
    tialize
    INFO: Loaded 184 range weapon definitions.
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loading range ammunition info...
    Oct 24, 2014 12:48:51 PM com.sevador.game.node.model.combat.form.Ammunition init
    ialize
    INFO: Loaded 219 ammunition definitions.
    Oct 24, 2014 12:48:51 PM com.sevador.game.misc.ShopManager load
    INFO: Loaded 11 game shops.
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading customized NPC classes...
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 19 customized NPCs.
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loading NPC spawns...
    Oct 24, 2014 12:48:51 PM com.sevador.game.world.NPCWorldLoader init
    INFO: Loaded 2331 NPC spawns.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 38 button events.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 35 magic spell events.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 75 special attack events.
    Oct 24, 2014 12:48:51 PM com.sevador.game.event.EventManager init
    INFO: Loaded 182 npc action events.
    Oct 24, 2014 12:48:52 PM com.sevador.game.event.EventManager init
    INFO: Loaded 1793 object action events.
    Oct 24, 2014 12:48:52 PM com.sevador.game.event.EventManager init
    INFO: Loaded 224 item action events.
    Oct 24, 2014 12:48:56 PM com.sevador.content.quest.QuestListener <clinit>
    INFO: Loaded 1, there are now 1 quest points you can achieve.
    java.sql.SQLException: Database not connected yet!
            at com.sevador.database.DatabaseConnection.createStatement(DatabaseConne
    ction.java:102)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1037)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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.lang.NullPointerException
            at com.sevador.database.DatabaseConnection.isClosed(DatabaseConnection.j
    ava:140)
            at com.sevador.database.DatabaseConnection.isFresh(DatabaseConnection.ja
    va:153)
            at com.sevador.database.ConnectionPool.nextFree(ConnectionPool.java:68)
            at com.sevador.game.node.player.Player.getForumTable(Player.java:1034)
            at com.sevador.network.out.LobbyResponse.get(LobbyResponse.java:39)
            at com.sevador.network.IOSession.write(IOSession.java:87)
            at com.sevador.game.node.player.PacketSender.sendLogin(PacketSender.java
    :85)
            at com.sevador.game.node.player.Player.init(Player.java:387)
            at net.burtleburtle.thread.NodeWorker.run(NodeWorker.java:117)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.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)
    Registered player [name=fdsdf, lobby=true, index=1, online=1]
    Channel disconnected; removing player Fdsdf from node worker.
    Unregistered player [name=fdsdf, lobby=true, online=0]
    ^ that brings me to this

    Code:
    public Statement createStatement() throws SQLException {
    		if (connection == null) {
    			throw new SQLException("Database not connected yet!");
    		}
    		if (connection.isClosed()) {
    			throw new SQLException("Connection closed!");
    		}
    		return connection.createStatement();
    	}
    what should I do to it?

    Are you even hosting a database?
    Reply With Quote  
     

  5. #5  
    Registered Member

    Join Date
    Feb 2011
    Posts
    1,143
    Thanks given
    545
    Thanks received
    110
    Rep Power
    87
    Quote Originally Posted by Mayne View Post
    Are you even hosting a database?
    This is the Sevador 666 release, and it comes with MySQL. I'm trying to remove MySQL to avoid buying a database.. Might just buy one anyways and just fuck it

    Reply With Quote  
     

  6. #6  
    Registered Member

    Join Date
    Feb 2013
    Posts
    4,409
    Thanks given
    59
    Thanks received
    478
    Rep Power
    138
    Quote Originally Posted by Falconpunch View Post
    This is the Sevador 666 release, and it comes with MySQL. I'm trying to remove MySQL to avoid buying a database.. Might just buy one anyways and just fuck it
    It's free..

    You're probably trying to connect to the database that was left over when he released it..
    He probably didn't remove it lol.
    You have to use your own..
    Reply With Quote  
     

  7. #7  
    Registered Member

    Join Date
    Feb 2011
    Posts
    1,143
    Thanks given
    545
    Thanks received
    110
    Rep Power
    87
    Quote Originally Posted by Mayne View Post
    It's free..

    You're probably trying to connect to the database that was left over when he released it..
    He probably didn't remove it lol.
    You have to use your own..
    Hmmmm kk which free sites do you recommend?

    Reply With Quote  
     

  8. #8  
    Registered Member

    Join Date
    Feb 2013
    Posts
    4,409
    Thanks given
    59
    Thanks received
    478
    Rep Power
    138
    Quote Originally Posted by Falconpunch View Post
    Hmmmm kk which free sites do you recommend?
    host it yourself
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

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


User Tag List

Similar Threads

  1. [PI]Remove MYSQL
    By 1NJ3CT3D in forum Help
    Replies: 4
    Last Post: 03-15-2011, 10:37 PM
  2. How to remove Mysql? Paying! [PI]
    By r3v0k3 in forum Help
    Replies: 5
    Last Post: 01-03-2011, 03:59 AM
  3. [BS]Removing MySQL
    By Shemhamforash in forum Help
    Replies: 4
    Last Post: 12-27-2009, 04:35 AM
  4. remove mysql?
    By Akeid in forum Help
    Replies: 1
    Last Post: 09-18-2009, 11:16 PM
  5. removing MYSQL from a server
    By fireking in forum Tutorials
    Replies: 0
    Last Post: 07-23-2008, 03:36 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •