Připojeni Iconomy na MySQL

[Server.FT]

Ale já vidím
# Database URL without table at the end.
URL: 'neco.fakaheda.eu'

[Sejsel]

To je zase špatně. Má to správně.

Tohle dej na false:

Kód: Vybrat vše

    Conversion:
      # Set to True, After converting, change this back to false!
      Enabled: true

[bobcz11]

Takže to musí být takhle?

Kód: Vybrat vše

Conversion:
      # Set to True, After converting, change this back to false!
      Enabled: false

[Server.FT]

Jo.

[bobcz11]

Podlě me se tam musí někde zadat server na kterém to běží.

[Sejsel]

To má tady:

Kód: Vybrat vše

URL: 'mysql://localhost:3306/105909_mysql_db'

localhost je stroj, na kterém to běží

[bobcz11]

Tak já už nevim čím to je ale ta tabulka se furt nedělá.

Kód: Vybrat vše

# iConomy 6.0.8b
# @author     Nijikokun <nijikokun@gmail.com>
# @license    GPLv2
# @copyright  Copyright AniGaiku LLC (C) 2010-2011
##
# Setup Notes
#   - Seconds
#         Basic Table:
#           1 minute = 60 seconds
#           1 hour = 1 minute * 60 = 3600 seconds
#           1 day = 1 hour * 24 = 86400 seconds
#           1 week = 1 day * 7 = 604800 seconds
#   - Database
#           Do not use remote databases from free sites, please use either a
#           remote database from a personal hosted VPS or DEDI or a local
#           database. This will prevent any 'timeout' or 'invalid settings'
#           or 'cannot connect to database' issues. Thank you :)!
##

System:
  Permissions:
    Use:
      # Should a user have the 'iConomy.holdings' to use /money
      # By default this is false, so that people stop complaining that
      # iConomy doesn't work. Yes, people actually report that.
      # If you are one of those people, leave this false.
      Holdings: false

  Default:
    Currency:
      # Major is the first segment [Major].Minor

      # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
      Major: [ 'Dollar', 'Dollars' ]

      # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 Coins)
      Minor: [ 'Coin', 'Coins' ]

    Account:
      # Default account balance when created
      Holdings: 30.0

  # Controls how money is formatted through methods
  Formatting:
    # Minor allows you to use the Minor amounts for amounts <1
    # Example (true) 0.23 Coins and 1.23 Dollars (false) 0.23 Dollars and 1.23 Dollars
    Minor: false

    # Seperate allows your money to be shown in an alternative way,
    # instead of 1.32 it will show as 1 Dollar 23 Coins
    # !!! NOTICE: This only works if Minor is set to true !!!
    Seperate: false                               # Example (true) 1 Dollar, 23 Coins (false) 1.23 Dollars (Only if Minor is true)

    # Single shows your money in another alternative way.
    # Instead of 1.23 Dollars you will see: 1 Dollar.
    # If your money is 0.23 you will see 0 Dollars if Minor is false, 23 Coins if Minor is true.
    # !!! Notice: This overrides seperate !!!
    Single: false

  # Logs all monetary transactions passed through iConomy
  Logging:
    Enabled: false

  # Purges Default Balances at Loading
  # Good way to keep unused accounts or default accounts wiped out and lower database usage.
  Purging:
    Enabled: true

  # Controls amount of money gained at a set interval.
  Interest:
    Enabled: false

    # Only give interest to players who are currently online?
    Online: true

    Announce:
      # Send a message when the player gains interest?
      Enabled: false

    Interval:
      #  Interval is done in seconds, here is a easy reference table for commonly set intervals:
      #   1 minute = 60 seconds
      #   1 hour = 1 minute * 60 = 3600 seconds
      #   1 day = 1 hour * 24 = 86400 seconds
      #   1 week = 1 day * 7 = 604800 seconds
      Seconds: 60

    Amount:
      # The balance to be met where we stop giving interest.
      # 0.0 for no limit
      Cutoff: 0.0

      # Percentage of holdings to give / take (Negative to take) (Overrides Min/Max)
      Percent: 0.0

      # This is range based, to set a "flat" or "constant" rate, set each (Maximum and Minimum) to the same number.
      # If the two numbers are different, it will be a random amount in-between the two.
      Maximum: 1
      Minimum: 2

  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
    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: 266
    MinorItem: 265

    # This controls the database name, by default it is iConomy
    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: 'mysql://localhost:3306/105909_mysql_db'

    # Login details for binary databases
    Username: '105909_mysql_db'
    Password: '******'

    ##############################################################
    # !!! Conversion is not your database settings !!!
    ##############################################################
    # Conversion allows you to convert your old 5.x to the new 6.x
    # All is currently unused.
    ##############################################################
    # URL is for MySQL only, H2DB doesn't use it.
    ##############################################################
    Conversion:
      # Set to True, After converting, change this back to false!
      Enabled: false

      # Database Type, H2DB or MySQL
      Type: 'mysql'

      # Database Table
      Table: 'iConomy'

      # Database URL without table at the end.
      URL: 'mysql://localhost:3306'

      # Username / Password
      # H2DB does not use this. MySQL Only.
      Username: '105909_mysql_db'
      Password: '******'

      # Unused ATM.
      All: true

[nejento]

Dej sem server.log při startu serveru. Do Code a Spoileru.

[bobcz11]

Dělám to na test serveru.

Kód: Vybrat vše

[FakaHeda] Successfully authorized 37.221.248.236!
229 recipes
27 achievements
> 00:54:54 [INFO] Starting minecraft server version 1.5.2
> 00:54:54 [INFO] Loading properties
> 00:54:54 [INFO] Default game type: SURVIVAL
> 00:54:54 [INFO] Generating keypair
> 00:54:54 [INFO] Starting Minecraft server on 93.91.250.140:27588
> 00:54:54 [INFO] This server is running CraftBukkit version git-Bukkit-1.5.2-R1.0-b2788jnks (MC: 1.5.2) (Implementing API version 1.5.2-R1.0)
> 00:54:54 [INFO] [LagMeter] Loading LagMeter v1.9.0
> 00:54:54 [INFO] [WorldEdit] Loading WorldEdit v5.5.7
> 00:54:54 [INFO] [FakaHedaMinequery] Loading FakaHedaMinequery v1.2
> 00:54:54 [INFO] [iConomy] Loading iConomy v7.0
> 00:54:54 [INFO] [AuthMe] Loading AuthMe v2.5
> 00:54:54 [INFO] [Essentials] Loading Essentials v2.11.1
> 00:54:54 [INFO] [EssentialsChat] Loading EssentialsChat v2.11.1
> 00:54:54 [INFO] [EssentialsProtect] Loading EssentialsProtect v2.11.1
> 00:54:54 [INFO] [EssentialsSpawn] Loading EssentialsSpawn v2.11.1
> 00:54:54 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
> 00:54:54 [WARNING] The server will make no attempt to authenticate usernames. Beware.
> 00:54:54 [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.
> 00:54:54 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
> 00:54:54 [INFO] Preparing level "world"
> 00:54:54 [INFO] Preparing start region for level 0 (Seed: -4088270094550553228)
> 00:54:55 [INFO] Preparing start region for level 1 (Seed: 2226251387331005759)
> 00:54:55 [INFO] Preparing start region for level 2 (Seed: 2226251387331005759)
> 00:54:55 [INFO] [LagMeter] Enabling LagMeter v1.9.0
> 00:54:55 [INFO] [LagMeter] Not using logs folder.
> 00:54:55 [INFO] [LagMeter 1.9.0] Enabled! Polling every 40 server ticks. Logging to /hlserver/27588/plugins/LagMeter/lag.log
> 00:54:55 [INFO] [WorldEdit] Enabling WorldEdit v5.5.7
> 00:54:55 [INFO] WEPIF: Using the Bukkit Permissions API.
> 00:54:55 [INFO] [FakaHedaMinequery] Enabling FakaHedaMinequery v1.2
> 00:54:55 [INFO] Starting FakaHedaMinequery server on 93.91.250.140:28588
> 00:54:55 [INFO] [iConomy] Enabling iConomy v7.0
> 00:54:55 [INFO] [iConomy] Database Error: java.sql.SQLException: Access denied for user '105909_mysql_db'@'localhost' (using password: YES)
> 00:54:55 [INFO] [iConomy - April Fools] Enabled (112 ms)
> 00:54:55 [INFO] [iConomy] Hello, I'm Nijikokun. Yes, this is an April Fools joke, but '/money top' was fixed! Enjoy :) - Rare Version!
> 00:54:55 [INFO] [iConomy - April Fools] Purged accounts with default balance.
> 00:54:55 [INFO] [iConomy] Database Error: java.sql.SQLException: Access denied for user '105909_mysql_db'@'localhost' (using password: YES)
> 00:54:55 [INFO] [AuthMe] Enabling AuthMe v2.5
> 00:54:55 [SEVERE] Error occurred while enabling AuthMe v2.5 (Is it up to date?)
java.lang.NoClassDefFoundError: org/bukkit/util/config/Configuration
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:792)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at org.bukkit.plugin.java.PluginClassLoader.findClass0(PluginClassLoader.java:80)
at org.bukkit.plugin.java.JavaPluginLoader.getClassByName0(JavaPluginLoader.java:300)
at org.bukkit.plugin.java.PluginClassLoader.findClass0(PluginClassLoader.java:76)
at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:53)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at uk.org.whoami.authme.AuthMe.onEnable(AuthMe.java:60)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_5_R3.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_5_R3.MinecraftServer.j(MinecraftServer.java:304)
at net.minecraft.server.v1_5_R3.MinecraftServer.e(MinecraftServer.java:283)
at net.minecraft.server.v1_5_R3.MinecraftServer.a(MinecraftServer.java:243)
at net.minecraft.server.v1_5_R3.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:382)
at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)
Caused by: java.lang.ClassNotFoundException: org.bukkit.util.config.Configuration
at org.bukkit.plugin.java.PluginClassLoader.findClass0(PluginClassLoader.java:70)
at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:53)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 27 more
> 00:54:55 [INFO] [Essentials] Enabling Essentials v2.11.1
> 00:54:56 [INFO] Essentials: Using config file enhanced permissions.
> 00:54:56 [INFO] Permissions listed in as player-commands will be given to all users.
> 00:54:56 [INFO] [Essentials] Payment method found (iConomy version: 6)
> 00:54:56 [INFO] [EssentialsChat] Enabling EssentialsChat v2.11.1
> 00:54:56 [INFO] [EssentialsProtect] Enabling EssentialsProtect v2.11.1
> 00:54:56 [INFO] [EssentialsSpawn] Enabling EssentialsSpawn v2.11.1
> 00:54:56 [INFO] Server permissions file permissions.yml is empty, ignoring it
> 00:54:56 [INFO] Done (1.386s)! For help, type "help" or "?"
> 00:54:56 [INFO] Starting GS4 status listener
> 00:54:56 [INFO] Starting remote control listener
> 00:54:56 [INFO] Query running on 93.91.250.140:27588
> 00:54:56 [WARNING] No rcon password set in '/hlserver/27588/server.properties', rcon disabled!

[nejento]

Nemůže se to přihlásit. Překontroluj si ještě jenou připojovací údaje a případně místo localhost nahraď server tím, který byl napsán v E-mailu při získání MySQL databáze.