Iconomy

Этот плагин всегда требует подключения к мускл? или можно как то без этого

 

в настройках можно поменять на SQLite и minidb (текстовая бд)

 

Пожалуйста скажи, где там в настройках

 

В файле Config.yml смотри секцию Database:

Спойлер

Код:

  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: 'sqlite3'
   
    # These are for InventoryDB only.
    # 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: 'sqlite:plugins/iConomy/iConomy.db'
 
    # Login details for binary databases
    Username: 'root'
    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

 

Кто поможет с подключением iconomy к mysql ?Напишите в скайп fenstann

 

Опиши здесь нормально проблему

 

У меня есть база данных fenstan_Crafter,а в ней таблица 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 Dollar (With Seperate 1 Dollar)
Major: [ 'Dollar', 'Dollars' ]

# Minor (Major.[Minor]) 0.23 Coins (With Seperate 0 Dollars, 23 Coins)
Minor: [ 'Coin', 'Coins' ]

Account:
# Default account balance when created
Holdings: 30.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 Dollars (false) 0.23 Dollars and 1.23 Dollars
Minor: false

# Seperate allows your money to be shown in an alternative way,
# instead of 1.32 it will show as 1 Dollar 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 Dollars you will see: 1 Dollar.
# 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: 'minidb'

# 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] h2ath/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
# [SQLite Default] sqliteath/to/iConomy/folder/iConomy.db
##
# Binary Databases use iport 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://s15.webhost1.ru:3306/fenstan_crafter.iconomy'

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

У меня все равно не подключается.
У

 

Код:

Type: 'minidb'

почему ты решил что он должен подключаться к mysql?

 

Написал,MySQL,все равно не работает

 

ну тогда давай посмотрим логи на предмет ошибок.

сразу вопрос, твой хостинг mysql разрешает подключаться к базе извне?
таблица в БД существует?
у твоего пользователя полные привилегии на БД?

А вобще не рекомендую юзать БД на хостинге, установи базу на тот же хост где и сервер, это исключит лаги (задержки, обрывы соединений) при работе с mysql, а вот с сайта (если это необходимо: статистика, топ богачей и т.д.) будешь соединяться с твоей БД и тут эти обрывы и задержки не так критичны, откроется страница на сайте через 500 мс или даже чере 1 сек.

покажи пинг с сервера до хостера БД.

 

сразу вопрос, твой хостинг mysql разрешает подключаться к базе извне? Да
таблица в БД существует? Да
у твоего пользователя полные привилегии на БД? Да

Спойлер

