[1/23/12 7:15 AM]: java.sql.SQLException: Access denied for user '584537_nuno199
6'@'46.23.70.224' (using password: YES)
Allow remote mysql
|
Hello Guys I need Help with My Sql it Cant Connect i think when i do ::claim it Appers Me This Error:
[1/23/12 7:15 AM]: java.lang.NullPointerException
[1/23/12 7:15 AM]: at server.util.SQL.destroyConnection(SQL.java:65)
[1/23/12 7:15 AM]: at server.util.SQL.query(SQL.java:33)
[1/23/12 7:15 AM]: at server.util.SQL.checkVote(SQL.java:44)
[1/23/12 7:15 AM]: at server.model.players.packets.Commands.playerComman ds(
Commands.java:133)
[1/23/12 7:15 AM]: at server.model.players.packets.Commands.processPacke t(C
ommands.java:47)
[1/23/12 7:15 AM]: at server.model.players.PacketHandler.processPacket(P ack
etHandler.java:137)
[1/23/12 7:15 AM]: at server.model.players.Client.processQueuedPackets(C lie
nt.java:1226)
[1/23/12 7:15 AM]: at server.model.players.PlayerHandler.process(PlayerH and
ler.java:140)
[1/23/12 7:15 AM]: at server.Server.main(Server.java:162)
[1/23/12 7:15 AM]: java.sql.SQLException: Access denied for user '584537_nuno199
6'@'46.23.70.224' (using password: YES)
[1/23/12 7:15 AM]: at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.j
ava:1055)
[1/23/12 7:15 AM]: at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.j
ava:956)
[1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:
3536)
[1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:
3468)
[1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:
917)
[1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 397
4)
[1/23/12 7:15 AM]: at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 82)
[1/23/12 7:15 AM]: at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onI
mpl.java:2142)
[1/23/12 7:15 AM]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.j
ava:773)
[1/23/12 7:15 AM]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion
.java:46)
[1/23/12 7:15 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
0(Native Method)
[1/23/12 7:15 AM]: at sun.reflect.NativeConstructorAccessorImpl.newInsta nce
(Unknown Source)
[1/23/12 7:15 AM]: at sun.reflect.DelegatingConstructorAccessorImpl.newI nst
ance(Unknown Source)
[1/23/12 7:15 AM]: at java.lang.reflect.Constructor.newInstance(Unknown Sou
rce)
[1/23/12 7:15 AM]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
[1/23/12 7:15 AM]: at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onI
mpl.java:352)
[1/23/12 7:15 AM]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg ist
eringDriver.java:282)
[1/23/12 7:15 AM]: at java.sql.DriverManager.getConnection(Unknown Source)
[1/23/12 7:15 AM]: at java.sql.DriverManager.getConnection(Unknown Source)
[1/23/12 7:15 AM]: at server.util.SQL.createConnection(SQL.java:14)
[1/23/12 7:15 AM]: at server.util.SQL.query(SQL.java:34)
[1/23/12 7:15 AM]: at server.util.SQL.checkVote(SQL.java:44)
[1/23/12 7:15 AM]: at server.model.players.packets.Commands.playerComman ds(
Commands.java:133)
[1/23/12 7:15 AM]: at server.model.players.packets.Commands.processPacke t(C
ommands.java:47)
[1/23/12 7:15 AM]: at server.model.players.PacketHandler.processPacket(P ack
etHandler.java:137)
[1/23/12 7:15 AM]: at server.model.players.Client.processQueuedPackets(C lie
nt.java:1226)
[1/23/12 7:15 AM]: at server.model.players.PlayerHandler.process(PlayerH and
ler.java:140)
[1/23/12 7:15 AM]: at server.Server.main(Server.java:162)
[1/23/12 7:15 AM]: java.lang.NullPointerException
[1/23/12 7:15 AM]: at server.util.SQL.query(SQL.java:26)
[1/23/12 7:15 AM]: at server.util.SQL.checkVote(SQL.java:44)
[1/23/12 7:15 AM]: at server.model.players.packets.Commands.playerComman ds(
Commands.java:133)
[1/23/12 7:15 AM]: at server.model.players.packets.Commands.processPacke t(C
ommands.java:47)
[1/23/12 7:15 AM]: at server.model.players.PacketHandler.processPacket(P ack
etHandler.java:137)
[1/23/12 7:15 AM]: at server.model.players.Client.processQueuedPackets(C lie
nt.java:1226)
[1/23/12 7:15 AM]: at server.model.players.PlayerHandler.process(PlayerH and
ler.java:140)
[1/23/12 7:15 AM]: at server.Server.main(Server.java:162)
[1/23/12 7:15 AM]: java.lang.NullPointerException
Ok Heres my SQL:
package server.util;
import java.sql.*;
import java.security.MessageDigest;
import server.model.players.Client;
public class SQL {
public static Connection con = null;
public static Statement stmt;
public static boolean connectionMade;
public static void createConnection() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance ();
con = DriverManager.getConnection("jdbc:mysql://localhost/votelunatic_zzl_vote","584537_nuno1996","PassWordR emoved");
stmt = con.createStatement();
connectionMade = true;
} catch (Exception e) {
connectionMade = false;
e.printStackTrace();
}
}
public static ResultSet query(String s) throws SQLException {
try {
if (s.toLowerCase().startsWith("select")) {
ResultSet rs = stmt.executeQuery(s);
return rs;
} else {
stmt.executeUpdate(s);
}
return null;
} catch (Exception e) {
destroyConnection();
createConnection();
e.printStackTrace();
}
return null;
}
public static void checkVote(Client c) {
try {
if(c.getItems().freeSlots() > 0) {
//Statement stmt = con.createStatement();
ResultSet rs = query("SELECT id,item_id, item_amount FROM `items` WHERE `username`= '" + c.playerName + "' AND `claimed`= '0'");
if(rs.next()) {
int rowid = rs.getInt("id");
int itemid = rs.getInt("item_id");
int amount = rs.getInt("item_amount");
query("UPDATE `items` SET `claimed` = 1 WHERE `username` = '" + c.playerName + "' AND `id`='" + rowid + "'");
c.getItems().addItem(itemid, amount);
c.sendMessage("You receive "+amount+" X "+c.getItems().getItemName(itemid)+".");
} else {
c.sendMessage("No items waiting for you.");
}
} else {
c.sendMessage("Please make space for your items.");
}
} catch (SQLException ex) {
System.out.println(ex);
}
}
public static void destroyConnection() {
try {
stmt.close();
con.close();
connectionMade = false;
} catch (Exception e) {
e.printStackTrace();
}
}
}
Please Help Heres My Msn: [email protected]
[1/23/12 7:15 AM]: java.sql.SQLException: Access denied for user '584537_nuno199
6'@'46.23.70.224' (using password: YES)
Allow remote mysql
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |