serveur + mysql

2994

Architecte en herbe
18 Mai 2011
97
4
115
29
dragonsss.fr
bonjour, je suis en train de configuerez mon serveur pour qu'il ce connecte a une base de donnée externe mais un probléme ce pose : seulement quelque plugin ce connecte.
je m'explique :
j'ai commencer par installer mcmmo de cette façon :
Code:
Items:
    Chimaera_Wing:
        Enabled: true
        Feather_Cost: 10
        Item_ID: 288
Spout:
    Menu:
        Key: KEY_M
    XP:
        Bar:
            Enabled: true
            X_POS: 95
            Y_POS: 6
        Icon:
            Enabled: true
            X_POS: 78
            Y_POS: 2
    Party:
        HP:
            Enabled: true
            X_POS: -11
            Y_POS: 0
            SPACING: 16
    Images:
        URL_DIR: http://mcmmo.rycochet.net/mcmmo/
    HUD:
        Default: STANDARD
        Retro:
            Colors:
                Swords:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Taming:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Acrobatics:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Border:
                    BLUE: 0.0
                    GREEN: 0.0
                    RED: 0.0
                Background:
                    BLUE: 0.75
                    GREEN: 0.75
                    RED: 0.75
                Woodcutting:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Archery:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Axes:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Repair:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Excavation:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Herbalism:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Unarmed:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
                Mining:
                    BLUE: 0.75
                    GREEN: 0.3
                    RED: 0.3
Skills:
    Woodcutting:
        Requires_Axe: true
    Herbalism:
        Green_Thumb:
            Cobble_To_Mossy: true
    Mining:
        Requires_Pickaxe: true
    Archery:
        Fire_Rate_Limiter:
            Enabled: true
            Interval: 1000
    Repair:
        Stone:
            Name: Cobblestone
            ID: 4
        Wood:
            Name: Wood Planks
            ID: 5
        Gold:
            Name: Gold Bars
            ID: 266
        Anvil_Messages: true
        Diamond:
            Name: Diamond
            Level_Required: 50
            ID: 264
        Iron:
            Name: Iron Bars
            ID: 265
Experience:
    Formula:
        Multiplier:
            Swords: 1.0
            Taming: 1.0
            Acrobatics: 1.0
            Sorcery: 1.0
            Excavation: 1.0
            Herbalism: 1.0
            Unarmed: 1.0
            Woodcutting: 1.0
            Mining: 1.0
            Archery: 1.0
            Axes: 1.0
            Repair: 1.0
    Gains:
        Mobspawners:
            Enabled: false
        Multiplier:
            PVP: 1
            Global: 1.0
    PVP:
        Rewards: true
    Excavation:
        Base: 40
        Cake: 3000
        Sulphur: 30
        Bones: 30
        Map: 200
        Slimeballs: 100
        Bucket: 100
        Apple: 100
        Mushroom: 80
        Eggs: 100
        Slowsand: 80
        Watch: 200
        Web: 150
        String: 200
        Glowstone: 80
        Music: 3000
        Diamond: 1000
        Cocoa_Beans: 100
    Woodcutting:
        Birch: 70
        Spruce: 80
        Pine: 90
    Herbalism:
        Sugar_Cane: 30
        Cactus: 30
        Flowers: 100
        Pumpkin: 550
        Mushrooms: 150
        Wheat: 50
    Mining:
        Sandstone: 30
        Glowstone: 30
        Obsidian: 150
        Stone: 30
        Netherrack: 30
        Gold: 350
        Redstone: 150
        Coal: 100
        Diamond: 750
        lapis: 400
        Iron: 250
MySQL:
    Enabled: true
    Database:
        User:
            Name: *****
            Password: *****
        Name: gj847-jeux
        TablePrefix: mcmmo_
    Server:
        Port: 3306
        Address: sql21.free-h.org
XP:
    Gains:
        Mobspawners:
            Enabled: false
    PVP:
        Rewards: true
General:
    HP_Regeneration:
        Enabled: true
    Locale: en_us
    MySpawn:
        Enabled: true
    MOTD:
        Enabled: true
Excavation:
    Drops:
        Cake: true
        Sulphur: true
        Bones: true
        Apples: true
        Map: true
        Slimeballs: true
        Bucket: true
        Netherrack: true
        Mushrooms: true
        Eggs: true
        Slowsand: true
        Watch: true
        Web: true
        String: true
        Glowstone: true
        Music: true
        Diamond: true
        Cocoa_Beans: true
Abilities:
    Cooldowns:
        Giga_Drill_Breaker: 240
        Berserk: 240
        Green_Terra: 240
        Skull_Splitter: 240
        Serrated_Strikes: 240
        Tree_Feller: 240
        Super_Breaker: 240
    Tools:
        Durability_Loss: 2
        Durability_Loss_Enabled: true
Commands:
    invite:
        Name: invite
        Enabled: true
    mctop:
        Name: mctop
        Enabled: true
    xplock:
        Name: xplock
        Enabled: true
    whois:
        Name: whois
        Enabled: true
    mcc:
        Name: mcc
        Enabled: true
    mmoedit:
        Name: mmoedit
        Enabled: true
    accept:
        Name: accept
        Enabled: true
    stats:
        Name: stats
        Enabled: true
    mcability:
        Name: mcability
        Enabled: true
    party:
        Name: party
        Enabled: true
    xprate:
        Name: xprate
        Enabled: true
    mcgod:
        Name: mcgod
        Enabled: true
    mcmmo:
        Name: mcmmo
        Enabled: true
        Donate_Message: true
    mcrefresh:
        Name: mcrefresh
        Enabled: true
    myspawn:
        Name: myspawn
        Enabled: true
    addxp:
        Name: addxp
        Enabled: true
    clearmyspawn:
        Name: clearmyspawn
        Enabled: true
    ptp:
        Name: ptp
        Enabled: true
