Spigot MySQL Verbindung Fehlgeschlagen

[TntTastisch]

Hallo,
Ich wollte gerne ein KnockbackFFA mit der Anweisung, dass ich es mit MySQL programmieren soll.
Ich habe einen Fehler, wo die Config sich nicht erstellt und wenn sie sich erstellt nichts drin steht.
Ich habe schon das Problem gegoogelt, aber da war alles richtig.
Bitte helft mir. Vielen Dank, schon mal im vorraus.

Fehlermeldung:
https://hastebin.com/acukakelas.css

Sourcecode - MySQL Klasse:
https://hastebin.com/ubipeqoqat.java

Sourcecode - Main Klasse:
https://hastebin.com/anowizicus.java

 

[DerFrZocker]

Tag,

1:

public static File config = new File("plugins//KnockbackFFA//");

Verweist auf einen Ordner und nicht auf eine File

2: gibt es die schöne Methode "getDataFolder()"

3:

Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Das Plugin wurde §aerfolgreich §6aktiviert§7.");

sollte das nicht lieber am ende der onEnable() Methode stehen? es kann immer noch was schief gehen beim Events/Commands regiestrieren.

 

[TntTastisch]

Dieser Fehler ist mir schon aufgefallen.

 

[TntTastisch]

Ich habe es wie du es gesagt hast geändert.

Spoiler: MySQL

package mysql;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.configuration.file.YamlConfiguration;


public class MySQL {

public static Connection con;
public static File config = new File("plugins//KnockbackFFA//config.yml");
public static YamlConfiguration configcfg = YamlConfiguration.loadConfiguration(config);


public static void connect(String host, String db, String user, String pass) {


try {



con = DriverManager.getConnection("jdbc:mysql://" + host + "306/" + db + "?autoReconnect=true", user, pass);

System.out.println("[KNOCKBACKFFA] Verbindung zu MySQL-DB hergestellt.");

} catch (SQLException e) {

e.printStackTrace();

}

}


public static void close(){

if (con!=null){

try{

con.close();

System.out.println("[KNOCKBACKFFA] Verbindung zu MySQL-DB geschlossen.");

}catch (SQLException e){

e.printStackTrace();

}

}

}


public static void update(String qry){

try{

Statement stmt = con.createStatement();

stmt.executeUpdate(qry);

}catch (SQLException e){

e.printStackTrace();

}

}


public static ResultSet query(String qry){

ResultSet rs = null;

try{

Statement stmt = con.createStatement();

rs = stmt.executeQuery(qry);

}catch (SQLException e){

e.printStackTrace();

}

return rs;

}


}

Spoiler: Main

package knockbackffa;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

import org.bukkit.Bukkit;
import org.bukkit.entity.Player;
import org.bukkit.event.Listener;
import org.bukkit.plugin.PluginManager;
import org.bukkit.plugin.java.JavaPlugin;

import commands.Command_Build;
import commands.Command_SetSpawn;
import listener.DeathListener;
import listener.FoodChangeListener;
import listener.HealthListener;
import listener.JoinQuitListener;
import listener.WeatherLisener;
import methods.BuildListener;
import methods.setSpawn;
import mysql.MySQL;

public class Main extends JavaPlugin implements Listener {

public static String prefix = "§8» §b§lKnockbackFFA §8▪ §7";
public static String noplayer = prefix + "§cDu musst ein Spieler sein, damit du diesen Befehl ausführen kannst!";
public static String noperms = prefix + "§cDu hast keine Rechte für diesen Befehl!";
public static ArrayList<Player> Buildmode = new ArrayList<>();
private static File dr = new File("plugins//KnockbackFFA");

private String host;
private String db;
private String user;
private String pass;

@Override
public void onEnable() {
PluginManager pm = Bukkit.getPluginManager();

pm.registerEvents(new JoinQuitListener(), this);
pm.registerEvents(new WeatherLisener(), this);
pm.registerEvents(new FoodChangeListener(), this);
pm.registerEvents(new HealthListener(), this);
pm.registerEvents(new DeathListener(), this);
pm.registerEvents(new BuildListener(), this);
this.getCommand("build").setExecutor(new Command_Build());
this.getCommand("setspawn").setExecutor(new Command_SetSpawn());

Config();

MySQL.connect(host,db,user,pass);

Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Das Plugin wurde §aerfolgreich §6aktiviert§7.");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Urheberecht und Autor: §4§lTntTastisch");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Plugin Version: §b§l" + getDescription().getVersion());
Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
}

