Problém při updatu na 1.11

[pitilon@seznam.cz]

verze skinsrestorer? Dělala jim to verze 12.9-12.9.4 v 12.9.5 to mají již opraveno

[Hanakocz]

...a proč jsi stále nezkusil ty pluginy, jako LWC, WorldGuard atd (ty, co házejí sqlite chybu) napojit místo sqlite na MySQL? Tím by ses té chybě (snad) zcela vyhnul......a mám za to, že takové řešení tu bylo už na první stránce. MySQL máš k serveru zdarma (!), plus je tisícinásobně pro dané pluginy vhodnější řešení, jak sqlite...

[Mike8748]

chybě by se nevyhnul.

protože pluginy jako WG, Authme a další, i když mají jako hlavní úložiště dat nastaveno MySQL databázi, tak SQLite používají pro cache.

pokud jde o sqlite.jar v LWC, je třeba smazat jen ten soubor sqlite.jar, ne celou složku. pokud se smaže celá složka, plugin ji obnoví a stáhne do ní opět sqlite.jar staré verze

[TheLaoming]

Mike, díky. To jsem udělal.

Každopádně, pluginy všechny aktualizované a rozhodl jsem se napojit ty pluginy na mysql...a teď tak trochu bojuju co se týče napojení authme na mysQl. Našel jsem si návod a udělal to podle něj, ale stále mi to hází chybu:

Kód: Vybrat vše

>[05:46:57 INFO]: [iConomy] Database Error: java.sql.SQLException: Access denied for user '230624_mysql_db'@'localhost' (using password: YES)

config:

Spoiler: zobrazit

Kód: Vybrat vše

DataSource:
    # What type of database do you want to use?
    # Valid values: sqlite, mysql
    backend: 'mysql
    # Enable database caching, should improve database performance
    caching: true
    # Database host address
    mySQLHost: '127.0.0.1'
    # Database port
    mySQLPort: '3306'
    # Username about Database Connection Infos
    mySQLUsername: '230624_mysql_db'
    # Password about Database Connection Infos
    mySQLPassword: '(MOJE HESLO)'
    # Database Name, use with converters or as SQLITE database name
    mySQLDatabase: '230624_mysql_db'
    # Table of the database
    mySQLTablename: 'authme'
    # Column of IDs to sort data
    mySQLColumnId: 'id'
    # Column for storing or checking players nickname
    mySQLColumnName: 'username'
    # Column for storing or checking players RealName
    mySQLRealName: 'realname'
    # Column for storing players passwords
    mySQLColumnPassword: 'password'
    # Column for storing players emails
    mySQLColumnEmail: 'email'
    # Column for storing if a player is logged in or not
    mySQLColumnLogged: 'isLogged'
    # Column for storing players ips
    mySQLColumnIp: 'ip'
    # Column for storing players lastlogins
    mySQLColumnLastLogin: 'lastlogin'
    # Column for storing player LastLocation - X
    mySQLlastlocX: 'x'
    # Column for storing player LastLocation - Y
    mySQLlastlocY: 'x'
    # Column for storing player LastLocation - Z
    mySQLlastlocZ: 'x'
    # Column for storing player LastLocation - World Name
    mySQLlastlocWorld: 'Spawnik'
    # Enable this when you allow registration through a website
    mySQLWebsite: false

Co tam je špatně? Řekl bych že to nemá přístup, což je zároveň blbost, protože heslo tam je stejné jako k db a server jsem restartoval.

Co se týče verze skin restorer, tak SkinsRestorer-v12.9.5.

[pitilon@seznam.cz]

Kód: Vybrat vše

    backend: 'mysql

zapomněl jsi to uzavřít zkus

Kód: Vybrat vše

    backend: 'mysql'

[TheLaoming]

No to jsem spravil. Nakonec to dopadlo tak, že se všem smazali peníze ze serveru...a když dám zálohu, kde to napojené na mysQl nebylo, tak to vypisuje stále a já nevím co stím. Jediné co jsem upravoval/napojoval je authme a když tam dám zálohu, kde to má být tak jak to bylo předtím, nefunguje to. I když v cfg je sqlite a ne mysql...danou databázi jsem zkoušel i smazat...

Po připojení hráče spamuje jeden a ten samý error:

Kód: Vybrat vše

