Stránka 1 z 1
SurvivalGames MySQL
Napsal: 17 úno 2013, 19:59
od Welton123
93.91.240.148:27535
Ahoj, chci se zeptat, co mám špatně, že se mi nechce plugin SurvivalGames připojit k DB ? :/
CONFIG:
Kód: Vybrat vše
################################################
# Survival Games #
# #
# Developed by #
# Double0negative #
# #
# #
# mc-sg.org #
# #
################################################
###DO NOT CHANGE THIS UNLESS YOU WANT YOUR CONFIG TO RESET###
config-version: 1
#set how many players are needed for the game
#to auto-start. Once the player limit is reached
#it will wait for x amount of seconds for
#additional players. Auto start vote means that
#x percent of players need to vote with /sg vote
#for the game to begin
auto-start-players: 10
auto-start-time: 15
auto-start-vote: 20
#If the player queue is enabled the if a player
#tries to join a game that is not joinable
#(ie ingame) the player will be added to a
#queue line to join the next time the game
#is open
enable-player-queue: true
#if set to true, commands not associated with
#the survival games will not be allowed to
#players in-game
disallow-commands: false
#set how long each player should
#be invincible for after the start of
#the game in seconds
grace-period: 10
#Sets if chest should be restocked on the first
#night. If set to true this will also have the side
#effect of setting the world time to Day at the start
#of the game. This is only temporary until per-arena time
#has been implemented
restock-chest: true
block:
place:
whitelist:
- 18
- 105
- 31
- 37
- 38
- 50
- 103
- 43
break:
whitelist:
- 18
- 105
- 31
- 37
- 38
- 50
- 103
- 43
#if mob-progression is enabled, then the
#difficulty of mobs and amount of mobs
#spawning will increase with a decrease
#of players. The ratio defines how much
#harder it should get for every person
#out. a ratio of 2 whould mean 2x harder
#The mob blacklist definesmobs that should
#not spawn.
##________NOT IMPLEMETED____________
mob-progression:
enabled: true
ratio: 2
mob-blacklist:
- slime
#if set to true, the logging manager
#will use sql to save block data. Otherwise
#it will be stored into memory.
logging:
usesql: true
#settings for the endgame. This enables
#when there are only x amount of players
#remaining. If place chest is enabled then
#when the player limit is reached, a chest
#will be placed inside the radius of every
#remain player contianing random items for
#that player. If fire-lighting is enabled
#the a lighting strike will be fired at the
#location of each player every x seconds to
#notify the other players of their location
endgame:
players: 5
fire-lighting:
enabled: true
interval: 20
#settings for connecting to the
#sql server. These settings will
#be used for both the online webstats
#and for logging block changes for the
#automated rollback. Prefix is what all
#tables used for surivalgames will be
#prefixed with. This should stay the same
# for most cases. Server prefix allows you
#To prefix arenaID's with a server prefix.
#This is useful if you have multiple servers
#and you want to have them on the same database
#and they have the same arenaID's but you want to
#keep them seperate. If you only have 1 server,
#leave this blank.
sql:
host: '93.91.240.148'
port: 3306
user: '115153_mysql_db'
pass: 'heslo :P'
database: 'survivalgames'
prefix: 'sg_'
server-prefix : ''
#Settings for the webstats. If enabled, stats
#such as k/d record, wins, win streaks, kill
#streaks etc will be saved. If webserver is
#enabled then a webserver will be started on the
#<yourserverip>:<port> and allow people to view
#the stats online.
##_______Online webserver not implemented. Use the
#PHP backend instead. ______________
stats:
enabled: true
points:
kill: 10
win: 300
position: 7
killstreak:
base: 10
multiplier: 2
killstreak:
level1: '&e{player}&7 Double Kill!'
level2: '&e{player}&9 Multi Kill!'
level3: '&e{player}&5 Ultra Kill!'
level4: '&e{player}&4 Unbelievable Kill!'
level5: '&e{player}&a&kii&4&l Unbelievable+!&a&kii'
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:06
od vojtamaniak
Zkus to takto (jen heslo si uprav):
Kód: Vybrat vše
################################################
# Survival Games #
# #
# Developed by #
# Double0negative #
# #
# #
# mc-sg.org #
# #
################################################
###DO NOT CHANGE THIS UNLESS YOU WANT YOUR CONFIG TO RESET###
config-version: 1
#set how many players are needed for the game
#to auto-start. Once the player limit is reached
#it will wait for x amount of seconds for
#additional players. Auto start vote means that
#x percent of players need to vote with /sg vote
#for the game to begin
auto-start-players: 10
auto-start-time: 15
auto-start-vote: 20
#If the player queue is enabled the if a player
#tries to join a game that is not joinable
#(ie ingame) the player will be added to a
#queue line to join the next time the game
#is open
enable-player-queue: true
#if set to true, commands not associated with
#the survival games will not be allowed to
#players in-game
disallow-commands: false
#set how long each player should
#be invincible for after the start of
#the game in seconds
grace-period: 10
#Sets if chest should be restocked on the first
#night. If set to true this will also have the side
#effect of setting the world time to Day at the start
#of the game. This is only temporary until per-arena time
#has been implemented
restock-chest: true
block:
place:
whitelist:
- 18
- 105
- 31
- 37
- 38
- 50
- 103
- 43
break:
whitelist:
- 18
- 105
- 31
- 37
- 38
- 50
- 103
- 43
#if mob-progression is enabled, then the
#difficulty of mobs and amount of mobs
#spawning will increase with a decrease
#of players. The ratio defines how much
#harder it should get for every person
#out. a ratio of 2 whould mean 2x harder
#The mob blacklist definesmobs that should
#not spawn.
##________NOT IMPLEMETED____________
mob-progression:
enabled: true
ratio: 2
mob-blacklist:
- slime
#if set to true, the logging manager
#will use sql to save block data. Otherwise
#it will be stored into memory.
logging:
usesql: true
#settings for the endgame. This enables
#when there are only x amount of players
#remaining. If place chest is enabled then
#when the player limit is reached, a chest
#will be placed inside the radius of every
#remain player contianing random items for
#that player. If fire-lighting is enabled
#the a lighting strike will be fired at the
#location of each player every x seconds to
#notify the other players of their location
endgame:
players: 5
fire-lighting:
enabled: true
interval: 20
#settings for connecting to the
#sql server. These settings will
#be used for both the online webstats
#and for logging block changes for the
#automated rollback. Prefix is what all
#tables used for surivalgames will be
#prefixed with. This should stay the same
# for most cases. Server prefix allows you
#To prefix arenaID's with a server prefix.
#This is useful if you have multiple servers
#and you want to have them on the same database
#and they have the same arenaID's but you want to
#keep them seperate. If you only have 1 server,
#leave this blank.
sql:
host: '93.91.240.148'
port: 3306
user: '115153_mysql_db'
pass: 'heslo :P'
database: '115153_mysql_db'
prefix: 'sg_'
server-prefix : ''
#Settings for the webstats. If enabled, stats
#such as k/d record, wins, win streaks, kill
#streaks etc will be saved. If webserver is
#enabled then a webserver will be started on the
#<yourserverip>:<port> and allow people to view
#the stats online.
##_______Online webserver not implemented. Use the
#PHP backend instead. ______________
stats:
enabled: true
points:
kill: 10
win: 300
position: 7
killstreak:
base: 10
multiplier: 2
killstreak:
level1: '&e{player}&7 Double Kill!'
level2: '&e{player}&9 Multi Kill!'
level3: '&e{player}&5 Ultra Kill!'
level4: '&e{player}&4 Unbelievable Kill!'
level5: '&e{player}&a&kii&4&l Unbelievable+!&a&kii'
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:11
od Welton123
Ou, já vynechal
Díky
Ale stejně se nechce připojit.
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:12
od vojtamaniak
Píše to do konzole nějakou chybu?
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:16
od zikl
skus tam nepsat čiselnou ip ale primo jmeno stroje
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:16
od Welton123
Ano, na konci o tom, že se nepřipojil k DB. Že nemá práva.
Kód: Vybrat vše
2013-02-17 19:15:31 [INFO] Starting minecraft server version 1.4.7
2013-02-17 19:15:31 [INFO] Loading properties
2013-02-17 19:15:31 [INFO] Default game type: SURVIVAL
2013-02-17 19:15:31 [INFO] Generating keypair
2013-02-17 19:15:32 [INFO] Starting Minecraft server on 93.91.240.148:27535
2013-02-17 19:15:32 [INFO] This server is running CraftBukkit version git-Bukkit-1.4.7-R1.0-b2624jnks (MC: 1.4.7) (Implementing API version 1.4.7-R1.0)
2013-02-17 19:15:32 [INFO] [PermissionsEx] sql backend registered!
2013-02-17 19:15:32 [INFO] [PermissionsEx] file backend registered!
2013-02-17 19:15:32 [INFO] [PermissionsEx] PermissionEx plugin initialized.
2013-02-17 19:15:33 [INFO] [LagMeter] Loading LagMeter v1.9.0
2013-02-17 19:15:33 [INFO] [AutoMessage] Loading AutoMessage v2.1.1
2013-02-17 19:15:33 [INFO] [WorldEdit] Loading WorldEdit v5.5.1
2013-02-17 19:15:33 [INFO] [FakaHedaMinequery] Loading FakaHedaMinequery v1.2
2013-02-17 19:15:33 [INFO] [SurvivalGames] Loading SurvivalGames vB 0.4.11
2013-02-17 19:15:33 [INFO] [ColoredSigns] Loading ColoredSigns v3.1
2013-02-17 19:15:33 [INFO] [Vault] Loading Vault v1.2.22-b277
2013-02-17 19:15:33 [INFO] [Multiverse-Core] Loading Multiverse-Core v2.5-b641
2013-02-17 19:15:33 [INFO] [PermissionsEx] Loading PermissionsEx v1.19.5
2013-02-17 19:15:33 [INFO] [PermissionsEx] Initializing file backend
2013-02-17 19:15:33 [INFO] Permissions file successfully reloaded
2013-02-17 19:15:33 [INFO] [WorldGuard] Loading WorldGuard v5.7.1
2013-02-17 19:15:33 [INFO] [Essentials] Loading Essentials v2.9.6
2013-02-17 19:15:33 [INFO] [Residence] Loading Residence v2.6.6.2
2013-02-17 19:15:33 [INFO] [ChatManager] Loading ChatManager v1.19.1
2013-02-17 19:15:33 [INFO] [AuthMe] Loading AuthMe v2.7.1b1
2013-02-17 19:15:33 [INFO] [EssentialsSpawn] Loading EssentialsSpawn v2.9.6
2013-02-17 19:15:33 [INFO] [Vault] Enabling Vault v1.2.22-b277
2013-02-17 19:15:33 [INFO] [Vault][Economy] Essentials Economy found: Waiting
2013-02-17 19:15:33 [INFO] [Vault][Permission] PermissionsEx found: Waiting
2013-02-17 19:15:33 [INFO] [Vault][Permission] SuperPermissions loaded as backup permission system.
2013-02-17 19:15:33 [INFO] [Vault][Chat] PermissionsEx found: Waiting
2013-02-17 19:15:33 [INFO] [Vault] Enabled Version 1.2.22-b277
2013-02-17 19:15:33 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
2013-02-17 19:15:33 [WARNING] The server will make no attempt to authenticate usernames. Beware.
2013-02-17 19:15:33 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
2013-02-17 19:15:33 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
2013-02-17 19:15:33 [INFO] Preparing level "Hl.Mapa"
2013-02-17 19:15:33 [INFO] Preparing start region for level 0 (Seed: 6600474769899602570)
2013-02-17 19:15:34 [INFO] Preparing spawn area: 57%
2013-02-17 19:15:34 [INFO] Preparing start region for level 1 (Seed: 8867319088990459334)
2013-02-17 19:15:35 [INFO] [LagMeter] Enabling LagMeter v1.9.0
2013-02-17 19:15:35 [INFO] [LagMeter] Not using logs folder.
2013-02-17 19:15:35 [INFO] [LagMeter 1.9.0] Enabled! Polling every 40 server ticks. Logging to /hlserver/27535/plugins/LagMeter/lag.log
2013-02-17 19:15:35 [INFO] [AutoMessage] Enabling AutoMessage v2.1.1
2013-02-17 19:15:35 [INFO] [WorldEdit] Enabling WorldEdit v5.5.1
2013-02-17 19:15:35 [INFO] WEPIF: Using the Bukkit Permissions API.
2013-02-17 19:15:35 [INFO] [FakaHedaMinequery] Enabling FakaHedaMinequery v1.2
2013-02-17 19:15:35 [INFO] Starting FakaHedaMinequery server on 93.91.240.148:28535
2013-02-17 19:15:35 [INFO] [SurvivalGames] Enabling SurvivalGames vB 0.4.11
2013-02-17 19:15:35 [INFO] METRICS STARTING
2013-02-17 19:15:35 [INFO] [ColoredSigns] Enabling ColoredSigns v3.1
2013-02-17 19:15:35 [WARNING] [ColoredSigns] Erorr While loading Commands. Have you installed the Right Craftbukkit Build?
2013-02-17 19:15:35 [WARNING] [ColoredSigns] Erorr While loading Commands. Please create a Ticket,when your Craftbukkit version is valid.
2013-02-17 19:15:35 [INFO] [ColoredSigns] Listeners Enabled.
2013-02-17 19:15:35 [INFO] [ColoredSigns] version 3.1 by Janomine Succesfully Enabled.
2013-02-17 19:15:35 [INFO] [Multiverse-Core] Enabling Multiverse-Core v2.5-b641
2013-02-17 19:15:35 [INFO] [AllPay] - Version 10.0 - hooked into Essentials Economy for Multiverse-Core v2.5-b641
2013-02-17 19:15:35 [WARNING] [Multiverse-Core] Exception while loading value for environment
2013-02-17 19:15:35 [WARNING] [Multiverse-Core] Exception while loading value for environment
2013-02-17 19:15:35 [INFO] [Multiverse-Core] Loading World & Settings - 'Hl.Mapa' - Env: NORMAL - Type: FLAT & seed: 6600474769899602570
2013-02-17 19:15:35 [INFO] [Multiverse-Core] Loading World & Settings - 'Hl.Mapa_the_end' - Env: THE_END - Type: NORMAL & seed: 8867319088990459334
2013-02-17 19:15:35 [WARNING] [Multiverse-Core] WorldManager: Can't load this world because the folder was deleted/moved: Hl
2013-02-17 19:15:35 [WARNING] [Multiverse-Core] Use '/mv remove' to remove it from the config!
2013-02-17 19:15:35 [INFO] Preparing start region for level 2 (Seed: 8096439894162256770)
2013-02-17 19:15:36 [INFO] [Multiverse-Core] 3 - World(s) loaded.
2013-02-17 19:15:36 [INFO] [Multiverse-Core] Version 2.5-b641 (API v18) Enabled - By Rigby, fernferret, lithium3141 and main--
2013-02-17 19:15:36 [INFO] [PermissionsEx] Enabling PermissionsEx v1.19.5
2013-02-17 19:15:36 [INFO] [PermissionsEx] Superperms support enabled.
2013-02-17 19:15:36 [INFO] [PermissionsEx] v1.19.5 enabled
2013-02-17 19:15:36 [INFO] WEPIF: PermissionsEx detected! Using PermissionsEx for permissions.
2013-02-17 19:15:36 [INFO] [Vault][Permission] PermissionsEx hooked.
2013-02-17 19:15:36 [INFO] [Vault][Chat] PermissionsEx_Chat hooked.
2013-02-17 19:15:36 [INFO] [WorldGuard] Enabling WorldGuard v5.7.1
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa) TNT ignition is PERMITTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa) Lighters are PERMITTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa) Lava fire is blocked.
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa) Fire spread is UNRESTRICTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] Loaded configuration for world 'Hl.Mapa'
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa_the_end) TNT ignition is PERMITTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa_the_end) Lighters are PERMITTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa_the_end) Lava fire is blocked.
2013-02-17 19:15:36 [INFO] [WorldGuard] (Hl.Mapa_the_end) Fire spread is UNRESTRICTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] Loaded configuration for world 'Hl.Mapa_the_end'
2013-02-17 19:15:36 [INFO] [WorldGuard] (mapa1) TNT ignition is PERMITTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] (mapa1) Lighters are PERMITTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] (mapa1) Lava fire is blocked.
2013-02-17 19:15:36 [INFO] [WorldGuard] (mapa1) Fire spread is UNRESTRICTED.
2013-02-17 19:15:36 [INFO] [WorldGuard] Loaded configuration for world 'mapa1'
2013-02-17 19:15:36 [INFO] [WorldGuard] 0 regions loaded for 'Hl.Mapa'
2013-02-17 19:15:36 [INFO] [WorldGuard] 0 regions loaded for 'Hl.Mapa_the_end'
2013-02-17 19:15:36 [INFO] [WorldGuard] 0 regions loaded for 'mapa1'
2013-02-17 19:15:36 [INFO] [Essentials] Enabling Essentials v2.9.6
2013-02-17 19:15:37 [INFO] [Vault][Economy] Essentials Economy hooked.
2013-02-17 19:15:37 [INFO] Essentials: Using PermissionsEx based permissions.
2013-02-17 19:15:37 [INFO] [Residence] Enabling Residence v2.6.6.2
2013-02-17 19:15:37 [INFO] [Residence] Found Vault using permissions plugin:PermissionsEx
2013-02-17 19:15:37 [INFO] [Residence] Scanning for economy systems...
2013-02-17 19:15:37 [INFO] [Residence] Found Vault using economy system: Essentials Economy
2013-02-17 19:15:37 [INFO] [Residence] Found WorldEdit
2013-02-17 19:15:37 [INFO] [Residence] Enabled! Version 2.6.6.2 by bekvon
2013-02-17 19:15:37 [INFO] [ChatManager] Enabling ChatManager v1.19.1
2013-02-17 19:15:37 [INFO] [ChatManager] ChatManager enabled!
2013-02-17 19:15:37 [INFO] [ChatManager] Multiverse 2 integration enabled!
2013-02-17 19:15:37 [INFO] [AuthMe] Enabling AuthMe v2.7.1b1
2013-02-17 19:15:37 [INFO] [AuthMe] Loading Configuration File...
2013-02-17 19:15:37 [INFO] [AuthMe] Merge new Config Options if needed..
2013-02-17 19:15:37 [INFO] [AuthMe] Set Language: en
2013-02-17 19:15:37 [INFO] [AuthMe] MySQL driver loaded
2013-02-17 19:15:37 [INFO] [AuthMe] Connection pool ready
2013-02-17 19:15:37 [INFO] [AuthMe] MySQL Setup finished
2013-02-17 19:15:37 [INFO] [AuthMe] Authme 2.7.1b1 enabled
2013-02-17 19:15:37 [INFO] [EssentialsSpawn] Enabling EssentialsSpawn v2.9.6
2013-02-17 19:15:37 [INFO] Server permissions file permissions.yml is empty, ignoring it
2013-02-17 19:15:37 [INFO] Done (4.690s)! For help, type "help" or "?"
2013-02-17 19:15:37 [INFO] Starting GS4 status listener
2013-02-17 19:15:37 [INFO] Starting remote control listener
2013-02-17 19:15:37 [INFO] Query running on 93.91.240.148:27535
2013-02-17 19:15:37 [INFO] RCON running on 93.91.240.148:26535
2013-02-17 19:15:38 [INFO] CONSOLE: Turned on white-listing[m
2013-02-17 19:15:38 [INFO] 1 1
2013-02-17 19:15:38 [WARNING] [SurvivalGames] Couldn't connect to MySQL database. Stopping...
Access denied for user 'root'@'localhost' (using password: NO)
2013-02-17 19:15:38 [SEVERE] java.lang.NullPointerException
2013-02-17 19:15:38 [SEVERE] at com.skitscape.survivalgames.util.DatabaseManager.createStatement(DatabaseManager.java:72)
2013-02-17 19:15:38 [SEVERE] at com.skitscape.survivalgames.logging.QueueManager.setup(QueueManager.java:55)
2013-02-17 19:15:38 [SEVERE] at com.skitscape.survivalgames.SurvivalGames$Startup.run(SurvivalGames.java:81)
2013-02-17 19:15:38 [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftTask.run(CraftTask.java:53)
2013-02-17 19:15:38 [SEVERE] at org.bukkit.craftbukkit.v1_4_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:344)
2013-02-17 19:15:38 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.r(MinecraftServer.java:530)
2013-02-17 19:15:38 [SEVERE] at net.minecraft.server.v1_4_R1.DedicatedServer.r(DedicatedServer.java:224)
2013-02-17 19:15:38 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.q(MinecraftServer.java:494)
2013-02-17 19:15:38 [SEVERE] at net.minecraft.server.v1_4_R1.MinecraftServer.run(MinecraftServer.java:427)
2013-02-17 19:15:38 [SEVERE] at net.minecraft.server.v1_4_R1.ThreadServerApplication.run(SourceFile:849)
2013-02-17 19:15:38 [SEVERE] [SurvivalGames] !!!Failed to connect to the database. Please check the settings and try again!!!
2013-02-17 19:15:38 [INFO] Loading Arena: 1
2013-02-17 19:15:38 [INFO] -265 68 -148
2013-02-17 19:15:38 [INFO] -468 0 -354
2013-02-17 19:15:38 [INFO] Location{world=CraftWorld{name=mapa1},x=-265.0,y=68.0,z=-148.0,pitch=0.0,yaw=0.0}
2013-02-17 19:15:38 [INFO] Location{world=CraftWorld{name=mapa1},x=-468.0,y=0.0,z=-354.0,pitch=0.0,yaw=0.0}
2013-02-17 19:15:38 [INFO] 4 8
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:18
od vojtamaniak
Zkus odmazat ty uvozovky...
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:30
od Welton123
Hotovo, ale pořád to píše
Kód: Vybrat vše
> 19:28:26 [WARNING] [SurvivalGames] Couldn't connect to MySQL database. Stopping...
Access denied for user '115153_mysql_db'@'ip-1-148.hlucinnet.cz' (using password: YES)Údaje mám dobře.
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 20:31
od vojtamaniak
Zkus host změnit na localhost
Re: SurvivalGames MySQL
Napsal: 17 úno 2013, 21:00
od Welton123
Sláááávaaa!!!!!
Přehlédnul jsem to, co psal zikl, dal jsem tam mike.fakaheda.eu a už to jede. Díky
Ještě jeden dotaz, nevíte, kde sehnat/stáhnout Ty webové statistiky ? :/
Hledal jsem tady
http://dev.bukkit.org/server-mods/survi ... /webstats/ ale buď jsem slepý, nebo tam nikde neni odkaz ke stažení.