Jump to content
News ticker
  • Bienvenue sur le nouveau forum VeryGames
  • Welcome to the new VeryGames forum
  • VeryNews

    aide serveur bug


    Recommended Posts

    Guest Invité

    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.

    Link to comment
    Share on other sites

    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??

    Link to comment
    Share on other sites

    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..

    Link to comment
    Share on other sites

    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

    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Reply to this topic...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

     Share

    ×
    ×
    • Create New...