2012-07-18 04:00:04 [INFO] Starting minecraft server version 1.2.5
2012-07-18 04:00:04 [INFO] Loading properties
2012-07-18 04:00:04 [INFO] Starting Minecraft server on *:25565
2012-07-18 04:00:04 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
2012-07-18 04:00:04 [WARNING] The server will make no attempt to authenticate usernames. Beware.
2012-07-18 04:00:04 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
2012-07-18 04:00:04 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
2012-07-18 04:00:04 [INFO] This server is running CraftBukkit version git-Bukkit-1.2.5-R1.0-b2149jnks (MC: 1.2.5) (Implementing API version 1.2.5-R1.0)
2012-07-18 04:00:04 [WARNING] Could not get information about this CraftBukkit version; perhaps you are running a custom one?: IOException
2012-07-18 04:00:04 [WARNING] Could not get latest artifact information: IOException
2012-07-18 04:00:05 [INFO] [PermissionsEx] sql backend registered!
2012-07-18 04:00:05 [INFO] [PermissionsEx] file backend registered!
2012-07-18 04:00:05 [INFO] [PermissionsEx] PermissionEx plugin initialized.
2012-07-18 04:00:05 [INFO] [WorldBorder] Loading WorldBorder v1.5.4
2012-07-18 04:00:05 [INFO] [LagMeter] Loading LagMeter v1.7
2012-07-18 04:00:05 [INFO] [AutoMessage] Loading AutoMessage v1.5
2012-07-18 04:00:05 [INFO] [WorldEdit] Loading WorldEdit v5.3-SNAPSHOT
2012-07-18 04:00:05 [INFO] [iConomy] Loading iConomy v6.0.9b
2012-07-18 04:00:05 [INFO] [BukkitCompat] Loading BukkitCompat vr20A
2012-07-18 04:00:05 [INFO] [CommandBook] Loading CommandBook v2.1
2012-07-18 04:00:05 [INFO] [Scavenger] Loading Scavenger v1.6
2012-07-18 04:00:05 [INFO] [RedstoneClockDetector] Loading RedstoneClockDetector v0.2.6
2012-07-18 04:00:05 [INFO] [PermissionsEx] Loading PermissionsEx v1.19.1
2012-07-18 04:00:05 [INFO] [PermissionsEx] Initializing file backend
2012-07-18 04:00:05 [INFO] [LWC] Loading LWC v4.2.1 (b700-git-MANUAL) (May 20, 2012)
2012-07-18 04:00:05 [INFO] [FalseBookCore] Loading FalseBookCore v0.93alpha
2012-07-18 04:00:05 [INFO] [LokiFix] Loading LokiFix v0.6
2012-07-18 04:00:05 [INFO] [WorldGuard] Loading WorldGuard v5.5.2-SNAPSHOT
2012-07-18 04:00:05 [INFO] [FalseBookCart] Loading FalseBookCart v0.93alpha
2012-07-18 04:00:05 [INFO] [ChatManager] Loading ChatManager v1.19.1
2012-07-18 04:00:05 [INFO] [FalseBookChat] Loading FalseBookChat v0.93alpha
2012-07-18 04:00:05 [INFO] [FalseBookBlock] Loading FalseBookBlock v0.93alpha
2012-07-18 04:00:05 [INFO] [CreativeGates] Loading CreativeGates v1.3.3
2012-07-18 04:00:05 [INFO] [FalseBookIC] Loading FalseBookIC v0.93alpha
2012-07-18 04:00:05 [INFO] [ChestShop] Loading ChestShop v3.4
2012-07-18 04:00:05 [INFO] [FalseBookExtra] Loading FalseBookExtra v0.93alpha
2012-07-18 04:00:05 [INFO] [LWC] Enabling LWC v4.2.1 (b700-git-MANUAL) (May 20, 2012)
2012-07-18 04:00:05 [INFO] LWC: Loading shared objects
2012-07-18 04:00:05 [INFO] LWC: Native library: plugins/LWC/lib/native/Linux/amd64/libsqlitejdbc.so
2012-07-18 04:00:05 [INFO] LWC: Protection cache: 0/10000
2012-07-18 04:00:05 [INFO] LWC: Loaded 206 locale strings (0 overrides)
2012-07-18 04:00:06 [INFO] [LWC] Permissions API: PEXPermissions
2012-07-18 04:00:06 [INFO] [LWC] Currency API: iConomy6Currency
2012-07-18 04:00:06 [INFO] [LWC] Connecting to SQLite
2012-07-18 04:00:06 [INFO] [LWC] Performing any necessary database updates
2012-07-18 04:00:06 [INFO] [LWC] Using database: Native
2012-07-18 04:00:06 [INFO] LWC: Precached 109 protections.
2012-07-18 04:00:06 [INFO] LWC: At version: 4.2.1 (b700)
2012-07-18 04:00:06 [INFO] [LWC] Latest version: 4.2.1

 

похоже это не весь лог, должно быть еще что-то типа

Код:

15:53:31 [INFO] [iConomy] Enabling iConomy v7.0
15:53:31 [INFO] [iConomy] Database Error: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
15:53:31 [INFO] [iConomy - April Fools] Enabled (337 ms)
15:53:31 [INFO] [iConomy] Hello, I'm Nijikokun. Yes, this is an April Fools joke, but '/money top' was fixed! Enjoy :) - Rare Version!
15:53:31 [INFO] [iConomy - April Fools] Purged accounts with default balance.
15:53:31 [INFO] [iConomy] Database Error: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

 

