UltraBans mysql

Technická podpora k herním serverům Minecraft a Tekkit
Message
Autor
Weizen
Příspěvky: 1429
Registrován: 19 úno 2014, 19:56
Reputation: 0
Kontaktovat uživatele:

UltraBans mysql

#1 Příspěvekod Weizen » 23 dub 2014, 20:28

IP: 93.91.250.207:27409
Dobrej :) Nevím proč ale když dám MySQL databasi tak mi to hází hrozný error a mám vše dobře nastavené (Potřebuju na banlist) a laguje ten error :D
Tady nastavení UltraBans
Spoiler: zobrazit

Kód: Vybrat vše

#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: MySQL
#MySQL Information#
MySQL:
  Database: 'jdbc:mysql://localhost:3306/minecraft'
  User: '146881_mysql_db'
  Password: '*****'
  Table: 'banlist'
  IPTable: 'banlistip'
#SQLite Information#
SQLite:
  Filename: 'banlist'
#delete dat on ban#
CleanOnBan: true
#clear warnings on ban#
ClearWarnOnBan: false
Log:
  Enabled: true
#Max Warnings#
MaxWarning:
  Enable: false
  Amt: 5
  #ban,kick,ipban,perma,tempban,tempipban#
  Result: ban
  Silent: true
  Reason: 'Max Warnings'
  #Used with Temporary actions#
  Temp:
    Amt: 5
  #sec,min,hour,day,week,month#
    Mode: day
#Default labels#
Label:
  Console: 'Server'
  Reason: 'Unsure'
#change to true or false to enable lockdown#
#also can be done ingame /lockdown#
Lockdown: false
Login:
#Check for duplicates on Login#
  DupeCheck:
    Enable: true
#PingBack joining players, and kick if unreachable. //Experimental#
  ProxyPingBack:
    Enable: false
    #How long in milliseconds to Timeout#
    Timeout: 10000
#This will set the server to sync the database if multiple servers are in place.#
Sync:
  Enabled: false
  #Timing is in Long format Example:#
  #1 Hour = 60 Seconds * 60 Minutes * 20 ServerTickRatePerSec = 72000L
  Timing: 72000L
#Auto Updater#
AutoUpdater:
  Enabled: true
#Chat#
Chat:
  #Checks Chat Messages for a valid IP address#
  #If its not valid, trust me they can't connect to it#
  IPCheck:
    Enable: true
    #Wildcards %scramble% will scramble the ip and %replace% will show your ip instead#
    #If no wildcards are present the message entered will replace the ip#
    #leave blank to erase#
    Blocking: '{Block}'
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: warn
    Silent: false
    Reason: 'Advertising'
  #This will allow you to filter out messages containing any words that you define#
  SwearCensor:
    Enable: true
    #Use your imagination these are not for me to decide#
    Words: 'kreten debil pico pica picus dement svine '
    #Wildcards %scramble% will scramble the word#
    #If no wildcards are present the message entered will replace the word#
    #leave blank to erase#
    Blocking: '{Block}'
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: warn
    Silent: false
    Reason: 'Slovnik'
  #Checks if the message is duplicate and disables it#
  SpamCheck:
    Enable: true
    #The amount of messages to give a result#
    Counter: 10
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: kick
    Silent: false
    Reason: 'Spam'
Muted:
  Vannila: true
  #When Vanilla: true allowed commands.#
  AllowedCommands:
  - '/login'
  - '/register'
#Jail Configuration#
Jail:
  Mute: true
  Vanilla: true
  #When Vanilla: true allowed commands.#
  AllowedCommands:
  - '/login'
  - '/register'