@Override
public void onDisable() {
MySQL.close();
Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Das Plugin wurde §aerfolgreich §6deaktiviert§7.");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Urheberecht und Autor: §4§lTntTastisch");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Plugin Version: §b§l" + getDescription().getVersion());
Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
}

private static void Config() {

if(!dr.exists()) {
dr.mkdir();
}

if(!setSpawn.location.exists()) {
try {
setSpawn.location.createNewFile();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

if(!MySQL.config.exists()) {
try {
MySQL.config.createNewFile();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


}

}

Spoiler: Fehlermeldung

[12:23:43 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[12:23:43 WARN]: at sun.reflect.GeneratedConstructorAccessor179.newInstance(Unknown Source)
[12:23:43 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[12:23:43 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[12:23:43 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[12:23:43 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java82)
[12:23:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
[12:23:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[12:23:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[12:23:43 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[12:23:43 WARN]: at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
[12:23:43 WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
[12:23:43 WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[12:23:43 WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[12:23:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[12:23:43 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[12:23:43 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[12:23:43 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[12:23:43 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[12:23:43 WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java78)
[12:23:43 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java05)
[12:23:43 WARN]: at java.sql.DriverManager.getConnection(Unknown Source)
[12:23:43 WARN]: at java.sql.DriverManager.getConnection(Unknown Source)
[12:23:43 WARN]: at mysql.MySQL.connect(MySQL.java:27)
[12:23:43 WARN]: at knockbackffa.Main.onEnable(Main.java:52)
[12:23:43 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java21)
[12:23:43 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java40)
[12:23:43 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
[12:23:43 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java57)
[12:23:43 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java17)
[12:23:43 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.reload(CraftServer.java:741)
[12:23:43 WARN]: at org.bukkit.Bukkit.reload(Bukkit.java:535)
[12:23:43 WARN]: at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25)
[12:23:43 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
[12:23:43 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)
[12:23:43 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627)
[12:23:43 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412)
[12:23:43 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java75)
[12:23:43 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
[12:23:43 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
[12:23:43 WARN]: at java.lang.Thread.run(Unknown Source)
[12:23:43 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.Communication***ception: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[12:23:43 WARN]: at sun.reflect.GeneratedConstructorAccessor125.newInstance(Unknown Source)
[12:23:43 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[12:23:43 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[12:23:43 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[12:23:43 WARN]: at com.mysql.jdbc.SQLError.createCommunication***ception(SQLError.java:1116)
[12:23:43 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java43)
[12:23:43 WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
[12:23:43 WARN]: at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
[12:23:43 WARN]: ... 30 more
[12:23:43 WARN]: Caused by: java.net.UnknownHostException: null
[12:23:43 WARN]: at java.net.InetAddress.getAllByName0(Unknown Source)
[12:23:43 WARN]: at java.net.InetAddress.getAllByName(Unknown Source)
[12:23:43 WARN]: at java.net.InetAddress.getAllByName(Unknown Source)
[12:23:43 WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)
[12:23:43 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
[12:23:43 WARN]: ... 32 more

 

[TntTastisch]

In der Main gibt es nur ein Fehler in der Line 52. Aber das ist die Verbindung zu den MySQL Server!

 

[DerFrZocker]

Wo in deinem Code weist du den Variable "host", "db", "user" und "pass" zu?
So wie ich das sehe nirgends. Deshalb gibt es dir auch den Fehler das es sich nicht verbinden kann.

Desweiteren gibt es die Methode "getConfig()"

 

[TntTastisch]

Könntest du mir dies bitte in der richtigen Code Folge zeigen?

 

[TntTastisch]

Also so zu sagen muss ich es so machen?

package mysql;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.configuration.file.YamlConfiguration;


public class MySQL {
    
    public static Connection con;
    public static File config = new File("plugins//KnockbackFFA//config.yml");
    public static YamlConfiguration configcfg = YamlConfiguration.loadConfiguration(config);
    private String host;
    private String db;
    private String user;
    private String pass;
    
    public static void connect(String host, String db, String user, String pass) {
        
        
        try {
             con = DriverManager.getConnection("jdbc:mysql://" + host + ":3306/" + db + "?autoReconnect=true", user, pass);

            System.out.println("[KNOCKBACKFFA] Verbindung zu MySQL-DB hergestellt.");

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }


    public static void close(){

        if (con!=null){

            try{

                con.close();

                System.out.println("[KNOCKBACKFFA] Verbindung zu MySQL-DB geschlossen.");

            }catch (SQLException e){

                e.printStackTrace();

            }

        }

    }


    public static void update(String qry){

        try{

            Statement stmt = con.createStatement();

            stmt.executeUpdate(qry);

        }catch (SQLException e){

            e.printStackTrace();

        }

    }


    public static ResultSet query(String qry){

        ResultSet rs = null;

        try{

            Statement stmt = con.createStatement();

            rs = stmt.executeQuery(qry);

        }catch (SQLException e){

            e.printStackTrace();

        }

        return rs;

    }


}

 

[DerFrZocker]

du machst einfach im onEnable() :

host = getConfig().getString("MySQL.host");
db = getConfig().getString("MySQL.db");

usw.

Danach erstells du dir eine File names "config.yml" DIese muss dort hin wo deine "plugin.yml" ist.
In dierser trägst du nun eine:

MySQL:
  host: localhost
  db: database

usw.

Und schon hast du eine config mit MySQL daten.

 

[TntTastisch]

Ok, vielen Dank

 

[TntTastisch]

Es besteht immer noch ein Fehler...
Ich habe jetzt alle gemacht wie du es gesagt hast.

Spoiler: Main

package knockbackffa;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

import org.bukkit.Bukkit;
import org.bukkit.entity.Player;
import org.bukkit.event.Listener;
import org.bukkit.plugin.PluginManager;
import org.bukkit.plugin.java.JavaPlugin;

import commands.Command_Build;
import commands.Command_SetSpawn;
import listener.DeathListener;
import listener.FoodChangeListener;
import listener.HealthListener;
import listener.JoinQuitListener;
import listener.WeatherLisener;
import methods.BuildListener;
import methods.setSpawn;
import mysql.MySQL;

public class Main extends JavaPlugin implements Listener {

public static String prefix = "§8» §b§lKnockbackFFA §8▪ §7";
public static String noplayer = prefix + "§cDu musst ein Spieler sein, damit du diesen Befehl ausführen kannst!";
public static String noperms = prefix + "§cDu hast keine Rechte für diesen Befehl!";
public static ArrayList<Player> Buildmode = new ArrayList<>();
private static File dr = new File("plugins//KnockbackFFA");

String host;
String db;
String user;
String pass;

@Override
public void onEnable() {
PluginManager pm = Bukkit.getPluginManager();

pm.registerEvents(new JoinQuitListener(), this);
pm.registerEvents(new WeatherLisener(), this);
pm.registerEvents(new FoodChangeListener(), this);
pm.registerEvents(new HealthListener(), this);
pm.registerEvents(new DeathListener(), this);
pm.registerEvents(new BuildListener(), this);
this.getCommand("build").setExecutor(new Command_Build());
this.getCommand("setspawn").setExecutor(new Command_SetSpawn());

Config();

host = getConfig().getString("MySQL.host");
db = getConfig().getString("MySQL.db");
user = getConfig().getString("MySQL.user");
pass = getConfig().getString("MySQL.password");



MySQL.connect(host,db,user,pass);

Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Das Plugin wurde §aerfolgreich §6aktiviert§7.");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Urheberrecht und Autor: §4§lTntTastisch");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Plugin Version: §b§l" + getDescription().getVersion());
Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
}

@Override
public void onDisable() {
Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Das Plugin wurde §aerfolgreich §6deaktiviert§7.");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Urheberrecht und Autor: §4§lTntTastisch");
Bukkit.getConsoleSender().sendMessage("§8+ §b§lKnockbackFFA §8- §7Plugin Version: §b§l" + getDescription().getVersion());
Bukkit.getConsoleSender().sendMessage("§8§m+------------------{ §r §b§lKnockbackFFA §8§m }------------------+");
MySQL.close();
}

private static void Config() {

if(!dr.exists()) {
dr.mkdir();
}

if(!setSpawn.location.exists()) {
try {
setSpawn.location.createNewFile();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


}

}

Spoiler: Fehlermeldung

[13:10:12 INFO]: [KnockbackFFA] Enabling KnockbackFFA v1.0.0
[13:10:18 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
[13:10:18 WARN]: at sun.reflect.GeneratedConstructorAccessor179.newInstance(Unknown Source)
[13:10:18 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[13:10:18 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[13:10:18 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[13:10:18 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java82)
[13:10:18 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
[13:10:18 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[13:10:18 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[13:10:18 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[13:10:18 WARN]: at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
[13:10:18 WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
[13:10:18 WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[13:10:18 WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[13:10:18 WARN]: at sun.reflect.GeneratedConstructorAccessor210.newInstance(Unknown Source)
[13:10:18 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[13:10:18 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[13:10:18 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[13:10:18 WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java78)
[13:10:18 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java05)
[13:10:18 WARN]: at java.sql.DriverManager.getConnection(Unknown Source)
[13:10:18 WARN]: at java.sql.DriverManager.getConnection(Unknown Source)
[13:10:18 WARN]: at mysql.MySQL.connect(MySQL.java:18)
[13:10:18 WARN]: at knockbackffa.Main.onEnable(Main.java:59)
[13:10:18 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java21)
[13:10:18 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java40)
[13:10:18 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
[13:10:18 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.loadPlugin(CraftServer.java57)
[13:10:18 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.enablePlugins(CraftServer.java17)
[13:10:18 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.reload(CraftServer.java:741)
[13:10:18 WARN]: at org.bukkit.Bukkit.reload(Bukkit.java:535)
[13:10:18 WARN]: at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:25)
[13:10:18 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
[13:10:18 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)
[13:10:18 WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627)
[13:10:18 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412)
[13:10:18 WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java75)
[13:10:18 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
[13:10:18 WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
[13:10:18 WARN]: at java.lang.Thread.run(Unknown Source)
[13:10:18 WARN]: Caused by: com.mysql.jdbc.exceptions.jdbc4.Communication***ception: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[13:10:18 WARN]: at sun.reflect.GeneratedConstructorAccessor125.newInstance(Unknown Source)
[13:10:18 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[13:10:18 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[13:10:18 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[13:10:18 WARN]: at com.mysql.jdbc.SQLError.createCommunication***ception(SQLError.java:1116)
[13:10:18 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java43)
[13:10:18 WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
[13:10:18 WARN]: at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
[13:10:18 WARN]: ... 29 more
[13:10:18 WARN]: Caused by: java.net.UnknownHostException: null
[13:10:18 WARN]: at java.net.InetAddress.getAllByName0(Unknown Source)
[13:10:18 WARN]: at java.net.InetAddress.getAllByName(Unknown Source)
[13:10:18 WARN]: at java.net.InetAddress.getAllByName(Unknown Source)
[13:10:18 WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)
[13:10:18 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
[13:10:18 WARN]: ... 31 more

Spoiler: MySQL

package mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class MySQL {

public static Connection con;

public static void connect(String host, String db, String user, String pass) {


try {
con = DriverManager.getConnection("jdbc:mysql://" + host + "306/" + db + "?autoReconnect=true", user, pass);

System.out.println("[KNOCKBACKFFA] Verbindung zu MySQL-DB hergestellt.");

} catch (SQLException e) {

e.printStackTrace();

}

}


public static void close(){

if (con!=null){

try{

con.close();

System.out.println("[KNOCKBACKFFA] Verbindung zu MySQL-DB geschlossen.");

}catch (SQLException e){

e.printStackTrace();

}

}

}


public static void update(String qry){

try{

Statement stmt = con.createStatement();

stmt.executeUpdate(qry);

}catch (SQLException e){

e.printStackTrace();

}

}


public static ResultSet query(String qry){

ResultSet rs = null;

try{

Statement stmt = con.createStatement();

rs = stmt.executeQuery(qry);

}catch (SQLException e){

e.printStackTrace();

}

return rs;

}


}

 

[DerFrZocker]

Der Fehler sagt das es keine Verbindung zu MySQL aufbauen konnte, hast du auch die richtigen Daten in der Config eingestellt bzw hat sich eine Config erstellt?

 

[TntTastisch]

Nein, sie hat sich nicht erstellt dabei habe ich sie im src Ordner reingesteck, also selben Ort wie die plugin.yml

 

[JOO200]

Mein Tipp wäre einfach mal, die Standardwerte für die Verbindung ohne Config zu testen, sondern die Verbindung hardcoded aufbauen.

Ansonsten:
https://www.spigotmc.org/wiki/creating-a-config-file/
http://www.vogella.com/tutorials/MySQLJava/article.html
https://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html

 

[DerFrZocker]

du musst sie nicht in den src ordner machen, sondern ein ordner vorher.