Спойлер

Sun Jun 10 01:08:56 CEST 2012.
2012-07-18 04:48:52 [WARNING] Details: http://dl.bukkit.org/downloads/craftbukkit/view/01149_1.2.5-R4.0/
2012-07-18 04:48:52 [WARNING] Download: http://dl.bukkit.org/downloads/craftbukkit/get/01149_1.2.5-R4.0/craftbukkit.jar
2012-07-18 04:48:52 [WARNING] ----- ------------------- -----
2012-07-18 04:48:52 [INFO] [PermissionsEx] sql backend registered!
2012-07-18 04:48:52 [INFO] [PermissionsEx] file backend registered!
2012-07-18 04:48:52 [INFO] [PermissionsEx] PermissionEx plugin initialized.
2012-07-18 04:48:53 [INFO] [WorldBorder] Loading WorldBorder v1.5.4
2012-07-18 04:48:53 [INFO] [LagMeter] Loading LagMeter v1.7
2012-07-18 04:48:53 [INFO] [AutoMessage] Loading AutoMessage v1.5
2012-07-18 04:48:53 [INFO] [WorldEdit] Loading WorldEdit v5.3-SNAPSHOT
2012-07-18 04:48:53 [INFO] [iConomy] Loading iConomy v6.0.9b
2012-07-18 04:48:53 [INFO] [BukkitCompat] Loading BukkitCompat vr20A
2012-07-18 04:48:53 [INFO] [CommandBook] Loading CommandBook v2.1
2012-07-18 04:48:53 [INFO] [Scavenger] Loading Scavenger v1.6
2012-07-18 04:48:53 [INFO] [RedstoneClockDetector] Loading RedstoneClockDetector v0.2.6
2012-07-18 04:48:53 [INFO] [PermissionsEx] Loading PermissionsEx v1.19.1
2012-07-18 04:48:53 [INFO] [PermissionsEx] Initializing file backend
2012-07-18 04:48:53 [INFO] [LWC] Loading LWC v4.2.1 (b700-git-MANUAL) (May 20, 2012)
2012-07-18 04:48:53 [INFO] [FalseBookCore] Loading FalseBookCore v0.93alpha
2012-07-18 04:48:53 [INFO] [LokiFix] Loading LokiFix v0.6
2012-07-18 04:48:53 [INFO] [WorldGuard] Loading WorldGuard v5.5.2-SNAPSHOT
2012-07-18 04:48:53 [INFO] [FalseBookCart] Loading FalseBookCart v0.93alpha
2012-07-18 04:48:53 [INFO] [ChatManager] Loading ChatManager v1.19.1
2012-07-18 04:48:53 [INFO] [FalseBookChat] Loading FalseBookChat v0.93alpha
2012-07-18 04:48:53 [INFO] [FalseBookBlock] Loading FalseBookBlock v0.93alpha
2012-07-18 04:48:53 [INFO] [CreativeGates] Loading CreativeGates v1.3.3
2012-07-18 04:48:53 [INFO] [FalseBookIC] Loading FalseBookIC v0.93alpha
2012-07-18 04:48:53 [INFO] [ChestShop] Loading ChestShop v3.4
2012-07-18 04:48:53 [INFO] [FalseBookExtra] Loading FalseBookExtra v0.93alpha
2012-07-18 04:48:53 [INFO] [LWC] Enabling LWC v4.2.1 (b700-git-MANUAL) (May 20, 2012)
2012-07-18 04:48:53 [INFO] LWC: Loading shared objects
2012-07-18 04:48:53 [INFO] LWC: Native library: plugins/LWC/lib/native/Linux/amd64/libsqlitejdbc.so
2012-07-18 04:48:53 [INFO] LWC: Protection cache: 0/10000
2012-07-18 04:48:53 [INFO] LWC: Loaded 206 locale strings (0 overrides)
2012-07-18 04:48:53 [INFO] [LWC] Permissions API: PEXPermissions
2012-07-18 04:48:53 [INFO] [LWC] Currency API: iConomy6Currency
2012-07-18 04:48:53 [INFO] [LWC] Connecting to SQLite
2012-07-18 04:48:53 [INFO] [LWC] Performing any necessary database updates
2012-07-18 04:48:53 [INFO] [LWC] Using database: Native
2012-07-18 04:48:53 [INFO] LWC: Precached 109 protections.
2012-07-18 04:48:53 [INFO] LWC: At version: 4.2.1 (b700)
2012-07-18 04:48:53 [INFO] Preparing level "world"
2012-07-18 04:48:53 [INFO] Default game type: 0
2012-07-18 04:48:53 [INFO] [LWC] Latest version: 4.2.1
2012-07-18 04:48:53 [INFO] Preparing start region for level 0 (Seed: 696467037)
2012-07-18 04:48:54 [INFO] Preparing spawn area: 52%
2012-07-18 04:48:56 [INFO] Preparing spawn area: 61%
2012-07-18 04:48:57 [INFO] Preparing spawn area: 81%
2012-07-18 04:48:57 [INFO] Preparing start region for level 1 (Seed: 95758553)
2012-07-18 04:48:58 [INFO] Preparing spawn area: 32%
2012-07-18 04:48:58 [INFO] Preparing start region for level 2 (Seed: 95758553)
2012-07-18 04:48:58 [INFO] [WorldBorder] Enabling WorldBorder v1.5.4
2012-07-18 04:48:58 [INFO] [WorldBorder] [CONFIG] Using round border, knockback of 3.0 blocks, and timer delay of 5.
2012-07-18 04:48:58 [INFO] [WorldBorder] [CONFIG] Проверка ограничения мира включена.
2012-07-18 04:48:58 [INFO] [WorldBorder] [CONFIG] Мир "world" ограниченradius 2000 at X: 4.7 Z: -63.0
2012-07-18 04:48:58 [INFO] Спавн для мира установлен на X: -3.0 Y: 68.0 Z: -65.0
2012-07-18 04:48:58 [INFO] [LagMeter] Enabling LagMeter v1.7
2012-07-18 04:48:58 [INFO] [LagMeter 1.7] Enabled! Polling every 40 server ticks. Logging to /opt/McMyAdmin/Minecraft/plugins/LagMeter/lag.log
2012-07-18 04:48:59 [INFO] [AutoMessage] Enabling AutoMessage v1.5
2012-07-18 04:48:59 [INFO] [AutoMessage] version [1.5] loaded
2012-07-18 04:48:59 [INFO] [WorldEdit] Enabling WorldEdit v5.3-SNAPSHOT
2012-07-18 04:48:59 [INFO] WEPIF: Using the Bukkit Permissions API.
2012-07-18 04:48:59 [INFO] [iConomy] Enabling iConomy v6.0.9b
2012-07-18 04:48:59 [INFO] [iConomy - Celty] Enabled (47 ms)
2012-07-18 04:48:59 [INFO] [iConomy - Celty] Purged accounts with default balance.
2012-07-18 04:48:59 [INFO] [BukkitCompat] Enabling BukkitCompat vr20A
2012-07-18 04:48:59 [INFO] MCMACOMPAT r20A
2012-07-18 04:48:59 [INFO] McMyAdmin Compatibility Plugin version r20A started.
2012-07-18 04:48:59 [INFO] [CommandBook] Enabling CommandBook v2.1
2012-07-18 04:48:59 [INFO] [CommandBook] Maximum wrapper compatibility is enabled. Some features have been disabled to be compatible with poorly written server wrappers.

 

ошибок не видно.