Хостинг серверов Minecraft playvds.com
  1. Вы находитесь в русском сообществе Bukkit. Мы - администраторы серверов Minecraft, разрабатываем собственные плагины и переводим на русский язык плагины наших собратьев из других стран.
    Скрыть объявление

Привязка PEX к mysql

Тема в разделе "[Архив] Помощь", создана пользователем DarkMiner, 14 апр 2013.

  1. Автор темы
    DarkMiner

    DarkMiner Активный участник

    Баллы:
    68
    Имя в Minecraft:
    Mateo
    Купил я премиум на Hostinger.ru, внешний доступ активировался, пишу данные для входа в базу, но он пишет ошибки
    Код:
    [SEVERE] Error occurred while enabling PermissionsEx v1.19.5 (Is it up to date?)
    java.lang.RuntimeException: java.sql.SQLException: null,  message from server: "Host '2.61.67.155' is not allowed to connect to this MySQL server"
        at ru.tehkode.permissions.backends.sql.SQLConnection.<init>(Unknown Source)
        at ru.tehkode.permissions.backends.SQLBackend.initialize(Unknown Source)
        at ru.tehkode.permissions.PermissionManager.setBackend(Unknown Source)
        at ru.tehkode.permissions.PermissionManager.initBackend(Unknown Source)
        at ru.tehkode.permissions.PermissionManager.<init>(Unknown Source)
        at ru.tehkode.permissions.bukkit.PermissionsEx.onEnable(Unknown Source)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:396)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
        at org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugin(CraftServer.java:291)
        at org.bukkit.craftbukkit.v1_4_R1.CraftServer.enablePlugins(CraftServer.java:273)
        at net.minecraft.server.MinecraftServer.j(MinecraftServer.java:602)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:568)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:447)
        at ho.c(DedicatedServer.java:203)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:724)
        at fy.run(ThreadMinecraftServer.java:16)
    Caused by: java.sql.SQLException: null,  message from server: "Host '2.61.67.155' is not allowed to connect to this MySQL server"
        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.MysqlIO.doHandshake(MysqlIO.java:1116)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at ru.tehkode.permissions.backends.sql.SQLConnection.connect(Unknown Source)
        ... 17 more
    2013-04-14 15:02:39 [INFO] Server permissions file permissions.yml is empty, ignoring it
     
  2. Хостинг MineCraft
    <
  3. Serrrgio

    Serrrgio Старожил Пользователь

    Баллы:
    173
    Skype:
    nonecsa
    Имя в Minecraft:
    None
    переводить нужно?

    скорей всего не правильно указал адрес БД. Почитай на хостинге как подключаться удаленно к БД сайта.
     
  4. Rebellious

    Rebellious Активный участник Пользователь

    Баллы:
    63
    Имя в Minecraft:
    Rebellious
    Есть люди которые тоже используют Hostinger?
    Я пытаюсь Iconomy подключить к mysql, но вылетает вот такое сообщенице в консоли

    15:51:16 [INFO]
    15:51:27 [INFO] rebellious[/178.215.76.106:51562] logged in with entity id 217 a
    t ([world] -376.34718996808675, 73.0, 119.31021896804765)
    15:51:27 [INFO] [iConomy] Database Error: com.mysql.jdbc.exceptions.jdbc4.Commun
    icationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
    15:51:27 [INFO] [iConomy] Database Error: com.mysql.jdbc.exceptions.jdbc4.Commun
    icationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
    15:51:27 [INFO] [iConomy] Database Error: com.mysql.jdbc.exceptions.jdbc4.Commun
    icationsException: Communications link failure
    Вот конфиг Iconomy
    # iConomy 6.0.8b
    # @author Nijikokun <nijikokun@gmail.com>
    # @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 Квадратик (With Seperate 1 Квадратик)
    Major: [ 'Квадратик', 'Квадратик' ]

    # Minor (Major.[Minor]) 0.23 Coins (With Seperate 0 Квадратиков, 23 Coins)
    Minor: [ 'Coin', 'Coins' ]

    Account:
    # Default account balance when created
    Holdings: 100.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 Квадратиков (false) 0.23 Квадратиков and 1.23 Квадратиков
    Minor: false

    # Seperate allows your money to be shown in an alternative way,
    # instead of 1.32 it will show as 1 Квадратик 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 Квадратик you will see: 1 Квадратик.
    # 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: true

    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: '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://mysql.hostinger.ru:3306/u251739414_mctop'

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

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

    # Database Table
    Table: 'iConomy'

    # Database URL without table at the end.
    URL: 'mysql://localhost:3306'

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

    # Unused ATM.
    All: true


    Для БД сделал внешний доступ, а понять в чем ошибка не могу!
    Если поможете решить проблему, могу заплатить.
     

Поделиться этой страницей