PEX via MySQL - Migrace (2.díl)

[cz_martin_k]

Nahrál jsem to tam, nenapsalo mi to žádnou chybu v Databázi, ale práva nefungují ve hře. Nemám před jménem Admin, a všichni píšou stejně a teď mi i k vůli tomu nefunguje ChatManager a Modifyworld. V server.log toho vypisuje strašně moc.

[cz_martin_k]

Zkusil jsem se v tom ještě trošku povrtat a podařilo se mi to. už to funguje!
Co to je to, za ty chyby s tim Essentialem, vždyť jsem ho už aktualizoval?
Tady je server.log:

Spoiler: zobrazit

Kód: Vybrat vše

2012-10-07 16:19:27 [INFO] Starting minecraft server version 1.3.2
2012-10-07 16:19:27 [INFO] Loading properties
2012-10-07 16:19:27 [INFO] Default game type: SURVIVAL
2012-10-07 16:19:27 [INFO] Generating keypair
2012-10-07 16:19:28 [INFO] Starting Minecraft server on 93.91.250.119:27802
2012-10-07 16:19:28 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
2012-10-07 16:19:28 [WARNING] The server will make no attempt to authenticate usernames. Beware.
2012-10-07 16:19:28 [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-10-07 16:19:28 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
2012-10-07 16:19:28 [INFO] This server is running CraftBukkit version git-Bukkit-1.3.2-R1.0-b2377jnks (MC: 1.3.2) (Implementing API version 1.3.2-R1.0)
2012-10-07 16:19:28 [INFO] Starting FakaHedaMinequery server on 93.91.250.119:28802
2012-10-07 16:19:28 [INFO] [PermissionsEx] sql backend registered!
2012-10-07 16:19:28 [INFO] [PermissionsEx] file backend registered!
2012-10-07 16:19:28 [INFO] [PermissionsEx] PermissionEx plugin initialized.
2012-10-07 16:19:28 [SEVERE] ebean.properties not found
2012-10-07 16:19:28 [WARNING] No Entities found in ClassPath using ClassPathReader [com.avaje.ebeaninternal.server.util.DefaultClassPathReader@314788d8] Classpath Searched[[file:/hlserver/27802/minecraft_server.jar]]
2012-10-07 16:19:28 [INFO] Classpath search hits in jars[] pkgs[]  searchTime[1]
2012-10-07 16:19:28 [INFO] DataSourcePool [LogOres] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
2012-10-07 16:19:28 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
2012-10-07 16:19:29 [INFO] Entities enhanced[0] subclassed[0]
2012-10-07 16:19:29 [INFO] [LagMeter] Loading LagMeter v1.9.0
2012-10-07 16:19:29 [INFO] [LegendaryMessages] Loading LegendaryMessages v3.5
2012-10-07 16:19:29 [INFO] [WorldEdit] Loading WorldEdit v5.4.2
2012-10-07 16:19:29 [INFO] [FakaHedaMinequery] Loading FakaHedaMinequery v1.1
2012-10-07 16:19:29 [INFO] [Vault] Loading Vault v1.2.19-b248
2012-10-07 16:19:29 [INFO] [PermissionsEx] Loading PermissionsEx v1.19.2
2012-10-07 16:19:29 [INFO] [PermissionsEx] Initializing sql backend
2012-10-07 16:19:29 [INFO] [PermissionsEx-SQL] Connecting to database "mysql://127.0.0.1:3306/gs_27802_1"
2012-10-07 16:19:29 [INFO] [PermissionsEx-SQL] Successfuly connected to database
2012-10-07 16:19:29 [INFO] [LWC] Loading LWC v4.3.0 (b736-git-1b1150b1) (August 08, 2012)
2012-10-07 16:19:29 [INFO] [SimpleRestart] Loading SimpleRestart v1.3.4
2012-10-07 16:19:29 [INFO] [AuthMe] Loading AuthMe v2.6.6
2012-10-07 16:19:29 [INFO] [ChopTree2] Loading ChopTree2 v2.2.0
2012-10-07 16:19:29 [INFO] [CompatNoCheatPlus] Loading CompatNoCheatPlus v6.2.8-b7
2012-10-07 16:19:29 [INFO] [OpenInv] Loading OpenInv v1.8.7
2012-10-07 16:19:29 [INFO] [BKCommonLib] Loading BKCommonLib v1.23
2012-10-07 16:19:29 [INFO] [TrueBlood] Loading TrueBlood v1.0.0
2012-10-07 16:19:29 [INFO] [Modifyworld] Loading Modifyworld v1.19.3
2012-10-07 16:19:29 [INFO] [SimpleReserve] Loading SimpleReserve v0.5.0
2012-10-07 16:19:29 [INFO] [MoneyDrop] Loading MoneyDrop v1.6.2
2012-10-07 16:19:29 [INFO] [FoundDiamonds] Loading FoundDiamonds v3.6
2012-10-07 16:19:29 [INFO] Loading LogOres v1.0.1
2012-10-07 16:19:29 [INFO] [Essentials] Loading Essentials v2.9.3
2012-10-07 16:19:29 [INFO] [LiftSign] Loading LiftSign v0.2.1
2012-10-07 16:19:29 [INFO] [ChatManager] Loading ChatManager v1.19.1
2012-10-07 16:19:29 [INFO] [EssentialsProtect] Loading EssentialsProtect v2.9.4
2012-10-07 16:19:29 [INFO] MLog clients using java 1.4+ standard logging.
2012-10-07 16:19:29 [INFO] [NoCheatPlus] Loading NoCheatPlus v3.7.3-b111
2012-10-07 16:19:29 [INFO] [EssentialsSpawn] Loading EssentialsSpawn v2.9.4
2012-10-07 16:19:29 [INFO] [BOSEconomy] Loading BOSEconomy v0.7.3.1
2012-10-07 16:19:29 [INFO] [EssentialsAntiBuild] Loading EssentialsAntiBuild v2.9.4
2012-10-07 16:19:29 [INFO] [ChestShop] Loading ChestShop v3.46
2012-10-07 16:19:29 [INFO] [EssentialsChat] Loading EssentialsChat v2.9.4
2012-10-07 16:19:29 [INFO] [Residence] Loading Residence v2.6.5.2
2012-10-07 16:19:29 [INFO] [Vault] Enabling Vault v1.2.19-b248
2012-10-07 16:19:29 [INFO] [Vault][Economy] BOSEconomy7 found: Waiting
2012-10-07 16:19:29 [INFO] [Vault][Economy] Essentials Economy found: Waiting
2012-10-07 16:19:29 [INFO] [Vault][Permission] PermissionsEx found: Waiting
2012-10-07 16:19:29 [INFO] [Vault][Permission] SuperPermissions loaded as backup permission system.
2012-10-07 16:19:29 [INFO] [Vault][Chat] PermissionsEx found: Waiting
2012-10-07 16:19:29 [INFO] [Vault] Enabled Version 1.2.19-b248
2012-10-07 16:19:29 [INFO] [LWC] Enabling LWC v4.3.0 (b736-git-1b1150b1) (August 08, 2012)
2012-10-07 16:19:29 [INFO] [LWC] Loaded 209 locale strings (0 overrides)
2012-10-07 16:19:29 [INFO] [LWC] Permissions API: §4VaultPermissions
2012-10-07 16:19:29 [INFO] [LWC] Currency API: §4VaultCurrency
2012-10-07 16:19:29 [INFO] [LWC] Connecting to SQLite
2012-10-07 16:19:29 [INFO] [LWC] Performing any necessary database updates
2012-10-07 16:19:29 [INFO] [LWC] Using database: Native
2012-10-07 16:19:29 [INFO] [LWC] Precached 548 protections
2012-10-07 16:19:29 [INFO] [BKCommonLib] Enabling BKCommonLib v1.23
2012-10-07 16:19:29 [INFO] BKCommonLib version 1.23 enabled!
2012-10-07 16:19:30 [INFO] Preparing level "world"
2012-10-07 16:19:30 [INFO] Preparing start region for level 0 (Seed: -3423481994322319875)
2012-10-07 16:19:30 [INFO] Preparing start region for level 1 (Seed: 2876442663037430069)
2012-10-07 16:19:31 [INFO] Preparing spawn area: 89%
2012-10-07 16:19:31 [INFO] Preparing start region for level 2 (Seed: 2876442663037430069)
2012-10-07 16:19:31 [INFO] [LagMeter] Enabling LagMeter v1.9.0
2012-10-07 16:19:31 [INFO] [LagMeter] Not using logs folder.
2012-10-07 16:19:31 [INFO] [LagMeter 1.9.0] Enabled!  Polling every 40 server ticks.  Logging to /hlserver/27802/plugins/LagMeter/lag.log
2012-10-07 16:19:31 [INFO] [LegendaryMessages] Enabling LegendaryMessages v3.5
2012-10-07 16:19:31 [INFO] [LegendaryMessages] Loaded players.yml!
2012-10-07 16:19:31 [INFO] [WorldEdit] Enabling WorldEdit v5.4.2
2012-10-07 16:19:31 [INFO] WEPIF: Using the Bukkit Permissions API.
2012-10-07 16:19:31 [INFO] [FakaHedaMinequery] Enabling FakaHedaMinequery v1.1
2012-10-07 16:19:31 [INFO] [PermissionsEx] Enabling PermissionsEx v1.19.2
2012-10-07 16:19:31 [INFO] [PermissionsEx] Superperms support enabled.
2012-10-07 16:19:31 [INFO] [PermissionsEx] v1.19.2 enabled
2012-10-07 16:19:31 [INFO] WEPIF: PermissionsEx detected! Using PermissionsEx for permissions.
2012-10-07 16:19:31 [INFO] [Vault][Permission] PermissionsEx hooked.
2012-10-07 16:19:31 [INFO] [Vault][Chat] PermissionsEx_Chat hooked.
2012-10-07 16:19:31 [INFO] [SimpleRestart] Enabling SimpleRestart v1.3.4
2012-10-07 16:19:31 [INFO] [SimpleRestart] permissions (PermissionsEx-Plugin) successfully loaded
2012-10-07 16:19:31 [INFO] [SimpleRestart] plugin enabled
2012-10-07 16:19:31 [INFO] [SimpleRestart] warning scheduled for 85800 seconds from now!
2012-10-07 16:19:31 [INFO] [SimpleRestart] warning scheduled for 86100 seconds from now!
2012-10-07 16:19:31 [INFO] [SimpleRestart] warning scheduled for 86280 seconds from now!
2012-10-07 16:19:31 [INFO] [SimpleRestart] warning scheduled for 86340 seconds from now!
2012-10-07 16:19:31 [INFO] [SimpleRestart] reboot scheduled for 86400 seconds from now!
2012-10-07 16:19:31 [INFO] [AuthMe] Enabling AuthMe v2.6.6
2012-10-07 16:19:31 [INFO] [AuthMe] Loading Configuration File...
2012-10-07 16:19:31 [INFO] [AuthMe] Merge new Config Options..
2012-10-07 16:19:31 [INFO] [AuthMe] Set Language: en
2012-10-07 16:19:31 [INFO] [AuthMe] Authme 2.6.6 enabled
2012-10-07 16:19:31 [INFO] [ChopTree2] Enabling ChopTree2 v2.2.0
2012-10-07 16:19:31 [INFO] [CompatNoCheatPlus] Enabling CompatNoCheatPlus v6.2.8-b7
2012-10-07 16:19:31 [INFO] [cncp] Registered hook(NCPHook might get added later): PlayerClass(default) / 2.1
2012-10-07 16:19:31 [INFO] [cncp] Registered hook(NCPHook might get added later): BlockBreak(default) / 1.1
2012-10-07 16:19:31 [INFO] [cncp] Registered hook(NCPHook might get added later): BlockPlace(default) / 1.0
2012-10-07 16:19:31 [INFO] [cncp] Registered hook(NCPHook might get added later): InstaBreak(default) / 1.0
2012-10-07 16:19:31 [INFO] [OpenInv] Enabling OpenInv v1.8.7
2012-10-07 16:19:31 [INFO] [OpenInv] version 1.8.7 enabled!
2012-10-07 16:19:31 [INFO] [TrueBlood] Enabling TrueBlood v1.0.0
2012-10-07 16:19:31 [INFO] [TrueBlood] TrueBlood: Enabled
2012-10-07 16:19:31 [INFO] [Modifyworld] Enabling Modifyworld v1.19.3
2012-10-07 16:19:31 [INFO] [Modifyworld] Modifyworld enabled!
2012-10-07 16:19:31 [INFO] [SimpleReserve] Enabling SimpleReserve v0.5.0
2012-10-07 16:19:31 [FINER] [SimpleReserve] Created SimpleReserveListener with kickMessage: "Byl si vyhozen, aby jsi uvolnil misto pro vyhrazeneho hrace!" and fullMessage: "Server je plny!"
2012-10-07 16:19:31 [INFO] [SimpleReserve] SimpleReserve version 0.5.0 enabled!
2012-10-07 16:19:31 [INFO] [MoneyDrop] Enabling MoneyDrop v1.6.2
2012-10-07 16:19:32 [INFO] [MoneyDrop] Startup complete.
2012-10-07 16:19:32 [INFO] [FoundDiamonds] Enabling FoundDiamonds v3.6
2012-10-07 16:19:32 [INFO] [FoundDiamonds] Enabled
2012-10-07 16:19:32 [INFO] Enabling LogOres v1.0.1
2012-10-07 16:19:32 [INFO] [LogOres] using VAULT:PermissionsEx for permissions
2012-10-07 16:19:32 [INFO] [LogOres]version 1.0.1, build 6 is enabled
2012-10-07 16:19:32 [INFO] [Essentials] Enabling Essentials v2.9.3
2012-10-07 16:19:32 [WARNING] Version mismatch! Please update EssentialsProtect to the same version.
2012-10-07 16:19:32 [WARNING] Version mismatch! Please update EssentialsSpawn to the same version.
2012-10-07 16:19:32 [WARNING] Version mismatch! Please update EssentialsAntiBuild to the same version.
2012-10-07 16:19:32 [WARNING] Version mismatch! Please update EssentialsChat to the same version.
2012-10-07 16:19:32 [INFO] [Vault][Economy] Essentials Economy hooked.
2012-10-07 16:19:32 [INFO] Essentials: Using PermissionsEx based permissions.
2012-10-07 16:19:32 [INFO] [Essentials] Payment method found (Vault - Economy: BOSEconomy version: 1.2.19-b248)
2012-10-07 16:19:32 [INFO] [LiftSign] Enabling LiftSign v0.2.1
2012-10-07 16:19:32 [INFO] [LiftSign] Loaded 6 locale strings (0 overrides)
2012-10-07 16:19:32 [INFO] [LiftSign] using VAULT:PermissionsEx for permissions
2012-10-07 16:19:32 [INFO] [LiftSign] version 0.2.1, build 79 is enabled
2012-10-07 16:19:32 [INFO] [ChatManager] Enabling ChatManager v1.19.1
2012-10-07 16:19:32 [INFO] [ChatManager] ChatManager enabled!
2012-10-07 16:19:32 [INFO] [EssentialsProtect] Enabling EssentialsProtect v2.9.4
2012-10-07 16:19:32 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
2012-10-07 16:19:32 [INFO] Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
2012-10-07 16:19:32 [INFO] [NoCheatPlus] Enabling NoCheatPlus v3.7.3-b111
2012-10-07 16:19:33 [INFO] [NoCheatPlus] Version 3.7.3-b111 is enabled.
2012-10-07 16:19:33 [INFO] [NoCheatPlus] Added hook: PlayerClass(cncp) [2.0].
2012-10-07 16:19:33 [INFO] [CompatNoCheatPlus] [cncp] Added 1 registered hooks to NoCheatPlus.
2012-10-07 16:19:33 [INFO] [EssentialsSpawn] Enabling EssentialsSpawn v2.9.4
2012-10-07 16:19:33 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
2012-10-07 16:19:33 [INFO] [BOSEconomy] Enabling BOSEconomy v0.7.3.1
2012-10-07 16:19:33 [INFO] BOSEconomy v0.7.3.1 enabled.
2012-10-07 16:19:33 [INFO] [Vault][Economy] BOSEconomy hooked.
2012-10-07 16:19:33 [INFO] [EssentialsAntiBuild] Enabling EssentialsAntiBuild v2.9.4
2012-10-07 16:19:33 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
2012-10-07 16:19:33 [INFO] [ChestShop] Enabling ChestShop v3.46
2012-10-07 16:19:33 [INFO] [ChestShop] LWC version 4.3.0 (b736-git-1b1150b1) (August 08, 2012) loaded.
2012-10-07 16:19:33 [INFO] [ChestShop] Vault loaded - using BOSEconomy
2012-10-07 16:19:33 [INFO] [EssentialsChat] Enabling EssentialsChat v2.9.4
2012-10-07 16:19:33 [WARNING] Version mismatch! Please update all Essentials jars to the same version.
2012-10-07 16:19:33 [INFO] [Residence] Enabling Residence v2.6.5.2
2012-10-07 16:19:33 [INFO] [Residence] Found Vault using permissions plugin:PermissionsEx
2012-10-07 16:19:33 [INFO] [Residence] Scanning for economy systems...
2012-10-07 16:19:33 [INFO] [Residence] Found Vault using economy system: BOSEconomy
2012-10-07 16:19:33 [INFO] [Residence] Found WorldEdit
2012-10-07 16:19:33 [INFO] [Residence] Enabled! Version 2.6.5.2 by bekvon
2012-10-07 16:19:33 [INFO] Server permissions file permissions.yml is empty, ignoring it
2012-10-07 16:19:33 [INFO] Done (3.865s)! For help, type "help" or "?"
2012-10-07 16:19:33 [INFO] Starting GS4 status listener
2012-10-07 16:19:33 [INFO] Query running on 93.91.250.119:27802
2012-10-07 16:19:33 [INFO] [AutoMessage] Potrebujes pomoct? zeptej se adminu, co jsou prave online, radi ti pomohou!
2012-10-07 16:19:36 [INFO] cz_martin_k[/77.48.234.34:61052] logged in with entity id 680 at ([world] -1006.6637750974519, 102.0, 249.39195540831108)
2012-10-07 16:19:36 [INFO] Vitej zpet, cz_martin_k!
2012-10-07 16:19:36 [WARNING] File motd.txt does not exist. Creating one for you.
2012-10-07 16:19:44 [INFO] cz_martin_k issued server command: /login
2012-10-07 16:19:44 [INFO] [AuthMe] §4[§9Hl.Admin§4]§acz_martin_k§7§f used the wrong password
2012-10-07 16:19:51 [INFO] cz_martin_k issued server command: /login
2012-10-07 16:19:51 [INFO] [AuthMe] §4[§9Hl.Admin§4]§acz_martin_k§7§f logged in!
2012-10-07 16:19:56 [INFO] cz_martin_k issued server command: /pl
2012-10-07 16:20:00 [INFO] <[Hl.Admin]cz_martin_k> c
2012-10-07 16:20:33 [INFO] [AutoMessage] Nebavi te porad behat domu, nastav si doma port /sethome a potom uz je staci dat /home. Je to tak tezky?


[vojtamaniak]

Updatoval jsi všechny Essentials? Essentials Chat atp.

[cz_martin_k]

Jo.

[Jungeman]

Vsetko v pohode. Napojenie pexov na MYSQL bez problemov, vytvorili sa mi tabulky, vymazal som obsah v tabulkach, dal som SQL, prekopiroval udaje z permissions.sql ale ked stlacim Proved tak mi to hodi chybu

Spoiler: zobrazit

Kód: Vybrat vše

Chyba

SQL-dotaz:

INSERT INTO `{permissions_entity}` ( `name` , `type` , `prefix` , `suffix` )
VALUES (
'user123', 1, '', ''
);

MySQL hlásí: Dokumentace
#1146 - Table '134359_mysql_db.{permissions_entity}' doesn't exist

[nejento]

Neexistuje v databázi tabulka {permissions_entity}. Co já vím, tak ta tabulka by měla být bez těch složených závorek {} a ten sql příkaz, který tam kopíruješ a necháváš použít by tu tabulku měl vytvořit. Pokud je tam tabulka permissions_entity vytvořená, tak jenom uprav ten řádek v sql příkazu, aby tam nebyly ty složené závorky.

[Jungeman]

Este maly dotaz. Uz sa mi to podarilo napojit do DB, prehodit pexi z yml do databazy ale ked som to dal do DB tak vsetky VIP stratili VIP tudiz - nemali prefix , nemali povolene commandy nemali proste nic jedine osoby ktore sa preniesili a mali svoje skupiny tak to boli ludia ktory boli zapisani natvrdo v skupine napr. Adminy / Helperi. Vip mam spravene cez fakahedu SMS Vip.

[LpBahos]

Provedl jsem příkaz pex dump sql "permissions.sql" ale nic to neudělalo (console)... Měl jsem napsat help

[ABYSI!DORANA!]

precistil som a nejde :/

Kód: Vybrat vše

SQL dopyt:

/* Group Majitel */ INSERT INTO  `{permissions_entity}` (  `name` ,  `type` ,  `prefix` ,  `suffix` ,  `default` )
VALUES (

'Majitel', 0,  '&3[Majitel]&b',  '&a', 0
);

MySQL hlási: Dokumentácia

#1146 - Table '160477_mysql_db.{permissions_entity}' doesn't exist

moj sql subor
http://pastebin.com/QzMGmYPQ

[nejento]

Protože to vkládá do tabulky {permissions_entity} a ne permissions_entity.
Můžeš zkusit v Notepad++ použít Ctrl + F a v druhé zálože nahradit {permissions_entity} za permissions_entity.
To stejné u {permissions} za permissions

Mohlo by to fungovat. Rozhodně si ale zazálohuj původní .sql soubor, protože chybná tabulka jde smazat vždycky.