FakaHeda.eu Fórum

Technická podpora game hostingu FakaHeda.eu
https://forum.fakaheda.eu/

iConomy - MySQL

https://forum.fakaheda.eu/viewtopic.php?f=67&t=28668

Stránka 1 z 1

iConomy - MySQL

Napsal: 21 pro 2015, 15:30
od ungurof
Server: 82.208.17.24:27482

Ahoj, celé dopoledne se snažím napojit iConomy na MySQL a pořád mi to nejde. Nevíte kde je chyba?

Config:

Kód: Vybrat vše

Database:
    # Databases Supported:
    # Flatfile, FF, mini, minidb
    #  - These all equate to miniDB
    ##
    # item, items, inventory, inventoryDB
    #  - These all equate to InventoryDB, which uses inventory for storage
    ##
    # xp, exp, orb, xpdb, expdb, orbdb
    #  - These all equate to ExperienceDB, which relies on Experience for balance.
    ##
    # mysql, mysqldb
    #  - These will attempt to connect to MySQL
    ##
    # sqlite, sqlite2, sqlite3, sqlitedb
    #  - These will attempt to create & connect to SQLite
    ##
    # postgre, postgreSQL, postgreDB
    #  - These will attempt to connect to PostgreSQL
    ##
    # Zde vyberes uloziste dat pro iConomy, jelikoz chces pouzit mysql tak zde zadas mysql (dle komentu nahore)
    Type: 'mysql'
   
    # These are for InventoryDB only.
    #
    # InventoryDB is essentially Physical Money.
    #   It isn't logged in a database, its based on the users inventory
    #   and the two items selected below.
    #
    # MajorItem is the item or block ID of the major currency
    # MinorItem is the item or block ID of the minor currency
    # e.g. MajorItem: 266, MinorItem: 265 for Gold/Iron
    #MajorItem nemusis resit, to je zde pro plugin inventoryDB
    MajorItem: 266
    MinorItem: 265

    # This controls the database name, by default it is iConomy
    ##
    #Jmeno tabulky v databazi, kam se budou data ukladat, muzes klidne nechat iConomy
    #nebo si to muzes zmenit treba na 'ekonomika', je to jenom na tobe
    Table: 'iConomy'

    # URL is for SQL Databases Only
    ##
    # Path to iConomy folder is easy, it's the COMPLETE path.
    # (Mine) G:\MineCraft\plugins\iConomy\
    # Won't be the same as yours, but it usually looks like that.
    ##
    # [H2DB Default] h2:path/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
    # [SQLite Default] sqlite:path/to/iConomy/folder/iConomy.db
    ##
    # Binary Databases use ip:port style connections.
    # ip
    #  - is the connection identifier (internet protocol)
    #  - for ipv6 usually encased in brackets [::1]
    # port
    #  - the port that the database is listening on
    #  - defaults: 3306 for mysql, postgre is either 5740 or 5432
    ##
    # [MySQL Default] mysql://localhost:3306/iConomy
    # [Postgre Default] postgresql://localhost:5740/iConomy
    ##
    #URL je vlastne IP mysql serveru vcetne portu a nazvu databaze
    #zacatek (mysql) nebudes menit, zajima te az cast localhost, kam hodis IP mysql serveru
    #port :3306 nechej i s dvojtečkou, za port hodis lomitko / a za to nazev databaze
    #nazev databaze a IP si dostal emailem od fakahedy
    #celkove to pak bude vypadat nejak takto: URL: 'mysql://93.91.150.150:3306/32546_mysql_xx'
    URL: 'mysql://82.208.17.24:3306/205357_mysql_db'

    # Login details for binary databases
    ##
    #Zde uz vyplnis jenom uzivatele (username) a heslo (password) k mysql
    #To ti zaslala opet FH na email, pote uz jenom ulozis na server a server spustit
    #pokud si vyplnil udaje spravne tak by se melo navazat uspesne spojeni
    Username: '205357_mysql_db'
    Password: '***'


MySQL údaje:

Kód: Vybrat vše

dbserver: casa14.fakaheda.eu
IP: 82.208.17.24
dbname: 205357_mysql_db
dbuser: 205357_mysql_db


Log po startu:

Kód: Vybrat vše

