iConomy

How to make iConomy 7 (6.0.10b) database to MySQL with localhost?

 

personnaly I don't know, but search it on google. or use the 192.168.1.1xx address (go to cmd and enter ipconfig/all, and I don't know on mac) this is the equivalent to localhost

 

Database part in config:

Code:

 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] 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://localhost:3306/iConomy'
 
    # 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

please help?

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

somebody?

 

You gave us little to no info on your server. Can you go into more detail.

 

Windows XP, server is running on my own computer, and i'm asking how to make that iConomy would save data on localhost with MySql.

 

are you running mysql on your windows laptop? if so, then point your config to localhost:3306 with a root username and password you chose. if you are not running it yet, then download xampp and install mysql with that. xampp works wonders for those who want mysql with little or no experience with it.

 

Code:

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

My settings of iConomy:

Code:

Type: 'mysql'
Table: 'iConomy'
URL: 'mysql://localhost:3306/iConomy'
Username: 'root'
Password: '12345'

And i'm getting this error:

Code:

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

I think i need to create a iConomy.db file, but i don't know where?

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Do you create an iConomy database?
If not, log into your mysql and create the database. I usually create a minecraft database and let the plugins create their tables.