Aller au contenu
News ticker
  • Bienvenue sur le nouveau forum VeryGames
  • Welcome to the new VeryGames forum
    • VeryNews

    aide serveur bug

    nicolas69200

    Par nicolas69200
    dans Minecraft VQS & VXP

     Share

    Messages recommandés

    Invité Invité

    Invité Invité

    Posté(e)
    Posté(e)

    Bonjour,

     

    si vous utilisez LogBlock et que vous avez des pertes de connections du plugin, il faut changer dans la configuration :

     

      host: sql-1.priv

     

    dans la partie mysql. Ceci peut être la cause de vos crashs serveur.

    Lien vers le commentaire
    Partager sur d’autres sites
    Max633 Newbie

    Max633

    Posté(e)
    Posté(e)
    Bonjour,

     

    si vous utilisez LogBlock et que vous avez des pertes de connections du plugin, il faut changer dans la configuration :

     

      host: sql-1.priv

     

    dans la partie mysql. Ceci peut être la cause de vos crashs serveur.

     

    Ah ouai.. Mais si je change, mon plugin ne sera plus connecter à ma base de données si??

    Lien vers le commentaire
    Partager sur d’autres sites
    Max633 Newbie

    Max633

    Posté(e)
    Posté(e)

    Et c'est donc pour ça que Iconomy bugais.. Il n'avait plus accès à sa base de données convenablement.. Tout mes plugins ayant une base de données, je me demande pourquoi il bugais.

     

    Edit: ton chemin local ne fonctionne pas, j'ai toujours les erreurs, et mes plugins ne fonctionne tjr pas. Enfin il fonctionne en soit mais l'argent étant sur mysql personne ne peut payer.. J'ai jobs, iconomy et logblock sous mysql..

    Lien vers le commentaire
    Partager sur d’autres sites
    Max633 Newbie

    Max633

    Posté(e)
    Posté(e)

    logblock:

    >19:14:12 [sEVERE] [LogBlock Consumer] SQL exceptioncom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: INSERT command denied to user 'webcacher'@'10.0.0.65' for table 'lb-players'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

    at com.mysql.jdbc.Util.getInstance(Util.java:382)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)

    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)

    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)

    at de.diddiz.LogBlock.Consumer.addPlayer(Consumer.java:358)

    at de.diddiz.LogBlock.Consumer.run(Consumer.java:285)

    at org.bukkit.craftbukkit.scheduler.CraftWork

     

    Iconomy:

     

    >19:14:13 [iNFO] [iConomy] Error issueing SQL query: java.sql.SQLException: UPDATE command denied to user 'webcacher'@'10.0.0.65' for table 'iConomy' Query: UPDATE iConomy SET balance=? WHERE username=? Parameters: [298.59, max633]

     

    >19:13:05 [sEVERE] iConomy6 - If you are using Flatfile storage be aware that iCo6 has a CRITICAL bug which can wipe ALL iconomy data.>19:13:05 [sEVERE] if you're using Votifier, or any other plugin which handles economy data in a threaded manner your server is at risk!

    >19:13:05 [sEVERE] it is highly suggested to use SQL with iCo6 or to use an alternative economy plugin!

     

    Jobs

     

    >19:13:07 [iNFO] [Jobs] Enabling Jobs v2.8.5>19:13:07 [sEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command denied to user 'webcacher'@'77.111.255.67' for table 'Job_jobs'

    >19:13:07 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    >19:13:07 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

    >19:13:07 [sEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    >19:13:07 [sEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

    >19:13:07 [sEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

    >19:13:07 [sEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)

    >19:13:07 [sEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

    >19:13:07 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

    >19:13:07 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

    >19:13:07 [sEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

    >19:13:07 [sEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)

    >19:13:07 [sEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)

    >19:13:07 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)

    >19:13:07 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)

    >19:13:07 [sEVERE] at me.zford.jobs.dao.JobsDAOMySQL.setUp(JobsDAOMySQL.java:43)

    >19:13:07 [sEVERE] at me.zford.jobs.dao.JobsDAOMySQL.<init>(JobsDAOMySQL.java:31)

    >19:13:07 [sEVERE] at me.zford.jobs.bukkit.config.JobsConfiguration.loadGeneralSettings(JobsConfiguration.java:170)

    >19:13:07 [sEVERE] at me.zford.jobs.bukkit.config.JobsConfiguration.reload(JobsConfiguration.java:63)

    >19:13:07 [sEVERE] at me.zford.jobs.bukkit.JobsPlugin.reloadConfigurations(JobsPlugin.java:200)

    >19:13:07 [sEVERE] at me.zford.jobs.bukkit.JobsPlugin.onEnable(JobsPlugin.java:95)

    >19:13:07 [sEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)

    >19:13:07 [sEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)

    >19:13:07 [sEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)

    >19:13:07 [sEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)

    >19:13:07 [sEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)

    >19:13:07 [sEVERE] at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:381)

    >19:13:07 [sEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:368)

    >19:13:07 [sEVERE] at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:197)

    >19:13:07 [sEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:432)

    >19:13:07 [sEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)

     

    LWC:

     

    >19:13:05 [iNFO] [LWC] Enabling LWC v4.2.1 (b700-git-MANUAL) (May 20, 2012)>19:13:05 [iNFO] LWC: Loading shared objects

    >19:13:05 [iNFO] LWC: Native library: plugins/LWC/lib/native/Linux/amd64/libsqlitejdbc.so

    >19:13:05 [iNFO] LWC: Protection cache: 0/10000

    >19:13:05 [iNFO] LWC: Loaded 207 locale strings (0 overrides)

    >19:13:05 [iNFO] [LWC] Permissions API: VaultPermissions

    >19:13:05 [iNFO] [LWC] Currency API: VaultCurrency

    >19:13:05 [iNFO] [LWC] Connecting to MySQL

    >19:13:05 [iNFO] [LWC] Performing any necessary database updates

    >19:13:05 [sEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command denied to user 'web658'@'77.111.255.67' for table 'lwc_protections'

    >19:13:05 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    >19:13:05 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

    >19:13:05 [sEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    >19:13:05 [sEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

    >19:13:05 [sEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

    >19:13:05 [sEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)

    >19:13:05 [sEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)

    >19:13:05 [sEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)

    >19:13:05 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)

    >19:13:05 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)

    >19:13:05 [sEVERE] at com.griefcraft.sql.Table.execute(Table.java:142)

    >19:13:05 [sEVERE] at com.griefcraft.sql.PhysDB.load(PhysDB.java:383)

    >19:13:05 [sEVERE] at com.griefcraft.lwc.LWC.load(LWC.java:1342)

    >19:13:05 [sEVERE] at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:231)

    >19:13:05 [sEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)

    >19:13:05 [sEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)

    >19:13:05 [sEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:190)

    >19:13:05 [sEVERE] at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:53)

    >19:13:05 [sEVERE] at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:166)

    >19:13:05 [sEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:432)

    >19:13:05 [sEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)

    >19:13:05 [sEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command denied to user 'web658'@'77.111.255.67' for table 'lwc_history'

    >19:13:05 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    >19:13:05 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

    >19:13:05 [sEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    >19:13:05 [sEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

    >19:13:05 [sEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

    >19:13:05 [sEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)

    >19:13:05 [sEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)

    >19:13:05 [sEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)

    >19:13:05 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)

    >19:13:05 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)

    >19:13:05 [sEVERE] at com.griefcraft.sql.Table.execute(Table.java:142)

    >19:13:05 [sEVERE] at com.griefcraft.sql.PhysDB.load(PhysDB.java:384)

    >19:13:05 [sEVERE] at com.griefcraft.lwc.LWC.load(LWC.java:1342)

    >19:13:05 [sEVERE] at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:231)

    >19:13:05 [sEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)

    >19:13:05 [sEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)

    >19:13:05 [sEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:190)

    >19:13:05 [sEVERE] at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:53)

    >19:13:05 [sEVERE] at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:166)

    >19:13:05 [sEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:432)

    >19:13:05 [sEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)

    >19:13:05 [sEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command denied to user 'web658'@'77.111.255.67' for table 'lwc_internal'

    >19:13:05 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    >19:13:05 [sEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

    >19:13:05 [sEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    >19:13:05 [sEVERE] at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

    >19:13:05 [sEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

    >19:13:05 [sEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)

    >19:13:05 [sEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

    >19:13:05 [sEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)

    >19:13:05 [sEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)

    >19:13:05 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)

    >19:13:05 [sEVERE] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)

    >19:13:05 [sEVERE] at com.griefcraft.sql.Table.execute(Table.java:142)

    >19:13:05 [sEVERE] at com.griefcraft.sql.PhysDB.load(PhysDB.java:385)

    >19:13:05 [sEVERE] at com.griefcraft.lwc.LWC.load(LWC.java:1342)

    >19:13:05 [sEVERE] at com.griefcraft.lwc.LWCPlugin.onEnable(LWCPlugin.java:231)

    >19:13:05 [sEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)

    >19:13:05 [sEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)

    >19:13:05 [sEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)

    >19:13:05 [sEVERE] at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:190)

    >19:13:05 [sEVERE] at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:53)

    >19:13:05 [sEVERE] at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:166)

    >19:13:05 [sEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:432)

    >19:13:05 [sEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)

    >19:13:05 [iNFO] [LWC] Using database: Mysql-connector-java-5.1.14 ( Revision: ${bzr.revision-id} )

    >19:13:05 [iNFO] LWC: Precached 437 protections.

    >19:13:05 [iNFO] LWC: At version: 4.2.1 (b700)

     

    Brefs.. tous les plugins étant connecter au mysql

    Lien vers le commentaire
    Partager sur d’autres sites

    Rejoindre la conversation

    Vous pouvez publier maintenant et vous inscrire plus tard. Si vous avez un compte, connectez-vous maintenant pour publier avec votre compte.

    Invité
    Répondre à ce sujet…

    ×   Collé en tant que texte enrichi.   Coller en tant que texte brut à la place

      Seulement 75 émoticônes maximum sont autorisées.

    ×   Votre lien a été automatiquement intégré.   Afficher plutôt comme un lien

    ×   Votre contenu précédent a été rétabli.   Vider l’éditeur

    ×   Vous ne pouvez pas directement coller des images. Envoyez-les depuis votre ordinateur ou insérez-les depuis une URL.

    ×
     Share
    Aller sur la liste des sujets
    ×
    ×
    • Créer...