[FakaHeda] Succesfully authorized (rw)!
> [14:27:44 INFO]: Pumpkin Growth Modifier: 100%
> [14:27:44 INFO]: Sapling Growth Modifier: 100%
> [14:27:44 INFO]: Wheat Growth Modifier: 100%
> [14:27:44 INFO]: NetherWart Growth Modifier: 100%
> [14:27:44 INFO]: Entity Activation Range: An 32 / Mo 32 / Mi 16
> [14:27:44 INFO]: Entity Tracking Range: Pl 48 / An 48 / Mo 48 / Mi 32 / Other 64
> [14:27:44 INFO]: Hopper Transfer: 8 Hopper Check: 8 Hopper Amount: 1
> [14:27:44 INFO]: Random Lighting Updates: false
> [14:27:44 INFO]: Structure Info Saving: true
> [14:27:44 INFO]: Sending up to 10 chunks per packet
> [14:27:44 INFO]: Max Entity Collisions: 8
> [14:27:44 INFO]: Custom Map Seeds: Village: 10387312 Feature: 14357617
> [14:27:44 INFO]: Max TNT Explosions: 100
> [14:27:44 INFO]: Tile Max Tick Time: 50ms Entity max Tick Time: 50ms
> [14:27:44 INFO]: Item Despawn Rate: 6000
> [14:27:44 INFO]: Item Merge Radius: 2.5
> [14:27:44 INFO]: Arrow Despawn Rate: 1200
> [14:27:44 INFO]: Allow Zombie Pigmen to spawn from portal blocks: true
> [14:27:44 INFO]: View Distance: 7
> [14:27:44 INFO]: Zombie Aggressive Towards Villager: true
> [14:27:44 INFO]: Chunks to Grow per Tick: 650
> [14:27:44 INFO]: Clear tick list: false
> [14:27:44 INFO]: Experience Merge Radius: 3.0
> [14:27:44 INFO]: -------- World Settings For [world_nether] --------
> [14:27:44 INFO]: Mob Spawn Range: 4
> [14:27:44 INFO]: Anti X-Ray: true
> [14:27:44 INFO]: Engine Mode: 1
> [14:27:44 INFO]: Hidden Blocks: [14, 15, 16, 21, 48, 49, 54, 56, 73, 74, 82, 129, 130]
> [14:27:44 INFO]: Replace Blocks: [1, 5]
> [14:27:44 INFO]: Nerfing mobs spawned from spawners: false
> [14:27:44 INFO]: Cactus Growth Modifier: 100%
> [14:27:44 INFO]: Cane Growth Modifier: 100%
> [14:27:44 INFO]: Melon Growth Modifier: 100%
> [14:27:44 INFO]: Mushroom Growth Modifier: 100%
> [14:27:44 INFO]: Pumpkin Growth Modifier: 100%
> [14:27:44 INFO]: Sapling Growth Modifier: 100%
> [14:27:44 INFO]: Wheat Growth Modifier: 100%
> [14:27:44 INFO]: NetherWart Growth Modifier: 100%
> [14:27:44 INFO]: Entity Activation Range: An 32 / Mo 32 / Mi 16
> [14:27:44 INFO]: Entity Tracking Range: Pl 48 / An 48 / Mo 48 / Mi 32 / Other 64
> [14:27:44 INFO]: Hopper Transfer: 8 Hopper Check: 8 Hopper Amount: 1
> [14:27:44 INFO]: Random Lighting Updates: false
> [14:27:44 INFO]: Structure Info Saving: true
> [14:27:44 INFO]: Sending up to 10 chunks per packet
> [14:27:44 INFO]: Max Entity Collisions: 8
> [14:27:44 INFO]: Custom Map Seeds: Village: 10387312 Feature: 14357617
> [14:27:44 INFO]: Max TNT Explosions: 100
> [14:27:44 INFO]: Tile Max Tick Time: 50ms Entity max Tick Time: 50ms
> [14:27:44 INFO]: Item Despawn Rate: 6000
> [14:27:44 INFO]: Item Merge Radius: 2.5
> [14:27:44 INFO]: Arrow Despawn Rate: 1200
> [14:27:44 INFO]: Allow Zombie Pigmen to spawn from portal blocks: true
> [14:27:44 INFO]: View Distance: 7
> [14:27:44 INFO]: Zombie Aggressive Towards Villager: true
> [14:27:44 INFO]: Chunks to Grow per Tick: 650
> [14:27:44 INFO]: Clear tick list: false
> [14:27:44 INFO]: Experience Merge Radius: 3.0
> [14:27:44 INFO]: -------- World Settings For [world_the_end] --------
> [14:27:44 INFO]: Mob Spawn Range: 4
> [14:27:44 INFO]: Anti X-Ray: true
> [14:27:44 INFO]: Engine Mode: 1
> [14:27:44 INFO]: Hidden Blocks: [14, 15, 16, 21, 48, 49, 54, 56, 73, 74, 82, 129, 130]
> [14:27:44 INFO]: Replace Blocks: [1, 5]
> [14:27:44 INFO]: Nerfing mobs spawned from spawners: false
> [14:27:44 INFO]: Cactus Growth Modifier: 100%
> [14:27:44 INFO]: Cane Growth Modifier: 100%
> [14:27:44 INFO]: Melon Growth Modifier: 100%
> [14:27:44 INFO]: Mushroom Growth Modifier: 100%
> [14:27:44 INFO]: Pumpkin Growth Modifier: 100%
> [14:27:44 INFO]: Sapling Growth Modifier: 100%
> [14:27:44 INFO]: Wheat Growth Modifier: 100%
> [14:27:44 INFO]: NetherWart Growth Modifier: 100%
> [14:27:44 INFO]: Entity Activation Range: An 32 / Mo 32 / Mi 16
> [14:27:44 INFO]: Entity Tracking Range: Pl 48 / An 48 / Mo 48 / Mi 32 / Other 64
> [14:27:44 INFO]: Hopper Transfer: 8 Hopper Check: 8 Hopper Amount: 1
> [14:27:44 INFO]: Random Lighting Updates: false
> [14:27:44 INFO]: Structure Info Saving: true
> [14:27:44 INFO]: Sending up to 10 chunks per packet
> [14:27:44 INFO]: Max Entity Collisions: 8
> [14:27:44 INFO]: Custom Map Seeds: Village: 10387312 Feature: 14357617
> [14:27:44 INFO]: Max TNT Explosions: 100
> [14:27:44 INFO]: Tile Max Tick Time: 50ms Entity max Tick Time: 50ms
> [14:27:44 INFO]: Item Despawn Rate: 6000
> [14:27:44 INFO]: Item Merge Radius: 2.5
> [14:27:44 INFO]: Arrow Despawn Rate: 1200
> [14:27:44 INFO]: Allow Zombie Pigmen to spawn from portal blocks: true
> [14:27:44 INFO]: View Distance: 7
> [14:27:44 INFO]: Zombie Aggressive Towards Villager: true
> [14:27:44 INFO]: Chunks to Grow per Tick: 650
> [14:27:44 INFO]: Clear tick list: false
> [14:27:44 INFO]: Experience Merge Radius: 3.0
> [14:27:44 INFO]: Preparing start region for level 0 (Seed: -7683491542452134456)
> [14:27:45 INFO]: Preparing start region for level 1 (Seed: -7683491542452134456)
> [14:27:45 INFO]: Preparing start region for level 2 (Seed: -7683491542452134456)
> [14:27:45 INFO]: [HeroicDeathPlus] Enabling HeroicDeathPlus v2.5
> [14:27:45 INFO]: [HeroicDeathPlus] 2.5 enabled.
> [14:27:45 INFO]: [WorldEdit] Enabling WorldEdit v6.1;no_git_id
> [14:27:46 INFO]: WEPIF: Using the Bukkit Permissions API.
> [14:27:46 INFO]: [WorldEdit] Using com.sk89q.worldedit.bukkit.adapter.impl.Spigot_v1_8_R3 as the Bukkit adapter
> [14:27:46 INFO]: [FakaHedaMinequery] Enabling FakaHedaMinequery v1.3
> [14:27:46 INFO]: Starting FakaHedaMinequery server on 82.208.17.24:28482
> [14:27:46 INFO]: [iConomy] Enabling iConomy v7.0
> [14:27:46 INFO]: [iConomy - April Fools] Enabled (11 ms)
> [14:27:46 INFO]: [iConomy] Hello, I'm Nijikokun. Yes, this is an April Fools joke, but '/money top' was fixed! Enjoy :) - Rare Version!
> [14:27:46 INFO]: [Vault][Economy] iConomy 7 hooked.
> [14:27:46 INFO]: [AdvancedBan] Enabling AdvancedBan v9
> [14:27:46 INFO]: [iConomy - April Fools] Purged accounts with default balance.
> [14:27:46 INFO]: [AdvancedBan] MC-Stats >> Connected
> [14:27:46 INFO]:
[=]---------------------------[=]
-= AdvancedBan =-
Dev: Leoko
Status: Enabled
License: Public
Link: http://dev.bukkit.org/bukkit-plugins/advancedban/
Support [Skype/Mail]: Leoko33 / Leoko4433@gmail.com
Version: 9
[=]---------------------------[=]
> [14:27:46 INFO]: [ActionHealth] Enabling ActionHealth v2.5
> [14:27:46 INFO]: [PermissionsEx] Enabling PermissionsEx v1.23.3
> [14:27:46 INFO]: [PermissionsEx] Initializing file backend
> [14:27:46 INFO]: [PermissionsEx] Permissions file successfully reloaded
> [14:27:46 INFO]: WEPIF: PermissionsEx detected! Using PermissionsEx for permissions.
> [14:27:46 INFO]: [Vault][Permission] PermissionsEx hooked.
> [14:27:46 INFO]: [Vault][Chat] PermissionsEx_Chat hooked.
> [14:27:46 INFO]: [ScoreboardStats] Enabling ScoreboardStats v0.9.1
> [14:27:46 INFO]: [ScoreboardStats] Registered replacers: [VaultVariables, PlayerPingVariable, BukkitGlobalVariables, GeneralVariables, BukkitVariables]
> [14:27:46 ERROR]: ebean.properties not found
> [14:27:46 INFO]: Using [com.github.games647.scoreboardstats.pvpstats.PathReader] to read the searchable class path
> [14:27:46 INFO]: DataSourcePool [ScoreboardStats] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
> [14:27:46 INFO]: DatabasePlatform name:ScoreboardStats platform:mysql
> [14:27:46 INFO]: SubClassFactory parent ClassLoader [com.github.games647.scoreboardstats.ReloadFixLoader]
> [14:27:46 INFO]: Entities enhanced[0] subclassed[1]
> [14:27:46 INFO]: runScript
> [14:27:46 INFO]: executing 1 of 1 create table IF NOT EXISTS player_stats ( id integer auto...
> [14:27:46 INFO]: ... end of script
> [14:27:46 INFO]: yCommand] Enabling MyCommand v5.1.6
> [14:27:46 INFO]: =-=-=-=-=-=-=-=-=-=-=-MyCommand-=-=-=-=-=-=-=-=-=-=-=-=
> [14:27:46 INFO]: = Vault : Ok. Hooked MyCommand Vault 1.5.6-b49
> [14:27:46 INFO]: = Spout : Not detected BarAPI : Not detected
> [14:27:46 INFO]: = Config : Ok
> [14:27:46 INFO]: = Custom commands loaded : 14
> [14:27:46 INFO]: = Version: 5.1.6
> [14:27:46 INFO]: = Author : MRI a.k.a Ivanpro
> [14:27:46 INFO]: = Status : Active
> [14:27:46 INFO]: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> [14:27:46 INFO]: [Essentials] Enabling Essentials vTeamCity
> [14:27:46 INFO]: Bukkit version format changed. Version not checked.
> [14:27:46 INFO]: git-Spigot-db6de12-d3e0b6f (MC: 1.8.8)
> [14:27:46 INFO]: 1.8.8-R0.1-SNAPSHOT
> [14:27:46 INFO]: [Essentials] Starting Essentials ban format conversion
> [14:27:46 INFO]: Using locale cs
> [14:27:47 INFO]: Using locale cs
> [14:27:47 INFO]: [Vault][Economy] Essentials Economy hooked.
> [14:27:47 INFO]: Essentials: Using PermissionsEx based permissions.
> [14:27:47 INFO]: [Essentials] Payment method found (Vault - Economy: iConomy 7 version: 1.5.6-b49)
> [14:27:47 INFO]: [Residence] Enabling Residence v2.6.7.0
> [14:27:47 INFO]: [Residence] Found Vault using permissions plugin:PermissionsEx
> [14:27:47 INFO]: [Residence] Failed to update language file: Polish.yml
> [14:27:47 INFO]: [Residence] Scanning for economy systems...
> [14:27:47 INFO]: [Residence] Found Vault using economy system: iConomy 7
> [14:27:47 INFO]: [Residence] Found WorldEdit
> [14:27:47 INFO]: [Residence] Enabled! Version 2.6.7.0 by bekvon
> [14:27:47 INFO]: [Jobs] Enabling Jobs v2.12.0
> [14:27:47 INFO]: [Jobs] Started database save task
> [14:27:47 INFO]: [Jobs] Started buffered payment thread
> [14:27:47 INFO]: [Jobs] Plugin has been enabled succesfully.
> [14:27:47 INFO]: [EssentialsSpawn] Enabling EssentialsSpawn vTeamCity
> [14:27:47 INFO]: [ChestShop] Enabling ChestShop v3.8.12
> [14:27:47 ERROR]: WARNING: you seem to not be using the Xerial SQLite driver. See ORMLite docs on SQLite: http://ormlite.com/docs/sqlite
> [14:27:47 INFO]: creating table 'items'
> [14:27:47 INFO]: executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `items` (`id` INTEGER PRIMARY KEY AUTOINCREMENT , `code` VARCHAR NOT NULL , UNIQUE (`code`))
> [14:27:47 ERROR]: WARNING: you seem to not be using the Xerial SQLite driver. See ORMLite docs on SQLite: http://ormlite.com/docs/sqlite
> [14:27:47 INFO]: creating table 'accounts'
> [14:27:47 INFO]: creating index 'accounts_shortName_idx' for table 'accounts
> [14:27:47 INFO]: executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `accounts` (`lastSeenName` VARCHAR NOT NULL , `name` VARCHAR NOT NULL , `shortName` VARCHAR NOT NULL , `uuid` VARCHAR NOT NULL , PRIMARY KEY (`name`) )
> [14:27:47 INFO]: executed create table statement changed 0 rows: CREATE INDEX IF NOT EXISTS `accounts_shortName_idx` ON `accounts` ( `shortName` )
> [14:27:47 ERROR]: [ChestShop] You are using an old version of Residence! Please update to the newest one, which supports UUIDs: http://ci.drtshock.net/job/Residence/
> [14:27:47 INFO]: [ChestShop] Residence version 2.6.7.0 loaded.
> [14:27:47 INFO]: [ChestShop] Vault loaded! Found an economy plugin!
> [14:27:48 INFO]: [EssentialsChat] Enabling EssentialsChat vTeamCity
> [14:27:48 INFO]: [AuthMe] Enabling AuthMe v3.4
> [14:27:48 INFO]: [AuthMe] Loading Configuration File...
> [14:27:48 INFO]: [AuthMe] Set Language: en
> [14:27:48 INFO]: [AuthMe] Vault plugin detected, hook with PermissionsEx system
> [14:27:48 INFO]: [AuthMe] Hook with Essentials plugin
> [14:27:48 INFO]: [AuthMe] Hook with EssentialsSpawn plugin
> [14:27:48 INFO]: [AuthMe] MySQL driver loaded
> [14:27:48 INFO]: [AuthMe] Connection pool ready
> [14:27:48 INFO]: [AuthMe] LICENSE : This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com
> [14:27:48 INFO]: [AuthMe] Authme 3.4 enabled
> [14:27:48 INFO]: Server permissions file permissions.yml is empty, ignoring it
> [14:27:48 INFO]: Done (3.662s)! For help, type "help" or "?"
> [14:27:48 INFO]: Starting GS4 status listener
> [14:27:48 INFO]: Starting remote control listener
> [14:27:48 INFO]: Query running on 82.208.17.24:27482
> [14:27:48 WARN]: No rcon password set in '/hlserver/27482/server.properties', rcon disabled!
> [14:27:48 INFO]: [Jobs] [Jobs] Successfully linked with Vault.
> [14:27:48 INFO]: [Vault] Checking for Updates ...
> [14:27:48 INFO]: [Vault] No new version available


Pomoc odměním K+

-- 22 pro 2015, 08:30 --

Stále aktivní, prosím poraďte mi někdo.

Re: iConomy - MySQL

Napsal: 22 pro 2015, 11:11
od Hanakocz
Zkoušel jsi třeba použít čistý config a ne tento upravený?

Re: iConomy - MySQL

Napsal: 22 pro 2015, 12:06
od ungurof
Ano, to bylo první co jsem dělal a když to nešlo tak jsem se inspiroval zde ve starších tématech ;)

-- 22 pro 2015, 17:45 --

Dobře už to funguje, ale je zde nějaký error:

Kód: Vybrat vše

> [17:44:06 INFO]: [iConomy] Enabling iConomy v7.0
> [17:44:06 INFO]: [iConomy] Database Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user '205357_mysql_db'@'%' to database 'iConomy'
> [17:44:06 INFO]: [iConomy - April Fools] Enabled (168 ms)
> [17:44:06 INFO]: [iConomy] Hello, I'm Nijikokun. Yes, this is an April Fools joke, but '/money top' was fixed! Enjoy :) - Rare Version!
Všechny časy jsou v UTC+02:00
Stránka 1 z 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/