[RESOLUE] Problème MySQL - Iconomy 6.0.8b / WolrdGuard

Voskyl · Juillet 29, 2015, 8:02

Bonsoir,
J’écris ici afin de demander de l’aide :
Les plugins « Jobs » et « Multiinv » se sont très bien connecté à ma base Mysql, cependant le plugin Iconomy ne veut pas s’y connecter, en m’affichant cette erreur :

[21:10:51] [Thread-10/INFO]: [iConomy - April Fools] Purged accounts with default balance. [21:10:51] [Thread-11/INFO]: [iConomy] Database Error: java.sql.SQLException: invalid database address: jdbc:adm.minecraft-mania.fr

Fichier Config.yml :

[code]# iConomy 6.0.8b

@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:
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: [ 'CP', 'CP' ]

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

Account:
  # Default account balance when created
  Holdings: 0.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: false

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: ‹ mysqldb ›

# 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: 'adm.minecraft-mania.fr'

# Login details for binary databases
Username: '442014072392742'
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: true

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

  # Database Table
  Table: 'iConomy'

  # Database URL without table at the end.
  URL: 'adm.minecraft-mania.fr'

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

  # Unused ATM.
  All: true[/code]

Identifiants MineCraft-Mania :

Adresse adm.minecraft-mania.fr Port 3306 Nom de la base a442014072220215994392742 Identifiant 442014072392742 Mot de Passe ******

Si vous pouviez m’aider, cela fait quelques heures que je cherche sur le net mais rien trouvé jusqu’à présent…

Hugo · Juillet 29, 2015, 8:18

Essaye avec l’ip chiffrée pour voir si le problème persiste : 87.98.146.249

Cordialement

Voskyl · Juillet 29, 2015, 8:35

Je l’ai mise dans “URL”,

[code]URL: ‘87.98.146.249’

# Login details for binary databases
Username: '442014072392742'
Password: '******'[/code]

et toujours pareil

[22:27:26] [Thread-10/INFO]: [iConomy - April Fools] Purged accounts with default balance. [22:27:26] [Thread-11/INFO]: [iConomy] Database Error: java.sql.SQLException: invalid database address: jdbc:87.98.146.249

PS : Le même problème est arrivé avec Worldguard, avec dans les logs toujours la database… mais celui-ci n’était pas vraiment nécessaire.

Hugo · Juillet 29, 2015, 9:45

Personnelement quand je lie ces deux plugins, je n’obtiens pas de message d’erreur :

Pour Iconomy :
La configuration à avoir (que tu dois modifier !) :

    # 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://87.98.146.249:3306/LeNomDeTaBaseDeDonnée'

    # Login details for binary databases
    Username: 'TonIdentifiant'
    Password: 'TonMotDePasse'

Ce que ça donne dans les logs :

[23:37:42] [Server thread/INFO]: [iConomy] Enabling iConomy v7.0
[23:37:42] [Server thread/INFO]: [iConomy - April Fools] Enabled (15 ms)
[23:37:42] [Server thread/INFO]: [iConomy] Hello, I'm Nijikokun. Yes, this is an April Fools joke, but '/money top' was fixed! Enjoy :) - Rare Version!
[23:37:42] [Server thread/INFO]: [Vault][Economy] iConomy 7 hooked.
[23:37:42] [Thread-6/INFO]: [iConomy - April Fools] Purged accounts with default balance.
[23:37:42] [Server thread/INFO]: [WorldGuard] Enabling WorldGuard v6.1

Pour WorldGuard :
La configuration à avoir :

    sql:
        use: true
        dsn: jdbc:mysql://87.98.146.249:3306/LeNomDeTaBaseDeDonnée
        username: TonIdentifiant/
        password: TonMotDePasse 
        table-prefix: 'LeNomDeLaTable(moi j'ai mis 'WG')'

Ce que ça donne dans les logs :

[23:37:43] [Server thread/INFO]: [WorldGuard] Loading region data...
[23:37:43] [Server thread/INFO]: [WorldGuard] Database: jdbc:mysql://87.98.146.249:3306/MaBaseDeDonnée(MySQL 5.5)
[23:37:43] [Server thread/INFO]: [WorldGuard] Current version of schema `MaBaseDeDonnée`: 2
[23:37:43] [Server thread/INFO]: [WorldGuard] Schema `MaBaseDeDonnée` is up to date. No migration necessary.
[23:37:43] [Server thread/INFO]: Server permissions file permissions.yml is empty, ignoring it

Cordialement

Voskyl · Juillet 30, 2015, 11:43

Ahhh ça a marché ! Vraiment merci pour ton aide !