>[11:35:07 INFO]: [iConomy] Database Error: java.sql.SQLException: Access denied for user '230624_mysql_db'@'localhost' (using password: YES)

Spoiler: zobrazit

err.png (53.3 KiB) Zobrazeno 3949 x

[pitilon@seznam.cz]

config iconomy?

[TheLaoming]

Jenže v economy sem nic neměnil, pouze v authme.

Kód: Vybrat vše

# iConomy 6.0.8b
# @author     moloco <molocodev@gmail.com>
# @license    GPLv2
# @copyright  Copyright moloco
##
# 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: [ 'Zlatak', 'Zlataku' ]

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

    Account:
      # Default account balance when created
      Holdings: 3000

  # 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: '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://localhost:3306/230624_mysql_db'

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


[pitilon@seznam.cz]

Kód: Vybrat vše

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

zkus vyplnit tohle a pozor u

Kód: Vybrat vše

    Password: '****'

toho začátku máš nějaké heslo radši si ho zamaskuj pokud se jedná o tvé (radši jsem ho zadělal ve svém příspěvku....)

[TheLaoming]

Ok, už to je napojené. Bohužel se resetovali všem peníze a já nevím jak to vrátit, dalo by se to???

A napojit bych měl i LWC a podobně a pak zkusit update?

//edit btw další věc , napíšu ve hře /d <název moba> a vypíše mi to tohle (což mi ve starší verzi libsdisguises nedělalo).

Spoiler: zobrazit

Kód: Vybrat vše

>[13:28:51 INFO]: lico88 issued server command: /d zombie
>[13:28:51 WARN]: java.lang.NullPointerException
>[13:28:51 WARN]: at me.libraryaddict.disguise.disguisetypes.Disguise.createDisguise(Disguise.java:89)
>[13:28:51 WARN]: at me.libraryaddict.disguise.disguisetypes.MobDisguise.<init>(MobDisguise.java:31)
>[13:28:51 WARN]: at me.libraryaddict.disguise.commands.BaseDisguiseCommand.parseDisguise(BaseDisguiseCommand.java:484)
>[13:28:51 WARN]: at me.libraryaddict.disguise.commands.DisguiseCommand.onCommand(DisguiseCommand.java:32)
>[13:28:51 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
>[13:28:51 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
>[13:28:51 WARN]: at org.bukkit.craftbukkit.v1_10_R1.CraftServer.dispatchCommand(CraftServer.java:647)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PlayerConnection.handleCommand(PlayerConnection.java:1358)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PlayerConnection.a(PlayerConnection.java:1193)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PacketPlayInChat.a(PacketPlayInChat.java:45)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PacketPlayInChat.a(PacketPlayInChat.java:1)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PlayerConnectionUtils$1.run(SourceFile:13)
>[13:28:51 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>[13:28:51 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.SystemUtils.a(SourceFile:45)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.D(MinecraftServer.java:732)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.DedicatedServer.D(DedicatedServer.java:400)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.C(MinecraftServer.java:668)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:567)
>[13:28:51 WARN]: at java.lang.Thread.run(Thread.java:745)
>[13:28:51 WARN]: java.lang.NullPointerException
>[13:28:51 WARN]: at me.libraryaddict.disguise.commands.BaseDisguiseCommand.parseDisguise(BaseDisguiseCommand.java:590)
>[13:28:51 WARN]: at me.libraryaddict.disguise.commands.DisguiseCommand.onCommand(DisguiseCommand.java:32)
>[13:28:51 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
>[13:28:51 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
>[13:28:51 WARN]: at org.bukkit.craftbukkit.v1_10_R1.CraftServer.dispatchCommand(CraftServer.java:647)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PlayerConnection.handleCommand(PlayerConnection.java:1358)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PlayerConnection.a(PlayerConnection.java:1193)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PacketPlayInChat.a(PacketPlayInChat.java:45)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PacketPlayInChat.a(PacketPlayInChat.java:1)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.PlayerConnectionUtils$1.run(SourceFile:13)
>[13:28:51 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>[13:28:51 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.SystemUtils.a(SourceFile:45)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.D(MinecraftServer.java:732)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.DedicatedServer.D(DedicatedServer.java:400)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.C(MinecraftServer.java:668)
>[13:28:51 WARN]: at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:567)
>[13:28:51 WARN]: at java.lang.Thread.run(Thread.java:745)