Erreur MySQL Permissionsex

Tintingraphics · 10 Septembre 2013

Je réitère mon post du forum Bukkit.fr :

Bonsoir ,

Plus tôt dans la journée , je vous avais posé la question suivante : Est-il possible de connecter une base MySQL à un serveur local. J'ai réussi à faire cela et je remercie les personnes m'ayant aidées.

J'essaie maintenant de connecter le plugin Permissionsex à une base MySQL.

Je configure donc le code du fichier "config.yml" du répertoire "permissionsex" de mon dossier "plugins " sur ce shema :

Code:

permissions:
    basedir: plugins/PermissionsEx
    backend: sql
    backends:
        sql:
            uri: mysql://localhost/databasename
            user: username
            password: password
            deploy: export.sql

Sachant que je remplace par mes identifiants sql.

Mon but serait de relier différents serveurs entre eux avec le MEME fichier de configuration de permissions !

Mais voilà , dans la console j'ai des grosses erreurs.

La partie centrale (celle entre des espaces) est la partie de l'erreur.

Auriez vous des réponses pour mon problème ?

Merci d'avance !

CODE :

Code:

C:\Users\Mon PC\Desktop\Serveurs\Hub>java -Xmx1024M -jar craftbukkit.jar -o true
21:05:48 [INFO] Starting minecraft server version 1.6.2
21:05:48 [INFO] Loading properties
21:05:48 [INFO] Default game type: SURVIVAL
21:05:48 [INFO] Generating keypair
21:05:48 [INFO] Starting Minecraft server on *:25566
21:05:48 [INFO] This server is running CraftBukkit version git-Bukkit-1.6.2-R0.1
-b2838jnks (MC: 1.6.2) (Implementing API version 1.6.2-R0.1)
21:05:48 [INFO] [PermissionsEx] sql backend registered!
21:05:48 [INFO] [PermissionsEx] file backend registered!
21:05:48 [INFO] [DoubleJump] Loading DoubleJump v0.1
21:05:48 [INFO] [HideStream] Loading HideStream v3.2
21:05:48 [INFO] [WorldEdit] Loading WorldEdit v5.5.7
21:05:48 [INFO] [Jump] Loading Jump v1.1
21:05:48 [INFO] [LilyPadCompass] Loading LilyPadCompass v2.4
21:05:48 [INFO] [LilyHub] Loading LilyHub v1.0
21:05:48 [INFO] [LilyPad-Connect] Loading LilyPad-Connect v35
21:05:48 [INFO] [PermissionsEx] Loading PermissionsEx v1.20.1
21:05:48 [INFO] [PermissionsEx] Initializing sql backend
21:05:48 [INFO] [PermissionsEx-SQL] Connecting to database "mysql://sql3.freemys
qlhosting.net"
21:05:50 [INFO] ----- Bukkit Auto Updater -----
21:05:50 [INFO] It appears that you're running a Beta Build, when you've specifi
ed in bukkit.yml that you prefer to run Recommended Builds.
21:05:50 [INFO] If you would like to be kept informed about new Beta Build relea
ses, it is recommended that you change 'preferred-channel' in your bukkit.yml to
'beta'.
21:05:50 [INFO] With that set, you will be told whenever a new version is availa
ble for download, so that you can always keep up to date and secure with the lat
est fixes.
21:05:50 [INFO] If you would like to disable this warning, simply set 'suggest-c
hannels' to false in bukkit.yml.
 
 
 
 
 
 
21:05:50 [INFO] ----- ------------------- -----
21:05:50 [INFO] [PermissionsEx-SQL] Successfully connected to database
21:05:51 [INFO] Deploying default database scheme
21:05:51 [SEVERE] [PermissionsEx]
========== UNABLE TO LOAD PERMISSIONS BACKEND =========
Your configuration must be fixed before PEX will enable
Details: Deploying of default data failed. Please initialize database manually u
sing mysql.sql
=======================================================
ru.tehkode.permissions.exceptions.PermissionBackendException: Deploying of defau
lt data failed. Please initialize database manually using mysql.sql
        at ru.tehkode.permissions.backends.SQLBackend.deployTables(SQLBackend.ja
va:263)
        at ru.tehkode.permissions.backends.SQLBackend.initialize(SQLBackend.java
:100)
        at ru.tehkode.permissions.PermissionManager.setBackend(PermissionManager
.java:429)
        at ru.tehkode.permissions.PermissionManager.initBackend(PermissionManage
r.java:495)
        at ru.tehkode.permissions.PermissionManager.<init>(PermissionManager.jav
a:57)
        at ru.tehkode.permissions.bukkit.PermissionsEx.onLoad(PermissionsEx.java
:86)
        at org.bukkit.craftbukkit.v1_6_R2.CraftServer.loadPlugins(CraftServer.ja
va:244)
        at org.bukkit.craftbukkit.v1_6_R2.CraftServer.<init>(CraftServer.java:21
7)
        at net.minecraft.server.v1_6_R2.PlayerList.<init>(PlayerList.java:56)
        at net.minecraft.server.v1_6_R2.DedicatedPlayerList.<init>(SourceFile:11
)
        at net.minecraft.server.v1_6_R2.DedicatedServer.init(DedicatedServer.jav
a:106)
        at net.minecraft.server.v1_6_R2.MinecraftServer.run(MinecraftServer.java
:391)
        at net.minecraft.server.v1_6_R2.ThreadServerApplication.run(SourceFile:5
82)
Caused by: java.sql.BatchUpdateException: No database selected
        at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
        at ru.tehkode.permissions.backends.SQLBackend.executeStream(SQLBackend.j
ava:227)
        at ru.tehkode.permissions.backends.SQLBackend.deployTables(SQLBackend.ja
va:243)
        ... 12 more
 
 
 
 
