Solved SQL connection to my own database error

Code:

23:26:57 [SEVERE] [SpaceWarz] Could not connect to MySQL server! because: Access
denied for user 'root'@'localhost' (using password: NO)
23:26:57 [SEVERE] [SpaceWarz] Could not connect to MySQL server! because: Access
denied for user 'root'@'localhost' (using password: NO)
23:26:57 [SEVERE] Error occurred while enabling SpaceWarz v0.5.6B (Is it up to d
ate?)
java.lang.NullPointerException
        at net.bhnetworks.spacewars.utils.MySQL.updateSQL(MySQL.java:139)
        at net.bhnetworks.spacewars.SpaceWars.connect(SpaceWars.java:41)
        at net.bhnetworks.spacewars.SpaceWars.onEnable(SpaceWars.java:25)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
.java:457)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
r.java:382)
        at org.bukkit.craftbukkit.v1_6_R3.CraftServer.loadPlugin(CraftServer.jav
a:288)
        at org.bukkit.craftbukkit.v1_6_R3.CraftServer.enablePlugins(CraftServer.
java:270)
        at org.bukkit.craftbukkit.v1_6_R3.CraftServer.reload(CraftServer.java:61
8)
        at org.bukkit.Bukkit.reload(Bukkit.java:277)
        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:
24)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:19
2)
        at org.bukkit.craftbukkit.v1_6_R3.CraftServer.dispatchCommand(CraftServe
r.java:532)
        at org.bukkit.craftbukkit.v1_6_R3.CraftServer.dispatchServerCommand(Craf
tServer.java:519)
        at net.minecraft.server.v1_6_R3.DedicatedServer.as(DedicatedServer.java:
276)
        at net.minecraft.server.v1_6_R3.DedicatedServer.t(DedicatedServer.java:2
41)
        at net.minecraft.server.v1_6_R3.MinecraftServer.s(MinecraftServer.java:4
83)
        at net.minecraft.server.v1_6_R3.MinecraftServer.run(MinecraftServer.java
:415)
        at net.minecraft.server.v1_6_R3.ThreadServerApplication.run(SourceFile:5
83)

I get that error every time I am starting my serer with my plugin trying to connect to a database, and I have no idea whats causing it. File is set up like so:

Code:

    user: root
    database: test
    host: localhost
    port: 3306
    password: -snip-

SQL Class (thanks Husky)

Code:java

package net.bhnetworks.spacewars.utils;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
 
import org.bukkit.plugin.Plugin;
 
 
/**
* Connects to and uses a MySQL database
*
* @author -_Husky_-
* @author tips48
*/
public class MySQL extends Database {
private final String user;
private final String database;
private final String password;
private final String port;
private final String hostname;
 
 
private Connection connection;
 
 
/**
* Creates a new MySQL instance
*
* @param plugin
* Plugin instance
* @param hostname
* Name of the host
* @param portnmbr
* Port number
* @param database
* Database name
* @param username
* Username
* @param password
* Password
*/
public MySQL(Plugin plugin, String hostname, String port, String database, String username, String password) {
super(plugin);
this.hostname = hostname;
this.port = port;
this.database = database;
this.user = username;
this.password = password;
this.connection = null;
}
 
 
@Override
public Connection openConnection() {
try {
Class.forName("com.mysql.jdbc.Driver");
String statement = "CREATE DATABASE IF NOT EXISTS "+database;
Connection conn = DriverManager.getConnection("jdbc:mysql://" + hostname + ":" + port, user, password);
Statement st = conn.createStatement();
st.executeUpdate(statement);
st.close();
conn.close();
connection = DriverManager.getConnection("jdbc:mysql://" + this.hostname + ":" + this.port + "/" + this.database, this.user, this.password);
} catch (SQLException e) {
plugin.getLogger().log(Level.SEVERE, "Could not connect to MySQL server! because: " + e.getMessage());
} catch (ClassNotFoundException e) {
plugin.getLogger().log(Level.SEVERE, "JDBC Driver not found!");
}
return connection;
}
 
 
@Override
public boolean checkConnection() {
return connection != null;
}
 
 
@Override
public Connection getConnection() {
return connection;
}
 
 
@Override
public void closeConnection() {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
plugin.getLogger().log(Level.SEVERE, "Error closing the MySQL Connection!");
e.printStackTrace();
}
}
}
 
 
public ResultSet querySQL(String query) {
 
 
Connection c = openConnection();
Statement s = null;
 
 
try {
s = c.createStatement();
} catch (SQLException e1) {
e1.printStackTrace();
}
 
 
ResultSet ret = null;
 
 
try {
ret = s.executeQuery(query);
 
} catch (SQLException e) {
e.printStackTrace();
}
 
 
return ret;
}
 
 
public void updateSQL(String update) {
 
 
Connection c = openConnection();
Statement s = null;
 
 
try {
s = c.createStatement();
s.executeUpdate(update);
} catch (SQLException e1) {
e1.printStackTrace();
}
 
 
}
 
 
}
 
 

Any ideas?

 

What are you extending that requires you to super the plugin up?

Also, please include the full class. The line numbers are messed up with what you provided.

 

1Rogue
Changed the OP, the weird thing is, it works for one plugin, but not another, any idea what causes this?

 

copy/paste direct from the class, what you've shown isn't from the same version as the error is.

 

Check your MySQL server, what address is it listening on? if it is listening on anything other then 0.0.0.0 or 127.0.0.1 then you will have to use that address rather then localhost to connect.. Also check what privileges your user has - do you have an allow connections from address set that is an ip or something preventing you from connecting on localhost? also check you are using the right password, and finally using root is probably OK for testing, but not a good idea for production servers.

 

1Rogue phillmac
I found the error:
In my connect method:

Code:

String pass = config.getString("SpaceWars.MySQL.pass");

In my setupConfig method:

Code:

config.addDefault("SpaceWars.MySQL.password"

Simple little typo....

 

Try enumerating configuration values so that you don't have mistakes like that:

https://github.com/1Rogue/Inventory...ue/inventoryshop/config/ConfigValues.java#L28