tout ses bien passé comme le montre l'image suivant :
Sans%20titre.jpg


j'ai donc continuer est j'ai voulut configuerer worldguard et je suis tomber sur sa
Code:
blacklist:
    use-as-whitelist: false
    logging:
        console:
            enable: true
        file:
            path: worldguard/logs/%Y-%m-%d.log
            enable: false
            open-files: 10
        database:
            dsn: jdbc:mysql://localhost:3306/minecraft
            enable: false
            table: blacklist_events
            user: root
            pass: ''
je me suis donc mi a configuerez et le fichier final et le suivant :
Code:
#
# WorldGuard's main configuration file
#
# This is the global configuration file. Anything placed into here will
# be applied to all worlds. However, each world has its own configuration
# file to allow you to replace any setting in here for that world only.
#
# About editing this file:
# - DO NOT USE TABS. You MUST use spaces or Bukkit will complain. If
#   you use an editor like Notepad++ (recommended for Windows users), you
#   must configure it to "replace tabs with spaces." In Notepad++, this can
#   be changed in Settings > Preferences > Language Menu.
# - Don't get rid of the indents. They are indented so some entries are
#   in categories (like "enforce-single-session" is in the "protection"
#   category.
# - If you want to check the format of this file before putting it
#   into WorldGuard, paste it into http://yaml-online-parser.appspot.com/
#   and see if it gives "ERROR:".
# - Lines starting with # are comments and so they are ignored.
#
iconomy:
    buy-on-claim-price: 1.0
    enable: false
    buy-on-claim: false
protection:
    enforce-single-session: true
    item-durability: true
    remove-infinite-stacks: false
chest-protection:
    enable: false
physics:
    allow-portal-anywhere: false
    no-physics-sand: false
    no-physics-gravel: false
    disable-water-damage-blocks: []
ignition:
    block-tnt: false
    block-lighter: false
regions:
    max-region-count-per-player: 7
    claim-only-inside-existing-regions: false
    max-claim-volume: 30000
    high-frequency-flags: false
    enable: true
    use-scheduler: true
    wand: 287
simulation:
    sponge:
        redstone: false
        enable: true
        radius: 3
    classic-water: false
fire:
    disable-lava-fire-spread: true
    lava-spread-blocks: []
    disable-fire-spread-blocks: []
    disable-all-fire-spread: false
suppress-tick-sync-warnings: false
spawn:
    login-protection: 3
    exact-respawn: false
    teleport-to-home-on-death: false
    kick-on-death: false
    spawn-protection: 0
default:
    disable-health-regain: false
mobs:
    anti-wolf-dumbness: false
    block-creature-spawn: []
    block-creeper-block-damage: false
    block-creeper-explosions: false
dynamics:
    disable-ice-melting: false
    disable-snow-formation: false
    disable-mushroom-spread: false
    disable-snow-melting: false
    disable-leaf-decay: false
    disable-ice-formation: false
blacklist:
    use-as-whitelist: false
    logging:
        console:
            enable: true
        file:
            path: worldguard/logs/%Y-%m-%d.log
            enable: false
            open-files: 10
        database:
            dsn: jdbc:mysql://sql21.free-h.org
            enable: true
            table: gj847-jeux
            user: *****
            pass: *****
summary-on-start: true
weather:
    always-raining: false
    disable-powered-creepers: false
    disable-weather: false
    disable-lightning-strike-fire: false
    always-thundering: false
    prevent-lightning-strike-blocks: []
    disable-thunderstorm: false
    disable-pig-zombification: false
crops:
    disable-creature-trampling: false
    disable-player-trampling: false
op-permissions: true
player-damage:
    teleport-on-void-falling: false
    disable-drowning-damage: false
    disable-mob-damage: false
    disable-explosion-damage: false
    disable-void-damage: false
    disable-fall-damage: false
    disable-fire-damage: false
    disable-contact-damage: false
    disable-suffocation-damage: false
    disable-lightning-damage: false
    disable-lava-damage: false
    teleport-on-suffocation: false
pumpkin-scuba: false
auto-invincible-permission: false
mais ce cous si il ne ce passe rien su la base de donnée
Sans%20titre.jpg

je me suis di que c'etait peutre normal, j'ai donc continuer avec iconomy toujour de la même façon
Code:
# iConomy 6.0
# @author     Nijikokun <[email protected]>
# @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:
  Default:
    Currency:
      # Major is the first segment [Major].Minor
      Major: [ 'Dollar', 'Dollars' ]                # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
      Minor: [ 'Coin', 'Coins' ]                    # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 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
  # 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.
    # 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: 'gj847-jeux'
    # 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: 'sql21.free-h.org'
    # Login details for binary databases
    Username: 'minecraft'
    Password: '446ergmg'
    # 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: true
      # Database Type, H2DB or MySQL
      Type: 'MySQL'
      # Database Table
      Table: 'gj847-jeux'
      # Database URL without table at the end.
      URL: 'sql21.free-h.org'
      # Username / Password
      # H2DB does not use this. MySQL Only.
      Username: '*****'
      Password: '*****'
      # Unused ATM.
      All: true
mais encor une fois il ne ses rien passez mais en plus j'ai l'erreur suivant dans la console :
Code:
16:04:19 [INFO] [iConomy] Database Error: java.sql.SQLException: No suitable driver found for jdbc:sql21.free-h.org

donc esque quelqu'un aurait une solution s'il vous plait ? car ses urgent :/
 
il faut un plugin en plus si je me rappele bien il doit apparaitre automatiquement dans un dossier appeler lib *mysql.jar*