21:05:51 [INFO] [LilyPad-Portal] Loading LilyPad-Portal v19
21:05:51 [INFO] [NametagEdit] Loading NametagEdit v1.8
21:05:51 [INFO] [EchoPet] Loading EchoPet v2.0.7
21:05:51 [INFO] [HypixelPets] Loading HypixelPets v1.0
21:05:51 [INFO] [WorldGuard] Loading WorldGuard v5.8
21:05:51 [INFO] [MagicClock] Loading MagicClock v4
21:05:51 [INFO] [Essentials] Loading Essentials v2.11.1
21:05:51 [INFO] [LilyPad-PortalCommand] Loading LilyPad-PortalCommand v10
21:05:51 [INFO] [EssentialsProtect] Loading EssentialsProtect v2.11.1
21:05:51 [INFO] [LilySigns] Loading LilySigns v0.1
21:05:51 [INFO] [EssentialsSpawn] Loading EssentialsSpawn v2.11.1
21:05:51 [INFO] [EssentialsChat] Loading EssentialsChat v2.11.1
21:05:51 [INFO] [ScoreboardStats] Loading ScoreboardStats v0.5.9
21:05:51 [INFO] [EssentialsAntiBuild] Loading EssentialsAntiBuild v2.11.1
21:05:51 [INFO] [LilyPad-Connect] Enabling LilyPad-Connect v35
21:05:51 [INFO] Preparing level "world"
21:05:52 [INFO] Preparing start region for level 0 (Seed: 0)
21:05:52 [INFO] Preparing start region for level 1 (Seed: -9171391464862794782)
21:05:52 [INFO] Preparing start region for level 2 (Seed: -9171391464862794782)
21:05:52 [INFO] [DoubleJump] Enabling DoubleJump v0.1
21:05:52 [INFO] [HideStream] Enabling HideStream v3.2
21:05:52 [INFO] [HideStream] Loaded configuration file.
21:05:52 [INFO] [HideStream] Checking for updates ..
21:05:53 [INFO] No update was found.
21:05:53 [INFO] [HideStream] v3.2 enabled.
21:05:53 [INFO] [WorldEdit] Enabling WorldEdit v5.5.7
21:05:53 [INFO] WEPIF: Using the Bukkit Permissions API.
21:05:53 [INFO] [Jump] Enabling Jump v1.1
21:05:53 [INFO] ###############################
21:05:53 [INFO] ##  Jump | [SoSDylan]
21:05:53 [INFO] ##  Jump has been enabled.
21:05:53 [INFO] ##  Version 1.1
21:05:53 [INFO] ###############################
21:05:53 [INFO] [LilyPadCompass] Enabling LilyPadCompass v2.4
21:05:53 [INFO] [LilyHub] Enabling LilyHub v1.0
21:05:53 [INFO] [PermissionsEx] Enabling PermissionsEx v1.20.1
21:05:53 [SEVERE] [PermissionsEx] ==== PermissionsEx could not be enabled due to
an earlier error. Look at the previous server log for more info ====
21:05:53 [INFO] [PermissionsEx] Disabling PermissionsEx v1.20.1
21:05:53 [INFO] WEPIF: Using the Bukkit Permissions API.
21:05:53 [INFO] WEPIF: Using the Bukkit Permissions API.
21:05:53 [INFO] [LilyPad-Portal] Enabling LilyPad-Portal v19
21:05:53 [INFO] [NametagEdit] Enabling NametagEdit v1.8
21:05:53 [INFO] [EchoPet] Enabling EchoPet v2.0.7
21:05:54 [INFO] [HypixelPets] Enabling HypixelPets v1.0
21:05:54 [INFO] [WorldGuard] Enabling WorldGuard v5.8
21:05:55 [INFO] [WorldGuard] (world) TNT ignition is PERMITTED.
21:05:55 [INFO] [WorldGuard] (world) Lighters are PERMITTED.
21:05:55 [INFO] [WorldGuard] (world) Lava fire is blocked.
21:05:55 [INFO] [WorldGuard] (world) Fire spread is UNRESTRICTED.
21:05:55 [INFO] [WorldGuard] Loaded configuration for world 'world'
21:05:55 [INFO] [WorldGuard] (world_nether) TNT ignition is PERMITTED.
21:05:55 [INFO] [WorldGuard] (world_nether) Lighters are PERMITTED.
21:05:55 [INFO] [WorldGuard] (world_nether) Lava fire is blocked.
21:05:55 [INFO] [WorldGuard] (world_nether) Fire spread is UNRESTRICTED.
21:05:55 [INFO] [WorldGuard] Loaded configuration for world 'world_nether'
21:05:55 [INFO] [WorldGuard] (world_the_end) TNT ignition is PERMITTED.
21:05:55 [INFO] [WorldGuard] (world_the_end) Lighters are PERMITTED.
21:05:55 [INFO] [WorldGuard] (world_the_end) Lava fire is blocked.
21:05:55 [INFO] [WorldGuard] (world_the_end) Fire spread is UNRESTRICTED.
21:05:55 [INFO] [WorldGuard] Loaded configuration for world 'world_the_end'
21:05:55 [INFO] [WorldGuard] 1 regions loaded for 'world'
21:05:55 [INFO] [WorldGuard] 0 regions loaded for 'world_nether'
21:05:55 [INFO] [WorldGuard] 0 regions loaded for 'world_the_end'
21:05:55 [INFO] [MagicClock] Enabling MagicClock v4
21:05:55 [INFO] [Essentials] Enabling Essentials v2.11.1
21:05:55 [INFO] Essentials: Using config file enhanced permissions.
21:05:55 [INFO] Permissions listed in as player-commands will be given to all us
ers.
21:05:55 [INFO] [LilyPad-PortalCommand] Enabling LilyPad-PortalCommand v10
21:05:55 [INFO] [EssentialsProtect] Enabling EssentialsProtect v2.11.1
21:05:55 [INFO] [LilySigns] Enabling LilySigns v0.1
21:05:55 [INFO] [EssentialsSpawn] Enabling EssentialsSpawn v2.11.1
21:05:55 [INFO] [EssentialsChat] Enabling EssentialsChat v2.11.1
21:05:55 [INFO] [ScoreboardStats] Enabling ScoreboardStats v0.5.9
21:05:55 [INFO] DataSourcePool [ScoreboardStats] autoCommit[false] transIsolatio
n[SERIALIZABLE] min[2] max[250]
21:05:55 [INFO] DatabasePlatform name:ScoreboardStats platform:sqlite
21:05:55 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.Plugi
nClassLoader]
21:05:55 [INFO] Entities enhanced[0] subclassed[1]
21:05:55 [INFO] [EssentialsAntiBuild] Enabling EssentialsAntiBuild v2.11.1
21:05:55 [INFO] Server permissions file permissions.yml is empty, ignoring it
21:05:55 [INFO] Done (3.830s)! For help, type "help" or "?"
21:05:55 [SEVERE] [NametagEdit] Plugin NametagEdit v1.8 has failed to register e
vents for class ca.wacos.nametagedit.NametagHookPEX because ru/tehkode/permissio
ns/events/PermissionEntityEvent does not exist.
21:05:55 [INFO] [NametagEdit] Hooked into PermissionsEx!
21:05:56 [INFO] [Connect] Connected to the cloud

Detobel36 · 11 Septembre 2013

Salut,

Attend, je comprend pas bien.
Est ce que tu a qqch sur ton pc ? Ton serveur, ta bdd, ou les 2 ?

Cordialement,
Detobel36

Tintingraphics · 11 Septembre 2013

Bonjour ,

Le serveur est en local , la BDD en ligne . Elle fonctionne correctement (c.f les logs) mais il y à une erreur de "BACKEND".

beubeulone · 11 Septembre 2013

Salut,

D'après le log, tu dois exécuter le contenu de mysql.sql pour créer les tables dans la base (Via Phpmyadmin).

Rechercher

Rechercher

Erreur MySQL Permissionsex

Tintingraphics

WebDesign & Graphism

Detobel36

Créateur de plugins (PhoenixRebirth)

Tintingraphics

WebDesign & Graphism

beubeulone

Feignant

Sujets similaires