Originally Posted by
Mayne
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?