Bonjour a tous , je suis noveau et je ne comprend la base sql de minecraft-maniia . Je configure le sql pour xauth , il me dise :
2013-09-22 07:34:31 [SEVERE] [xAuth] Failed to borrow MySQL connection from pool!
java.sql.SQLException: Must specify port after ‘:’ in connection string
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:190)
at com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:672)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:296)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at de.luricos.bukkit.xAuth.database.ConnectionPool.leaseConn(ConnectionPool.java:62)
at de.luricos.bukkit.xAuth.database.DatabaseController.getConnection(DatabaseController.java:105)
at de.luricos.bukkit.xAuth.database.DatabaseController.isConnectable(DatabaseController.java:94)
at de.luricos.bukkit.xAuth.xAuth.onEnable(xAuth.java:151)
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_6_R2.CraftServer.loadPlugin(CraftServer.java:282)
at org.bukkit.craftbukkit.v1_6_R2.CraftServer.enablePlugins(CraftServer.java:264)
at net.minecraft.server.v1_6_R2.MinecraftServer.l(MinecraftServer.java:313)
at net.minecraft.server.v1_6_R2.MinecraftServer.f(MinecraftServer.java:290)
at net.minecraft.server.v1_6_R2.MinecraftServer.a(MinecraftServer.java:250)
at net.minecraft.server.v1_6_R2.DedicatedServer.init(DedicatedServer.java:151)
at net.minecraft.server.v1_6_R2.MinecraftServer.run(MinecraftServer.java:391)
at net.minecraft.server.v1_6_R2.ThreadServerApplication.run(SourceFile:582)
2013-09-22 07:34:31 [SEVERE] [xAuth] Failed to establish MySQL database connection!
2013-09-22 07:34:31 [INFO] [xAuth] Disabling xAuth v2.4.0
Et il me le desactive et pour iconomy , il me dise :
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Config xauth pour le sql :
mysql:
enabled: true
host: localhost
port: 3307
user: 1201307221016181926198
password: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
database: a1201307221016181926198
tables:
account: accounts
location: locations
lockout: lockouts
playerdata: playerdata
session: sessions
et pour iconomy :
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://a12013072226198:3307/iConomy'
# Login details for binary databases
Username: '12013072226198'
Password: '[color=#000000]aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa[/color]'
Vous pourrier m’aider s’il vous plait .
