Hallo,
hier ist sind erstmal die Klassen in denen sich der Fehler befindet:
Ich weiß nicht wie ich dieses warn beheben kann 🙁
hier ist noch die mySQL.yml, wo verbindungsdate drinstehen:
Hoffentlich könnt ihr mir helfen
hier ist sind erstmal die Klassen in denen sich der Fehler befindet:
AddSpawnPoint.java
Spleef.java
Java:
package net.developer.spleef.database;
import net.developer.spleef.Spleef;
import org.bukkit.Bukkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MySQL {
public static String host;
public static String username;
public static String password;
public static String database;
public static String port;
public static Connection con;
public static void connect() {
if (!isConnected()) {
try {
con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
Bukkit.getConsoleSender().sendMessage(Spleef.getInstance().prefix + " " + "§aMySQL Verbindung aufgebaut.");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close() {
if (isConnected()) {
try {
con.close();
Bukkit.getConsoleSender().sendMessage(Spleef.getInstance().prefix + " " + "§cMySQL Verbindung geschlossen.");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static boolean isConnected() {
return con != null;
}
public static void createTable() {
if (isConnected()) {
try {
con.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS Arenen (Arenenname VARCHAR(100),Spielerspawn1 VARCHAR(100), Spielerspawn2 VARCHAR(100), Spielerspawn3 VARCHAR(100), Spielerspawn4 VARCHAR(100))");
} catch (SQLException e) {
e.printStackTrace();
}
}
}Spleef.java
Java:
/**
* Created by mrose on 07.08.2016.
*/
public class Spleef extends JavaPlugin {
@Override
public void onEnable() {
instance = this;
registerCommands();
registerListener();
FileManager.setStandardConfig();
FileManager.setStandardMySQL();
FileManager.readConfig();
FileManager.readMySQL();
MySQL.connect();
MySQL.createTable();
Bukkit.getConsoleSender().sendMessage(prefix + " " + "§aAktiviert");
}
@Override
public void onDisable() {
MySQL.close();
}
public void registerCommands(){
AddSpawnPoint cAddSpawnPoint = new AddSpawnPoint(this);
getCommand("addSpawnPoint").setExecutor(cAddSpawnPoint);
}
private void registerListener() {
}
public String prefix;
public static Spleef instance;
public static Spleef getInstance() {
return instance;
}
}
Code:
[19:16:59 INFO]: [TerraSpleef] Enabling Spleef v1.0.0
[19:16:59 WARN]: java.sql.SQLException: null, message from server: "Host 'fr25.server.pro' is not allowed to connect to this MariaDB server"
[19:16:59 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
[19:16:59 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
[19:16:59 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
[19:16:59 WARN]: at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1038)
[19:16:59 WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254)
[19:16:59 WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285)
[19:16:59 WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084)
[19:16:59 WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
[19:16:59 WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
[19:16:59 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:16:59 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[19:16:59 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[19:16:59 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[19:16:59 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
[19:16:59 WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
[19:16:59 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
[19:16:59 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:664)
[19:16:59 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:247)
[19:16:59 WARN]: at net.optdeveloper.spleef.database.MySQL.connect(MySQL.java:21)
[19:16:59 WARN]: at net.optdeveloper.spleef.Spleef.onEnable(TerraSpleef.java:23)
[19:16:59 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:292)
[19:16:59 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332)
[19:16:59 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404)
[19:16:59 WARN]: at org.bukkit.craftbukkit.v1_10_R1.CraftServer.loadPlugin(CraftServer.java:347)
[19:16:59 WARN]: at org.bukkit.craftbukkit.v1_10_R1.CraftServer.enablePlugins(CraftServer.java:319)
[19:16:59 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.t(MinecraftServer.java:407)
[19:16:59 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.l(MinecraftServer.java:372)
[19:16:59 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.a(MinecraftServer.java:327)
[19:16:59 WARN]: at net.minecraft.server.v1_10_R1.DedicatedServer.init(DedicatedServer.java:242)
[19:16:59 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:517)
[19:16:59 WARN]: at java.lang.Thread.run(Thread.java:745)Ich weiß nicht wie ich dieses warn beheben kann 🙁
hier ist noch die mySQL.yml, wo verbindungsdate drinstehen:
port: '3306'
database: spleef
password: password
username: root
host: 188.xxx.xxx.xx
database: spleef
password: password
username: root
host: 188.xxx.xxx.xx
Hoffentlich könnt ihr mir helfen