Tady error
Spoiler: zobrazit
> [20:26:40 ERROR]: [Ultrabans] Unable to retreive connection
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.GeneratedConstructorAccessor256.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.Util.getInstance(Util.java:382) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~inecraft_server.jar:git-Spigot-1446]
at sun.reflect.GeneratedConstructorAccessor254.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~inecraft_server.jar:git-Spigot-1446]
at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[?:1.7.0_51]
at java.sql.DriverManager.getConnection(DriverManager.java:187) ~[?:1.7.0_51]
at com.modcrafting.ultrabans.db.SQL.getSQLConnection(SQL.java:49) [Ultrabans.jar:?]
at com.modcrafting.ultrabans.db.SQL.setAddress(SQL.java:141) [Ultrabans.jar:?]
at com.modcrafting.ultrabans.listeners.UltraBanPlayerListener.onPlayerJoin(UltraBanPlayerListener.java:102) [Ultrabans.jar:?]
at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_51]
at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.PlayerList.c(PlayerList.java:251) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.PlayerList.a(PlayerList.java:138) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.LoginListener.c(LoginListener.java:105) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.LoginListener.a(LoginListener.java:43) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:179) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.ServerConnection.c(ServerConnection.java:77) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:713) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:283) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:576) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:482) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) inecraft_server.jar:git-Spigot-1446]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user '146881_mysql_db'@'%' to database 'minecraft'
at sun.reflect.GeneratedConstructorAccessor252.newInstance(Unknown Source) ~[?:?]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.Util.getInstance(Util.java:382) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) ~inecraft_server.jar:git-Spigot-1446]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186) ~inecraft_server.jar:git-Spigot-1446]
... 33 more
> [20:26:40 ERROR]: Could not pass event PlayerJoinEvent to Ultrabans v3.1.0
org.bukkit.event.EventException
at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:294) ~inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) ~inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) inecraft_server.jar:git-Spigot-1446]
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.PlayerList.c(PlayerList.java:251) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.PlayerList.a(PlayerList.java:138) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.LoginListener.c(LoginListener.java:105) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.LoginListener.a(LoginListener.java:43) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:179) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.ServerConnection.c(ServerConnection.java:77) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:713) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:283) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:576) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:482) inecraft_server.jar:git-Spigot-1446]
at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) inecraft_server.jar:git-Spigot-1446]
Caused by: java.lang.NullPointerException
at com.modcrafting.ultrabans.db.SQL.setAddress(SQL.java:142) ~[?:?]
at com.modcrafting.ultrabans.listeners.UltraBanPlayerListener.onPlayerJoin(UltraBanPlayerListener.java:102) ~[?:?]
at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_51]
at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) ~inecraft_server.jar:git-Spigot-1446]
... 15 more
Naposledy upravil(a) Weizen dne 24 dub 2014, 07:34, celkem upraveno 1 x.

vojtamaniak
Příspěvky: 3512
Věk: 26
Registrován: 18 úno 2012, 21:02
Reputation: 11

Re: UltraBans mysql

#2 Příspěvekod vojtamaniak » 23 dub 2014, 20:54

Kód: Vybrat vše

Database: 'jdbc:mysql://localhost:3306/minecraft'

má být takto

Kód: Vybrat vše

Database: 'jdbc:mysql://localhost:3306/146881_mysql_db'

Weizen
Příspěvky: 1429
Registrován: 19 úno 2014, 19:56
Reputation: 0
Kontaktovat uživatele:

Re: UltraBans mysql

#3 Příspěvekod Weizen » 23 dub 2014, 21:17

aha :D Hups :D

Uživatelský avatar
Batllefury
Příspěvky: 1084
Věk: 27
Registrován: 07 bře 2013, 15:35
Reputation: 5
Kontaktovat uživatele:

Re: UltraBans mysql

#4 Příspěvekod Batllefury » 23 dub 2014, 21:59

schovej heslo !
Pomoc se odměňuje karmou !

Weizen
Příspěvky: 1429
Registrován: 19 úno 2014, 19:56
Reputation: 0
Kontaktovat uživatele:

Re: UltraBans mysql

#5 Příspěvekod Weizen » 24 dub 2014, 07:34

radši jsem ho ještě změnil :D (ještě že to heslo bylo jen k tomu MySql :D)


Zpět na „Minecraft, Tekkit“

Kdo je online

Uživatelé prohlížející si toto fórum: Žádní registrovaní uživatelé a 25 hostů