Server: 93.91.250.112:37285
Dobrý den
Nejdříve bych se chtěl zeptat kde si mám zažádat o MySQL databázi na banlist na web, jelikož mi to bohužel nejde nastavit podle návodu zde http://forum.fakaheda.eu/viewtopic.php?f=85&t=3628. Můj problém je ten že vše nastavím jak má být reloadnu server a nejde banovat. Prosím kdyžtak o vysvětlení proč se to děje, nebo jak to napravit.
Po té bych se chtěl zeptat jestli nejde nějak nastavit mód creative jen na určitý čas denně. pokud ano prosím napište jak.
Za odpověd předem děkuji.
MySQL + banlist,creative
Technická podpora k herním serverům Minecraft a Tekkit
Message
Autor
- Sejsel
- Příspěvky: 4131
- Registrován: 19 čer 2011, 09:43
- Reputation: 0
- Bydliště: /home/sejsel/
- Kontaktovat uživatele:
Re: MySQL + banlist,creative
-
0
- Citace
#2 Příspěvekod Sejsel » 28 kvě 2012, 07:42
O MySQL můžeš zažádat na emailu sales@fakaheda.eu. Jinak, reload není zas tak moc dobrý příklad, některé pluginy ho nepodporují (dobrým příkladem jsou pluginy na login, které po reloadu mají krásné chyby).
01101110011101010110001001110111
Re: MySQL + banlist,creative
-
0
- Citace
#3 Příspěvekod LavorekCZ » 28 kvě 2012, 07:43
tasuro píše:mód creative jen na určitý čas denně
Nikdy v životě jsem s tím nesetkal, nechápu k čemu ti to bude.
Pomohl ti někdo? Pak určitě bude rád, když mu zvedneš karmu!
not sure
not sure
Re: MySQL + banlist,creative
-
0
- Citace
#4 Příspěvekod tasuro » 03 čer 2012, 23:02
Popíšu problém přesněji a vložím sem Config Ultrabans.
Takže postupuji takto:
1. naistaluji ultrabans. V pluginech se mi hlásí jako fungující jde i banovat.
2. Vypnu server
3. Upravim konfig na toto9%admin%
4. Zapnu server. S webem se mi to spojí, ale v tu chvíli se mi na serveru začne ultrabans ukazovat jako nefungující a kupodivu nejde banovat .
5. Na webu je to nastavene takto
zde je jak to má vypadat - http://www.best-fun.eu/minecraft/banlist/
Za každý pokus o pomoc předem děkuji a strašně si ji vážím. sLast
Takže postupuji takto:
1. naistaluji ultrabans. V pluginech se mi hlásí jako fungující jde i banovat.
2. Vypnu server
3. Upravim konfig na toto
Spoiler: zobrazit
Kód: Vybrat vše
#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: MySQL
mysql-database: 'jdbc:mysql://localhost:37285/gs_37285_1'
mysql-user: 'gs_37285_1'
mysql-password: 'Heslo,které mám zadané'
#Change these if you want to load or create different databases#
#First load will create these databases#
mysql-table: banlist
mysql-table-ip: banlistip
#SQLite Information#
sqlite-dbname: banlist
#parameters#
auto-complete: true
#Ultraban requires Vault for the Command /fine#
#Disable this if you don't not want to use fines#
#Or would rather not use the Vault Library#
#Command Checks#
useFine: true
useJail: true
useLockdown: true
useStarve: true
useForceRespawn: true
useEmpty: true
usePermaban: true
useWarn: true
useRules: true
#change to true or false to enable lockdown#
#also can be done ingame /lockdown#
lockdown: false
messages:
banMsgFailed: '&c%victim% &8is already banned!'
unbanMsg: '&8Successfully unbanned &c%victim%&8!'
unbanMsgBroadcast: '&c%victim% &8was unbanned by &9%admin%&8!'
unbanMsgFailed: '&c%victim% &8is already unbanned!'
kickAllMsg: '%admin% kicked everyone. Reason: %reason%!'
kickMsgVictim: 'You have been kicked by %admin%. Reason: %reason%!'
kickMsgBroadcast: '&c%victim% &8was kicked by &9%admin%&8. Reason: &c%reason%!'
kickMsgFailed: '&8Kick failed: &8%victim% &8isn''t online.'
banMsgVictim: 'You have been banned by %admin%. Reason: %reason%!'
banMsgBroadcast: '&c%victim% &8was banned by &9%admin%&8. Reason: &c%reason%!'
permbanMsgVictim: 'You have been permabanned by %admin%. Reason: %reason%!'
permbanMsgBroadcast: '&c%victim% &8has been permabanned by &9%admin%&8. Reason: &c%reason%!'
tempbanMsgVictim: 'You have been temp. banned by %admin%. Reason: %reason%!'
tempbanMsgBroadcast: '&c%victim% &8was temp. banned by &9%admin%&8. Reason: &c%reason%!'
LoginTempban: '&8You are banned until &c%time%&8! Reason: &c%reason%!'
LoginBan: '&8You are banned from this server! Reason: &c%reason%!'
LoginIPBan: 'Your IP is banned!'
fineMsgVictim: 'You have been fined by %admin% in the amount of %amt%!'
fineMsgBroadcast: '&c%victim% &8was fined by &9%admin%&8 in the amount of &c%amt%!'
emptyMsgVictim: '&9%admin% has cleared your inventory!'
emptyMsgBroadcast: '&9%admin% has cleared the inventory of &c%victim%!'
starveMsgVictim: '&8You are now starving!'
starveMsgBroadcast: '&c%victim% is now starving!'
fspawnMsgVictim: '&8You have been sent to spawn!'
fspawnMsgBroadcast: '&c%victim% &8is now at spawn!'
jailMsgVictim: '&8You have been jailed by &9%admin%&8. Reason: &c%reason%!'
jailMsgRelease: '&c%victim% &8was released from jail by &9%admin%&8!'
jailMsgBroadcast: '&c%victim% &8was jailed by &9%admin%&8. Reason: &c%reason%!'
warnMsgVictim: '&8You have been warned by &9%admin%&8. Reason: &c%reason%!'
warnMsgBroadcast: '&c%victim% &8was warned by &9%admin%&8. Reason: &c%reason%!'
lockMsgLogin: 'Server is under a lockdown, Try again later! Sorry.'
jailCmdMsg: 'You cannot use commands while jailed!'
jailChatMsg: 'Your cry falls on deaf ears.'
jailPlaceMsg: 'You cannot place blocks while you are jailed!'
jailBreakMsg: 'You cannot break blocks while you are jailed!'
muteChatMsg: 'You have been muted!'
unmuteMsgVictim: 'You have been unmuted.'
unmuteMsg: 'You have unmuted %victim%.'
ruleMsg: '&9The Servers Rules Are As Follows!'
#Adjust as you see fit or set ingame.#
rules:
one:
two:
three:
four:
five:
six:
seven:
eight:
nine:
ten:
#Do Not Change Values Below#
jail:
x: 0
y: 0
z: 0
yaw: 0
pitch: 0
4. Zapnu server. S webem se mi to spojí, ale v tu chvíli se mi na serveru začne ultrabans ukazovat jako nefungující a kupodivu nejde banovat .
5. Na webu je to nastavene takto
Spoiler: zobrazit
Kód: Vybrat vše
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="UTF-8" />
<meta name="keywords" content="UltraBans,Extended,Banlist" />
<meta name="robots" content="index,FOLLOW" />
<meta name="author" content="Mysteria" />
<meta name="description" content="UltraBans Extended Banlist" />
<link rel="stylesheet" type="text/css" href="./styly.css" />
<script type="text/javascript" src="http://yourjavascript.com/52202232241/jquery.js" charset="utf-8"></script>
<script type="text/javascript" src="http://yourjavascript.com/02422224215/jquery.dataTables.js" charset="utf-8"></script>
<script type="text/javascript" src="http://yourjavascript.com/21233004222/jquery.dataTables.CZDate.js" charset="utf-8"></script>
<script>
$(document).ready(function()
{
$('#Tresty').dataTable(
{
"aoColumnDefs": [{"sType": "CZDate", "aTargets": [4]}],
"aaSorting": [[4, "desc"]],
"iDisplayLength": "-1",
"oLanguage":
{
"oPaginate":
{
"sFirst": "",
"sLast": "",
"sNext": "",
"sPrevious": ""
},
"sEmptyTable": "Tabulka neobsahuje žádné řádky!",
"sInfo": "Zobrazuji _TOTAL_ řádků tabulky.",
"sInfoEmpty": "Žádné řádky k zobrazení.",
"sInfoFiltered": "Vyfiltrováno z celkových _MAX_ řádků tabulky.",
"sInfoPostFix": "",
"sInfoThousands": " ",
"sLengthMenu": "",
"sLoadingRecords": "Načítám tabulku, prosím čekejte ...",
"sProcessing": "DataTables jsou zaneprázdněny jinou operací!",
"sSearch": "Filtruj řádky tabulky dle zadaných slov:",
"sUrl": "",
"sZeroRecords": "Vámi zadanému filtru neodpovídá žádný řádek tabulky!"
}
});
});
</script>
<title>Minecraft banlist Best-Fun</title>
</head>
<body>
<div class="Strana">
<?php
# Název: UltraBans Extended Web Banlist
# Autor: Mysteria - http://www.mysty.cz
# Poslední verze: 0.98
# Poslední update: 5. 5. 2012
# Více informací: http://forum.fakaheda.eu/viewtopic.php?f=85&t=5946
Error_reporting(0);
Include_Once("./funkce.php");
# Připojení k MySQL databázi
$Server = "rocky.fakaheda.eu";
$Uzivatel = "gs_37285_1";
$Heslo = "7dbc3ec0";
$NazevDatabaze = "gs_37285_1";
# Otevření spojení s MySQL
MySQL_Connect($Server, $Uzivatel, $Heslo);
$ChybaSpojeni = MySQL_Error();
MySQL_Select_DB($NazevDatabaze);
$ChybaSpojeni = MySQL_Error();
# Definice konstant pro formátování HTML kódu
$Tb = "\t\t\t";
$THead = "\t\t\t\t";
$Th = "\t\t\t\t\t\t";
$TBody = "\t\t\t\t";
$Tr = "\t\t\t\t\t";
$Td = "\t\t\t\t\t\t";
# Získání obsahu tabulky
$Vysledek = MySQL_Query("SELECT * FROM banlist ORDER BY id DESC");
MySQL_Close();
# Zpracování získaných údajů
If (MySQL_Num_Rows($Vysledek) != 0)
{
Echo "<table id='Tresty'>\n";
Echo "$THead<thead>\n";
Echo "$Tr<tr>\n";
Echo "$Th<th>Typ trestu</th>\n";
Echo "$Th<th>Přezdívka hráče</th>\n";
Echo "$Th<th>Důvod trestu</th>\n";
Echo "$Th<th>Trestající admin</th>\n";
Echo "$Th<th>Datum udělení trestu</th>\n";
Echo "$Th<th>Datum vypršení trestu</th>\n";
Echo "$Th<th>Délka trestu</th>\n";
Echo "$Th<th>Trest vyprší za</th>\n";
Echo "$Tr</tr>\n";
Echo "$THead</thead>\n";
Echo "$TBody<tbody>\n";
While($Radek = MySQL_Fetch_Array($Vysledek))
{
# Zjištění typu trestu
Switch ($Radek["type"])
{
Case 0:
$TypTrestu = "Ban";
Break;
Case 1:
$TypTrestu = "IP Ban";
Break;
Case 2:
$TypTrestu = "Varování";
Break;
Case 3:
$TypTrestu = "Vyhození";
Break;
Case 4:
$TypTrestu = "Pokuta";
Break;
Case 5:
$TypTrestu = "Unban";
Break;
Case 6:
$TypTrestu = "Vězení";
Break;
Case 7:
$TypTrestu = "Umlčení";
Break;
Case 9:
$TypTrestu = "Trvalý ban";
Break;
Default:
$TypTrestu = "Neznámý";
}
# Výpis obsahu tabulky
# Zobrazování pouze banů
If ($TypTrestu == "Ban" || $TypTrestu == "IP Ban" || $TypTrestu == "Trvalý ban")
{
Echo "$Tr<tr>\n";
Echo "$Td<td>" . $TypTrestu . "</td>\n";
Echo "$Td<td>" . $Radek["name"] . "</td>\n";
Echo "$Td<td>" . $Radek["reason"] . "</td>\n";
Echo "$Td<td>" . $Radek["admin"] . "</td>\n";
Echo "$Td<td>" . Date("d.m.Y H:i:s", $Radek["time"]) . "</td>\n";
# Zobrazování správných textů pro různé typy trestů
If ($TypTrestu == "Ban" || $TypTrestu == "IP Ban" || $TypTrestu == "Trvalý ban" || $TypTrestu == "Umlčení")
{
# Výpis pro Datum vypršení trestu
If ($Radek["temptime"] == "0")
{
Echo "$Td<td>Nikdy</td>\n";
}
Else
{
Echo "$Td<td>" . Date("d.m.Y H:i:s", $Radek['temptime']) . "</td>\n";
}
# Výpis pro Délku trestu
If ($Radek["temptime"] == "0")
{
Echo "$Td<td>Trvalá</td>\n";
}
Else
{
$DelkaTrestuSekundy = $Radek["temptime"] - $Radek["time"];
If ($DelkaTrestuSekundy < 1)
{
Echo "$Td<td>Žádná</td>\n";
}
Else
{
Echo "$Td<td>";
PrevedCas($DelkaTrestuSekundy);
Echo "</td>\n";
}
}
# Výpis pro Trest vyprší za
If ($Radek["temptime"] == "0")
{
Echo "$Td<td>Nikdy</td>\n";
Echo "$Tr</tr>\n";
}
Else
{
$SekundyDoVyprseni = $Radek["temptime"] - Time();
If ($SekundyDoVyprseni < 1)
{
Echo "$Td<td>Vypršel</td>\n";
Echo "$Tr</tr>\n";
}
Else
{
Echo "$Td<td>";
PrevedCas($SekundyDoVyprseni);
Echo "</td>\n";
Echo "$Tr</tr>\n";
}
}
}
Else
{
Echo "$Td<td>Ihned</td>\n";
Echo "$Td<td>Žádná</td>\n";
Echo "$Td<td>Vypršel</td>\n";
Echo "$Tr</tr>\n";
}
}
}
Echo "$TBody</tbody>\n";
Echo "$Tb</table>\n";
}
Else
{
Echo "<div class='Chyba'>V aplikaci se vyskytla následující chyba:";
If ($ChybaSpojeni != "")
{
Echo "<ul><li>" . $ChybaSpojeni . "</li></ul></div>\n";
}
Else
{
Echo "<ul><li>Tabulka v MySQL databázi, která má obsahovat tresty je prázdná</li></ul></div>\n";
}
}
?>
<div class="Informace">
<p>UltraBans Extended Banlist coded by <a href="http://mysty.cz"><strong>Mysteria</strong></a>, designed by <a href="http://www.forcestudiosatb.com"><strong>Force studios ATB</strong></a> for gamehosting <a href="http://fakaheda.eu"><strong>FakaHeda.eu</strong></a>.</p>
</div>
</div>
</body>
</html>
zde je jak to má vypadat - http://www.best-fun.eu/minecraft/banlist/
Za každý pokus o pomoc předem děkuji a strašně si ji vážím. sLast
Re: MySQL + banlist,creative
-
0
- Citace
#5 Příspěvekod nejento » 04 čer 2012, 14:43
A server.log když to začne blbnout nám dáš taky?
Přidejte se ke komunitě zákazníků na FakaHeda.eu Discord! Poznejte nové lidi nebo vyřešte svůj technický problém živě: http://discord.fakaheda.eu/
Re: MySQL + banlist,creative
-
0
- Citace
#6 Příspěvekod tasuro » 06 čer 2012, 12:14
Spoiler: zobrazit
Kód: Vybrat vše
2012-06-06 01:02:53 [INFO] Starting FakaHedaMinequery server on 93.91.250.112:38285
2012-06-06 01:02:53 [INFO] [UltraBan] Loading UltraBan v0.2.7
2012-06-06 01:02:53 [INFO] [Vault][Permission] PermissionsEx hooked.
2012-06-06 01:02:53 [INFO] [Vault][Chat] PermissionsEx_Chat hooked.
2012-06-06 01:02:53 [INFO] [UltraBan] Enabling UltraBan v0.2.7
2012-06-06 01:02:53 [INFO] [UltraBan] Configuration: config.yml Loaded!
2012-06-06 01:02:57 [SEVERE] 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.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:243)
at com.modcrafting.ultrabans.db.SQLDatabases.getSQLConnection(SQLDatabases.java:39)
at com.modcrafting.ultrabans.db.SQLDatabases.initialize(SQLDatabases.java:117)
at com.modcrafting.ultrabans.UltraBan.onEnable(UltraBan.java:123)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:336)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:250)
at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:232)
at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:543)
at org.bukkit.Bukkit.reload(Bukkit.java:182)
at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:166)
at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:473)
at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:821)
at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:781)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:764)
at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:34)
at net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:113)
at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:449)
at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: 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.
at sun.reflect.GeneratedConstructorAccessor218.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
... 35 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 37 more
2012-06-06 01:02:57 [SEVERE] [UltraBan] Could not establish SQL connection. Disabling UltraBan
2012-06-06 01:02:57 [SEVERE] [UltraBan] Adjust Settings in Config or set MySql: False
2012-06-06 01:02:57 [INFO] [UltraBan] Disabling UltraBan v0.2.7
2012-06-06 01:02:57 [INFO] UltraBan disabled.
2012-06-06 01:03:01 [SEVERE] 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.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:243)
at com.modcrafting.ultrabans.db.SQLDatabases.getSQLConnection(SQLDatabases.java:39)
at com.modcrafting.ultrabans.db.SQLDatabases.loadJailed(SQLDatabases.java:737)
at com.modcrafting.ultrabans.UltraBan.onEnable(UltraBan.java:124)
2012-06-06 06:32:45 [INFO] [UltraBan] Loading UltraBan v0.2.7
2012-06-06 06:32:48 [INFO] [UltraBan] Enabling UltraBan v0.2.7
2012-06-06 06:32:48 [INFO] [UltraBan] Configuration: config.yml Loaded!
at com.modcrafting.ultrabans.db.SQLDatabases.getSQLConnection(SQLDatabases.java:39)
at com.modcrafting.ultrabans.db.SQLDatabases.initialize(SQLDatabases.java:117)
at com.modcrafting.ultrabans.UltraBan.onEnable(UltraBan.java:123)
2012-06-06 06:32:52 [SEVERE] [UltraBan] Could not establish SQL connection. Disabling UltraBan
2012-06-06 06:32:52 [SEVERE] [UltraBan] Adjust Settings in Config or set MySql: False
2012-06-06 06:32:52 [INFO] [UltraBan] Disabling UltraBan v0.2.7
2012-06-06 06:32:52 [INFO] UltraBan disabled.
at com.modcrafting.ultrabans.db.SQLDatabases.getSQLConnection(SQLDatabases.java:39)
at com.modcrafting.ultrabans.db.SQLDatabases.loadJailed(SQLDatabases.java:737)
at com.modcrafting.ultrabans.UltraBan.onEnable(UltraBan.java:124)
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
... 25 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:391)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:241)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
... 27 more
2012-06-06 06:32:56 [SEVERE] Error occurred while enabling UltraBan v0.2.7 (Is it up to date?)
java.lang.NullPointerException
at com.modcrafting.ultrabans.db.SQLDatabases.loadJailed(SQLDatabases.java:742)
at com.modcrafting.ultrabans.UltraBan.onEnable(UltraBan.java:124)
2012-06-06 11:58:23 [INFO] [AuthMe] §2[Majitel]§6tasuro§a logged in!
2012-06-06 11:58:32 [INFO] <[0mH[37m [0mVH[37m [33mVK[37m [32m[Majitel][33m[31mtasuro[37m[32m> caute[0m
2012-06-06 12:00:02 [INFO] [33m[Best-fun] [31mNavstivte nase stranky www.best-fun.eu.[0m
2012-06-06 12:03:02 [INFO] [33m[Best-fun] [32mJakekoliv porusovani pravidel je nepripustne a tresta se ![0m
Jelikož je povoleno jen 60 000 znaku snažil jsem se to omezit jen na čas kde je něco o ultrabanu.
Za pomoc děkuji.
Re: MySQL + banlist,creative
-
0
- Citace
#7 Příspěvekod nejento » 06 čer 2012, 15:57
Dej sem config UltraBans. Tan aktuální = ten co tam máš teď. Do code a SMAŽ HESLO DO MYSQL
Přidejte se ke komunitě zákazníků na FakaHeda.eu Discord! Poznejte nové lidi nebo vyřešte svůj technický problém živě: http://discord.fakaheda.eu/
Re: MySQL + banlist,creative
-
0
- Citace
#8 Příspěvekod tasuro » 07 čer 2012, 07:00
Spoiler: zobrazit
Kód: Vybrat vše
#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: MySQL
mysql-database: 'jdbc:mysql://localhost:37285/gs_37285_1'
mysql-user: 'gs_37285_1'
mysql-password: 'pass'
#Change these if you want to load or create different databases#
#First load will create these databases#
mysql-table: banlist
mysql-table-ip: banlistip
#SQLite Information#
sqlite-dbname: banlist
#parameters#
auto-complete: true
#Ultraban requires Vault for the Command /fine#
#Disable this if you don't not want to use fines#
#Or would rather not use the Vault Library#
#Command Checks#
useFine: true
useJail: true
useLockdown: true
useStarve: true
useForceRespawn: true
useEmpty: true
usePermaban: true
useWarn: true
useRules: true
#change to true or false to enable lockdown#
#also can be done ingame /lockdown#
lockdown: false
messages:
banMsgFailed: '&c%victim% &8is already banned!'
unbanMsg: '&8Successfully unbanned &c%victim%&8!'
unbanMsgBroadcast: '&c%victim% &8was unbanned by &9%admin%&8!'
unbanMsgFailed: '&c%victim% &8is already unbanned!'
kickAllMsg: '%admin% kicked everyone. Reason: %reason%!'
kickMsgVictim: 'You have been kicked by %admin%. Reason: %reason%!'
kickMsgBroadcast: '&c%victim% &8was kicked by &9%admin%&8. Reason: &c%reason%!'
kickMsgFailed: '&8Kick failed: &8%victim% &8isn''t online.'
banMsgVictim: 'You have been banned by %admin%. Reason: %reason%!'
banMsgBroadcast: '&c%victim% &8was banned by &9%admin%&8. Reason: &c%reason%!'
permbanMsgVictim: 'You have been permabanned by %admin%. Reason: %reason%!'
permbanMsgBroadcast: '&c%victim% &8has been permabanned by &9%admin%&8. Reason: &c%reason%!'
tempbanMsgVictim: 'You have been temp. banned by %admin%. Reason: %reason%!'
tempbanMsgBroadcast: '&c%victim% &8was temp. banned by &9%admin%&8. Reason: &c%reason%!'
LoginTempban: '&8You are banned until &c%time%&8! Reason: &c%reason%!'
LoginBan: '&8You are banned from this server! Reason: &c%reason%!'
LoginIPBan: 'Your IP is banned!'
fineMsgVictim: 'You have been fined by %admin% in the amount of %amt%!'
fineMsgBroadcast: '&c%victim% &8was fined by &9%admin%&8 in the amount of &c%amt%!'
emptyMsgVictim: '&9%admin% has cleared your inventory!'
emptyMsgBroadcast: '&9%admin% has cleared the inventory of &c%victim%!'
starveMsgVictim: '&8You are now starving!'
starveMsgBroadcast: '&c%victim% is now starving!'
fspawnMsgVictim: '&8You have been sent to spawn!'
fspawnMsgBroadcast: '&c%victim% &8is now at spawn!'
jailMsgVictim: '&8You have been jailed by &9%admin%&8. Reason: &c%reason%!'
jailMsgRelease: '&c%victim% &8was released from jail by &9%admin%&8!'
jailMsgBroadcast: '&c%victim% &8was jailed by &9%admin%&8. Reason: &c%reason%!'
warnMsgVictim: '&8You have been warned by &9%admin%&8. Reason: &c%reason%!'
warnMsgBroadcast: '&c%victim% &8was warned by &9%admin%&8. Reason: &c%reason%!'
lockMsgLogin: 'Server is under a lockdown, Try again later! Sorry.'
jailCmdMsg: 'You cannot use commands while jailed!'
jailChatMsg: 'Your cry falls on deaf ears.'
jailPlaceMsg: 'You cannot place blocks while you are jailed!'
jailBreakMsg: 'You cannot break blocks while you are jailed!'
muteChatMsg: 'You have been muted!'
unmuteMsgVictim: 'You have been unmuted.'
unmuteMsg: 'You have unmuted %victim%.'
ruleMsg: '&9The Servers Rules Are As Follows!'
#Adjust as you see fit or set ingame.#
rules:
one:
two:
three:
four:
five:
six:
seven:
eight:
nine:
ten:
#Do Not Change Values Below#
jail:
x: 0
y: 0
z: 0
yaw: 0
pitch: 0
Přejít na
- Pravidla a informace
- Pravidla
- Oznámení
- Foreign customers
- Valve Hry
- Counter-Strike: Source
- Návody
- Překlady
- Counter-Strike 1.6
- Návody
- AMX mod X
- Counter-Strike: Global Offensive
- Návody
- Valve Hammer Editor
- Tvorba pluginů
- Left4Dead
- Návody
- Left4Dead 2
- Návody
- Team Fortress 2
- Návody
- Day of Defeat: Source
- Návody
- CSPromod
- Návody
- Garry's Mod
- Série BattleField
- BattleField 3
- BattleField: Bad Company 2
- BattleField 2
- Návody
- BattleField 2142
- Série Call of Duty
- Call of Duty 2
- Návody
- Call of Duty 4 : Modern Warfare
- Návody
- Call of Duty 5 : World at War
- Návody
- Série TrackMania
- TrackMania 2: Canyon
- Návody
- TrackMania Forever
- Návody
- TrackMania Nations
- Návody
- Ostatní hry
- Minecraft, Tekkit
- Návody
- RUST
- Návody
- GTA San Andreas Multiplayer
- Návody
- Space Engineers
- Návody
- 7 days to die
- Návody
- Don't Starve Together
- Návody
- Medal of Honor Warfighter
- Arma 2 / DayZ: Epoch
- Návody
- Arma 3 / DayZ
- Návody
- Killing Floor
- Návody
- Unturned
- Návody
- ARK: Survival Evolved
- Návody
- Life is Feudal: Your Own
- Návody
- Ostatní hry
- Herní servery obecně
- Conan Exiles
- Další služby
- VPS (Virtual private Server)
- Návody
- Web hosting
- Návody
- FTP
- Komunikační servery
- Team Speak 2
- Team Speak 3
- Mumble
- TS3 Music Bot
- Návody
- Control Panel & web fakaheda.eu
- API
- Ostatní služby k herním serverům
- PsychoStats
- AMX Bans
- HLTV
- SourceBans
- HLstatsX
- Pokec
- Off topic
- Prodám / koupím
Kdo je online
Uživatelé prohlížející si toto fórum: Žádní registrovaní uživatelé a 136 hostů